Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A bank provides many types of machines to handle different types of bank transactions for its account holders. All the machines are identified by Machine.
A bank provides many types of machines to handle different types of bank transactions for its account holders. All the machines are identified by Machine. JL, Location, Warranty, Last. Serxiced and Machine. Type. Cheque machines have their own unique attributes that include Cbeque.No and Cheque. Sum. ATM machines has a unique attribute named Type. Transact. ATM machines may or may not have a cash deposit feature. ATM machines with a cash deposit feature also have attributes that include \$10_Qty, \$20_Qty, \$50_Qty and \$100_Qty. A manufacturer (machine manufacturer) supplies at least one machine. Each machine is supplied by only one manufacturer. Manufacturers are identified by Manufacture. JL. Manufacturer. Name and Address. An account makes at least one transaction. Accounts are identified by Account. Ne and Account.Dame. Attributes for transactions include Transaction.ID. Transaction.Date, Receiver and Amount. Each machine may be used to make many transactions by many accounts. Draw an extended (enhanced) entity relationship diagram for the bank based upon the description above
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started