Description
QUESTION 1,
Data Management Project: Logical Design(WEEK 3)
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 .
YOUTUBE:
- Video: Module 6 – Normalization of Data Tables (10:44 min.)
- Video: Module 6 – Improving the Design (8:34 min.)
Question 2.
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.
you tube:
- 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.)
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello, Check the two documents.Thank you for your time
DATA MANAGEMENT DATA MODEL
Student’s Name
Course Title
March 26, 2019
Data model
Questions
1) identify the entity or entities that represent a supertype and the entities that are
subtypes.
The table outl...