Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following ERD for a Dental Clinic and solve the following questions. Dentist PK dentNum: char(5) grade: char(2) denName: vrachar(25) address: varchar(25) yearsOfService:
Consider the following ERD for a Dental Clinic and solve the following questions. Dentist PK dentNum: char(5) grade: char(2) denName: vrachar(25) address: varchar(25) yearsOfService: char(2) Nurse PK nursNum: char(5) grade: char(2) nursName: varchar(25) address: varchar(25) Patient PK patNum:char(6) patName varchar(25) address varchar(25) age: char(3) has has can take Appointment PK appNum: char(5) date date dateOfStartTreatment date dateOfEndTreatment date FK dentNum: char(5) FK nursNum: char(5) FK patNum:char(6) Procedure PK proNum:char(10) Section A: DDL and Relational Algebra description varchar(200) cost decimal(0,2) has contains AppointmentDetails PK appNum:char(5) PK proNum:char(10) date: date FK appNum char(5) FK proNum char(10) (7marks) 1. Create the database by using SQL DDL commands and fill the tables with at least 3 rows. (5marks) 2. Code solutions to the following problems as a relational-algebraic expression: (2marks) a. Display all patients' names who have an appointment on 1-1-2020 b. Find dentists number and name who have 10 years of service and living in Muscat.
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