hw01.366 - . . Winter 2008 CPE/CSC 366: Database Modeling,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 2

hw01.366 - . . Winter 2008 CPE/CSC 366: Database Modeling,...

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

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