- Description
DBM 380 Week 3 Individual: ERD Creation Project
The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.
Use a Microsoft Visio diagram to create a detailed ERD using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty feedback.
Use a Microsoft Access database to create the preliminary database tables, columns with data types, primary keys, and relationships.
I have posted two short YouTube videos that show me completing a sample version of the assignment in the Toolwire Student Desktop environment. These should give you a good idea of what is expected.
Creating the ERD in Visio: https://www.youtube.com/watch?v=FZYG49-Hylk
Creating the database in Access: https://www.youtube.com/watch?v=sUjmplthSNQ
Click the Assignment Files tab to submit your assignment.
Here is the rubric I will be using for this assignment:
| Element | Points |
| Creates detailed ERD using Visio based on week 2 database description – ERD includes entities, attributes, primary keys, and foreign keys. | 40 |
| Create database based on ERD – includes tables, columns, primary keys, and foreign key relationships with referential integrity enforced. Choose the appropriate data types for your columns (not everything should be text). | 60 |