Objectives
Creation and Design of MySQL Schema Objects
Design and create normalized databases
Create and modify tables using appropriate data types and indexing
Describe and create table constraints enforcing data integrity
Requirements
Identify a real world application that would require a database. This could be a business, an organization or a specific area within a business or organization (i.e. human resources, payables and receivables, etc.)
Identify 2-3 major entities involved in the application. For example, if you were doing a college scheduling application, the entities might be students, classes and instructors.
For each entity, identify the information about the entities (data fields) that would be needed. You should have about 5-10 fields for each entity.
Using the identified entities and data fields, go through the data normalization process to identify the tables that would be needed for a relational database.
Assign valid SQL fieldnames to each field.
Identify a primary key for each table.
Identify the foreign keys that would be needed.
Use the data modeling utilities in the workbench to create a new EER diagram for your database and submit that.