DBM 380 Week 3 Individual: ERD Creation Project

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
Powered by