Define a relation ?

Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a list of domains. Each relation consists of a set of named columns and an arbitrary number of rows. The columns correspond to the areas describing each tuple within the table or relation. The rows correspond to each instance of the entity elaborates through the table or relation.

Posted Date: 5/10/2013 5:48:57 AM | Location : United States

Ask an Expert

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

Write discussion on Define a relation in dbms
Your posts are moderated

Write your message here..

Related Questions

Non-redundant cover and canonical cover, Given the following set of functio... Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

What are costs to be considere when transaction is roll back, What are the ... What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

Example of primary key, Suppose that in an organisation, an employee may do... Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

State the component diagram, State the Component Diagram A component d... State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com

What are the two types of indices, What are the two types of indices? T... What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

What is the aim of logical schema, What is the aim of logical schema ? ... What is the aim of logical schema ? The main motive of the logical schema is to ensure the portability of procedures and models on various physical schemas at runtime.

Explain the role of a database administrator, Explain the Role of a databas... Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

Write short notes on relational constraints, Write short notes on relationa... Write short notes on relational constraints? Relational Constraints are: 1. NOT NULL 2. Unique 3. Primary key 4. Foreign key 5. Table check

Explain query execution plan, Explain query execution plan? - Optimizer... Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

What is a records management consultation, What is a records management con... What is a records management consultation? Our organization is an authority for disseminating your specific requirements and giving you with a solution to effectively manage yo