Ask Computer Engineering Expert

Working with Database Tables

For this assignment, you will create a Visual Basic.NET application based on the skills and concepts used in IP2. In this exercise, you will create a solution that works with two tables having a Master/Detail relationship. The first table contains music category records, and the second table contains album detail records for each category.

A screen shot of the desired UI is shown in the following image. You can also download a running example of the completed project and the required database ITP400_IP3_B.mdb. Please be aware that the example program does not necessarily demonstrate all of the functional requirements, and it is intended only as an example. You are responsible for meeting the listed requirements. Please refer to the following information for the complete requirements.

Requirements:

For this project you will use the following database schema, which has two tables.

Table 1 -- Schema for the tblCategories table

Column Name Data Type
ldCategoryID Integer
fldCategoryDesc String

Table 2 -- Schema for table named tblAlbums

Column Name
Data Type

fldAlbumID
Integer

fldCategoryID
Integer

fldAlbumName
String

fldArtist
String

fldDatePurchased
Date

fldCost
Single

The input form contains a ListBox and a DataGrid control. Select album categories in the list box and then the corresponding album information appears in the DataGrid. As you select different categories, the total costs are recalculated for the selected category and displayed in a label on your form, formatted as currency.
Configure the form so it appears on the center of the desktop when the solution is run.
Do not allow the user to resize the form.
Remove minimize, maximize, and close buttons from the title bar
Perform the appropriate steps to create a connection to the sample database. Be sure to select the option to copy the database to your project so it will be automatically included in the project.

Create an instance of the ListBox control. Set the necessary properties so that the ListBox control will display the field fldCategoryDesc.

Create an instance of the DataGrid control on the form. Configure the DataGrid control instance so it displays records from the table named tblAlbums, but only for those records matching the selected category shown in the list box.
Format the DataGrid so the column header names are the same as the ones shown in the Figure. Set appropriate column widths, and format the cost column as currency, right justified. The date column should also be right justified.
Write the necessary code to calculate the total cost of the displayed albums. Display the results in a Label control above the cost column of the DataGrid. Format the output as currency. Right-justify the output in the Label control instance.
Create an Update button that will allow the user to save any changes made to the DataGrid back to the database. Write the necessary code for the button. Allow the user to add, change, and delete records in the Album table.
Create an Exit button for the solution. In the Click event handler for the button, display a message box to get confirmation from the user before exiting the solution.

Enhancements (optional to achieve maximum points)

Add a basic help system to your application.
Additional Notes

Name your project and set the title of your form (the Text property of the main form) to ITP400_IP3_.

Make sure you fulfill the minimum requirements before attempting advanced features.

Be sure to include good comments in your code.Name your objects, variables, functions, and others with appropriate and consistent names.
Your form(s) should be designed attractively and consistently.

Zip all your project files together and submit your assignment to your instructor via the drop box.
Please submit your assignment.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M9208129

Have any Question?


Related Questions in Computer Engineering

Does bmw have a guided missile corporate culture and

Does BMW have a guided missile corporate culture, and incubator corporate culture, a family corporate culture, or an Eiffel tower corporate culture?

Rebecca borrows 10000 at 18 compounded annually she pays

Rebecca borrows $10,000 at 18% compounded annually. She pays off the loan over a 5-year period with annual payments, starting at year 1. Each successive payment is $700 greater than the previous payment. (a) How much was ...

Jeff decides to start saving some money from this upcoming

Jeff decides to start saving some money from this upcoming month onwards. He decides to save only $500 at first, but each month he will increase the amount invested by $100. He will do it for 60 months (including the fir ...

Suppose you make 30 annual investments in a fund that pays

Suppose you make 30 annual investments in a fund that pays 6% compounded annually. If your first deposit is $7,500 and each successive deposit is 6% greater than the preceding deposit, how much will be in the fund immedi ...

Question -under what circumstances is it ethical if ever to

Question :- Under what circumstances is it ethical, if ever, to use consumer information in marketing research? Explain why you consider it ethical or unethical.

What are the differences between four types of economics

What are the differences between four types of economics evaluations and their differences with other two (budget impact analysis (BIA) and cost of illness (COI) studies)?

What type of economic system does norway have explain some

What type of economic system does Norway have? Explain some of the benefits of this system to the country and some of the drawbacks,

Among the who imf and wto which of these governmental

Among the WHO, IMF, and WTO, which of these governmental institutions do you feel has most profoundly shaped healthcare outcomes in low-income countries and why? Please support your reasons with examples and research/doc ...

A real estate developer will build two different types of

A real estate developer will build two different types of apartments in a residential area: one- bedroom apartments and two-bedroom apartments. In addition, the developer will build either a swimming pool or a tennis cou ...

Question what some of the reasons that evolutionary models

Question : What some of the reasons that evolutionary models are considered by many to be the best approach to software development. The response must be typed, single spaced, must be in times new roman font (size 12) an ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As