Skip to main content

Relation model concept and its advantage & disadvantage - Computer science fundamentals tutorial

    Relation model concept and it's advantage & disadvantage

   PDF version of this post also available. to get the pdf click the link given at  the  end of this post.      
    
1.What is relational model?
  Ø Relation model represent database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values. This row in the table denotes a real world entity or relationship.

     Relational model concept: -
  ·Attribute: -Each column in a table, Attributes is the properties which define a relation. Example: - DNO, DNAME.

  ·Table: - In the relational model relations are saved in the table format. A table has two properties rows, column. Rows represent records and column represents attributes.


  · Degree: - The total number of attribute which in the relation which called the degree of relation.

  ·Cardinality: -Total number of rows present in the table.

    Attribute domain: -Every attribute has some predefined values and scope which is known as attribute domain.

     Advantage of relational model: -
    1) Simplicity: - A relational data model is simpler than hierarchical model and network model.

    2) Easy to use: - The relational model is easy as table consisting of rows and column is quite natural and easy to understand.

    3) Data independence: - the structure of a database can be changed without having to change any application.

    4)   Query capability: -It make possible for a high level query language like SQL to avoid complex data navigation.

      Disadvantage of using relational model: -
   · Few relational databases have limits on field length which cannot be exceeded

   · Relational databases can sometime become complex as the amount of data grows and the relation between pieces of data become more complicated.     

     ·Complex relational database may lead isolated databases where information cannot be shared from one system to another. 
        
                        click here For PDF of this post           
    PDF of  Relation model concept and its advantage & disadvantage

  

Labels

Labels:

Comments

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

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

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