SQL LAB at Home 1

4. You have been hired by a regional hospital to create a database that will be used to store the information of the patients. Implementing the database will make the data easily accessible. The following ER diagram represents the relationship between the patient and the doctor.

The following list bescribes the entities,attributes,and relationship of the
preceding ER diagram:


* Entities-patient and Doctor
* Attributes of patient_Name,Patient_Id,and Date_admitted
* Attributes of Doctor-Doc_ID,Doc_Name, and Specialization
* Type of Relationship_ Many-to-many

5.Tom is working in an organization as a database administrator. Based on the hierarchy, the organization has multiple departments and each department has multiple employees. The following ER diagram represents the relationship between the departments and the employees.

The following listdescribes the entition,attributes,and relationship of the preceding ER diagram:


*  Entities - Department and Employee
*  Attributes of Department - DepID,DepName,and DepHead
*  Attributes of Employee -EmpID,EmpName,and DepID
*  Type of Relationship- Many-to-one

6. Lee Wong is the newly appointed database administrator at Standard bank. The management of this bank wants to computerize the process of banking. According to the bank's policy, one customer can have many accounts but one account cannot be shared by many customers. The following ER diagram represents the relationship between a customer and the accounts owned by a particular customer. In

The following list describes the entities, the attibues, and relationship of the
preceding ER diagram.
*  Entities- Customer and Account
*  Attributes of Customer- Customer Name, SSN Number,and Customer Address
*  Attributes of Account- Account Number and Balance
*  Type of Relationship - One-and-Many

7. Consider the following scenario: An author can write multiple books and a book can be written by more than one author. Identify the relationship between the author entity and the book entity and represent it with an ER Diagram.

8. Consider the following scenario: In a college, there are multiple departments. Each department has various faculty members. Only one of these faculty members holds the position of the Head of the Department. Identify the relationship between the faculty and the department and represent it with an ER Diagram.