Hw2

Download Document
Showing pages : 1 of 1
This preview has blurred sections. Sign up to view the full version! View Full Document
ISYS 464, Section 1, Spring, 2012 (Beckman) Homework #2: Description Due: Tuesday, February 21, 2012, start of class Chapter 3, textbook page 144, “Problems and Exercises, #9”. (10 points) 3. A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge SAVINGS: Acct No, Date Opened, Balance, Interest Rate LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment Assume that each bank account must be a member of exactly one of these subtypes. Using generalization,
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: develop an EER model segment to represent this situation using the traditional EER notation. Remember to include a subtype discriminator. Chapter 4, textbook page 195, Problems and Exercises, #4a. (10 points) 1. For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form: a. Chapter 2, Problems and Exercises 15b (page 104) Note from Beckman: The ER diagram referred to looks like:...
View Full Document