Answer to Question #202617 in Databases | SQL | Oracle | MS Access for sayyam butt

Question

atm management system code in sql

Answer 1

The standard query language (SQL) is very useful in the Automatic Teller Machine (ATM) management system because of its high performance and scalability. The SQL codes link the user interface and the databases. The SQL command like DELETE, INSERT, SELECT, DROP, and CREATE form the SQL codes and can also manipulate tables in the database. 

The ATM management system code must contain the SQL statements to make it more effective and efficient. The SQL statements can delete and drop table in the database. The delete statement only removes the records in the table while the drop statement removes the entire table from the database. 

The ATM management system has a database, which consists of tables. The tables store the details of various users. Transactions can occur upon these tables. The transaction can be withdrawal of funds, amount deposit, checking balances, and funds transfers. The SQL codes perform the various transactions that the user wants to accomplish.