Database Design:

(Please make a hospital database with a conceptual schema that is an ER/EER model)

Instructions:

Please give all the relations (tables) in the database being designed for your own project case. For each relation, it should have a name and a list of all the relation attributes. Please underline the chosen primary key attribute(s) for each relation. Please indicate all foreign keys clearly. For each foreign key, please indicate which attribute of which table is the referenced key that this foreign key references. You can either use arrows or write the information out in words.

A sample relation is:

STUDENT(Student_ID, Student_name, Student_Home_Addr, Student_email_addr)