hw2 - develop an EER model segment to represent this...

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

Create a FREE account now to get started. Log In

The email address you entered is not valid. The email address you provided is already in use.
Your username must be at least 5 characters. Your username must consist of only alphanumeric characters. Your username must contain at least one letter. Your username contains inappropriate language. Another user has already claimed this username.
Your password must be at least 6 characters in length.
{[ $select.selected.label ]} Please select a valid school.
By creating an account you agree to our Privacy Policy, Terms of Use, and Honor Code.
Create my FREE account Processing...
Sign Up with Facebook

We will never post anything without your permission.

Already on Course Hero? Log In