Identify the foreign key. 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.

Choose a topic from the examples below, or come up with your own.
Hospital 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
After selecting and identifying your topic, complete the following:
List at least two entities and identify primary key for each entity. Use shorthand representation shown on page 32 of Concepts of Database Management. Underline the primary key for each table.
List attributes 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.
Identify the foreign key. 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.