We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Database Management System (CS403) Assignment No: 4 Total Marks: 10 Due Date: Thursday 24th Jan 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

 

 

 

 

 

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 2188

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Attachments:

Replies to This Discussion

1. SQL query to enter data in to database

INSERT INTO Customer
VALUES ('001''Umair','M.A Jinnah road', '021xxx','021xxx','umair@live.com','imp','KHI')

2. Establishing Foreign key constraint

ALTER TABLE Sale ADD FOREIGN KEY (CustomerID)
REFERENCES Customer(CustomerID)

3. Sorting Sale Table in ascending Order

SELECT SaleID, CustomerID, InvoiceDate, InvoiceNumber, Discount, Description
FROM Sale
ORDER BY CustomerID ASC

&

SELECT SaleID, CustomerID, InvoiceDate, InvoiceNumber, Discount, Description
FROM Sale
ORDER BY InvoiceNumber ASC

4. Count number of rows from Purchase where discount > 10

SELECT COUNT(*) as "rows where discount is greater than 10"
FROM Purchase
WHERE Discount > 10;

NOTE: Those using windows 7 on their pc's should install
"SQL SERVER MANAGEMENT STUDIO EXPRESS 2005" or newer version of
same application coz server studio 2000 windows 7 ke saath problem kerta hai.

plz see the attached file & tell me how to resolve this error

Attachments:

Dear Shani Pakistani

You are getting the error because you are not entering the data according to data types. i.e. you have provided the fields 'PhoneNumber' and  'FAX' as a varchar but you are entering data in these fields as 'int'. You must enclose the data in single quoutes while entering data. I mean that you must give data as '658697000564', '7667886587'. 

dear aap ny phone or fax k varchar k sath size nae lagaia
ager nae lagana to usy single courts mein likh ly

cs403 assign idea solution

Attachments:

Can any one tell me how can we show relation between tables in sql server 2000 ?? I have established relation between tables but don't know how to show it in a diagramatic way? Plz help me out! 

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service