The Assignment
In this assignment, your task is to analyze, design, and develop tables
to hold two lists of data: the list of sister cities and the list of people
associated with the organization. The data have been kept in
spreadsheet form.
Design Deliverables Summary
To Canvas (in one zipped folder
submit the following
to assignment L2d-LM&PM. Only one submission from one team member is required) :
- Visio Logical Data Model
- MySQL Workbench Physical Data Design
- The team work record log file
Analyst Notes & Deliverables Details
Data Model & ERD. [req 2.00] Download the spreadsheets
SCASisterCities.xlsx and
SCAPersons.xlsx by
clicking these links. Your team will submit for review two diagrams:
a data model created in Visio, and a physical database design using
MySQL Workbench. (See "Deliverables" above.)
Before you begin making diagrams, please read these notes carefully ...
- Study and refer to the
Diagramming Guidelines,
Naming Conventions, and 421 Data Specifications
when creating the data models
- This is a new diagram, not a revision of the conceptual data model from Lab 1. You may throw your Lab 1 conceptual model away now.
- Carefully examine the data in SCASisterCities.xlsx and SCAPersons.xlsx.
- Create a logical data model (Visio) with two entities that represent the data found in SCASisterCities.xlsx and SCAPersons.xlsx.
- Create a physical data model (MySQLWorkbench) that is based on the logical data model you create above for the data found in SCASisterCities.xlsx and SCAPersons.xlsx.
Make sure to follow all naming conventions
- There is no direct relationship between the sister cities and people: neither the logical data model and nor the physical data design will include
relationships.
End of Instructions
|