CS403 Database Management Systems Assignment No.4 Fall Semester 2013

[Vuhelper]

CS403 Database Management Systems Assignment No.4 Fall Semester 2013


Database Management System (CS403)
Assignment No.4
Total Marks: 10

Deadline
Your assignment must be uploaded before or on Thursday 24th Jan 2013.

Rules for Marking
It should be clear that your assignment will not get any credit if:
1. The assignment is submitted after due date.
2. The assignment is copied.

Objectives
The objective of this assignment is:
Understating the working environment of SQL Server and populating your created tables. Giving the idea of data extraction i.e. how data is retrieved from different tables by using DML (Data Manipulation Language) commands.

Important things to consider before doing this assignment:

1. Till now you have completed your conceptual design, logical design and then started physical design. Your physical design is incomplete yet. In this assignment you will work to complete your physical design of database.
2. This assignment is the continuation of the third assignment. You have to consider the same case study of Best Mart System also provided below. You had created a database with your student ID in assignment 3. You will use the same database, and populate it. Your database name should be same as your student ID, as it was in the third assignment; otherwise you will lose your marks.
3. You will use DML (Data manipulation Language) to populate tables and perform different tasks.

Task Description:

In this assignment you will focus only on the tasks given below:

1. Populate all of your tables which you have created in assignment 3 by using INSERT statement. You should insert at least 3 records in each table.
2. Apply foreign key constraint on all those tables which have foreign key in the ERD of BEST Mart system by using ALTER table command.
3. Sort the output of “SALE” table in ascending order based on CustomerID and InvoiceNumber.
4. Count number of rows from “Purchase” table in which discount is greater than 10.
5. You have to send screenshots of every step of your work in a MS Word (.doc) file.

Note: Use all concepts and techniques you have studied so far discussed particularly in lectures 28 to onwards.

ERD of BEST Mart System