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 is dml compiler, What is DML compiler? DML Compiler: Translates DM... What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

What are partial and natural key, What are partial, alternate,, artificial,... What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

Describe the concepts of structural semantic data model, Question 1 List a... Question 1 List and explain various Normal Forms. How BCNF differs from the Third Normal Form and 4th Normal forms? Question 2 Describe the concepts of Structural Semantic Da

Client server databases, Client Server Databases- The concept behind the C... Client Server Databases- The concept behind the Client/Server systems is simultaneous, cooperative processing. It is an approach that presents a one systems view from a user's vie

What is property - properties of a database, What is property - properties ... What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Illustrate the view of software architecture, Illustrate the view of softwa... Illustrate the view of software architecture A model is a semantically closed abstraction of system composes of elements. It can be visualized using any of the following five v

Explain weak and strong entity sets, Explain weak and strong entity sets? ... Explain weak and strong entity sets? Weak and Strong entity sets: A physically powerful entity set has a primary key. All tuples in the group are distinguishable through that k

Define what Immediate database modification technique uses, Define what Imm... Define what Immediate database modification technique uses?  Ans: Both undo and redo.

Find a 3nf decomposition , Find a 3NF decomposition of the following relati... Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

Database problem in wordpress, Project Description: I am having a random... Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th