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
Define decision tree classifiers? As the name suggests decision tree classifiers use a tree: Every leaf node has an associated class, and every internal node has a predicate as

Analyzing Association Traversal Association Traversal shall be understood properly for the association design explanation.  Analyzing association traversal means analyzing tra

Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

what is meant semantic query optimization? how does it differ from other query optimization techniques?