Task 1

Background

A departmental store issues in-store-credit-card to facilitate and encourage customers to make

more purchases in the store. The in-store-credit-card is available to public members who wish to

apply. Card holder is given a credit limit (based on card holder's income) for making purchases

in the store. At the end of the month, card holder will be billed for the amount spent. Premium

card holder can earn bonus points when making purchases, and the bonus points can be used to

redeem merchandise.

B) Based on the relational schemas, provide SQL statements to create the tables. You must

choose an appropriate data type and length for each column. You must also include

appropriate check constraints and foreign key constraints to ensure data integrity

C) To prepare for possible changes in the near future, the store owner requests for a set of

ALTER Table statements to alter the table structure without dropping and re-creating the

tables. The changes are stated below.