Relational schema for person, Database Management System

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







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
Related Questions
3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R

What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2.    Descriptions of attr


For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att

intent locking

SET concept is used in which type of modelling? SET concept is used in Network Model.

Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n

Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat