CS403 Database Management Systems assignment no 5 fall January 2012

[Vuhelper]

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)

[Vuhelper]

idea solution are in attachment