Answered step by step
Verified Expert Solution
Link Copied!

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

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

Fraud examination

Authors: Steve Albrecht, Chad Albrecht, Conan Albrecht, Mark zimbelma

4th edition

538470844, 978-0538470841

More Books

Students also viewed these Databases questions

Question

f. What subspecialties and specializations does the person list?

Answered: 1 week ago

Question

Define induction and what are its objectives ?

Answered: 1 week ago

Question

Discuss the techniques of job analysis.

Answered: 1 week ago

Question

How do we do subnetting in IPv6?Explain with a suitable example.

Answered: 1 week ago

Question

Explain the guideline for job description.

Answered: 1 week ago

Question

What is job description ? State the uses of job description.

Answered: 1 week ago