Database
Choose a topic from the examples below, or come up with your own.
Hospital Database
Design a database for a hospital that will store physician and patient records. Tables:
Physician
Patient
University Database
Design a database for a university. Tables:
Advisor
Student
Company Database
Design a database for a company. Tables:
Project
Employee
Pharmacy Database
A pharmacy has a database of different types of medicines. Tables:
Patient
Prescription
Create your own database.
Complete the following:
List at least two entities (i.e., tables) and identify primary key for each entity. Use shorthand representation shown on page 32 of Concepts of Database Management (Pratt and Last, 2015). Underline the primary key for each table.
List attributes (i.e., columns) of each table. Use shorthand representation shown on page 32 of Concepts of Database Management (Pratt and Last, 2015).
Identify the foreign key (i.e., which column, in which table). If you have two tables, there should be one foreign key in one table that will link the two tables together.
