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 A₁, A₂...A_n is a list of attributes showing R then R (A1, A₂...A_n) 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

Ask an Expert

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

Write your message here..

Related Questions

Explain clustering file organization, Explain Clustering file organization ... Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that

Design and building a distributed information system, The scenario You ... The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

Create an entity relationship diagram, Cyber Transit Ltd keeps up-to-date i... Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr

Define signal, Define Signal. It allows methods to respond to events tr... Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy

Writing a pl/sql program, Problem 1. Create a PL/SQL program to insert ... Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data

What are the various properties of relational tables, What are the various ... 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

Lossless-join decomposition, Lossless-Join Decomposition   Let us sh... Lossless-Join Decomposition   Let us show an intuitive decomposition of a relation. We require a better basis for deciding decompositions since intuition may not always be r

Three level architecture of dbms-logical architecture, Three Level Architec... Three Level Architecture of DBMS or Logical DBMS Architecture The logical architecture defines how data in the database is perceived by users. It is not deals with how the da

Physical or internal level, give me a diagram about physical or internal le... give me a diagram about physical or internal level

File sharing, random file sharing random file sharing