Budget- Easy For A DBMS Guy With SQL Knowledge Assignments | Online Homework Help
Week 2 – Data Management Project: Conceptual Design
The Data Management Project for Week 2 builds upon what you did for the Data Management Project in Week 1.
- Create a conceptual data model of data management project showing the entities and relationships.
- Add a new ‘Conceptual Data Model’ section to your DBMS assignment you submitted last week.
- Add the conceptual data model to the new section.
- Make sure you correct the DBMS assignment document from week 1 based on my feedback before submitting this assignment.
Week 3 – Data Management Project: Logical Design
Attached Files:
- pdf(266.891 KB)
- ERD Car Dealership.pdf (314 KB)
- pdf(76.277 KB)
- pdf(194.87 KB)
The Data Management Project for week 3 builds upon what you did for the Data Management Project in weeks 1 and 2. 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.
I have attached four examples for you to see how your models should look — hope it helps!
A data dictionary for all tables defined in data model is required for final project. This week, you will create a data dictionary for two entities from week 3 submission of data model. A data dictionary defines information for data model and database design.
Please identify the following components for each of the two entities:
- Attribute name
- Attribute data type
- Attribute description
- Attribute values
