Virtual Study Solutions: CS403 Assignment

CS403 Assignment No 1 Solution Spring 2018

<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment No 1 Spring 2018</span></h3>
<span style="font-family: Verdana, sans-serif;">Dear Students, Here you can read or Download <b>CS403</b> - <u>Database Management System</u> <b>Assignment No 1 Solution</b> and Discussion of Semester <b>Spring 2018</b>. Assignment Due Date is 14 MAY, 2018. Total Marks are 20. This assignment covers lesson no. 1-10. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. <b>CS403 Assignment Solution</b> File has been added. Previously we shared <a href="https://virtualstudysolutions.blogspot.com/2017/03/cs403-current-mid-term-paper-fall-2016.html">CS403 Current Mid Term Paper Fall 2016</a>.</span><div>
<span style="font-family: Verdana, sans-serif;"><br /></span></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/AVvXsEjqZ2SDfWkAMBQDxq6RUAW14r5B3QowV3UMisSNY8DXI-D3On2vSI7jeuYzhT-DccsgDXF4EptSYfeXyCt_fH6p46EmqghKeUkI9zWbfDQ5H7nYF97MgMuaQnUu6wTagZWpX6yK-s0hVDA/s1600/CS403+Assignment+No+1+Solution+and+Discussion+Spring+2018.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment No 1 Solution and Discussion Spring 2018" border="0" data-original-height="669" data-original-width="944" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqZ2SDfWkAMBQDxq6RUAW14r5B3QowV3UMisSNY8DXI-D3On2vSI7jeuYzhT-DccsgDXF4EptSYfeXyCt_fH6p46EmqghKeUkI9zWbfDQ5H7nYF97MgMuaQnUu6wTagZWpX6yK-s0hVDA/s320/CS403+Assignment+No+1+Solution+and+Discussion+Spring+2018.png" title="CS403 Assignment No 1 Solution and Discussion Spring 2018" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif;">CS403 Assignment No 1 Solution and Discussion Spring 2018</span></td></tr>
</tbody></table>
<div>
<h4 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Instructions</span></h4>
<span style="font-family: Verdana, sans-serif;">Please read the following instructions carefully before solving & submitting assignment:</span><br /><br /><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;">
<li><span style="font-family: Verdana, sans-serif;">The assignment is submitted after due date.</span></li>
<li><span style="font-family: Verdana, sans-serif;">The submitted assignment does not open or file corrupt.</span></li>
<li><span style="font-family: Verdana, sans-serif;">The assignment is full or partially copied from (other student or ditto copy from handouts or internet).</span></li>
<li><span style="font-family: Verdana, sans-serif;">Student ID is not mentioned in the assignment File or name of file is other than student ID.</span></li>
<li><span style="font-family: Verdana, sans-serif;">The assignment is not submitted in .doc or .docx format.</span></li>
</ul>
<span style="font-family: Verdana, sans-serif;"><b>Recommended</b> : <a href="https://virtualstudysolutions.blogspot.com/2017/05/all-cs-subjects-mid-term-past-papers.html">All CS Subjects Mid Term Past Papers Collection</a></span><div>
<h4 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Uploading instructions</span></h4>
<div>
<span style="font-family: Verdana, sans-serif;">Your submission must include:<br /><ul style="text-align: left;">
<li>Assignment should be in .doc or .docx format. </li>
<li>Save your assignment with your ID (e.g. bx020200786.doc). </li>
<li>Assignment submission through email is NOT acceptable </li>
</ul>
</span><h4 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Objective</span></h4>
<span style="font-family: Verdana, sans-serif;">The objective of this assignment is :<br /><ul style="text-align: left;">
<li>To give basic knowledge and understanding of Database.</li>
<li>To be able to understand Conceptual Database Design.</li>
</ul>
<b>Please Note:</b><br /></span><span style="font-family: Verdana, sans-serif;">Your answer must follow the below given specifications.</span><span style="font-family: Verdana, sans-serif;"><br /><ul style="text-align: left;">
<li>Font style: “Times New Roman”</li>
<li>Font color: “Black”</li>
<li>Font size: “12”</li>
<li>Bold for heading only.</li>
<li>Font in Italic is not allowed at all.</li>
<li>No formatting or bullets are allowed to use.</li>
<li>Your answer should be precise and to the point, avoid irrelevant detail.</li>
</ul>
</span><h4 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Deadline</span></h4>
<span style="font-family: Verdana, sans-serif;">Your assignment must be uploaded/submitted at or before 14/05/2018.</span><h3 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Assignment Question No 1:</span></h3>
<span style="font-family: Verdana, sans-serif;">Trend of celebrating events in Pakistan is changing rapidly. People got more conscious about the event related arrangements. They spend more time, energy and money to make their events memorable and different from others. Event planners are hired to make events more organized, memorable and ostentatious. “Traditions” is a newly established event planning company. <br /><br />“Traditions” covers weddings functions, birthday parties and corporate meetings. Customers have to get registered before placing order. Customer has to select the desired venue according to the category of function. Customer can select only a single venue for a function. Company is also offering other services like catering, stage decoration etc., for the events. Customers select the menu and catering while placing order. Menu has many food items. <br /><br />The entire application is going to be developed in the broad perspective, However you are required to keep in view only the scenario (portion) whose details have mentioned above and perform the following tasks.</span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><b><br /></b></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><b>Assignment Tasks:</b><br /><ul style="text-align: left;">
<li>Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it.</li>
</ul>
<b>Please Note:</b> You are required to submit ERD as your solution only.</span><div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<h3 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment No 1 Solution Spring 2018</span></h3>
<span style="font-family: "verdana" , sans-serif;">You can see the Sample Preview of <u>CS403 </u>(</span><span style="font-family: Verdana, sans-serif;"><b>Database Management System</b></span><u style="font-family: Verdana, sans-serif;">)</u><span style="font-family: Verdana, sans-serif;"> </span><u style="font-family: verdana, sans-serif;">Assignment No 1 Solution</u><span style="font-family: verdana, sans-serif;"> provided by (</span><a href="https://virtualstudysolutions.blogspot.com/" style="font-family: verdana, sans-serif;">Virtual Study Solutions</a><span style="font-family: verdana, sans-serif;">) below. Click on Download Button to Download Solution File in Your PC. Please Share it with your friends. You can also like our Facebook Page or Subscribe Us below for Updates.</span><br />
<span style="font-family: verdana, sans-serif;"><br /></span>
<span style="font-family: verdana, sans-serif;"><b>Other Subjects Assignment Solution :</b></span><br />
<span style="font-family: Verdana, sans-serif;"><ul style="text-align: left;">
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/mth101-assignment-no-1-solution-spring-2018.html">MTH101 Assignment No 1 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/mth603-assignment-no-1-solution-spring-2018.html">MTH603 Assignment No 1 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/cs614-assignment-no-1-solution-spring-2018.html">CS614 Assignment No 1 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/cs601-assignment-no-1-solution-spring-2018.html">CS601 Assignment No 1 Solution Spring 2018</a></li>
</ul>
</span></div>
<div>
<div>
<h4 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><span style="font-family: "verdana" , sans-serif;">CS403 Assignment Solution Idea Sample Preview</span></span></h4>
<div>
<span style="font-family: "verdana" , sans-serif;">This is a Solution Idea. Solution idea File </span><span style="font-family: "verdana" , sans-serif;">Sample</span><span style="font-family: "verdana" , sans-serif;"> </span><span style="font-family: "verdana" , sans-serif;">Page Preview has been added below with Solution File.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<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/AVvXsEhjtmLjKikUxTtgOT9vMVLp_iyuXXK888SsOtRZEy3tN-XhW7dRfSYcB5VuYOgVmuU4YKf4zB4FfRX86inxrgrETbZoZP81_siLu51IGQh8CJKGT5Gxjc3uebH3NG-1egcQSdBsWI-eHUE/s1600/CS403+Assignment+No+1+Solution+Idea+Sample+Preview+Spring+2018.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment No 1 Solution Idea Sample Preview Spring 2018" border="0" data-original-height="464" data-original-width="473" height="313" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjtmLjKikUxTtgOT9vMVLp_iyuXXK888SsOtRZEy3tN-XhW7dRfSYcB5VuYOgVmuU4YKf4zB4FfRX86inxrgrETbZoZP81_siLu51IGQh8CJKGT5Gxjc3uebH3NG-1egcQSdBsWI-eHUE/s320/CS403+Assignment+No+1+Solution+Idea+Sample+Preview+Spring+2018.png" title="CS403 Assignment No 1 Solution Idea Sample Preview Spring 2018" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif;">CS403 Assignment No 1 Solution Idea Sample Preview Spring 2018</span></td></tr>
</tbody></table>
</div>
</div>
<div>
<span style="font-family: "verdana" , sans-serif;"><span style="font-family: "verdana" , sans-serif;">
</span></span></div>
<h4 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment Solution Download Link</span></h4>
<a class="bevel orange" href="https://drive.google.com/open?id=1aa_UPrX7fswV5b-BA2dao4iErKmCNPO9" rel="nofollow" style="font-family: verdana, sans-serif;" target="_blank"> Download</a><span style="font-family: "verdana" , sans-serif;">  [ Solution Idea File Upload Status : ✅ ]</span><br />
<div dir="ltr" trbidi="on">
<br /></div>
</div>
</div>
</div>
</div>
</div>

