Consider the following ERD for a Dental Clinic and solve the following questions. Dentist PK dentNum:...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Consider the following ERD for a Dental Clinic and solve the following questions. Dentist PK dentNum: char(5)](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64ff026eb63cf_1694433900841.jpg)
![Section C: PL/SQL (8marks) 1. Write a procedure called patient_delete_procedure to delete the patient](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64ff027fa8eb5_1694433918854.jpg)
![Sign in to edit and save changes to this file. Dentist PK dentNum: char(5) grade: char(2) denName:](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64ff028f529f1_1694433934258.jpg)
Transcribed Image Text:
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. Section C: PL/SQL (8marks) 1. Write a procedure called patient_delete_procedure to delete the patient "ahmed102 once he gets well, given the patient number as a parameter. Then test the procedure. (4marks) 2. Code a function called Dentist Services Function to return the number of years of services of a given dentist. (4marks) Sign in to edit and save changes to this file. 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 FK FK patNum:char(6) dentNum: char(5) nursNum: char(5) Procedure PK proNum:char(10) description:varchar(200) cost decimal(9,2) has contains AppointmentDetails PK appNum:char(5) PK proNum:char(10) date: date FK appNum:char(5) FK proNum:char(10) Sign in 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. Section C: PL/SQL (8marks) 1. Write a procedure called patient_delete_procedure to delete the patient "ahmed102 once he gets well, given the patient number as a parameter. Then test the procedure. (4marks) 2. Code a function called Dentist Services Function to return the number of years of services of a given dentist. (4marks) Sign in to edit and save changes to this file. 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 FK FK patNum:char(6) dentNum: char(5) nursNum: char(5) Procedure PK proNum:char(10) description:varchar(200) cost decimal(9,2) has contains AppointmentDetails PK appNum:char(5) PK proNum:char(10) date: date FK appNum:char(5) FK proNum:char(10) Sign in
Expert Answer:
Answer rating: 100% (QA)
To fulfill the requirements presented in the question images well break down the tasks into several parts First well address Section A and Section C a... View the full answer
Related Book For
Fraud examination
ISBN: 978-0538470841
4th edition
Authors: Steve Albrecht, Chad Albrecht, Conan Albrecht, Mark zimbelma
Posted Date:
Students also viewed these databases questions
-
Thad, a single taxpayer, has taxable income before the QBI deduction of $201,000. Thad, a CPA, operates an accounting practice as a single member LLC (which he reports as a sole proprietorship)....
-
What are the major resource dependencies for high-end restaurants? Who do they depend on most for the critical resources needed to survive? 2) The high-end restaurants appear almost helpless at the...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
In Exercises solve the first-order differential equation by any appropriate method. y' = 2x1 - y
-
Find fY (y) if f X,Y (x, y) = 2exey for x and y defined over the shaded region pictured. y=x
-
Correct the definition of the italicized term without reference to the text, if correction is needed, so that it is in a form acceptable for publication. The rank of a free abelian group G is the...
-
Noventis Corporation prepared the following estimates for the four quarters of the current year: LO3 First Second Third Fourth Quarter Quarter Quarter Quarter Sales. . . $1,000,000 $1,200,000...
-
Dana Baird was manager of a new Medical Supplies Division. She had just finished her second year and had been visiting with the companys vice president of operations. In the first year, the operating...
-
QUESTIONS (25 MARKS) Johnson Company set the following standard unit costs for its single product. RM Direct materials (7kg RM5 per kg) 25 Direct labore (Shrs RM10 per lur) 30 Factory...
-
Simulation can be used to illustrate a number of results from statistics that are difficult to understand with non-simulation arguments. One is the famous central limit theorem, which says that if...
-
In a successful manufacturing organization, what is the relationship between all elements, including the line and support functions? Question 21Select one: a. Sequential b. Interdependent c....
-
Go to: https://www.instagram.com/ryderseyewear/ on your desktop, laptop, or mobile (or a combination of all 3). You are the new Social Media Marketing Manager for Ryders Eyewear. You've been asked...
-
As leaders, it is very important that we have the ability to assess our own motivation and the motivation of others around us. It is also important to recognize the key factors involved in...
-
At the end of this exam, you will find Article 1 - " How Companies Can Prepare for a Long Run of High Inflation ". Please read the article and, when necessary, consult additional sources and the...
-
You can develop your capabilities as a manger by better understanding different ways of motivating and rewarding employees. You can also better prepare for your own career by better understanding the...
-
Topic: Project Malasakit of Kara David https://projectmalasakit.org/ What is the pros and cons of these alternative courses of the action below: Strengthen the internal organization via promoting it...
-
Please explain ! Required information (The following information applies to the questions displayed below.) Yi Min started an engineering firm called Min Engineering. He began operations and...
-
Willingness to pay as a measure of a person's value for a particular good measures the maximum a person would be willing to pay requires that payment actually be made depends on the satisfaction that...
-
Jason works at a new software development company. The company has been in existence for only two years. Since the company is new, everybody is working extra hours and spending all of their time...
-
Peter Jones, a senior accountant, and Mary Miller, a junior accountant, were the only accountants for XYZ Company, a medium-size business. Peter had been with the company for over four years and was...
-
What are the three different categories into which disclosure frauds can be categorized?
-
2. Modifying organizational structure to fit the communication needs of the organization
-
1. Clarifying and defining jobs
-
8. Can paperwork regarding this job be eliminated?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App