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. For simplicity, you may assume that a patient can see only one physician and that a physician can have multiple patients. Tables:

  • Physician
  • Patient

University Database
Design a database for a university. Data may include student and advisor tables. A student can only have one advisor, but an advisor can advise multiple students. Tables:

  • Advisor
  • Student

Company Database
Design a database for a company. The company has completed projects as well as active projects and needs a database to store its data. The database should include information about the employees and the projects they are engaged in. You may assume that an employee can only be engaged in one project. Multiple employees can be engaged in a single project. Tables:

  • Project
  • Employee

Pharmacy Database
A pharmacy has a database of different types of medicines. The database should store the details of all prescriptions brought by patients. A prescription belongs to one patient. A patient can have multiple prescriptions. Tables:

  • Patient
  • Prescription

Create your own database
If you would like to select a topic (i.e., database) other than those options provided, your topic must be approved by your instructor.

  • Identify the type of database you are going to create.
  • Explain what data it will manage.
  • Identify two tables in the database.

After selecting and identifying your topic, 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. These attributes are data items that will be stored in your database. 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. That column must be the primary key of the other table.

As the intention of this assignment is to get you started on your Final Project, you do not need to include records of actual data. You need only to submit a Word document containing the information detailed in these instructions.