When designing an E-R diagram for a particular enterprise, you have several alternatives from which to choose.

Question:

a. What criteria should you consider in making the appropriate choice?

b. Design three alternative E-R diagrams to represent the university registrar’s office of Exercise 2.4. List the merits of each. Argue in favor of one of the alternatives.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

See More Books

Question Posted: Jan 28, 2011 05:54 AM

See More Questions

What factors should Eugenio Costa consider in making the choice among various types of Medicare: Medicare, Medigap, or HMO health care insurance policies?
The phasor diagram for a particular RLC series circuit is shown in the figure. If the circuit has a resistance of 100 Î© and is driven at a frequency of 60 Hz, find (a) The current...
ERP software has thousands of options from which to choose when the software is configured so that the system can be tailored to the special characteristics of each company. Why couldn't an ERP be...
$ 45.00 Direct material: 5 pounds at $9.00 per pound Direct labor: 3 hours at $14 per hour Variable overhead: 3 hours at $9 per hour Total standard variable cost per unit 42.00 27.00 $114.00 The...
Refer to E8-28A. InteliSystems needs 79,000 optical switches next year (assume same relevant range). By outsourcing them, InteliSystems can use its idle facilities to manufacture another product that...
Tyva makes a very popular undyed cloth sandal in one style, but in Regular and Deluxe. The Regular sandals have cloth soles and the Deluxe sandals have cloth-covered wooden soles. Tyva is preparing...
Identify the important legal provisions governing information security and privacy in your country.
In January 2009, the company made $24,000 in expenditures. These expenditures should have been expensed immediately. Instead, the company recorded this $24,000 payment as a purchase of equipment with...
A local manufacturer produces two different products on the same production line. Product A requires .5 hours of labor while product B requires .8 hours of labor. The total labor available in any one...
How many check bits are needed if the Hamming error correction code is used to detect single bit errors in a 1024-bit data word?
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,...
An E-R diagram can be viewed as a graph. What do the following mean in terms of the structure of an enterprise schema? a. The graph is disconnected. b. The graph is acyclic.
A meter stick moves parallel to its length with speed v = 0.6c relative to you. (a) Compute the length of the stick measured by you. (b) How long does it take for the stick to pass you? (c) Draw a...
The most recent financial statements for Alexander Company are shown here: Income Statement Balance Sheet Sales Costs $ 45,000 28,800 Current assets $70,470 Long-term debt $ 48,600 Fixed assets...
The figure below shows two blocks connected by a string of negligible mass passing over a frictionless pulley. m = 3.6 kg and 0 = 12.0. Assume that the incline is smooth. m m (a) For what value of m...
The following image represents the ruler when the list in your document is selected. Which of the options is true about the resulting table? 2 3 1 Y . 1 . O The data in the Region column is...
1) what was the alpha for DISH Network during this period? 2) What was Alphabet's beta (to two decimal places) during this period? 3) What is the r-squared (in percentage terms, to two decimal...
You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and...
Fabric Wholesalers Ltd operates three departments. The accessories department has not been performing very well and has shown a loss for the past 3 years according to the companys income statement....
on 8 For the following set of lengths 130, 170, 160, 160, 150, 190 Third quartile is: et red d out of Select one: O a. 160 a question O b. 145 O c. 175 O d. 180
Whats the difference between discrimination and generalization?
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
An E-R diagram usually models the state of an enterprise at a point in time. Suppose we wish to track temporal changes, that is, changes to data over time. For example, Zhang may have been a student...
York's outstanding stock consists of 80,000 shares of cumulative 7.5% preferred stock with a $5 par value and also 200,000 shares of common stock with a $1 par value. During its first four years of...
Hudson Community College enrolls students in two departments, Liberal Arts and Sciences. The college also has two service departments, the Library and the Computing Services Department. The usage of...
Robert is designing a new Active Directory Domain Services infrastructure for a company called Litware, Inc., which has its headquarters in New York and two additional offices in London and Tokyo....

When designing an E-R diagram for a particular enterprise, you have several alternatives from which to choose.

Question:

Step by Step Answer:

a The criteria to use are intuitive design accurate expression of the realworld concept and efficien...View the full answer

Database System Concepts

Students also viewed these Computer Sciences questions