View the step-by-step solution to:

Question

Assume that you are setting up a data base for a credit card company and after initial analysis you have come up

with the 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 needs to be maintained so that the data base user can find out the date of the 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 the above facts and draw the complete E-R (entity-relationship) diagram b) Provide the relationship schema to go with the above E-R Diagram

Sign up to view the entire interaction

Top Answer

Great question... View the full answer

ER_diag.docx

b) Relational schema:
(M-Id, M-Address, Type-of-business, BBB-Rating)
Customer
C_ID
AutoNumber
C_name
Text
C_address
Text
C_Emailid
Text
CreditCardAccount
a/c_number
expiry_date
max_limit...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online