CS403 Assignment No. 04 Fall 2016-17

<div dir="ltr" style="text-align: left;" trbidi="on"> <h3 style="text-align: left;"> <span style="font-family: "verdana" , sans-serif;">CS403 Assignment No. 04 Fall 2016</span></h3> <span style="font-family: "verdana" , sans-serif;">Here You can get <b>CS403</b> Database Management Systems <b>Assignment No. 04 Solution</b> and discussion.Semester: <b>Fall 2016</b>. </span><span style="font-family: "verdana" , sans-serif;">Total Marks: 20. </span><span style="font-family: "verdana" , sans-serif;">Due Date: <b>07/02/2017</b>.</span><br /> <div> <span style="font-family: "verdana" , sans-serif;"><br /></span></div> <span style="font-family: "verdana" , sans-serif;"><b>Also Read:</b> <a href="https://virtualstudysolutions.blogspot.com/2016/02/mth301-final-term-solved-papers-mega.html">MTH301 Final Term Solved Papers Mega Collection</a></span><br /> <div> <span style="font-family: "verdana" , sans-serif;"><br /></span></div> <div> <span style="font-family: "verdana" , sans-serif;">You Can Also Download </span><span style="font-family: "verdana" , sans-serif;">CS403 </span><span style="font-family: "verdana" , sans-serif;">Solved Final Term Papers, </span><span style="font-family: "verdana" , sans-serif;">CS403 </span><span style="font-family: "verdana" , sans-serif;">Short Notes, </span><span style="font-family: "verdana" , sans-serif;"><b>CS403 </b></span><span style="font-family: "verdana" , sans-serif;"><b>Assignment Solutions</b>, Lecture Wise Questions Answers Files, Solved MCQs, Solved Quiz, </span><span style="font-family: "verdana" , sans-serif;">CS403 </span><span style="font-family: "verdana" , sans-serif;">Solved Final Term Subjective Papers ,</span><span style="font-family: "verdana" , sans-serif;">CS403 </span><span style="font-family: "verdana" , sans-serif;">Solved Final Term Objective Papers from Virtual Study Solutions For Preparation of Final Term Papers.</span><br /> <span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: Verdana, sans-serif;"><b>Also Read:</b> <a href="https://virtualstudysolutions.blogspot.com/2017/02/cs101-short-notes-for-final-term-lec-22-to-45.html">CS101 Short Notes for Final Term From Lec 22 to 45</a></span></div> <div> <h3 style="text-align: left;"> <span style="font-family: "verdana" , sans-serif;">CS403 Assignment Uploading instructions:</span></h3> <span style="font-family: "verdana" , sans-serif;">Your assignment should be in .doc /.docx format.<br />Save your assignment with your ID (e.g. bc000000000.doc).<br />No assignment will be accepted through email.</span><br /> <span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: Verdana, sans-serif;"><b>Also Read:</b> <a href="https://virtualstudysolutions.blogspot.com/2016/02/mgt101-all-past-final-term-papers.html">MGT101 All Past Final Term Papers</a></span><h3 style="text-align: left;"> <span style="font-family: "verdana" , sans-serif;">CS403 Assignment Rules for Marking:</span></h3> <span style="font-family: "verdana" , sans-serif;">It should be clear that your assignment will not get any credit if:</span><br /> <ul style="text-align: left;"><span style="font-family: "verdana" , sans-serif;"> <li>The assignment is submitted after due date.</li> <li>The submitted assignment does not open, execute or file is corrupted.</li> <li>Your assignment is copied from internet, handouts or from any other student</li> <li>(Strict disciplinary action will be taken in this case).</li> </span></ul> <span style="font-family: Verdana, sans-serif;"><b>Also Read:</b> <a href="https://virtualstudysolutions.blogspot.com/2016/02/eng101-final-term-past-papers-Collection.html">ENG101 Final Term Past Papers Collection</a></span><span style="font-family: verdana, sans-serif;"><br /></span><ul style="text-align: left;"><span style="font-family: "verdana" , sans-serif;"> </span></ul> <span style="font-family: "verdana" , sans-serif;"> </span><br /> <h3 style="text-align: left;"> <span style="font-family: "verdana" , sans-serif;">CS403 Assignment No. 04 </span></h3> <span style="font-family: "verdana" , sans-serif;"><b>Question:</b> (20 Marks)</span><br /> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div> <span style="font-family: "verdana" , sans-serif;">Two relations of a Railway Management System are given below:<br /><br />Train (Train_ID, Train_Name, Source_Location, Destination_Location, Departure Date, Departure Time)<br /><br />Passenger ( Train_ID, Passenger_ID, P Name, Seat_No, Ticket_No, Fare)<br /><br />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.<br /><br />Now you have to perform the following tasks using SQL queries:<br /><br />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.<br /><br />Select all the Train_IDs with fares which have fare less than 1000 and greater than 400 for destination location Karachi.<br /><br />Show the summary of each Train_ID and tickets sold against each Train_ID.<br /><br />Show Train_ID, Train name along with fares collected against each item.<br /><br />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.<br /><br />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).</span><br /> <h3 style="text-align: center;"> <span style="font-family: "verdana" , sans-serif;">Table 1, </span><span style="font-family: "verdana" , sans-serif;">Query 1</span><span style="font-family: "verdana" , sans-serif;"> Screenshot</span></h3> </div> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-q8cH-rmZw8gg0BxVyM94hUuTZAhkw9h72qwp-ZOnbeP-_KQASPn2_Cb4A8a6dLaomTE9iaeQC0trOyzrsxs_B0hjpXODBAFbTyxKd7qw72evjLVGNJ9RDLb53wo9Zpk5z9bZcvkSkvI/s1600/cs403+assignment+table+1%252C+query+1.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto; text-align: center;"><img alt="CS403 Assignment No. 04 Fall 2016-17" border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-q8cH-rmZw8gg0BxVyM94hUuTZAhkw9h72qwp-ZOnbeP-_KQASPn2_Cb4A8a6dLaomTE9iaeQC0trOyzrsxs_B0hjpXODBAFbTyxKd7qw72evjLVGNJ9RDLb53wo9Zpk5z9bZcvkSkvI/s640/cs403+assignment+table+1%252C+query+1.jpg" title="CS403 Assignment No. 04 Fall 2016-17" width="460" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;"><span style="font-family: "verdana" , sans-serif;">CS403 Assignment No. 04 Fall 2016-17</span></td></tr> </tbody></table> <h3 style="text-align: left;"> <span style="font-family: "verdana" , sans-serif;">CS403 Assignment Important Note: </span></h3> <div> <span style="font-family: "verdana" , sans-serif;">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 <a href="mailto:cs403@vu.edu.pk" rel="nofollow" target="_blank">cs403@vu.edu.pk</a>. 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.</span><br /> <h3 style="text-align: left;"> <span style="font-family: "verdana" , sans-serif;">CS403 Assignment No. 04 Deadline:</span></h3> </div> <div> <span style="font-family: "verdana" , sans-serif;">Your assignment must be uploaded/submitted on or before 7th February 2017.</span><br /> <span style="font-family: "verdana" , sans-serif;"></span><br /> <h4 style="text-align: left;"> <span style="font-family: Verdana, sans-serif; font-size: large;">CS403 Assignment No. 04 Solution</span></h4> </div> </div> <span style="font-family: Verdana, sans-serif;"><div> <ul style="text-align: left;"> <li>Please wait.</li> <li>Assignment Solution will be updated Soon.</li> </ul> </div> If you want to Get the Next Assignment Solution Directly in Your Inbox.<br />Subscribe us below to Receive CS601 Assignment Solution in Your Mail Box.</span></div>

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...

Latest Articles »