Assignment 4

			     Due Date : 8 Sept	

Note :
1. Microsoft acces is installed from pro-02 to pro-10 except pro-07 machines
   in new software lab.
2. The assignment has to be done in group of 3.
3. Everytime you finish your work with windows, please log off & restart the 
   machine in linux. 

Use Microsoft Access to do the following :

1. Create following tables with appropriate primary key & foreign key constraints : 
	Programs( progcode, progname )
		Primary Key : progcode
	Department( deptcode, deptname )
		Primary key : Use autonumbering feature as two diff 
		              specializations have same department code. 
			      e.g. "system & control" & "communications" do
			      have same dept code as "Electical"
	Student( rollno, name, deptcode, progcode, hostel )
		Primary key : rollno
		Foreign key : deptcode references Department( deptcode )
		Foreign key : code references Programs( progcode )

2. Execute following queries :
   1. Give all the students from hostel 9
   2. Give all the student names, rollno & student's department name
   3. Create Crosstabs on student :
   		Make rows as dept & columns as programs 

3. Create reports :
   1. Give information of all the students.
   1. Give information of all students staying in hostel 1.