Question

The purpose of this exercise is to successfully identify and describe in detail 3 database systems that you or someone you are close to encounters often for their normal day-to-day activities. When considering database systems to describe, consider the points listed below:
1. What is the database system identified? Remember to keep it broad (e.g. our accounting system) 2. Where would you typically see such a database system used? 3. Why does this database system exist? What problem is being solved? 4. How is this database system used? 5. Who is the primary user for this database system?
I expect to see nothing less than a paragraph (4-5 sentences) about each system identified. You are all database professionals so I expect it to be written in a professional format.

So I pick three database systems that are a good one is Personal database, Document databases and, Network databases.

Answer 1

Ans:
database is known for record keeping.
the purpose of database system is to maintain the records.
records are collected in table.a data base table is composed of rows and columns.
a record(row ) is a group of fields(columns).
example :
if there is a need to manage a financial accounting.it means there is a need to keep record of each financial transaction.
for example : bank transaction (deposit transaction).
to record a deposit transaction following fields are required .
1)Account_number
sample value:4352635363
2)nature_of_transaction
sample value:deposit
3)amount
sample value:10000$
4)Name_of_account_holder
sample: Tom
5)date_of_transaction:
sample value 09-03-2019(MM-DD-YYYY)

a table can contain several such types of transactions.
if there are several tables, then group of tables is called database.

apart from all that, there may be a need to retrieve/insert/update/delete records in a table.
so a well organized system is required to achieve all the above mentioned functionality, such a system is known as database management system.

Types of data integrity available database management system

1)Null Rule
with the help of this rule a developer can specify that insertion of new record is allowed or not if record contains a null value.
same for update operation.

2)Unique Column Values
it means that insertion of a new row is allowed only if new row contains a unique value for a particular column(or a set of columns).
same for update operation.

3)Primary Key Values

each row should be uniquely identified by the value of the column.
for example: two students can not have same roll number.each student should be identified uniquely by his/her roll number.
Note: Unique column can take Null value but primary key can not accept Null value

4)Referential Integrity Rules(Foreign key)
two tables(T1 ans T2) can be related.
example: if table T1 has a primary key Roll_Number .
Table T2 will have a column Roll_Number(foreign key) .
value inserted in the column Roll_Number of T2 must present in the column Roll_number(Primary key) of T1

Oracle can enforce data integrity in following manner
a)in the form of constraints
at time of table creation developer can put constraints on columns of table such as primary key, foreign key and so on.

b)With the help of Triggers:
with the help of triggers we can implement event driven programming.
event driven programming means, a particular piece of code is executed when any specific event occurs.
for example
example1
some code is executed when record is inserted in a table.
example2
some code is executed when records is updated in a table.

Integrity rules can also be enforced with the help of triggers

ans 2:
such types of database management systems are used in Banking industries and insurance industries.

Ans 3:

the purpose of database management system is to implement and maintain the business rules with consistency, integrity,and reliability.
Types of data integrity available database management system

1)Null Rule
with the help of this rule a developer can specify that insertion of new record is allowed or not if record contains a null value.
same for update operation.

2)Unique Column Values
it means that insertion of a new row is allowed only if new row contains a unique value for a particular column(or a set of columns).
same for update operation.

3)Primary Key Values

each row should be uniquely identified by the value of the column.
for example: two students can not have same roll number.each student should be identified uniquely by his/her roll number.
Note: Unique column can take Null value but primary key can not accept Null value

4)Referential Integrity Rules(Foreign key)
two tables(T1 ans T2) can be related.
example: if table T1 has a primary key Roll_Number .
Table T2 will have a column Roll_Number(foreign key) .
value inserted in the column Roll_Number of T2 must present in the column Roll_number(Primary key) of T1

Oracle can enforce data integrity in following manner
a)in the form of constraints
at time of table creation developer can put constraints on columns of table such as primary key, foreign key and so on.

b)With the help of Triggers:
with the help of triggers we can implement event driven programming.
event driven programming means, a particular piece of code is executed when any specific event occurs.
for example
example1
some code is executed when record is inserted in a table.
example2
some code is executed when records is updated in a table.

Integrity rules can also be enforced with the help of triggers.

Ans 4.
now a days most of the companies are using database system in on line manner.now a days all the Bank ATMs are connected to servers.
now a days e commerce , online banking, online shopping have become popular.data base is distributed. concept of data replication is also used to cope up with the situation of disaster for quick recovery.

Ans:
Primary users:
1)bank employees
2)other financial institutions's employees.

Three data bases
a) for small organizations Ms Access is good choice because Ms access can maintain database effectively and efficiently if data base is small.
it is user friendly and easy.

b)for large organization one can go for Mysql or oracle.
both the data bases are capable to handle large amount of data.
the advantage of Mysql is that it is open source.

for document database MongoDB is a good choice

c) for network data base big data is good choice.

for example hadoop
NOSql Data bases

big data is known for its 3Vs
a)high volume of data(Volume)
b)high speed of incoming data(Velocity)
c)variety of data(variety)

big data handles unstructured and multi structured data .

in big data , each record does not contain same number of column.
each record is a document and, can have different number of columns
different kind of data(image, text, voice,video) can be handled.

big data means to deal with network data.

in big data , the speed of incoming data is very high.