Task

Create a database that contains tables from your ER diagrams you created in assignment 1.1. Here are the requirements...

• Create Database
• Create tables
• Create columns (with appropriate datatypes)
• Create primary keys
• Create an ER diagram within SSMS with relationships
• Create a query using the query editor and include an execution plan

Deliverables

For each 'create', take a screenshot. Label the screenshot appropriately, zip them up and submit to Blackboard.