Define a relation schema, Database Management System

A Relation Schema represented by R(A1, A2, ..., An) is made up of the relation name the list of attributes and R Ai that it contains. A relation is described as a set of tuples. Let r be the relation which have set tuples (t1, t2, t3, ..., tn). Each tuple is an ordered list of n-values t=(v1,v2, ..., vn).

The purpose of the relational model is to give a declarative function for specifying queries and data: users directly state what information the database have and what information they want from it, and let the database management system software take care of explain data structures for retrieval procedures and storing the data for answering queries.

 

1225_Relational Schema.png

Posted Date: 7/30/2012 1:52:29 AM | Location : United States







Related Discussions:- Define a relation schema, Assignment Help, Ask Question on Define a relation schema, Get Answer, Expert's Help, Define a relation schema Discussions

Write discussion on Define a relation schema
Your posts are moderated
Related Questions
Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat

What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a

Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

What are the two integrity rules?  Ans:  The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule.   Entity Integrity Rule - If the attribute A of rel

I am going to develop a web site to present decision tree structure. For this, I want a web application with AJAX technology to connect the database and prepare the decision tree's

What are the two types of serializability? The two types of serializability is a)      Conflict serializability b)      View serializability

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia