Example:

RELATIONAL SCHEMA for PERSON:

PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String)

RELATION INSTANCE

In this instance, m = 3 and n = 4

PERSON_ID	NAME	AGE	ADDRESS
1	Sanjay Prasad	35	b-4,Modi Nagar
2	Sharad Gupta	30	Pocket 2, Mayur Vihar.
3	Vibhu Datt	36	c-2, New Delhi

Therefore current relation state reflects only the valid tuples that show a particular state of the real world. Though, Null values can be assigned for the cases where the values are missing or unknown.

Posted Date: 3/6/2013 5:21:34 AM | Location : United States

Ask an Expert

Related Discussions:- Relational schema for person, Assignment Help, Ask Question on Relational schema for person, Get Answer, Expert's Help, Relational schema for person Discussions

Write discussion on Relational schema for person
Your posts are moderated

Write your message here..

Related Questions

What disadvantage of odbc does ole db overcome, What disadvantage of ODBC d... What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

What are the advantages of object id, What are the advantages of object ID?... What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Relationship, What is multiple relationship ? What is multiple relationship ?

File Management Principles, What are the requirements to ensure the objecti... What are the requirements to ensure the objectives of file management principle is realized?

Primary key, explaination explaination

Explain Lock-Based protocols, # ???? .. # ???? ..

Define deadlock term, a. Define the term "deadlock". There are four conditi... a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

What are stand-alone procedures, What are stand-alone procedures? Proce... What are stand-alone procedures? Procedures that are not part of a package are called as stand-alone because they independently defined. A good example of a stand-alone procedu

Data, Explain three main attributes of data. Explain three main attributes of data.

Create table and insert data manufacturer-dbms, Create a table according to... Create a table according to given data:  AmbulanceDriver(Driver_Number#, Name, Address, Birth_Date) AmbulanceDriverTeam(Team_Number#, Driver_Number#, Join_Date, Lea