Logical/Physical Data Model Assignment

 

• Textbook: Chapters 4 and 5
• Websites

  Oracle Data Types provides hardware and software availabilities.
  SQL Server data types provides SQL server information.
  MySQL data types provides information about database management.

Assignment Definition:

Use the data model designed in Week 2. This data model will be reviewed and taken from the conceptual model to logical and physical model status.

Make sure you define the following:

1. Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes.

2. Make sure all relationships have been addressed and corrected.

3. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).