CS403 Assignment No. 04 Fall 2016-17

CS403 Assignment No. 04 Fall 2016

Here You can get CS403 Database Management Systems Assignment No. 04 Solution and discussion.Semester: Fall 2016. Total Marks: 20. Due Date: 07/02/2017.

Also Read: MTH301 Final Term Solved Papers Mega Collection

You Can Also Download CS403 Solved Final Term Papers, CS403 Short Notes, CS403 Assignment Solutions, Lecture Wise Questions Answers Files, Solved MCQs, Solved Quiz, CS403 Solved Final Term Subjective Papers ,CS403 Solved Final Term Objective Papers from Virtual Study Solutions For Preparation of Final Term Papers.

Also Read: CS101 Short Notes for Final Term From Lec 22 to 45

CS403 Assignment Uploading instructions:

Your assignment should be in .doc /.docx format.
Save your assignment with your ID (e.g. bc000000000.doc).
No assignment will be accepted through email.

Also Read: MGT101 All Past Final Term Papers

CS403 Assignment Rules for Marking:

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, execute or file is corrupted.

Your assignment is copied from internet, handouts or from any other student

(Strict disciplinary action will be taken in this case).

Also Read: ENG101 Final Term Past Papers Collection

CS403 Assignment No. 04

Question: (20 Marks)

Two relations of a Railway Management System are given below:

Train (Train_ID, Train_Name, Source_Location, Destination_Location, Departure Date, Departure Time)

Passenger ( Train_ID, Passenger_ID, P Name, Seat_No, Ticket_No, Fare)

Create a database with your VU ID as you created in previous assignment (The name of database must be your own VU ID like BC12345678 otherwise zero marks will awarded) and add above mentioned tables in the database. Now add at least 10 to 20 proper dummy records in each of the table by keeping the constraints of Primary keys. Take screen shots of both tables along with dummy data and then paste to the MS Word file.

Now you have to perform the following tasks using SQL queries:

Select all train names whose departure time is in between 3:00 PM 6:00 PM and date between is 24 Jan 2017 26 Jan 2017.

Select all the Train_IDs with fares which have fare less than 1000 and greater than 400 for destination location Karachi.

Show the summary of each Train_ID and tickets sold against each Train_ID.

Show Train_ID, Train name along with fares collected against each item.

Show the list of Train_ID and Train name where least profitable train will be displayed first and most profitable train will be displayed at the end.

You are required to write the queries in MS Word. After that, execute each of the queries in SQL Server and take the screen shot of every query along with its result and then paste it to MS Word file (As given Below).

Table 1, Query 1 Screenshot

CS403 Assignment No. 04 Fall 2016-17

CS403 Assignment Important Note:

You are required to submit the MS Word file containing the solution of both parts. Do not put any query on MDB about this assignment, if you have any query then email at cs403@vu.edu.pk. Furthermore, if any student found cheating from any other student or from online forums then he/she will be awarded ZERO right away and strict disciplinary action will be taken against the student.