CS403 Assignment No 1 Solution Spring 2018

CS403 Assignment No 1 Spring 2018 Dear Students, Here you can read or Download CS403 - Database Management System Assignment No 1 Solut...

Latest Articles »

CS403 Assignment No 3 Solution Spring 2017

<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment No 3 Spring 2017</span></h3>
<span style="font-family: "verdana" , sans-serif;">Dear VU Students, Here you can read and</span><span style="font-family: Verdana, sans-serif;"> download <b>CS403</b> - Database Management Systems <b>Assignment No 3 Sol</b></span><span style="font-family: "verdana" , sans-serif;"><b>ution Spring 2017</b>. Due Date 21 July 2017. Total Marks 20. </span><span style="font-family: Verdana, sans-serif;">Previously we shared <a href="http://virtualstudysolutions.blogspot.com/2017/05/cs403-assignment-no-2-spring-2017.html">CS403 Assignment No 2 Spring 2017 Solution and Discussion</a>.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<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/AVvXsEjy4knYYNhS89KtKDb5_XYOgdzwdttnVmvCeuTj-s6H3frT7R40yqOR7oARxCxLpm3YCf498HfTgusG4j7HnVP2cf5OHR9_ywavhnZs1Ls2wydRTC19U81ke_kPMndzUledEBpFNwv8Tng/s1600/cs403+assignment+no+3+solution+and+discussion.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment No 3 Solution and Discussion Spring 2017" border="0" data-original-height="669" data-original-width="944" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy4knYYNhS89KtKDb5_XYOgdzwdttnVmvCeuTj-s6H3frT7R40yqOR7oARxCxLpm3YCf498HfTgusG4j7HnVP2cf5OHR9_ywavhnZs1Ls2wydRTC19U81ke_kPMndzUledEBpFNwv8Tng/s320/cs403+assignment+no+3+solution+and+discussion.png" title="CS403 Assignment No 3 Solution and Discussion Spring 2017" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif;">CS403 Assignment No 3 Solution and Discussion Spring 2017</span></td></tr>
</tbody></table>
<div>
<span style="font-family: "verdana" , sans-serif;">You Can Also Download Solved Final Term Papers, Short Notes, Assignment Solutions, Lecture Wise Questions Answers Files, Solved MCQs, Solved Quiz , Solved Final Term Subjective Papers , Solved Final Term Objective Papers from Virtual Study Solutions For Preparation of Final Term Papers.</span><span style="font-family: "verdana" , sans-serif;"><br /></span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><b>Recommended :</b> <a href="http://virtualstudysolutions.blogspot.com/2017/05/how-to-copy-save-quiz-questions-from-vulms.html">How to Copy/Save Quiz Questions from VULMS - Tutorial</a></span><br /><h3 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment Deadline:</span></h3>
<span style="font-family: "verdana" , sans-serif;"></span><br />
<div>
<span style="font-family: "verdana" , sans-serif;">Your assignment must be uploaded/submitted on or before 21st July 2017.</span></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;"></span><br />
<ul style="text-align: left;"><span style="font-family: "verdana" , sans-serif;">
<li>Your assignment should be in .doc /.docx format.</li>
<li>Save your assignment with your ID (e.g. bc000000000.doc).</li>
<li>No assignment will be accepted through email.</li>
</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 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 (Strict disciplinary action will be taken in this case).</li>
</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 3 </span><span style="font-family: "verdana" , sans-serif;">Question:</span></h3>
<span style="font-family: "verdana" , sans-serif;">Analyze the given ER diagram very carefully and perform the following task<br /><br /><b>a) </b>Convert the given ERD in relational data model by identifying all possible relations along with relevant attributes from the given diagram.<br />Normalize the relations up to 3rd normal form.<br /><br /><b>b)</b> Install SQL Server (Any version) on your system and open Query Analyzer. In Query Analyzer, perform the following tasks using SQL queries.<br /><br /> <br />Create a database in SQL Server by using Create query. The name of database must be your VU ID i.e. BC123456789 (You have to write your VU ID here. In case of any other database name, zero marks will be awarded).<br />Create all tables identified in part a in the database (BC123456789) using SQL queries. Associate proper data type to each attribute of all the tables.<br />Add 2 dummy records in each table by using the Insert query.<br /><br /><b>Please Note :</b><br />You are required to write the queries in MS Word. After that, execute each of the queries in SQL Server and take screen shot of every query along with its result and then paste it to MS Word file (As given in next page).<br /><br /><b>Note:</b> 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</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<div>
<span style="font-family: "verdana" , sans-serif;">Screenshot 1: (Result of Query No. 1)<br /><br />Screenshot 2: (Result of Query No. 2)<br /><br />Screenshot 3: (Result of Query No. 3)</span><br />
<h4 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif; font-size: large;">CS403 Assignment No 3 Solution</span></h4>
<span style="font-family: "verdana" , sans-serif;"><iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/aWxucvHl1a8" width="560"></iframe></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">if You want to receive the solution in your mailbox, Please subscribe us below or like us on Facebook. we will inform you as soon as Solution is added. Thank you.</span></div>
</div>
</div>

