Question
Assume that you set up a data base for a credit card company and after initial analysis you have come up with following entity sets, each of which will be a relation in the final database: Customer(C-id, C-Name, C-address,) Primary key C-id
CreditCardAccount(A/C-Number, Exp-Date, Max-Limit, Unpaid-Balance) Primary key A/C-Number
Merchant (M-Id, M-Address, Type-of-business, BBB-Rating) Primary key M-Id
The following facts are to be noted-
1) A customer can have multiple credit card accounts, but a credit card account can only belong to one customer.
2) Whenever a customer charges a purchase, information wants to be maintained so that the data base user can find out the date of purchase, the amount of purchase, and all available information about the merchant where the purchase was made.
a) Introduce any relationship sets or additional entity sets that you think are necessary to record above facts and draw complete E-R (entity-relationship) diagram
b) Give relationship schema to go with the above E-R Diagram