Assignment: Database Design
Overview
- Purpose: To begin to understand how databases are designed by taking an existing database and reverse engineering it into how it would look in an ERD (or how it was designed to begin with).
- Task: To create an ERD from data you find on a web based database.
Steps
- Pick any website that you think might be using a database to show content on its pages.
- Just think about the following questions (no need to type them out and submit them):
- What entities might they be using in the database?
- What are some of the attributes that would go with each of those entities?
- What data type would be used for each of these attributes?
- How could the entities be related?
- Once you have the answers to your questions, create an ERD (entity relationship diagram) in Workbench showing each entity with its attributes and their data-types and how each entity is related with crows feet notation. If you need to review how to make the ERD see the workbench3 video from Week 1 and start at 2:18
Note: Many databases are very large and complex. You do not need to cover every possible entity or attributes in your design. But, you should have at least three or more entities to your design.
Submission
Return to Canvas and Submit a screenshot or image of the Entity-Relationship Diagram (ERD). To save the model you can save with a File - Save Model, it will create an mwb file for you. Do not turn in the .mwb file, however. It does not always open properly for the grader. Please submit the screenshot as a png file using File - Export - Export as a PNG.
Please place the name of the website in the comments of your submission on Canvas.
Use the How to extract a good ERD image video for reference if needed. (01:52 mins, "MySQL Workbench How to Extract ERD Image" Transcript)
Useful Links:
- Next Activity: Complete W01 Prove Quiz and W01 60-second Status Update in Canvas
- Previous Activity: W02 Assignment: SQL Overview
- Go to: Week Index • Course Home • Canvas