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
Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

What are the various symbols used to draw an E-R diagram? Explain with the help of an example how weak entity sets are represented in an E-R diagram. Various symbols used to d

Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return

Which component is not included in database environment ? A users component is not included in database environment.


Replication : It is definite as a copy of a relation. Every replica is stored at a dissimilar site. The alternative to replication is to store only single copy of a relation which

Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as

PRINCIPLES OF DATABASE 1. State the following terms: a) Database b) Database Management System c) Entity d) Attribute e) Relationship 2. Discuss the Three Level Architecture

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp