read doc

3.docx

Home >Information Systems homework help >read doc

· Using the crow’s foot notation, draw a single ER diagram that models the following relationships in a hospital environment. (10 Points)

a. A HOSPITAL has its staff one or more PHYSICIANs;

A PHYSCIAN is on the staff of only one HOSPITAL.

b. A PHYSCIAN may admit zero or many PATIENTs;

A PATIENT is admitted by only one PHYSCIAN.

c. A HOSPITAL has one or more WARDs;

Each WARD is located in exactly one HOPITAL.

d. A WARD has any number of EMPLOYEEs;

An EMPLOYEE may work in only one WARD.

· Based on the figure, answer the following questions and explain your rationale for your response. (10 Points)

· Can an order exist without a physician?

· Can an order exist with a patient?

· Can a treatment exist without an order?

· Can an order detail be always traced back to a patient?

· Can an order detail be always traced back to a physician?

· Draw an ER diagram for the Valley View International using the crow’s foot notation for each of the description below. Particularly, identify (1) entities, particularly associate entities, (2) attributes and attribute classification, and (3) relationships, the degree and cardinalities of the relationships. If you need to make additional assumptions to resolve any ambiguities in the description, clearly list them below the diagram. (20 Points)

· 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, a name and an address. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.

· A book is written by one or multiple authors. Each author is identified by an author number and has a name, date of birth, and phone number. Each author has either one or multiple books; in addition, occasionally data are needed regarding perspective authors who have not yet published any books.

· Regarding the relationship between a book and its authors, it is important to record the percentage of the royalties that belongs to a specific author and each author’s position in the sequence of the book’s authors.

· An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and also records the date and the amount paid.

· A book can be part of a series, which is also identified as a book and has its own ISBN number. One book can belong to several series and a series consists of at least one but potentially many books.

Now please integrate the individual ER diagrams you draw into a single ER diagram.