Answer to Question #163500 in Databases | SQL | Oracle | MS Access for Noor

Question

Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.

As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

Also, what you think that replication of database suitable in the above given scenario?

Answer 1

We will use relational database, and make the data normalized form. So that we can access, update, delete and execute the records and fetch the required data.The relational database is easy to function the valuable system records.