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
What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.

Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

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.

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap

What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have


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

What is foreign key? Foreign Key - Let there are two relations in tables R and S. Any candidate key of the relation R that is referred in the relation S is known as the forei


The cross-section of twisted pair The cross-section of each and every strand of the twisted pair is π/4 square mm. A 10-km length of this type of material, with two strands per