Server side program: Develop a server side program which will do the following:

Question

Server side program: Develop a server side program which will do the following: * (i) Make connection to the database * (ii) Retrieve the data from the table as per the searching criteria
Scenario 1 You have been asked to develop an interactive system for online banking system. The client side would accept from the user the account number and the amount of money being deposited which will then be passed on to the server. Upon receiving the data from the client, the server wi connect to the database which holds records consisting of customer name, balance and account number, and use the account number provided by the client to search the database for a matching record. Once the matching record is found, the balance will be retrieved from the database and added to the deposited amount provided by the client. The new balance will then be used to calculate the interest. The new balance and the interest will be sent back to the client where they will be displayed on screen for the user. The interest rate used would be 0.02 which is stored on the server. If a matching record is not found, send back an appropriate message such as 0 for both the balance and interest. Develop a clien server application to implement this system with the following tasks:

Explanation / Answer

Express apps can use any database supported by Node (Express itself doesn't define any specific additional behaviour/requirements for database management). There are many popular options, including PostgreSQL, MySQL, Redis, SQLite, and MongoDB.

When choosing a database, you should consider things like time-to-productivity/learning curve, performance, ease of replication/backup, cost, community support, etc. While there is no single "best" database, almost any of the popular solutions should be more than acceptable for a small-to-medium-sized site like our Local Library.

The very best performance can be gained by using SQL, or whatever query language is supported by the database. ODM's are often slower because they use translation code to map between objects and the database format, which may not use the most efficient database queries (this is particularly true if the ODM supports different database backends, and must make greater compromises in terms of what database features are supported).

The benefit of using an ORM is that programmers can continue to think in terms of JavaScript objects rather than database semantics — this is particularly true if you need to work with different databases (on either the same or different websites). They also provide an obvious place to perform validation and checking of data.

We can save our references to the related document by assigning the _id value. Below we create an author, then a book, and assign the author id to our stories author field.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.