mis 1

MIS343 Assignment#1

Objective: E-R modeling.

Due: 6:00PM, Monday, April 17, 2017

Description (Total: 50 points)

1. Page 84, Review Questions #3.

2. Contrast the following terms: a. stored attribute; derived attribute b. simple attribute; composite attribute c. entity type; relationship type d. strong entity type; weak entity type e. degree; cardinality f. required attribute; optional attribute g. composite attribute; multivalued attribute h. ternary relationship; three binary relationships

2. Page 85, Problems and Exercises #1 -- g, h, i, j

1. A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The E-R diagram in Figure 2-23 illustrates the key entities of interest to the operator and the relationships between them. Based on the figure, answer the following questions and explain the rationale for your response. For each question, identify the element(s) in the E-R diagram that you used to determine your answer.

g. Assume a handset type exists that can utilize multiple operating systems. Could this situation be accommodated within the model included in Figure 2-23?

h. Is the company able to track a manufacturer without maintaining information about its handsets?

i. Can the same operating system be used on multiple handset types?

j. There are two relationships between Customer and Plan. Explain how they differ.

3. Page 85, Problems and Exercises #2a

For each of the descriptions below, perform the following tasks: i. Identify the degree and cardinalities of the relationship. ii. Express the relationships in each description graphically with an E-R diagram.

A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.

4. Page 88, Problems and Exercises #17d

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have been told to use in the course. Hoffer, Jeffrey A.; Topi, Heikki; Venkataraman, Ramesh. Essentials of Database Management (页码88). Pearson HE, Inc.. Kindle 版本.

d. A hospital has a large number of registered physicians. Attributes of PHYSICIAN include Physician ID (the identifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient ID (the identifier) and Patient Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment Detail). Components of Treatment Detail include Date, Time, and Results. Did you draw more than one relationship between physician and patient? Why or why not? Did you include hospital as an entity type? Why or why not? Does your ERD allow for the same patient to be admitted by different physicians over time? How would you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted

Answer the above questions and solve the problems. Write your answers and draw the graphic models in a MS Doc file. Submit the file through course website or by email. Save a backup copy of your work.