Current Data Volume - Create a Database Diagram - IT Computer Science Assignment Help

Assignment Task :

1 Use the current data volume details given below to modify the ER Diagram provided to create a data volume map.
a. The total number of Customers 1000
b. The total number of Items in the database is 15000.
c. The total number of sales reps in the database is 12.
d. The total number of recorded shipments in the database is 1200.
e. The total number of Suppliers is 500
f. On average there are 300 items in a shipment.
g. On average a customer places 9 orders.
h. On average there are 3 items in an order

2 Create the following tables of the database (see the ER Diagram provided) using Transact- SQL commands. Specify primary keys and referential integrity constraints in your commands. If a table has foreign key(s), state the appropriate on-delete action

3 Populate tables with data (Enter at least five records to each table). 
Include the INSERT SQL commands used to create tables in your report. 

4 Create a Database Diagram with all the tables in it. Include a screen dump of the Database Diagram in your report. You must save the diagram of your database for the examiner to check.

5 Create index files to improve performance for appropriate tables. You may use the assumption that there should be at least 20000 records in a table to improve performance using an index file.
Include the CREATE INDEX SQL commands used to create index files in your report

6 A suggestion of one possible de-normalisation (merging tables) to improve performance of the database in the ER Diagram provided. You must describe both positive and negative consequences of the merge. Attributes of the merged tables must be shown using standard relational notations indicating primary keys and the foreign keys in your report. 

7 Create the following reports using the reports using the SQL Server Report Builder.
List of customers (First Name, Surname) and the sales reps (Name of Rep) who severed them.

This IT Computer Science Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.