CS403 Assignment No 3 Solution Spring 2017

CS403 Assignment No 3 Spring 2017 Dear VU Students, Here you can read and download CS403 - Database Management Systems Assignment No 3 ...

Latest Articles »

CS403 Assignment No 2 Spring 2017 Solution and Discussion

<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment No 2 Spring 2017</span></h3>
<span style="font-family: Verdana, sans-serif;">Here You can read and Download <b>CS403</b> – Database Management Systems <b>Assignment No 02 Solution</b> and Discussion <b>Spring 2017</b>.  Assignment Total Marks: 15. CS403 Assignment Due Date: 19/05/2017.</span><div>
<span style="font-family: Verdana, sans-serif;"><br /></span></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/AVvXsEhMXFR-BZuMyQP5R61QdkdTEfuJ6x_u9Kn9x47ntHaVO0wV3nIeWxUppzircsOCFDf8mAWGqM7cZ4fJ2yOl4Bl3ZEr80Kw2JsQX-mxtBSv99wxK5MvzY9X93GTua4ftv80ny8O8He7idMg/s1600/CS403+Assignment+No+2+Spring+2017+Solution+and+Discussion.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment No 2 Spring 2017 Solution and Discussion" border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMXFR-BZuMyQP5R61QdkdTEfuJ6x_u9Kn9x47ntHaVO0wV3nIeWxUppzircsOCFDf8mAWGqM7cZ4fJ2yOl4Bl3ZEr80Kw2JsQX-mxtBSv99wxK5MvzY9X93GTua4ftv80ny8O8He7idMg/s400/CS403+Assignment+No+2+Spring+2017+Solution+and+Discussion.png" title="CS403 Assignment No 2 Spring 2017 Solution and Discussion" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif;">CS403 Assignment No 2 Spring 2017 Solution and Discussion<br /></span></td></tr>
</tbody></table>
<div>
<span style="font-family: Verdana, sans-serif;"><b>Recommended :</b> <a href="http://virtualstudysolutions.blogspot.com/2017/03/cs403-current-mid-term-paper-fall-2016.html">CS403 Current Mid Term Paper Fall 2016</a></span><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;"><ul style="text-align: left;">
<li>Your assignment should be in .doc /.docx format. </li>
<li>Save your assignment with your ID (e.g. bc000000000.doc).</li>
<li>No assignment will be accepted through email.</li>
</ul>
</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:<br /><ul style="text-align: left;">
<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 (Strict disciplinary action will be taken in this case).</li>
</ul>
<b>Recommended : </b><a href="http://virtualstudysolutions.blogspot.com/2017/05/cs101-graded-assignment-no-1-solution.html">CS101 Graded Assignment No 1 Solution Spring 2017</a></span></div>
<h3 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Deadline:</span></h3>
<div>
<span style="font-family: Verdana, sans-serif;">Your assignment must be uploaded/submitted on or before 19th May 2017.</span><span style="font-family: Verdana, sans-serif;"><br /></span><h3 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Question: </span></h3>
<div>
<span style="font-family: Verdana, sans-serif;">(15 Marks)<br />A public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw an entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities.<br /><br />A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward in the hospital will keep personal record of the patients such as (patient ID, patient name, CNIC, address). Along with personal record, complete treatment history of the patient will also be maintained by the system. <br /><br /><br /><b>Please Note:</b> Do not put any query on MDB about this assignment, if you have any query then email at <b>cs403@vu.edu.pk</b>. </span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">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></div>
<div>
<h4 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">Download CS403 Assignment No 2 Solution Spring 2017</span></h4>
<span style="font-family: Verdana, sans-serif;">CS403 Assignment Solution file will be added Soon.<br /><br />If you want to receive the solution file in your mail box as soon as solution is updated. Please Subscribe below or Like us on Facebook. Thank You.</span></div>
</div>
</div>
</div>

