Question

Compare and contrast the key benefits for each system. Examples might be full customization, a cloud-based model, scalability, strong support.

Please provide answers based on the database management system.

Answer 1

Answer)

There are mostly 2 types of a database management system which are as mentioned below:

1) Single or flat file database

The flat file is the one which stored the data in a simple plain text file and every line holds one record while this has delimiters like the commas separated file where the flat file database would use some simple structure and might not have multiple tables and relations.

2) Multi-file relational or that of the structured database:

This on the other hand has many data with rows as well as columns that are related to one another using special key fields. This is mostly very flexible and also gives functionality for the creation, updating, and deletion of the data.

Example: Cloud-based model which has the flexibility to store data virtually and be accessible from anywhere which is supported by most of the applications and is secure to use.

While the above Database Management Systems are further classified as:

1) Hierarchical database systems which has a tree like structure and has a pre-defined structure as one to one manner having parent and child nodes

2) Network Database which is also a hierarchical structure and has a single parent tree hierarchy which supports many to many relationship

3) Object Oriented Database wherein the information gets represented as object format.

Please comment if you need any other inputs.
Share a like if you find the answer helpful. This would help us learn and share our learning better.
Thank you.