Question: Suppose a college had one dormitory with many rooms. The DORMITORY entity, which is actually a dormitory room entity since there is only one dorm.

Suppose a college had one dormitory with many rooms. The DORMITORY entity, which is actually a “dormitory room” entity since there is only one dorm. Dormitory has the attributes room number and single/double (meaning there are private rooms and double rooms). Let us suppose the STUDENT entity in this case contains the attributes student number, student name, and telephone number. Draw the ER diagram in the Chen-like model linking the two entities. Name your relationships. Write the grammar for the relationship between the two entities.

Step by Step Solution

★★★★★

3.28 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

A student may live in a dormitory room ... 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

Students Have Also Explored These Related Database Design Using Entity Relationship Diagrams Questions!

AlwaysRain Irrigation, Inc. would like to determine capacity requirements for the next four years. Currently, two production lines are in place for making bronze and plastic sprinklers. Three types...

Complete the methodology by adding sample data to Figures 5.3, 5.5, and Exercises 5.1, 5.2, 5.3, and 5.4. FIGURE 5.3 Exercises 5.1 Draw an ER diagram (using the Chen-like model) for an entity called...

Suppose that a college had one dormitory with many rooms. The dormitory entity, which is a DORMITORY ROOM entity since there is only one dorm, has the attributes room number and single/double...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Exercise 5.2 Suppose that we reconsider our STUDENT example, and the only attributes of student are student number and name. Let us suppose that we have another entity called HIGH SCHOOL that is...

Exercise 5.3 Suppose that a college had one dormitory with many rooms. The DORMITORY entity, which is actually a dormitory room entity since there is only one dorm, has the attributes room number and...

Basic Probability 87 CHAPTER 4: BASIC PROBABILITY 1. If two events are collectively exhaustive, what is the probability that one or the other occurs? a) 0 b) 0.50 c) 1.00 d) Cannot be determined from...

1 WILMINGTON UNIVERSITY LIBRARY Business Continuity Plan (BCP) and Disaster Recovery Plan (DRP) 2 WILMU LIBRARY SERVICES 20,000 student population served 13 physical locations of access to university...

http://scholar.google.com/scholar_case? case=7296890772230669764&hl=en&as_sdt=6&as_vis=1&oi=scholarr WebImagesMore... Sign in Baldwin v. Zoradi, 123 Cal. App. 3d 275 - Cal: Court of Appeal, 5th...

23 Nickel and Dimed: On (Not) Getting By in America BARBARA EHRENREICH Major changes in welfare legislation in 1996 eliminated cash payments to millions of America's poor, requiring them to find...

From 1998-2006 there were four large, well-funded competitors in the regional theme park industry. In order: Six Flags, Cedar Fair, Paramount Parks, and Busch Entertainment. Of these, Cedar Fair was...

NA Forest Resources purchased forest acreage for $500,000 from which an estimated 200 million board feet of lumber is recoverable. The company will sell the lumber for $0.10 per board foot. No lumber...

Jake Black has an opportunity to start an automobile pollution inspection business. After extensive studies, he has developed the following set of projected annual data on which to make his decision:...

Her Company traded machinery with a book value of $ 7 6 0 , 0 0 0 ( cost basis $ 1 , 0 0 0 , 0 0 0 and accumulated depreciation as of transaction date of $ 2 4 0 , 0 0 0 ) and a fair value of $ 7 2 0...

A sales representative mistakenly entered 382469 instead of 328469 in the customer number field. Which type of control would be most effective in preventing this type of problem? a. Turnaround...

Let T be a text of length n, and let P be a pattern of length m. Describe an O(n+ m)-time method for finding the longest prefix of P that is a substring of T.

Give a justification of why the computeFailKMP method (Code Fragment 13.4) runs in O(m) time on a pattern of length m. 1 private static int[] computeFailKMP(char[ ] pattern) { int m = pattern.length;...

Describe an example of a text T of length n and a pattern P of length m such that the brute-force pattern-matching algorithm achieves a running time that is (nm).

places. should be chosen

what is the role of interrupt vector

-Sweets Company produces boxes of chocolate. Sweets purchased and used 2,200 pounds of chocolate during the month of April for $4.80 per pound. A standard of 2 pounds of material is expected to be...