DBMS 5th sem ISE

How to study this subject

Program No 1.

Consider the following relations:

STUDENT (

snum: integer,

sname: string,

major: string,

level: string,

age: integer)

CLASS (

name: string,

meets_at: string,

room: string,

fid: integer

)

ENROLLED(

snum:integer,

cname: string

)

FACULTY(fid:integer,

fname: string,

deptid: integer)

The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Level is a two character code with 4 different values

(Junior: JR, Senior:SR, Super Senior: SS, Fresher: FR)

Table Creation Program No 1.

Consider the following relations:

STUDENT (snum: integer, sname: string, major: string, level: string, age: integer)

CLASS (name: string, meets_at: string, room: string, fid: integer)

ENROLLED(snum: integer, cname: string)

FACULTY(fid: integer, fname: string, deptid: integer)

The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Level is a two character code with 4 different values (Junior: JR, Senior:SR, Super Senior: SS, Fresher: FR)

Table Creation Program No 1.

Consider the following relations:

STUDENT (snum: integer, sname: string, major: string, level: string, age: integer)

CLASS (name: string, meets_at: string, room: string, fid: integer)

ENROLLED(snum: integer, cname: string)

FACULTY(fid: integer, fname: string, deptid: integer)

The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Level is a two character code with 4 different values (Junior: JR, Senior:SR, Super Senior: SS, Fresher: FR)

Table Creation Program No1.

Consider the following relations: STUDENT (snum: integer, sname: string, major: string, level: string, age: integer) CLASS (name: string, meets_at: string, room: string, fid: integer) ENROLLED(snum: integer, cname: string) FACULTY(fid: integer, fname: string, deptid: integer) The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Level is a two character code with 4 different values (Junior:

JR, Senior:SR, Super Senior: SS, Fresher: FR) Table Creation Program No 1. Consider the following relations: STUDENT (snum: integer, sname: string, major: string, level: string, age: integer) CLASS (name: string, meets_at: string, room: string, fid: integer) ENROLLED(snum: integer, cname: string) FACULTY(fid: integer, fname: string, deptid: integer) The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Level is a two character code with 4 different values (Junior: JR, Senior:SR, Super Senior: SS, Fresher: and this is much usefull than that you thinks.

Add contents here

Official Notes

Add contents here

Notes from other sources

Add contents here

Model question papers

Add contents here

Previous year question papers

Add contents here

Useful links

Add contents here and

Editors