An Automatic Teller machine (ATM) is an Electronic Device that provides services like balance inquiry, cash withdraw and money transfer etc. The ATM system is considered an example of a safety critical system and hence the need to formalize its services. To formalize the ATM system we need to first declare variables to be used. - An ATM card contains the following information CARD := cardNo | accountNo | expiryDate - After any transaction the ATM machine gives the following responses ATMRESPONSE := operationSuccessfull | operationFailed - An ATM can be in two states STATE := available | busy - For any withdraw operation the ATM machine has restrictions on the minimum and maximum amount one can withdraw. AMOUNT := minimumAmount | maximumAmount - The other important variable is the date DATE := issueDate | expiryDate | todayDate - The ATM generates the following possible error messages ERROR := invalidCard | invalidPin | invalidAmount | insufficientBalance - Below is a schema for a Bank Account Account accountName : PNAME accountNo : PNUMBER balance : NUMBER →7N Has : NAME ↔ NUMBER domHas = accountName balance(NUMBER) ≥ 0 Use the information provided above to develop schema that describe the following ATM operations. (a) Card reading (b) Balance inquiry (c) Withdraw (d) Money transfer from one account to the other

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

An Automatic Teller machine (ATM) is an Electronic Device that provides services like balance inquiry, cash withdraw and money transfer etc. The ATM system is considered an example of a safety critical system and hence the need to formalize its services. To formalize the ATM system we need to first declare variables to be used.
- An ATM card contains the following information CARD := cardNo | accountNo | expiryDate - After any transaction the ATM machine gives the following responses ATMRESPONSE := operationSuccessfull | operationFailed - An ATM can be in two states STATE := available | busy - For any withdraw operation the ATM machine has restrictions on the minimum and maximum amount one can withdraw. AMOUNT := minimumAmount | maximumAmount - The other important variable is the date DATE := issueDate | expiryDate | todayDate - The ATM generates the following possible error messages ERROR := invalidCard | invalidPin | invalidAmount | insufficientBalance - Below is a schema for a Bank Account
Account accountName : PNAME accountNo : PNUMBER balance : NUMBER →7N Has : NAME ↔ NUMBER domHas = accountName balance(NUMBER) ≥ 0
Use the information provided above to develop schema that describe the following ATM operations.
(a) Card reading
(b) Balance inquiry
(c) Withdraw
(d) Money transfer from one account to the other

Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Problems on Dynamic Programming
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education