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 a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de

explain the steps for reduction of er model into relational model?

A set of possible data values is called? A set of possible data values is called as domain.

Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:

Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record