Create a new service-based database, Database Management System

Assignment Help:

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables.

1. Create a new project named FactoryDB.sln.

2. Create a new service-based database (mdf) named Factory in the solution.

3. On the menu item, create a menu item named Create Factory table. The code in this menu item should execute the SQL statement that will create the table named tblFactory.

4. On the menu item, create a menu item named Create Inventory table. The code in this menu item should execute the SQL statement that will create the table named tblInventory. Create the table such that is a one-to-many relationship between the table named tblFactory and the table named tblInventory.

5. On the menu item, create a menu item named Create Sales table. The code in this menu item should execute the SQL statement that will create the table named tblSales. Create the table such that is a one-to-many relationship between the table named tblInventory and the table named tblSales.

6. Create a menu item named Create Test Data. Write the statements:

a. To generate at least 3 records for the Factory table.

b. Create random test data for the table named tblInventory. Use random values for the cost, sales price and quantity on hand. Generate at least 300 test records for the inventory table.

c. Create random test data for the table named tblSales. Use random values for the quantity sold, sales price and sales date. Generate at least 6000 test records for the sales table.

7. Create a menu item named Get Inventory that will will generate a method named GetInventory that should accept one parameter, the FactoryID number, and return a DataSet containing the inventory records for the current factory ID.

8. Create a Navigate menu with menu items that will allow the user to locate the first, previous, next, and the last factory records. As the user navigates from record to record, display in a DataGrid control instance the inventory in that factory by calling the method that you already created above. Besides, you need to provide a Find menu item for the user to search the record by the Factory ID.

9. Use the View Designer to create the view to link the tables based on their primary keys and foreign keys.

10. Create a second form that uses a data grid to display the data in the view.


Related Discussions:- Create a new service-based database

What is a homogeneous distributed database, What is a homogeneous distribut...

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

How to create values of structured type, How to create values of structured...

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

A file manipulation command that extracts some records, A file manipulation...

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

HRM, is Chipo carrying his baby

is Chipo carrying his baby

Explain the two types of participation constraint, Explain the two types of...

Explain the two types of participation constraint.  Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i

What database management system, Company XYZ is an advertising company. It...

Company XYZ is an advertising company. It has its own website but the search facilities offered are not reliable. The company is willing to invest to acquire new machines and sof

What is trigger, What is Trigger? Trigger: A database trigger is proced...

What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

What is called mirroring, What is called mirroring? The simplest approa...

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

In case of entity integrity the primary key may be declared, In case of ent...

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.

Serialisability, Serialisability: Any schedule that makes the similar resul...

Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd