Databases Question

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

Email

Student email

(Your table and columns will vary based on the scenario you choose.)


Part 2: Identify the Primary Key

Answer the following:

  1. Which column is your primary key?
  2. 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

WRITE MY PAPER