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

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt trac

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

Explain the difference between the three storage types - volatile, non volatile and stable.             Ans: Volatile storage: if storage media loses data while power goes off,

Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

What is a state chart diagram? State diagrams (State Chart Diagram) explain all possible states that a particular object can get into, and how object's state changes as result

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

Fourth Normal Form (4NF) When attributes in a relation have multi-valued dependency, further Normalization to 4NF and 5NF are needed. Let us first find out what multi-valued d

We need help in Booking System for Golf Business Development of a web based booking system which permits clients to book golf lessons with the following features- a) 4 user p