Homework 1 - Database Concepts and E/R Modeling
CIS4301
Spring 2009

*Note: You do not have to turn in the solutions to this homework.  It is
recommended that you work on the problems before class on Thursday January
22, 2009 where we will go over some of the solutions in preparation for
the first quiz.

1. Define the following terms:
    -Database:
    -Database Management System:
    -Database System:

2. List and describe the ACID properties of transactions

3.  (Exercise 4.1.2 from the textbook) Design a database for a bank,
including information about customers and their accounts. Information
about a customer includes their name, set of addresses, set of phone
numbers, and Social Security number. Accounts have numbers, types (e.g.
savings, checking) and balances. The system must allow each account to
have at most one customer.

4. (Exercise 4.1.6 from the textbook) Design a genealogy database with one
entity set: People. The information to record about persons includes their
name, their mother, their father, and children.

5. (Exercise 4.4.4(b) from the textbook) Draw an E/R diagram for a system
consisting of Leagues, Teams, and Players. Note that league names are
unique. No league has two teams with the same name. No team has two
players with the same number. However, there can be players with the same
number on different teams, and there can be teams with the same name in
different leagues. Make sure to indicate the keys for all entity sets.