Choose one real-world scenario below and design one database table for it.
Scenario Options (Choose One)
- Patients in a clinic
- Students enrolled in a university
- Employees at a company
- Products sold by a store
Part 1: Design Your Table
Create one table with:
- A clear table name
- 46 columns
- One primary key
Example (structure only):
|
Column Name |
Description |
|
StudentID |
Unique identifier for each student |
|
FirstName |
Students first name |
|
LastName |
Students last name |
|
Major |
Academic major |
|
|
Student email |
(Your table and columns will vary based on the scenario you choose.)
Part 2: Identify the Primary Key
Answer the following:
- Which column is your primary key?
- Why is this column a better primary key than:
- A name?
- An email or phone number?
Part 3: Reflection
In 35 sentences, respond to:
- What problems could occur if your table did not have a primary key?
- Why are primary keys especially important as databases grow?
Deliverables
- One page or less
- Table design + written responses
- Clear section labels
Requirements: enough to met assignment requirements

Leave a Reply
You must be logged in to post a comment.