This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: . . Winter 2008 CPE/CSC 366: Database Modeling, Design and Implementation Alexander Dekhtyar . . Homework 1 Due date: Tuesday, January 29, in class. Problem 1 You are building a credit card transactions database. The following information is made available to you. The credit card company issues credit cards to individuals and corpora- tions . Each credit card account is uniquely identified by its number . The database must also store information about the date of issue of the credit card, its expiration date (both are stored as month, year pairs), billing address , phone number , credit limit , interest rate , date of last statement , and current ballance . Each credit card account, both individual, and corporate allows for a number of authorized users. Each individual account is associated with a list of customers . Each corporate account is associate with a company and the company , in turn has a list of authorized users for the account, also customers ....
View Full Document
- Spring '08