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

Data manipulation language, Question 1 Discuss about second normal form an...

Question 1 Discuss about second normal form and third normal form Question 2 Write short note on                        1) Data Manipulation Language 2) Data Definition La

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

Which database level is closest to the users, Which database level is close...

Which database level is closest to the users? External database level is closest to the users.

Define assertions in sql, Define Assertions in SQL a. An assertion is a...

Define Assertions in SQL a. An assertion is a predicate that is expressing a condition we wish the database to always satisfy.  b. Domain constraints, functional dependency

What do you understand by acid, What do you understand by ACID? - ACID...

What do you understand by ACID? - ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:

Explain algorithm of er to relational mapping, Explain algorithm of ER To R...

Explain algorithm of ER To Relational Mapping ? ER-to-Relational Mapping Algorithm: 1) Step 1: Mapping of regular entity types: For each strong entity type E, form a relatio

Compare wait-die deadlock prevention with wait-wound scheme, Compare wait-d...

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

What is conceptual model, What is conceptual model ? A conceptual model...

What is conceptual model ? A conceptual model is a independent of both hardware and software.

Can you scan double-sided documents and remove blank pages, Can you scan do...

Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program

Write short notes on relational model, Write short notes on relational mode...

Write short notes on relational model   The  relational  model  uses a  collection of  tables  to show  both data  and the relationships between those  data.  The relational mo

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