Computer Science Homework Help. HU Logical Modeling and Normalization
Create a logical data model for the following external artifact
Use a step-by-step normalization method:
- Use algebraic notation to describe all values for the external artifact
- Identify a primary unique identifier for the master entity
- Create a base entity-relationship diagram (ERD) with the master entity on it
- Apply the rules of normalization (1st, 2nd, and 3rd Normal Forms) to create a normalized logical data model including an updated ERD and revised entities described using algebraic notation
