Question: Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes

Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as

• Course with attributes name, department, and c-number

• Section with attributes s-number and enrollment, and dependent as a weak entity set on course

• Room with attributes r-number, capacity, and building

a. Show an E-R diagram illustrating the use of all three additional entity sets listed.

b. Explain what application characteristics would influence a decision to include or not to include each of the additional entity sets

Step by Step Solution

★★★★★

3.42 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a See Figure below b The additional entity sets are useful if we wish to st... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

16-CS-DB (101).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

As production manager, you are responsible for the scheduling of workers and machines in the manufacturing process. At the end of the day, you will learn how many seat covers were produced. a....

A large university administers entrance exams to all entering students. The test is administered again as an exit exam for all graduates. The test results forgone group of students are: a. The scores...

Consider an entity type SECTION in a UNIVERSITY database, which describes the section offerings of courses. The attributes of SECTION are SectionNumber, Semester, Year, CourseNumber, Instructor,...

Question 0.4 1210 - 20Marks 4.1. Design a generalization specialization hierarchy for a motor-vrile sales company. The company sells motorcycles, passenger cars, Vans, and buses. Justify your...

Q.4. 4.1. Design a generalization-specialization hierarchy for a motor vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attributes at...

If it takes 50 mL of 0.5 M KOH solution to completely neutralize 125 mL of HSO4 solution, what is the [HSO4]?

Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number,...

Problem 2. Convert the following angles to radians correct to 4 decimal places: (a) 5 (b) 40 (c) 85

In a titration with methyl orange as the indicator, 25.0 cm of sodium hydroxide solution required 27.85 cm of 0.0487 mol dm sulphuric acid to produce a colour change. Calculate the concentration of...

Consider a university database for the scheduling of classrooms for final exams. A course has a number and a name. A section has a name and can have 5 to 25 students. A student has a name and an id....

What is a preferred stock bailout? How does Sec. 306 operate to prevent a shareholder from realizing the otherwise available tax benefits of a preferred stock bailout?

Tests on a 10 kVA 11 000/240 V, 50 Hz single-phase distribution transformer gave the following results: Open-circuit-test 11 000 V, 70 W, 21.8 mA Short-circuit-test 310 V, 80 W, 0.9 A In both tests...

(16) Use either indirect proof or conditional proof to derive the conclusions of the following symbolized arguments. 1. (x)[(Ax Bx) Cx] 2. (x)(Ax Dx) (x)Ex / (x)Cx (x)Ex

The length of a covalent bond depends upon the size of the atoms and the bond order. For each pair of covalently bonded atoms, choose the one expected to have the shortest bond length. (A) P-Br (B)...

A. A main group element with the valence electron configuration 3s 2 3p 1 is in periodic group . It forms a monatomic ion with a charge of

Considering only ions with charges of +1, +2, -1 and -2, or neutral atoms, give the symbols for 4 species that are isoelectronic with the selenide ion , Se 2- .

A main group element with the valence electron configuration 4s 2 4p 5 is in periodic group ____. It forms a monatomic ion with a charge of______.

A researcher was interested in comparing the heights of women in two different countries. Independent simple random samples of 9 women from country B and 9 women from country A yielded the following...

In testing a hypothesis about the difference between two proportions, the Z test statistic is computed to be 2.04. The null hypothesis should be rejected if the chosen level of significance is 0.01...

Suppose the advisor relationship set were one-to-one. What extra constraints are required on the relation advisor to ensure that the one-to-one cardinality constraint is enforced?

Consider a many-to-one relationship R between entity sets A and B. Suppose the relation created from R is combined with the relation created from A. In SQL, attributes participating in a foreign key...

Consider a relation such as sec course, generated from a many-to-one relationship set sec course. Do the primary and foreign key constraints created on the relation enforce the many-to-one...

In SQL, foreign key constraints can reference only the primary key attributes of the referenced relation or other attributes declared to be a superkey using the unique constraint. As a result, total...

Consider the following lattice structure of generalization and specialization A X B Y C

Large semitrailer trucks cost $ 9 0 , 0 0 0 each. A trucking company buys such a truck and agrees to pay for it by a loan that will be amortized with 1 0 semiannual payments at 1 7 % compounded...