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
Explain the term - Control as Concurrent Tasks As we know, any object can be implemented as a task in programming language or operating system. This is the most general approa

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

Performance of Various Concurrency Control Mechanisms

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

I want a script that will run, and update my virtual machine's LAN settings (proxy server and port), and also re-configure the Firefox User Agent. I want a script that will run,

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

statical data

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

a project based on normalization with first, second and third normalization. There need to be a diagram also

What is called query processing? Query processing refers to the range of activities included in extracting data from a database.