Assignment 4 is the template and example provided by professsor, and assignment 3 is the ERD you need to code, copy all the code to SQL, and type the code between the template step by step. make sure to follow the template and the order.
1. Take the ER Diagrams that you were working on during the first half of the semester, and implement the table structures in your database on SQL Server.
a. You’ll use DROP TABLE statements, as in the assignment script supplied.
b. You’ll use CREATE TABLE statements, as well as setting PRIMARY KEYs.
c. Be sure to include the FOREIGN KEY statements.
2. After you’ve created your tables, issue INSERT INTO statements to get some fake data in them.
a. Make sure you have enough data to test various scenarios.
3. Finally, issues SELECT * FROM statements on each of your newly populated tables.
REMINDERS:
*** Only turn in one (1) .sql file (No .docx, no .pdf, no .rtf — don’t waste your time)
*** Remember to COPY YOUR OUTPUT to the .sql file!
0 comments