Introduce relationship sets or additional entity, Ask an Expert

Engineering

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

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M9133635

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Case study 1 user interfacesearly user interfaces were

Case Study 1: User Interfaces Early user interfaces were designed with little or no consideration for the end user. This was largely due to technical and hardware limitations. The poor interface design required a specifi ...

Design a combinational circuit with three inputs a b and c

Design a combinational circuit with three inputs: A, B, and C, D and the output W. The output should be 1 only when the values of A, B interpreted as an unsigned integer (AB) is equal to the values of C, D interpreted as ...

1 what would be the purpose for a user to protect a

1. What would be the purpose for a user to protect a file from "read" or "write" access by other users? 2. Is there a reason why it would be safer for administrators to use two different accounts when working with a comp ...

Assignment week 5 user acceptance testinguser acceptance

Assignment: Week 5 User Acceptance Testing User acceptance testing, or UAT, is a round of testing in which the users who are expected to use the system after it goes live exercise the system. UAT differs from quality ass ...

Suppose a soft drink company want to perform a taste test

Suppose a soft drink company want to perform a taste test on 5 brands of diet cola. How many permutations are there for presenting 5 diet colas to test subjects?

Question suppose you want to back up a huge file to a cd-r

Question : Suppose you want to back up a huge file to a CD-R. You can do this by splitting the file into smaller pieces and backup up those pieces separately. Write a utility program named FileSplitter that splits a larg ...

Subject digital securityprovide an fidm authentication

Subject : Digital Security Provide an FIdM authentication system that you have used (being subjet to). Tell the name of the organizations acted as the IdP (Identity Provider) and SP (Service Provider)?

To speed up memory access caching is typically used a

To speed up memory access, caching is typically used. A memory cache is a small but fast memory where data recently accessed is kept in anticipation of future references. When an access is made, if the data is in the cac ...

A bar wants to move into a new area they want to find out

A bar wants to move into a new area. They want to find out the average income of people in the area to set a price point. To estimate the income of the locals with an error of at most $5,000 at a 80% confidence level, wh ...

Question you company provides wireless networking services

Question: You company provides wireless networking services. One of your customers complains about the downloading performance being poor. After investigation, you find that the customer's 802.11 wireless network is inte ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert