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

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  Hardware support to memory management

Study any two multicore processor architecture and discuss the following features briefly

  Discuss and describe the potential security threats

Discuss and describe the potential security threats

  Application to computer science

Find the matrices that represent the relations.

  What is microprocessor - motorola 68k assembly language

What is microprocessor - Motorola 68k assembly language? Implement your plan using a user vectored interrupt number 3. Use busy line from the printer to trigger the interrupt. The printer interrupt level is 2. Explain the extra hardware to make t..

  How to set a rule that used by snort to detect an ack scan

How to set a rule that used by snort to detect an ACK scan What do you think Bro can do a better job detecting an ACK scan?

  How to draw a hierarchy chart

How to draw a hierarchy chart

  What aspects of environment support structure of colleges

What aspects of environment support structure of colleges.

  How to solve following problems on functions

How to solve following problems on functions

  Classify traditional grade school algorithms

Classify traditional grade school algorithms

  Explain contents of an initially empty avl tree

Explain contents of an initially empty AVL tree

  Program of five to ten lines in assembly language

Program of five to ten lines in assembly language

  Explain the method to find cost of sorting the relation

Explain the method to find cost of sorting the relation In each case, how many combine passes are required?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd