Question: ANALYSIS. (16 Marks) Direction: Analyze the scenario and answer the questions Construct an E-R diagram for a Bank. Each Bank issues several credit cards with

ANALYSIS. (16 Marks)

Direction: Analyze the scenario and answer the questions

Construct an E-R diagram for a Bank. Each Bank issues several credit cards with a unique identification code and expiry date. A credit card must be issued by one Bank and only to one user. Each user can own more than one credit card. Users are identified by HKID, Name and address. Bank is identified by Bankname and Branchno

a) Analyze the above scenario and derive the Entity relationship diagram (10 marks)

(Marking Scheme: 4 Marks for identifying 4 entities+2 marks for the attributes+2 marks for cardinality+2 marks for

relationship)

b) Construct at least three tables for the above scenario using relational database model (6 marks) (Marking Scheme:2 marks for each table)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

C. Get the summation of the produc variable and its probability. D. Get the square root of the discrete random varial 4. What can we general What I Need to Know This module was created and written...

Pls help me to answer the think critically 11.1, 11.2 & Review Concepts. This book is Banking system 2nd edition 11. Robbery Prevention and Response goals - Discuss how security measures can prevent...

Hey i need help with this, use the 2 repports that i have attatched to answer, will give tip if done fast UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 Form 10-K ANNUAL...

CERTIFICATE IV IN FINANCE AND MORTGAGE BROKING - FN540820 Page 1 UNIT 3 - COMPLY WITH FINANCIAL SERVICES REGULATION AND INDUSTRY CODES OF PRACTICE Unit Code: FNSFMK515 This unit describes the skills...

Review an Annual Report to gain a general understanding of the types of financial information contained in the report and why that information might be useful to a potential reader. You will also be...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Southwest Bankers, Inc. (not it's real name) through its subsidiaries, provides financing for industrial and commercial properties, for interim construction related to industrial and commercial...

I need the following homework exercise completed. All of the information is within the attached files. I require no explanations, just the answers. Part 1: Finding information: Each of the following...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

20 mL of a mixture of CO and H were mixed with excess of O and exploded & cooled. There was a volume contraction of 23 mL. All volume measurements corresponds to room temperature (27C) and one...

In 2016, there were 104 female officials in Congress, and there were 64 more female members of the House of Representatives than female senators. Find the number of females in each house of Congress.

b . Over the 5 - year period, what average nominal interest rate would be expected to produce a 2 % real risk - free return on 5 - year Treasury securities ? Assume M R P = 0

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...