CS403 Assignment No 2 Spring 2017 Solution and Discussion

CS403 Assignment No 2 Spring 2017 Here You can read and Download CS403 – Database Management Systems Assignment No 02 Solution and Disc...

Latest Articles »

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 »

CS403 Assignment No. 2 Solution Fall 2016

<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="font-family: Trebuchet MS, sans-serif;">CS403 Assignment No. 2 Fall 2016</span></h3>
<span style="font-family: Trebuchet MS, sans-serif;">Dear Students. Here You can get <b>CS403 Assignment No. 2 Solution</b> for <b>Fall 2016</b>. CS403 – Database Management Systems Assignment Due Date: 02/12/2016. Total Marks= 15. </span><h3 style="text-align: left;">
<span style="font-family: Trebuchet MS, sans-serif;">CS403 Assignment Uploading instructions: </span></h3>
<div>
<ul style="text-align: left;">
<li><span style="font-family: Trebuchet MS, sans-serif;">Your assignment should be in .doc /.docx format. </span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;">Save your assignment with your ID (e.g. bc000000000.doc). </span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;">No assignment will be accepted through email. </span></li>
</ul>
</div>
<h3 style="text-align: left;">
<span style="font-family: Trebuchet MS, sans-serif;">CS403 Assignment Rules for Marking: </span></h3>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">It should be clear that your assignment will not get any credit if:</span></div>
<div>
<ul style="text-align: left;">
<li><span style="font-family: Trebuchet MS, sans-serif;">The assignment is submitted after due date. </span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;">The submitted assignment does not open, execute or file is corrupted. </span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;">Your assignment is copied from internet, handouts or from any other student (Strict disciplinary action will be taken in this case).  </span></li>
</ul>
<h3 style="text-align: left;">
<span style="font-family: Trebuchet MS, sans-serif;">You Should Also read:</span></h3>
</div>
<div>
<ul style="text-align: left;">
<li><a href="http://virtualstudysolutions.blogspot.com/2015/01/cs-201-all-past-solved-midterm-papers.html"><span style="font-family: Trebuchet MS, sans-serif;">CS 201 all past solved midterm papers 2015</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2015/01/mth301-midterm-solved-past-papers.html"><span style="font-family: Trebuchet MS, sans-serif;">Mth301 midterm Solved past papers</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2013/06/cs101-mid-term-16-solved-papers-quizzes.html"><span style="font-family: Trebuchet MS, sans-serif;">CS101 Mid term 16 SOlved Papers + Quizzes + Solved Subjectives + HTML TAGS</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2015/01/financial-accounting-mgt101-solved.html"><span style="font-family: Trebuchet MS, sans-serif;">financial accounting MGT101 Solved Papers</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2015/02/cs201-solved-final-term-past-papers.html"><span style="font-family: Trebuchet MS, sans-serif;">CS201 Solved Final Term Past Papers Collection</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2013/05/cs-assignment-no-2-solution.html"><span style="font-family: Trebuchet MS, sans-serif;">Cs101 Assignment no 2 Solution</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2013/08/how-to-make-datesheet-for-exam-at-vu.html"><span style="font-family: Trebuchet MS, sans-serif;">HOW TO MAKE DATESHEET FOR EXAM at VU</span></a></li>
<li><a href="http://virtualstudysolutions.blogspot.com/2015/02/cs101-latest-solved-mcqs.html"><span style="font-family: Trebuchet MS, sans-serif;">CS101 Latest Solved MCQs</span></a></li>
</ul>
</div>
<div>
<h3 style="text-align: left;">
<span style="font-family: Trebuchet MS, sans-serif;">CS403 Assignment Question: (15 Marks) </span></h3>
</div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">As you all know that Virtual University of Pakistan provides an interface to the student for making their own
exam date-sheet according to their convenience. In date-sheet interface, students are required to enter their VU
allocated ID and password to get logged in the system. In next step, students are required to select exam
city/center of their choice before further proceedings. After that, a list of students’ registered courses will be
displayed and students will select the date and time of exam for each course to finalize their date-sheet. </span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">Also, note
that students and exam data is managed by a system administrator in the date-sheet system. </span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">Now, by keeping the above scenario in your mind, you are required to:</span></div>
<div>
<ul style="text-align: left;">
<li><span style="font-family: Trebuchet MS, sans-serif;">Identify all the Entities along with proper attributes. [5 Marks] </span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;">Make an ER Diagram of the system showing all entities, their attributes and relations among the entities.
[10 Marks] </span></li>
</ul>
</div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">NOTE: Do not put any query on MDB about this assignment, </span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">if you have any query then email at
<a href="mailto:cs403@vu.edu.pk" rel="nofollow" target="_blank">cs403@vu.edu.pk</a>. </span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;">Deadline: Your assignment must be uploaded/submitted on or before 2nd December 2016. </span><h4 style="text-align: left;">
<span style="font-family: Trebuchet MS, sans-serif;"><span style="font-size: x-large;">CS403 Assignment No. 2 Solution </span></span></h4>
<span style="font-family: Trebuchet MS, sans-serif;">You can Download the Solution of CS403 Assignment No. 2 Solution Fall 2016 from the Links Below:</span></div>
<ul style="text-align: left;">
<li><span style="font-family: Trebuchet MS, sans-serif;"><a href="http://vustudents.ning.com/group/cs403databasemanagementsystems/forum/attachment/download?id=3783342%3AUploadedFile%3A5686838" rel="nofollow" target="_blank">CS403 Assignment No. 2 Solution_by_Ayyaz.docx</a>, 78 KB</span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;"><a href="http://vustudents.ning.com/group/cs403databasemanagementsystems/forum/attachment/download?id=3783342%3AUploadedFile%3A5687032" rel="nofollow" target="_blank">CS403 Assignment No. 2 Solution_by_Ajmal.docx</a>, 36 KB</span></li>
<li><span style="font-family: Trebuchet MS, sans-serif;"><a href="http://vustudents.ning.com/group/cs403databasemanagementsystems/forum/attachment/download?id=3783342%3AUploadedFile%3A5687264" rel="nofollow" target="_blank">CS403 Assignment No. 2 Solution_by_hammad.docx</a>, 73 KB</span></li>
</ul>
</div>

CS403 Assignment No. 2 Solution Fall 2016

CS403 Assignment No. 2 Fall 2016 Dear Students. Here You can get CS403 Assignment No. 2 Solution for Fall 2016 . CS403 – Database Manage...

Latest Articles »

Virtual Study Solutions

Adsetra Ads

CS403 Assignment No 1 Solution Spring 2018

CS403 Assignment No 3 Solution Spring 2017

CS403 Assignment No 2 Spring 2017 Solution and Discussion

CS403 Assignment No. 04 Fall 2016-17

CS403 Assignment No. 2 Solution Fall 2016

Trending

Archive