This project will give you hands-on practice in working with MySQL Workbench (or similar tool) to create a key-based, fully attributed, 3 NF data model. In this project you will design a database, draw a data model to represent the design, then create a “physical model” of your design in the format of DDL (table create statements.)
Objectives
1. Become familiar with a data modeling tool of your choice 2. Demonstrate ability to create a complete data model.
3. Use the data modeling software to generate the DDL to create the database you have designed
Deliverables
1. A key-based, fully-attributed data model depicting your database design using the output of homework number one as your input. Your model should include:
• All tables with primary key attributes defined
• All attributes with data type, length, and constraints defined
• Proper table names, key names and attribute names
• All relationships between tables showing captions both ways, and proper optionality and cardinality
2. The DDL necessary to create the database you have designed.
3. Documentation of any assumptions you made regarding unclear or missing requirements.
For example:
• If you are creating surrogate keys, name the key and explain why you are creating the surrogate.
• Note the fact that you are using auto-increment for any created surrogate keys.
INPUT
For your data model drawing, please use the 3NF result from your homework number one.
