Cs101 > Cs101_8

CS 101 Introduction to Computing

Assignment #8 Deadline Your assignment must be uploaded / submitted on or before 01st August, 2004.

Upload Instructions Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.

Rules for Marking Please note that your assignment will not be graded if: • It is submitted after due date • The file you uploaded does not open • The file you uploaded is copied from some one else • It is in some format other than .mdb

Objective The assignment has been designed to enable you: •

Work in Microsoft Access.

ASSIGNMENT 1. Create a database in Microsoft Access that contains two tables. 2. First table named Student_Info should have following five fields Student_Rollno, Student_Name, Student_Fathername, Address, and Phone. It should have primary key on Student_Rollno. 3. Second table named Student_Group should have following three fields Student_Rollno, Class and Session. 4. Establish primary, foreign key relationship between these two tables. 5. Establish relationship with respect to degrees between these tables (one to one, one to many, many to many).

INSTRUCTIONS 1. You have to read about the primary key, foreign key and relationship between tables. 2. You can consult the following links for detail http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials_main.asp http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials/relation.pdf