Introduce relationship sets or additional entity sets

Assignment Help Computer Engineering

Reference no: EM133219

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

Reference no: EM133219

Questions Cloud

Illustrate general network design : Illustrate general network design

Program on string representing : Program on string representing

What is an interface : What is an interface

Write down program for a bank account : Write down program for a bank account

Introduce relationship sets or additional entity sets : Introduce relationship sets or additional entity sets

Problems on word processing application : Problems on word processing application

What is customer relationship management system : What is Customer Relationship management System (CRM)? How does such system add value to an organisation and to its consumers How does a Database Management System assist a business to improve centralisation, eliminate redundancy, and maintain re..

Write down program that models an employee : Write down program that models an employee

Generate queries for new database : Generate Queries for New Database

User Account

All Pages