Skip to main content

Types of Database model - Computer science fundamentals tutorial

Database model & it's types in DBMS

 Database model: - Database model defines the logical design and structure of database and defines how data will be stored and updated in a database management. Data Models are fundamental entities to introduce abstraction in a DBMS.
Types of Database model: - 
There are four types database model in DBMS.  The models are 
1) Hierarchical Model
 2)  Network Model
 3) Entity relationship model (ER model)
4) Relational model
now we discuss about each models.
1) Hierarchical Model: - This database model organizes data into a tree like structure with a single root to which all the other data is linked. The hierarchy starts from root data and expands like tree, adding child nodes to the parent nodes. In this model a child node will only have a single parent node. This model efficiently describes many real world relationship like index of a book, recipes. In hierarchical model, data is organized into tree like structure with one, one to many relationship between two different types of data.


 2)  Network Model: - This is an extension of the hierarchical model. In this model data is organized more like a graph and are allowed to have more than one parent node. In this database model data is more related as more relationship established in this model. As the data is related, hence accessing the data is also easier and fast. This database model was used to map many to many data relationship.



 3) Entity relationship model (ER model): - In this model relationship are created by dividing objects of interest into entity and its characteristic into attributes. ER model are define to represent the relationship into pictorial form to make it easier for different situation to understand. This model is good to design a database which can be turn into tables in relational mode.


       4) Relational model: - In this model, data is organized into two dimensional tables and relationship is maintain by storing a common filed. Basic structure of data in the relational model is tables. All the information related to a particular type is stored in rows of that table.



Labels:

Comments

  1. Aaron jhonsonJanuary 28, 2022 at 5:16 PM

    Thanks for sharing such an informative Article. It will be beneficial to those who seek information. Continue to share your knowledge through articles like these, and keep posting on

    Data Engineering Solutions 

    AI Solutions

    Data Analytics Services

    Business Intelligence Solutions

    ReplyDelete

Post a Comment

please subscribe my blog and let me suggest how I improve this site

Popular posts from this blog

Minterm and maxterm in Digital logic design - Computer Science fundamentals tutorial

Minterm and Maxterm First thing to know before we proceed   towards   what is ‘minterm’ and ‘maxterm’ we have to know the sum of product and product of sum. Sum of product: - The logical sum of two or more logical product term is called sum of products expression. It is basically an OR operation of AND operated variables such as Y = AB+BC+ABC Product of Sum: - The logical product of two or more logical sum term is called product of sums expressions. It is basically an AND operation of OR operated variables such as Y = (A+B).(B+C).(A+B+C) Minterm: - Product term containing all the k variables of the functions is either complimented or uncomplimented form is Minterm. Canonical form of sum of product: - It is defined as the logical sum of all the minterms derived from the rows of a truth table for which value of the function is 1. It is called a minterm canonical form. The canonical sum of product expression can be given in a compact form by lis...
Post a Comment
Read more

Solve-write C program to find grade of student by using nested else-if statement

C program to find grade of student by using nested else-if statement Problem Description This program take input as your number then show your grade. Problem Solution 1. enter your marks as input. 2. then check your marks with 'If' block's condition. if it satisfied then show your grade as output. 3. if it not satisfied then it checks with all else-if block's condition repeatedly. 4. print the grade according to your given marks as input and exit. Program codes:-   #include<stdio.h> main() { int n; printf("\n enter the marks:"); scanf("%d",&n); if(n>89) printf("O"); else if(n>79) printf("E"); else if(n>69) printf("A"); else if(n>59) printf("B"); else if(n>49) printf("C"); else if(n>39) printf("D"); else printf("F"); } Program explanation:- 1. enter your marks. for example we take 70 . ...
Post a Comment
Read more

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS  1. A RDBMS consists a collection of ? a. Tables b. Fields c. Records d. Keys  ANS/- a. table 2. The term attribute refers to a ___________ of a table a. Record b. Tuple c. Column d. Key   ans/- c. Column 3. In relational model, the row of table is known to be ?  a. Relation b. Entity field c. Tuple d. Attribute  ans/- C. Tuple 4. . Address field of a person should not be part of primary key, since it is likely to ? a. Dependent b. Too long c. Changed d. Not changed  ans/- c. Changed 5. The relational model is concerned with ? a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these  ans/- c. Both a and b 6. Which is the false statement from the following ? a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these  ans/- d. None of these 7. The union of primary key...
6 comments
Read more