Phase 3 - Task 1
Task Type:
Discussion Board
Deliverable Length:
see assignment details
Primary Discussion Response is due by Wednesday Primary Task Response: Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas:

Once the logical model is complete, the steps to transform that model into the actual physical data schema can be performed. This process actually creates the normalized database structure and is a very important part of database development. Complete the following:

Use the Internet to research the steps needed to transform a logical data model into a physical data schema.
Discuss the importance and purpose of normalization and denormalization.
Be sure to support your information by citing at least two references using APA format.
Phase 3 - Task 2
Task Type:
Individual Project
Deliverable Length:
Paper of 4–5 pages (excluding references and cover page) + Database System Plan template
Write an Entity Relationship (ER) Diagram document of 4–5 pages based on the conceptual model that you completed in Week 2. Include the following:

An ER diagram that outlines the primary keys for all entities, the relationships between different entities, the attributes (and data types) for each entity, and junction tables to support any many-to-many relationships
A design that meets the minimum of third normal form (3NF)
A description of the steps that you took to ensure that your design was normalized to the desired level and any exceptions you had to make to prevent anomalies and a loss in data integrity
Add section to the Entity Relationship (ER) Diagram section of your database system plan
Name the document as follows:
All sources should be cited both in the text and in the References section by using APA format.
Submit the document for grading.