Question: 1 . 1 . The entity types, relationship types, and corresponding attributes are as follows:Entity Types: Department, Employee, Patient, Operation, Acquaintance.Attributes:Department: ID , Name, Phone

1.1. The entity types, relationship types, and corresponding attributes are as follows:Entity Types: Department, Employee, Patient, Operation, Acquaintance.Attributes:Department: ID, Name, Phone Number, Locations, Manager (Doctor).Employee: Name, Social Security Number, Job Type, Salary, Address, Office Phone Number, Cell Phone Number, Gender, Age, Birth Date, Department.Patient: Name, ID, Social Security Number, Gender, Birth Date, Blood Type, Home Address, Acquaintance Information.Operation: ID, Name, Time, Location, Doctors, Nurses, Patient.Acquaintance: Name, Relationship, Phone Number.Relationship Types:Manages: between Doctor and Department.Works for: between Employee and Department.Supervises: between Employee and Employee.Makes appointment with: between Patient and Doctor/Nurse.Performs: between Doctor and Operation.Undergoes: between Patient and Operation.1.2. The degree with respect to each relationship type is as follows:Manages: Binary relationship (Doctor and Department).Works for: Binary relationship (Employee and Department).Supervises: Binary relationship (Employee and Employee).Makes appointment with: Binary relationship (Patient and Doctor/Nurse).Performs: Binary relationship (Doctor and Operation).Undergoes: Binary relationship (Patient and Operation).1.3. The structural constraints of all the relationship types are as follows:Manages: Each department is managed by one doctor, and a doctor can manage only one department.Works for: Each employee works for one department, and a department can have multiple employees.Supervises: An employee can supervise multiple employees, but each employee is supervised by only one employee.Makes appointment with: A patient can make multiple appointments with doctors or nurses, and a doctor or nurse can have appointments with multiple patients.Performs: A doctor can perform multiple operations, and an operation can be performed by multiple doctors.Undergoes: A patient can undergo multiple operations, and an operation can be undergone by multiple patients.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!