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:
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. 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.
Expert 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 1138, use the given conditions to write an equation for each line in point-slope form and slope-intercept form. Slope = 2, passing through (3, 5)
-
Determine the moment of inertia and the radius of gyration of the shaded area shown with respect to the x axis. y =-mx y =mx. y=-kr y= kr3
-
Given the block diagram of a system shown in Figure P5.8, find the transfer function G(s) = 22 (s)/ 11 (s). O1 (s) +7 021 (s) G|(s) G2(s) G3(8) G-(s) O12 (s) + O22 (s) G4(s) G5(3) G6(s) FIGURE P5.8
-
Use the wine quality data in Table B. 11 to construct a regression model for quality using the stepwise regression approach. Compare this model to the one you found in Problem 10.4, part a. Data From...
-
The following transactions of Harmony Music Company occurred during 2010 and 2011: 2010 Mar 3 Purchased a piano (inventory) for $70,000, signing a six-month, 4% note payable. May 31 Borrowed $75,000...
-
Demand for single occupancy apartments is Qd=400,000-250 P. Supply is given by Qs = 200,000 + 250 P. The price of an apartment is measured in hundreds of dollars and quantity is measured in thousands...
-
Health Care Systems of Florida (HCSF) is planning to build a number of new emergency-care clinics in central Florida. HCSF management has divided a map of the area into seven regions. They want to...
-
Identify what type of property rights attach to the following (if any): a pond or swimming pool (dug into the ground) Select one: a. Real Property b. Personal Property c. Copyright d. Not protected...
-
One of the activities that are included in project risk management involves the identification of project risks. Examine the various tools and techniques that can be utilised in risk identification....
-
How do emerging trends such as quantum computing, biometric authentication, and Internet of Things (IoT) devices influence the future trajectory of Electronic Funds Transfer (EFT) systems, reshaping...
-
Mostly cloudy Room Operating Costs $2,012.000 Depreciation Expense $964,000 Property Taxes Expense $358,000 Management Salaries $413,000 Other Operating Costs $2,361,000 Total Operating Costs...
-
What is the result of adjusting gross requirements for inventory on hand and scheduled receipts?
-
At December 31, 2010, the stockholders' equity of Gost Corporation and its 80%-owned subsidiary, Tree Corporation, are as follows: Common stock, $10 par Retained earnings Totals value Gost $20,000...
-
In a perfectly competitive market, the process of entry and exit will end when firms face O a. marginal revenue equal to the long-run average total cost. b. total revenue equal to the average total...
-
Refer to the data for problem 13-36 regarding Long Beach Pharmaceutical Company. Required: Compute each division's residual income for the year under each of the following assumptions about the...
-
1. What are some of the symptoms of fraud in this case? 2. What questions would you ask yourself about fraud symptoms that might help you investigate this fraud? 3. Why would an undercover operation...
-
You are a manager for a large department store. It has recently come to light that a receiving clerk has been stealing merchandise. About $5,000 has been stolen. The clerk has stopped stealing, and...
-
1. Ghost employee schemes usually generate the largest losses among the payroll disbursement fraud schemes. 2. Corruption is divided into four fraud scheme types: (1) Bribery, (2) Conflict of...
-
For the periodic processes shown below: a. Schedule the processes using an RMS policy. b. Schedule the processes using an EDF policy. In each case, compute the schedule for an interval equal to the...
-
For the periodic processes and deadlines given below: a. Schedule the processes using RMS. b. Schedule using EDF and compare the number of context switches required for EDF and RMS Process Time...
-
For the periodic processes given below, find a valid schedule a. using standard RMS; b. adding one unit of overhead for each context switch. 22 P2 P1 P3 Process P1 P2 P3 Time Deadline 2 30 57 40 120...
Study smarter with the SolutionInn App