create a database and translate the normalized ERD from the Week Three homework into the SQL server entities.

Homework: Creating a Database

This homework will be completed within the Virtual Lab Environment. For this homework, you will access your virtual Structured Query Language (SQL) server, create a database and translate the normalized ERD from the Week Three homework into the SQL server entities. Within the SQL server database all the following requirements must be met.

  1. Create all entities with appropriate attributes
  2. Select appropriate data types for all fields
  3. Translate business requirements into integrity constraints
  4. 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.

WhatsApp icon