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
The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

for the following business rules . Identify all entities, attributes, relationships, primary keys, cardinalities and constraints where appropriate 3. (9) An art museum owns a larg

What is meant by object-oriented data model? The object-oriented paradigm is based on encapsulation of data and code related to an object in to a one unit, whose contents are n

Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

1. Staff(staffID, firstName, lastName, availabilityID, experience, phone, mobile, email); 2. Availability(availabilityID, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday,