CS403 Database Management Systems assignment no 5 fall January 2012

[Vuhelper]

View more random threads:

• cs506 assigment no 1 April 1 spring 2011
• cs703 assignment no 3 Solution 20th January 2016
• MGT610 Business Ethics Assignment No.1 Solutuon Fall...
• cs201 assignment no 1 may 2015 solution
• Advance Computer Architecture - CS501 assignment no 3...
• cs604 Solution for the assignment no 2 fall 2010
• CS403 Database Management Systems assign Assignment No. 04...
• CS604 Assignment 02 Solution spring April 2012 due date...
• CS507 Information Systems Assignment no 2 Spring fall 2...
• CS601- Data Communication assignment no 5 solution fall 2010

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)













Sponsored Links



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