Suppose, let’s consider the banking database. let’s take PNC bank. It has many b

Question

Suppose, let’s consider the banking database. let’s take PNC bank. It has many branches, For each branch, one database is there and overall one database. If a change occurs in a branch database, it won’t reflect in the main database. Because the tables are different for different branches. If we want to retrieve out account information. we can retrieve using account number directly because data is stored in tables based on account number.

Can you please explain me this example of relational database Model?

Explanation / Answer

Relational Database--Relational database was proposed by Edgar Codd around 1969.
RDBMS, such as Oracle, IBM DB2 and Microsoft SQL Server are commercial Relational Database Management System.
RDBMS organizes data in tables. A table is made up of rows and columns. RDBMS uses SQL (Structured Query Language)

A well-designed database have,
The same piece of data shall not be stored in more than one place.
This is because duplicate data not only waste storage spaces but also easily lead to inconsistencies
Ensure Data Integrity and Accuracy

PRIMARY KEY--A primary key is a special relational database table column (or combination of columns) designated to uniquely
identify all table records. A primary key's main features are:
It must contain a unique value for each row of data. It cannot contain null values

Create Relationships among Tables-
1.one-to-many
2.many-to-many
3.one-to-one
Normalization--
1-First Normal Form (1NF)
2-Second Normal Form (2NF)
3-Third Normal Form (3NF)
4-BCNF

All these rules for good RDBMS.
Now focus on the main point of your question.
To fallow RDBMS.
1- PNC bank and all his branches used a single central database structure. There should no differences in tables or anything.
  
2- In IT Industry standard if the small project(no of users less) then use a single database.
For large enterprise project like the bank, the load on database become higher.
So in such type of project, multiple databases of the same structure used. Suppose you update or insert in one database its value update or insert in all another database by using a script.
3 Multiple databases are used for the purpose if any database stop working by a load of users request then
it diverts to another database.
4- The request of the users randomly hit database So there is no load on a single database.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

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