Question 2 (18 marks, 3 marks each) A university database contains information about professors (identified by...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 2 (18 marks, 3 marks each) A university database contains information about professors (identified by ssn) and courses (identified by courseid). Professors teach courses; each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it (assuming that no further constraints hold) and using CREATE TABLE to model the information in the ER diagram. 1. Professors can teach the same course in several semesters, and each offering must be recorded. 2. Professors can teach the same course in several semesters, and only the most recent such offering needs to be recorded. (Assume this condition applies in all subsequent questions.) 3. Every professor must teach some course. 4. Every professor teaches exactly one course (no more, no less). 5. Every professor teaches exactly one course (no more, no less), and every course must be taught by some professor. 6. Now suppose that certain courses can be taught by a team of professors jointly, but it is possible that no one professor in a team can teach the course. Model this situation, introducing additional entity sets and relationship sets if necessary. Question 2 (18 marks, 3 marks each) A university database contains information about professors (identified by ssn) and courses (identified by courseid). Professors teach courses; each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it (assuming that no further constraints hold) and using CREATE TABLE to model the information in the ER diagram. 1. Professors can teach the same course in several semesters, and each offering must be recorded. 2. Professors can teach the same course in several semesters, and only the most recent such offering needs to be recorded. (Assume this condition applies in all subsequent questions.) 3. Every professor must teach some course. 4. Every professor teaches exactly one course (no more, no less). 5. Every professor teaches exactly one course (no more, no less), and every course must be taught by some professor. 6. Now suppose that certain courses can be taught by a team of professors jointly, but it is possible that no one professor in a team can teach the course. Model this situation, introducing additional entity sets and relationship sets if necessary.
Expert Answer:
Related Book For
Quantitative Methods for Business
ISBN: 978-1285866314
13th edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Posted Date:
Students also viewed these programming questions
-
32) What does the Force of Gravity (governed by the Law of Universal Gravitation) between two masses depend upon? mass 1 mass 2, and distance (radius) Fg Gm, m 2 = Force on m2 by m1 = 7.42 10-10 N 2...
-
Required 1 . ?Prepare and complete a 1 0 - column work sheet for the current fiscal year, starting with the unadjusted trial balance and including adjustments using the following additional...
-
The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here's the...
-
Create a use case diagram that would illustrate the use cases for the following dentist office system: Whenever new patients are seen for the first time, they complete a patient information form that...
-
Cola, approximated as pure water at 20C, is to fill an 8-oz container (1 U.S. gal =128 fl oz) through a 5-mm-diameter tube. Estimate the minimum filling time if the tube flow is to remain laminar....
-
Dexter Company's bank reconciliation shows adjusted cash balance of $3,254.33. The following items also appear on the reconciliation: NSF check ................ $110.50 Deposit in transit...
-
Choose the brittle marterial. (a) Mild steel (b) Cast iron (c) Aluminium (d) Copper
-
On May 1, Jeff Wilkins started Skyline Flying School, a company that provides flying lessons, by investing $45,000 cash in the business. Following are the assets and liabilities of the company on May...
-
Question 1. From the research for this terms Crisis Management Team Assignment - Taylor swift and Ticket Master Crisis a. Explaining, with some detail, three (3) specific things that the leader(s) in...
-
onsider the model of the electrically heated stirred-tank system in Section 2.4.3. Subscript e refers to the heating element: (a) Derive transfer functions relating changes in outlet temperature T to...
-
The ideal air to fuel ratio for an engine is 14.8:1. If a vehicle burns 7 lb of fuel, how many pounds of air should it draw to achieve the ideal ratio
-
A company sells a piece of real estate it owns and receives $20.0 million in cash which includes a reported gain on sale of $1.5 million on its income statement. How would the statement of cash flows...
-
A person shared an article promoting the company they work for on Facebook early in the morning at work on their personal page. Their boss sees the post and commented on it. Someone leaves a negative...
-
5. A 4.7 x 10-15 kg oil drop hangs between two parallel plates. a. Calculate the oil drop's charge. b. Calculate the electron excess or deficit in the drop. 0.21 cm ++++ ++++ 220 V + +
-
Mai, age 40, is leaving the workforce. The average life expectancy for a 40-year old female is age 90. She has the opportunity to commute the value of her pension. Assuming an expected rate of return...
-
Write a 3-5 page paper explaining what palliative care is and what the role of a palliative care team is. Consider aspects of care such as: client preferences and choicesfor care, end of life and...
-
Assume that instead of 2 par value shares, Hydro-Slide SA has 5 stated value no-par shares and the company issues 8,000 shares at 7 per share for cash. The journal entry is: a. Cash (Dr) 56,000 Share...
-
Teasdale Inc. manufactures and sells commercial and residential security equipment. The comparative unclassified balance sheets for December 31, 2015 and 2014 are provided below. Selected missing...
-
Using the return data in Table 12.10, construct a portfolio from Apple, AMD, and Oracle that matches the Information Technology S&P index as closely as possible. Use the return data for the...
-
Suppose that the point spread for a particular sporting event is 10 points and that with this spread you are convinced you would have a 0.60 probability of winning a bet on your team. However, the...
-
Consider the following mixed-integer linear program: Max 2x1 + 3x2 s.t. 4x1 + 9x2 ( 36 7x1 + 5x2 ( 35 x1, x2 ( 0 and x1 integer a. Graph the constraints for this problem. Indicate on your graph all...
-
Why are none of the bulbs in Figure 31. 24 lit? Data from Figure 31. 24 Figure 31.24 (1) (iii) NNN
-
In Figure 31. 25, identify the energy conversions that occur between points \(A\) and \(B, B\) and \(\mathrm{C}, \mathrm{C}\) and \(\mathrm{D}\), and \(\mathrm{D}\) and \(\mathrm{A}\). Data from...
-
In Figure 31. 26, bulb B is brighter than bulb C, which in turn is brighter than bulb A. Rank, largest first, \((a)\) the magnitudes of the potential differences across the bulbs, \((b)\) the...
Study smarter with the SolutionInn App