[solved]-56u Convert Dental Office Diagram Create Relational Schema Following Diagrams Using Follow Q38991954

5.6u Convert Dental Office Diagram

Create a relational schema for each of the following diagramsusing the following notation:

Table names are shown in boldface with attributes listed inparentheses. Primary key are underlined. Forigen keys are indicatedby a separate statement that indicartes the table referenced on theline immediately following the attribute list.

Here is an example:

Department (DepartmentID, DepartmentName,ManagerID)
   ManagerID references Employee

Employee (EmployeeID, FirstName, LastName,HireDate, DepartmentID)
DepartmentID references Department

PerformanceReview (ReviewID, ReviewDate,ReviewScore, Notes, EmployeeID, ManagerID)
EmployeeID references Employee
ManagerID references Employee

Procedure Appointment 1,.* 0..* ProcedureID AppointmentID DateTime ProcedureName Desciption NominalCost Service 0..* ActualCost is for O.. 1..1 done on Patient 1 * PatientlD Tooth Name ToothNumber Address ToothType Phone Show transcribed image text Procedure Appointment 1,.* 0..* ProcedureID AppointmentID DateTime ProcedureName Desciption NominalCost Service 0..* ActualCost is for O.. 1..1 done on Patient 1 * PatientlD Tooth Name ToothNumber Address ToothType Phone

Expert Answer

---

Answer to 5.6u Convert Dental Office Diagram Create a relational schema for each of the following diagrams using the following not… . . .