Data Modeling Assignment Example
. Use this assignment along with the accompanying video to understand what is expected of the assigned data modeling assignment
. Task:
Build the “Physical” design of this data model (“Logical” design). Requirements:
Create a database called, “Customer_Sales”. Create the entities below. Add an appropriate Foreign Key (FK). NOTE: The Foreign Key (FK) is not seen in the “Logical” design below. You will need to add this to the “Physical” design. Also, the below diagram is NOT normalized. Apply 1NF, 2NF, and 3NF to the below “Logical” design into your “Physical” design. Now add (INSERT) 5 rows of data
in each of the entities (tables). Write a SELECT statement to confirm the results of both tables. Example of an INSERT statement: INSERT INTO dbo.Salesperson VALUES (‘text’, .05, 2022)
Example of SELECT statement: SELECT Salesperson_Name, Commission_Percentage, Year_of_Hire FROM dbo.Salesperson
In-Class Deliverable
: Backup your database with the finalized “Physical” design. Turn in your .bak file in Canvas. Copy/Paste a screen shot of the SELECT query and it’s results after execution in a MS Word Document. In the same MS Word document, describe in several sentences the “Cardinality” and “Modality” of this database design. Upload the MS Word document to the same in-class assignment in Canvas.
