Relation schema for student, Database Management System

Example

RELATION SCHEMA for STUDENT:

STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

                                                STUDENT

 

         ROLLNO

NAME

 

AGE

t1          3467

Shikha

Noorie_jan@yahoo.com

20

 t2          4677

kanu

Golgin_atat@yahoo.com

20

Where t1 = (3467, Shikha, Noorie_jan@yahoo.com, 20) for this relation instance, m = 2 and n = 4.

Posted Date: 3/6/2013 5:20:35 AM | Location : United States







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

Write discussion on Relation schema for student
Your posts are moderated
Related Questions
What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape


Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o


Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.

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

Strict 2PL :Though, this basic 2PL suffers from the trouble that it can result into loss of isolation / atomic property of transaction as theoretically speaking once a lock is rele

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement