ASSIGNMENT 1
Build a Database System
Work as a team to design a simple, real-world database.
Groups
Students must divide themselves into groups composed of 3-4 students
Roles
Part of this process each student must take one role of the following;
Data Designer: Creates tables, builds the structure of the chain
Connection Manager: Explain the connections between tables
Data Analyst: Creates and answers 2 Data questions
Quality Checker: Proof the chain, explain how to fix bad data
Choose a Model
Groups must choose a model in relation to the database they are building. Online Stores, School Systems, Applications, etc.
Reflection
Each student must submit a quick exit reflection after the assignment is complete
Required Components
Identify your data
Choose your entity
List 3-5 attributes to your data
Identify a Primary Key
Show Relationships
Explain how your tables are interconnected
Using a diagram emphasize why it is composed as such
Use your database in a real world example
Create 2 scenarios with your Model
Test your Database with these scenarios and record your observations
Record your findings
Identify and uproot any bad data that may be found in your exercise
Explain your observations and what you did to reverse these errors
