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

Oracle, comparison of oracle RDBMS with MySQL

comparison of oracle RDBMS with MySQL

Describe specialsation and generalization, Describe Specialsation and gener...

Describe Specialsation and generalization? Specialisation /generalization: This is a top down and bottom up approach to the design of database. It displays the IS_A relation

Explain the disadvantages of a file processing system, Explain the disadvan...

Explain the disadvantages of a file processing system? Ans: Disadvantages of File Processing Systems include: 1) Data Redundancy 2) Data Inconsistency 3) Difficult to acce

Describe substring comparison in sql, Describe substring comparison in SQL....

Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

What is database files , The database files accept the actual data and ...

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

Explain cascade and restrict clauses of drop schema command, Explain severa...

Explain several types of constraints that can be specified using CREATE TABLE command. Explain CASCADE and RESTRICT clauses of DROP SCHEMA command? Constraint Description PRIM

Reflects organisational structure, Reflects organisational structure: Many ...

Reflects organisational structure: Many organizations are distributed over various locations. If an organisation has many offices in dissimilar cities, databases used in such an ap

Write query to insert data in student table, Consider student (std_id, std_...

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Project on designing and creating a database , This project will involve de...

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

State the terms designing the database and normalization, State the terms D...

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

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