Virtual University of Pakistan| Virtual Gurus| Vu Gurus

Assignment No. 05
Semester Fall 2011
Database Management Systems-CS403 Total Marks: 30

Due Date:
26 – 01 – 2012

Objective
To understand the Creation of tables and Forms in MS-Access

Software to Use MS - Access

Submission Format Your-Rollno.mdb (.mdb is extension of MS-Access file)

Instructions:
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:

The assignment is submitted after due date.
The submitted assignment does not open or file is corrupt.
The assignment is copied (from other student or copy from handouts).
The assignment is in the format other than (.mdb) is not acceptable.
Student ID is not mentioned in the assignment File or name of file is other than student ID.

GOOD LUCK

Assignment: There are Three (3) Tasks in this assignment.

Task 1: (Marks: 5)
Create Four tables in MS – Access according to information given below;

Customer (Customer-ID, Customer-Name, Customer-Address, Customer-Phone)
Product (Product-ID, Product-Name, Unit-Price)
Order (Order-ID, Customer-ID, Order-Date, Ship-Date)
Order-Detail (Order-ID, Product-ID, Quantity)

Select suitable data types for each attribute.
Task 2: (Marks: 5)
Enter at-least five (5) valid entries in each table

Task 3: (Marks: 20 = 5 + 5 + 10)
Design Forms as given below; (Prototype Forms)
* You may change interface of forms

Form 1: Customer Information Form (Based on Table CUSTOMER

Form 2: Product Information Form (Based on Table PRODUCT

Form 3: Order Information Form (Based on Tables ORDER and ORDER-DETAIL)