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
What are the authentication modes in SQL Server? How can it be changed? Windows mode and Mixed Mode - SQL and Windows. To alter authentication mode in SQL Server click Start, P

Northwind Pty Ltd sells a variety of food products throughout the world.  They want to use the reporting features of SAP's Business Information Warehouse to better understand their

Developer is required to do a task including: - Database Normalization - Database Analysis - ERM Diagram Details can be provided and then you can change your bid accord

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.


How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

The Incident table, with an auto-incrementing incident number, etc, looks like: incident_num reporter date time incide


Eliminate Repeating Groups The problem is, "Find out the list of employees, who knows DB2". For this problem we require to perform an awkward scan of the list looking for re