Question: When designing an E-R diagram for a particular enterprise, you have several alternatives from which to choose. a. What criteria should you consider in making

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

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.

Step by Step Solution

★★★★★

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The criteria to use are intuitive design accurate expression of the realworld concept and efficien... 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 (102).docx

120 KBs Word File

Students Have Also Explored These Related Databases 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...

Choose the correct answer I have one hour only I want last answer for example: Q1: a, Q2:c In the process of making a decision, you have identified the opportunities and problems in that particular...

Chapter 2 The Origins of Software Chapter Overview Make an overview of the primary purposes of this chapter. What is the main concept introduced in this chapter? What kind of strategies should...

can you please answers all multiple choice answers please. Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman Chapter 6 DEVELOPING AND IMPLEMENTING EFFECTIVE...

STRATEGY How Companies Become Platform Leaders Under the right circumstances, * companies of any size can grow to become platform leaders. And particular business and technology decisions can help...

Conduct an internet search to find an organization that lists its mission and vision statement on its website. What do the mission and vision statements communicate? How might the organization use...

To read the article describing the components of Payn'e CRM Framework The link below also describes the framework and gives you some insights in relation to how to apply it...

Q1. review case study #1 Understanding Your Employee Benefits: Investing in your Retirement found on page 123 of your textbook. Please post your answers to the two questions found at the end of the...

MTT Custom Classics uses a job costing system. Overhead is applied on the basis of direct material cost. The overhead rate used is 200% of direct labor cost. The following is an incomplete Cost of...

Rascal, Inc., has an issue of preferred stock outstanding that pays a $9.7 dividend every year in perpetuity. If this issue currently sells for $90.35 pershare, the required return is ___________...

8. When T d = 0, the PD controller reduces to a proportional controller, G s c ( ) = K . In this case, use the Nyquist plot to determine the limiting value of K for closed-loop stability. a. K = 0.5...

Arrange the following elements in order of increasing electronegativity: carbon , fluorine , oxygen , nitrogen

Tony is 55 years old and has been an alcoholic for years. Suddenly today he cannot remember how old he is or how to get to back to his house. He is unable to see clearly to read his newspaper. When...

Dorothy is 67 years old and lives alone with her Maltese Terrier named Fred. Her breakfast consists of mainly toast and tea. She has usually has a tomato sandwich with a spinach salad for lunch. For...

5) Sam is in his second year of college enjoying his freedom from his nagging mom. Since he has been living on his own, he eats anything he wants to. He rarely eats any vegetables. He has bacon &...

Tracy is a 20-year old college student that has started a new diet to lose weight. She has sworn off meat and bread. She eats some vegetables like lettuce and corn but avoids potatoes and spinach....

In testing a hypothesis about the difference between two proportions, the p-value is computed to be 0.034. The null hypothesis should be rejected if the chosen level of significance is 0.01.

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...

Our discussion of lossless decomposition implicitly assumed that attributes on the left-hand side of a functional dependency cannot take on null values. What could go wrong on decomposition, if this...

Show that there can be more than one canonical cover for a given set of functional dependencies, using the following set of dependencies: X YZ, Y XZ, and Z XY.

for question with dropdowns 1. 82000/92400/50400/33600 2.120960/201600/84000/80640 3. posion pill/ a proxy/ a takeover/ dilution 4. proxy/ preemptive right 5.75600/100800/101800/151200 1. Rights and...