Assignment: Database Design and ERD Creation
Perform a logical design on the proposed database environment without going through the full normalization process. Include the identification of all entities and attributes associated with the environment.
Use a 2-page memo to document your logical design including the process you went through.
Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.
Create a detailed ERD using the data specifications from the logical design. Use Microsoft Visio or another tool to create this diagram. One alternative is to create a free account to access LucidChart, a Visio compaible tool.
Learning Team: Status Update
Continue working on your Learning Team Database and Presentation due in Week Five. Design your database including the creation of an ERD, identifying primary and foreign keys, determining the appropriate types for database attributes, determining necessary constraints, and normalizing the database to at least the 3rd Normal Form. Use the logical database design to create the physical database. Populate the database with test data using the requirements outlined.