Relation and relational schema, Database Management System

A relation has:

  • Relational Schema
  • Relation instance

Relational Schema:

A relational schema shows the relation's name, its attributes and the domain of every attribute. If R is the name of a relation and A1, A2...An is a list of attributes showing R then R (A1, A2...An) is known as a relational schema. Every attribute in this relational schema takes a value from some explicit domain called Domain (Ai).

For instance, the relational schema for relation PERSON as in Figure will be: PERSON (PERSON_ID:integer, NAME: string, AGE:integer, ADDRESS:string)

Total number of attributes in a relation indicates the degree of a relation. Hence the

PERSON relation includes four attributes, so this relation is of degree 4

Posted Date: 3/6/2013 5:16:52 AM | Location : United States







Related Discussions:- Relation and relational schema, Assignment Help, Ask Question on Relation and relational schema, Get Answer, Expert's Help, Relation and relational schema Discussions

Write discussion on Relation and relational schema
Your posts are moderated
Related Questions
Define what Immediate database modification technique uses?  Ans: Both undo and redo.

Question: (a) What do you meant by content management and briefly describe four major components of a Content Management System? (b) Explain key benefits of a Content Manage

An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Using Literal Character String Example: To print IS A as one string with column name employee SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;

Hi I have got an assignment for making an er diagram for market management software can any budy help me?

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu

Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below


In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the