Review the Microsoft Create a Database (Links to an external site.)Links to an external site. website and review any relevant information in this week’s lecture. Review the chapter readings and the website to learn more about the process of creating tables and related attributes.
This assignment will be completed within the Virtual Lab Environment. For this assignment, you will access your virtual Structured Query Language (SQL) server, create a database and translate the normalized ERD from the Week Three assignment into the SQL server entities. Within the SQL server database all the following requirements must be met.
Create all entities with appropriate attributes
Select appropriate data types for all fields
Translate business requirements into integrity constraints
Build the ERD using the SQL Server Diagramming tool
Once you have created your SQL server database you will create a document. Take screenshots of the ERD and each of the individual tables within the database and paste these with appropriate labels into the document. You must submit the document via Waypoint for grading. Your instructor will also review your SQL server database within your virtual lab for grading purposes.