Virtual Study Solutions: CS403 Assignment No 2

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

Virtual Study Solutions

Adsetra Ads

CS403 Assignment No 2 Spring 2017 Solution and Discussion

CS403 Assignment No. 2 Solution Fall 2016

Trending

Archive