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
