SQL project

To complete it, you will need SQL Server 2012

The Project is in two parts. Study the [url removed, login to view] file attahed to this assignment. From this analysis, you are to create a database that would support the re-creation of the invoice. There are four (4) areas of interest. They are:

1) Customers

2) Products

3) Salesperson (Employee)

4) Invoices (The sale itself)

Remember, any Many to Many relationships need an intersection table.

You should produce two items for submission. They are:

1) ERD representing your design of the database to support the invoice problem.

2) A COMPLETE SQL script that would Create a database and all necessary Tables, Keys, Indexes, Constraints,

Identities, etc. The script should also create sample data for all tables adhering to the constraints defined in the ERD.

You need at least three rows in each table. (i.e. a least 3 customers, three invoices, etc)

I have attached [url removed, login to view] script to follow . You have to follow it..

The Script should run completely and should not require user interaction. Please run a Select * on all your tables at the end of the Script. Example: SELECT * FROM tblCustomers

SQL

ID Proyek: #12268726

Tentang proyek