Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 DoctorEmployee: 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 DoctorNursePerforms: between Doctor and Operation.Undergoes: between Patient and Operation The degree with respect to each relationship type is as follows:Manages: Binary relationship Doctor and DepartmentWorks for: Binary relationship Employee and DepartmentSupervises: Binary relationship Employee and EmployeeMakes appointment with: Binary relationship Patient and DoctorNursePerforms: Binary relationship Doctor and OperationUndergoes: Binary relationship Patient and Operation 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started