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
A database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity? Integrity simply means t

Emergence of Client Server Architecture Some of the pioneering work that was completed by some of the relational database vendors permitted the computing to be distributed on m

What is storage manager? A storage manager is a program module that gives the interface among the low level data keeps in a database and the application programs and queries su

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

We need help in Booking System for Golf Business Development of a web based booking system which permits clients to book golf lessons with the following features- a) 4 user p

I have to solve a problem using access

Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows: σ AGE The resu

Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices