{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment2_final - Bus 510/W11-Prof Mehdi Beheshtian Tony...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Bus 510/W11-Prof. Mehdi Beheshtian Tony Pagan Maggie Tam Chi-Hsin, Chang Chen-Hung,Wu Homework 2 1. A hospital wants to have a database to keep track of its patients, doctors, and wards. Construct an E-R diagram to model the business. Indicate the key for each entity type. Entities – a thing which is recognized as being capable of an independent existence and which can be uniquely identified. Entities can be considered as nouns and relationships as verbs. Entities = patients, doctors, and wards. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Bus 510/W11-Prof. Mehdi Beheshtian Tony Pagan Maggie Tam Chi-Hsin, Chang Chen-Hung,Wu 2. A small bank offers two types of accounts to local residents, checking and saving. To keep its transactions simple, the bank does not allow joint accounts. Please construct an E-R diagram to represent its database design. Indicate the key for each entity type. 2
Background image of page 2
Bus 510/W11-Prof. Mehdi Beheshtian Tony Pagan Maggie Tam Chi-Hsin, Chang Chen-Hung,Wu 3. (Optional Research) Go to the web and find out some facts about entity- relationship diagrams. Then write an essay for a popular magazine about what the model is about. Facts about the E-R Diagram: Data models are tools used in analysis to describe the data requirements and assumptions in the system from a top-down perspective Diagrammatically represents the business relationship amongst organizational data Aids communication across a variety of users and stakeholders
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}