Basics of relational models, Database Management System

In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you information about E-R models and relational. The relational model is a widely used model for DBMS execution. Most of the commercial DBMS products available in the industry are relational at core. In this part we will talk about the operators, terminology and operations used in relational model.

The second model discussed in this section is the E-R model, which mostly is a semantic model and is very essential in creating raw database design that can be further normalised. We talk about DBMS E-R diagrams, and their conversion to tables in this part.

After Reading this unit, you should be able to:

• Explain relational model and its advantages;

• Execute basic operations using relational algebra;

• Illustrate an E-R diagram for a given problem;

• Change an E-R diagram to a relational database and vice versa.

Posted Date: 3/6/2013 5:12:19 AM | Location : United States







Related Discussions:- Basics of relational models, Assignment Help, Ask Question on Basics of relational models, Get Answer, Expert's Help, Basics of relational models Discussions

Write discussion on Basics of relational models
Your posts are moderated
Related Questions
explain in details about one to one binary relationship

Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

can you create a database for me in oracle/sql

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

Explain the disadvantages of a file processing system? Ans: Disadvantages of File Processing Systems include: 1) Data Redundancy 2) Data Inconsistency 3) Difficult to acce

Explain Foreign Key? Foreign Key - Let there are two relations (tables) R and S. Any candidate key of the relation R that is referred within the relation S is known as the fo

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

Describe briefly models which define the operations on classes. The three models which are used to define operations on classes are as: Object Model = data dictionary + Obje