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

Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

Hi is anyone well versed in accounting information systems available now to help me work through an important assignment due tomorrow at noon?

#queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que

Smart Alex Catering Sevice (SACS) is a company offering top class catering staff  for prestigious events.  The company employs approximately 200 hourly paid contact staff - chefs,

Copy Data from One Database to another Database Project Description: I am having two MySQL databases with same tables. I just need to copy one Data from one to another dat

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA