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 DocumentRight 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 They also set the stage for the design of databases later on in the SDLC
Background image of page 3

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

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

This note was uploaded on 02/24/2011 for the course BUS 510 taught by Professor Mehdi during the Spring '11 term at University of La Verne.

Page1 / 7

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

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online