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...
-
A body of mass m is hauled from the Earth's surface by applying a force F varying with the height of ascent y as F = 2 (ay = 1) mg, where a is a positive constant. Find the work performed by this...
-
The monthly income of investor is $9,000 per month, and up to 30% of the family income can be used to pay back a mortgage loan . His bank offers him a 30-year mortgage loan with a 2.5% interest rate....
-
Amy commutes to work by two different routes A and B. If she comes home by route A, then she will be home no later than 6 P.M. with probability 0.8, but if she comes home by route B, then she will be...
-
Foghorn Leghorn is considering the replacement of an old egg-sorting machine used with his Foggy's Farm Fresh Eggs business. The old ,egg machine is not quite running eggs actly the way it was...
-
You've been provided the demand and supply equation for a Sydney transport company. P = 300e-0.2Qa P = 2e0.80s Where P, Qa, and Qs denote the price and quantity demanded and quantity supplied,...
-
The trial balance of Racer Internet at March 31, 2012, follows: Adjustment data at March, 31, 2012 a. Unearned service revenue still unearned, $500. b. Prepaid rent still in force, $2,000. c....
-
The basic function of the transformer is to change: The frequency. The power factor. The power level. The level of the voltage. Clear my choice
-
Prepare Form 1040, Sch. 1, Sch. A, Sch. E, Sch. SE and the Qualified Dividends and Capital Gain Tax Worksheet for 2021 for Ryan and Rebecca Reed. No other forms are required. Although these forms...
-
Question 2: T1=1 sec T2=1 sec TO= 1 sec. Process start with the press of button and continuously repeats in the cycle. Draw a ladder diagram TO/2 T1. T2 TOr2 TO12 T1 T2 TO12
-
b) The notch filter shown in Fig. Q4(b) has a transfer function given by +(R V V where p=- s+ R By comparing this transfer function to the general transfer function of the R + R notch filter, write...
-
Develop a menu driven complete program that can perform the illustrated features in Figure 1. This program works for an individual user (i.e. student) only; it can generate the transcript of the...
-
(4) For this question, you are required to use the DESMOS Graph calculator (time Evolution of superposed Wavefunction) and answer the following questions. a) Set n = 1, m = 2 and c = 1.0. Increase...
-
You sold your lakeside cabin and provided seller-financing to the buyer through a $100,000 mortgage, which has a ten-year life, an 8% interest rate and semi-annual mortgage payments. Assume the sale...
-
Why do bars offer free peanuts?
-
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...
-
A \(0.010-\mathrm{kg}\) bullet is fired from a \(5.0-\mathrm{kg}\) gun with a muzzle velocity of \(250 \mathrm{~m} / \mathrm{s}\). (a) While the bullet is traveling in the barrel, what is the ratio...
-
A \(1500-\mathrm{kg}\) car going at \(6.32 \mathrm{~m} / \mathrm{s}\) collides with a \(3000-\mathrm{kg}\) truck at rest. If the collision is totally inelastic and takes place over an interval of...
-
On a low-friction track, a \(0.66-\mathrm{kg}\) cart initially going at \(1.85 \mathrm{~m} / \mathrm{s}\) to the right collides with a cart of unknown inertia initially going at \(2.17 \mathrm{~m} /...
Study smarter with the SolutionInn App