The Data Management Project for week 3 builds upon what you did for the Data Management Project in weeks 1 and 2 (ANSWERS YOU PROVIDED ARE ATTACHED). Create a logical data model of data management project showing the entities, relationships, primary keys, and foreign keys. Eliminate composite attributes, like student_name, by creating student_first_name and student_last_name. Create associative entities to resolve any many-to-many relationships between entities. Make sure each entity is in third normal form, meaning that each non-key attribute must depend on the primary key, the whole primary key, and only nothing but the primary key. Use the draw.io tool (https://www.draw.io/) to create your logical model.
Export your data model as a PDF, as shown in the Draw.io video tutorial. Submit the PDF .
- Video: Module 6 – Normalization of Data Tables (10:44 min.)
- Video: Module 6 – Improving the Design (8:34 min.)
the data model attached (employee saving fund) . For that data model , copy and paste that data model graphic into a MS Word document. (You can copy the data model graphic by right-clicking on it. On PCs, the keyboard combination of ctrl-V is the shortcut command for pasting.) In your MS Word document, 1) identify the entity or entities that represent a supertype and the entities that are subtypes, 2) specify which attributes the subtypes inherit from the supertype(s), 3) specify which attributes are unique to each subtype.
- Video: Module 5 – Entity Supertypes and Subtypes (4:55 min.)
- Video: Module 5 – Inheritance and the Specialization Hierarchy (2:14 min.)
- Video: Module 5 – Selecting Primary Keys (7:29 min.)