Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What are continental rises?

Answered: 1 week ago

Question

What is its position?

Answered: 1 week ago

Question

What are the organizations relationship goals on this issue?

Answered: 1 week ago