Based on the ERD:

CREATE all tables

INSERT data $-$ add at least $10$ records for each table

TEST the implementation $-$ Write SQL statements to test the implementation

Tasks: Review the resources below to complete this assignment. You have five tasks:

Review this source for how to create SQL Server Database $$ Create, Alter, Drop, Restore.

Review this source for how to create SQL Server Table $$ CREATE, ALTER, DROP $[$T$-$SQL Examples$].$

Review this source for how to create SQL PRIMARY KEY $$ How to Create & Add to Existing Table.

Review this source for how to create SQL FOREIGN KEY $$ How to Create in SQL Server with Example.

Review this source for how to create SQL SERVER JOINS Tutorial $$ INNER, LEFT, RIGHT, OUTER

What to Submit

Upload screenshots for each of the above explaining your process and what problems you experienced.

Include ALL SQL logic used during the implementation. Code should be included in a SQL file