Consider the following relations for a database that keeps track of visits of various doctors working...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following relations for a database that keeps track of visits of various doctors working for a group of hospitals, to various hospitals under the group: DOCTORS(DSsn, Name, Start year, Dept_no, location) VISIT(DSsn, From_hospital, To_hospital, Departure_date, Return date, Visit_id) EXPENSE(Visit id, Account#, Amount) (a) | 25 points] How can you create the table using SQL? Also, show us how you can insert five data values (at least three with the location name New York). (b) | 15 points] Identify different database keys for this schema, draw the schema diagram, stating any assumptions you make. (c) 10 points] Write the SQL to list the doctors in New York in descending order by name. Consider the following relations for a database that keeps track of visits of various doctors working for a group of hospitals, to various hospitals under the group: DOCTORS(DSsn, Name, Start year, Dept_no, location) VISIT(DSsn, From_hospital, To_hospital, Departure_date, Return date, Visit_id) EXPENSE(Visit id, Account#, Amount) (a) | 25 points] How can you create the table using SQL? Also, show us how you can insert five data values (at least three with the location name New York). (b) | 15 points] Identify different database keys for this schema, draw the schema diagram, stating any assumptions you make. (c) 10 points] Write the SQL to list the doctors in New York in descending order by name.
Expert Answer:
Posted Date:
Students also viewed these programming questions
-
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (SSN, From_City, To_City,...
-
Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate) COURSE (Course#, Quarter,...
-
Operating Rules. Indicate whether the following statements are true or false. If the statement is false, explain why. a. Since most corporations make distributions only when they are profitable and...
-
Tango Corporation, a calendar year taxpayer, has been an S corporation for several years. Tangos business activities have become very profitable in recent years. On June 16, 2015, its sole...
-
UMPI Corporation manufactures and sells mini robots, a seasonal product that has peak sales in the 3rd quarter. The following information is related to the operations for Year 2 (the upcoming year)...
-
Describe three reasons why independent auditors are the appropriate group to provide the potential investor with an unbiased opinion as to whether the financial statements are fairly presented.
-
Oscars Bowling Inc. wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys, It. however, only has enough capital to build one facility. Oscar...
-
The following transactions have been journalized and posted to the proper accounts: i . Edward Wilson invested $ 8 , 0 0 0 cash in his new landscaping business. ii . The business paid the first...
-
Outline the planning process used in investment appraisal in the public sector and discuss the main factors (qualitative and quantitative) that need to be considered when assessing investments in the...
-
Research legislation that has occurred within the last 5 years at the Texas or federal level as a result of nurse advocacy. Describe the legislation and what was accomplished. What additional steps...
-
PLEASE HELP ME MY CANCEL BUTTON AND TRY BUTTON DO THE SAME THING I WANT MY CANCEL BUTTON TO CLOSE MY PROGRAM/FRAME import java.awt. * ; import javax.swing. * ; import java.awt.event. * ; import...
-
BrockChilton is a small-medium auditing firm that specialises in auditing retirement villages. BrockChilton is currently auditing the accounts of Ventnor Retirement Village, a place where Jenny...
-
Capital assets are important in all businesses because they represent significant investments. How are capital assets accounted for in government and not-for-profit organizations? Provide examples....
-
Use the following items taken from the financial statements of the Postal Service for the year ending December 31, 2012Accounts payable $ 9,000 Accounts receivable 11,000 Accumulated depreciation -...
-
Doug, the owner of a miniature golf course must make several business decisions soon. Is the fee for playing a golf game high enough to cover the related cost? What costs can be reduced to make the...
-
Hardin Services Co. experienced the following events in 2016: 1. Provided services on account. 2. Collected cash for accounts receivable. 3. Attempted to collect an account and, when unsuccessful,...
-
One of the blades of an electric fan is removed. The steel shaft \(A B\), on which the blades are mounted, is equivalent to a uniform shaft of diameter \(25 \mathrm{~mm}\) and length \(150...
-
A steel shaft of \(0.05 \mathrm{~m}\) diameter and \(2 \mathrm{~m}\) length is fixed at one end and carries at the other end a steel disc of \(1 \mathrm{~m}\) diameter and \(0.1 \mathrm{~m}\)...
-
A cylinder of mass \(m\) and mass moment of inertia \(J_{0}\) is free to roll without slipping but is restrained by two springs of stiffnesses \(k_{1}\) and \(k_{2}\), as shown in Fig. 2.103. Find...
Study smarter with the SolutionInn App