|
Rajwinder Singh
Welcome to my blog .......
Tuesday, December 24, 2013
Rajwinder Singh is still waiting for you to join Twitter...
Thursday, December 19, 2013
Rajwinder Singh sent you an invitation
|
Wednesday, September 21, 2011
DBMS LAB - for University Data base schema
create table classroom
(building varchar(15),
room_number varchar(7),
capacity numeric(4,0),
primary key (building, room_number)
);
create table department
(dept_name varchar(20),
building varchar(15),
budget numeric(12,2) check (budget > 0),
primary key (dept_name)
);
create table course
(course_id varchar(8),
title varchar(50),
dept_name varchar(20),
credits numeric(2,0) check (credits > 0),
primary key (course_id),
foreign key (dept_name) references department
on delete set null
);
create table instructor
(ID varchar(5),
name varchar(20) not null,
dept_name varchar(20),
salary numeric(8,2) check (salary > 29000),
primary key (ID),
foreign key (dept_name) references department
on delete set null
);
create table section
(course_id varchar(8),
sec_id varchar(8),
semester varchar(6)
check (semester in ('Fall', 'Winter', 'Spring', 'Summer')),
year numeric(4,0) check (year > 1701 and year < 2100),
building varchar(15),
room_number varchar(7),
time_slot_id varchar(4),
primary key (course_id, sec_id, semester, year),
foreign key (course_id) references course
on delete cascade,
foreign key (building, room_number) references classroom
on delete set null
);
create table teaches
(ID varchar(5),
course_id varchar(8),
sec_id varchar(8),
semester varchar(6),
year numeric(4,0),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id,sec_id, semester, year) references section
on delete cascade,
foreign key (ID) references instructor
on delete cascade
);
create table student
(ID varchar(5),
name varchar(20) not null,
dept_name varchar(20),
tot_cred numeric(3,0) check (tot_cred >= 0),
primary key (ID),
foreign key (dept_name) references department
on delete set null
);
create table takes
(ID varchar(5),
course_id varchar(8),
sec_id varchar(8),
semester varchar(6),
year numeric(4,0),
grade varchar(2),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id,sec_id, semester, year) references section
on delete cascade,
foreign key (ID) references student
on delete cascade
);
create table advisor
(s_ID varchar(5),
i_ID varchar(5),
primary key (s_ID),
foreign key (i_ID) references instructor (ID)
on delete set null,
foreign key (s_ID) references student (ID)
on delete cascade
);
create table time_slot
(time_slot_id varchar(4),
day varchar(1),
start_hr numeric(2) check (start_hr >= 0 and start_hr < 24),
start_min numeric(2) check (start_min >= 0 and start_min < 60),
end_hr numeric(2) check (end_hr >= 0 and end_hr < 24),
end_min numeric(2) check (end_min >= 0 and end_min < 60),
primary key (time_slot_id, day, start_hr, start_min)
);
create table prereq
(course_id varchar(8),
prereq_id varchar(8),
primary key (course_id, prereq_id),
foreign key (course_id) references course
on delete cascade,
foreign key (prereq_id) references course
);
(building varchar(15),
room_number varchar(7),
capacity numeric(4,0),
primary key (building, room_number)
);
create table department
(dept_name varchar(20),
building varchar(15),
budget numeric(12,2) check (budget > 0),
primary key (dept_name)
);
create table course
(course_id varchar(8),
title varchar(50),
dept_name varchar(20),
credits numeric(2,0) check (credits > 0),
primary key (course_id),
foreign key (dept_name) references department
on delete set null
);
create table instructor
(ID varchar(5),
name varchar(20) not null,
dept_name varchar(20),
salary numeric(8,2) check (salary > 29000),
primary key (ID),
foreign key (dept_name) references department
on delete set null
);
create table section
(course_id varchar(8),
sec_id varchar(8),
semester varchar(6)
check (semester in ('Fall', 'Winter', 'Spring', 'Summer')),
year numeric(4,0) check (year > 1701 and year < 2100),
building varchar(15),
room_number varchar(7),
time_slot_id varchar(4),
primary key (course_id, sec_id, semester, year),
foreign key (course_id) references course
on delete cascade,
foreign key (building, room_number) references classroom
on delete set null
);
create table teaches
(ID varchar(5),
course_id varchar(8),
sec_id varchar(8),
semester varchar(6),
year numeric(4,0),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id,sec_id, semester, year) references section
on delete cascade,
foreign key (ID) references instructor
on delete cascade
);
create table student
(ID varchar(5),
name varchar(20) not null,
dept_name varchar(20),
tot_cred numeric(3,0) check (tot_cred >= 0),
primary key (ID),
foreign key (dept_name) references department
on delete set null
);
create table takes
(ID varchar(5),
course_id varchar(8),
sec_id varchar(8),
semester varchar(6),
year numeric(4,0),
grade varchar(2),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id,sec_id, semester, year) references section
on delete cascade,
foreign key (ID) references student
on delete cascade
);
create table advisor
(s_ID varchar(5),
i_ID varchar(5),
primary key (s_ID),
foreign key (i_ID) references instructor (ID)
on delete set null,
foreign key (s_ID) references student (ID)
on delete cascade
);
create table time_slot
(time_slot_id varchar(4),
day varchar(1),
start_hr numeric(2) check (start_hr >= 0 and start_hr < 24),
start_min numeric(2) check (start_min >= 0 and start_min < 60),
end_hr numeric(2) check (end_hr >= 0 and end_hr < 24),
end_min numeric(2) check (end_min >= 0 and end_min < 60),
primary key (time_slot_id, day, start_hr, start_min)
);
create table prereq
(course_id varchar(8),
prereq_id varchar(8),
primary key (course_id, prereq_id),
foreign key (course_id) references course
on delete cascade,
foreign key (prereq_id) references course
);
Tuesday, August 30, 2011
CAT Scores for MBA Admission in IITs and IISc
The Indian Institutes of Technology (IITs) and the Indian Institute of Science (IISc) have decided to use CAT 2011 as part of the selection process of their MBA and management programmes from the academic year 2012-13.
The Joint Management Entrance Test (JMET) previously used for admission by the IITs and the IISc stands discontinued, according to an IIM press release.
The decision was taken after a recent review revealed that the relatively young JMET is not too dissimilar to CAT, and that the effort to organise JMET each year seemed enormous in relation to the approximately 40,000 candidates who took the test each year.
"The intersection of candidates who take both CAT and JMET in a single year is quite large. The decision to use CAT for admission into the IITs and IISc will minimise the test preparation and financial burden on candidates," said LS Ganesh, former head of the IIT-Madras management department.
The five original IITs - Kharagpur, Bombay, Madras, Kanpur and Delhi - as also IIT-Roorkee, are among India's earliest institutions to have offered postgraduate and research programmes in management since the 1960s.
"CAT is an ideal fit for IITs as it is a well-evolved, established, standardised and widely accepted entrance exam for admission into PG programmes in management in India," Ganesh said.
"This is a major initiative that brings two premier higher education systems together. We anticipate that this will result in closer tie-ups and collaborative research work that will provide both sets of institutions a competitive edge in the long run," CAT 2011 convenor Janakiraman Moorthy said.
CAT 2011 will be conducted over a 20-day window from October 22-November 18 across 36 cities.
The Joint Management Entrance Test (JMET) previously used for admission by the IITs and the IISc stands discontinued, according to an IIM press release.
The decision was taken after a recent review revealed that the relatively young JMET is not too dissimilar to CAT, and that the effort to organise JMET each year seemed enormous in relation to the approximately 40,000 candidates who took the test each year.
"The intersection of candidates who take both CAT and JMET in a single year is quite large. The decision to use CAT for admission into the IITs and IISc will minimise the test preparation and financial burden on candidates," said LS Ganesh, former head of the IIT-Madras management department.
The five original IITs - Kharagpur, Bombay, Madras, Kanpur and Delhi - as also IIT-Roorkee, are among India's earliest institutions to have offered postgraduate and research programmes in management since the 1960s.
"CAT is an ideal fit for IITs as it is a well-evolved, established, standardised and widely accepted entrance exam for admission into PG programmes in management in India," Ganesh said.
"This is a major initiative that brings two premier higher education systems together. We anticipate that this will result in closer tie-ups and collaborative research work that will provide both sets of institutions a competitive edge in the long run," CAT 2011 convenor Janakiraman Moorthy said.
CAT 2011 will be conducted over a 20-day window from October 22-November 18 across 36 cities.
Subscribe to:
Posts (Atom)