Virtual Study Solutions: CS403 Assignment Solution

CS403 Assignment No 2 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 2 Spring 2018</span></h3>
<span style="font-family: "verdana" , sans-serif;">Dear Students, Here you can read or Downl</span><span style="font-family: "verdana" , sans-serif;">oad <b>CS403</b> - <u>Database Management Systems</u>  <b>Assignment No 2 Solution</b> and Discussion of Semester <b>Spring 2018</b>. Assignment Due Date is 28 MAY, 2018. Total Marks are 20.This assignment is based on the previous scenario (<a href="https://virtualstudysolutions.blogspot.com/2018/05/cs403-assignment-no-1-solution-spring-2018.html" target="_blank">Assignment No.1 solution</a>).       We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. <u>CS403 </u></span><span style="font-family: "verdana" , sans-serif;"><u>Assignment Solution</u> File has been added. Previously we share</span><span style="font-family: "verdana" , sans-serif;">d <a href="https://virtualstudysolutions.blogspot.com/2018/05/cs301-assignment-no-2-solution-spring-2018.html">CS301 Assignment No 2 Solution Spring 2018</a>.</span><br />

<h3>
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment No 2 Solution Fall 2019</span></h3>
<div>
<div class="post-table">
<table><thead>
<tr><th><span style="font-family: "verdana" , sans-serif;">File Name</span></th><th><span style="font-family: "verdana" , sans-serif;">Download Link</span></th></tr>
</thead><tbody>
<tr><td data-label="First Name"><span style="font-family: "verdana" , sans-serif;"><i class="fa fa-file-word-o"></i>CS403  Assignment No 2 Solution Fall 2019.docx </span></td><td data-label="Last Name"><span style="font-family: "verdana" , sans-serif;"><a class="button large download" href="https://virtualstudysolutions.blogspot.com/2019/11/cs403-assignment-no-2-solution-fall-2019.html" rel="" target="_blank">Download</a></span></td></tr>
</tbody></table>
</div>
</div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<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/AVvXsEh3qHYQaV-AkJrwzmdZGTBl836blYbv7BXn7DkE1xe01wNGFociZNO15VUBsuJVTIFx0nglY9XNzhJ_EnEzdvkoYYeowqa92xslC3bIWRhcwyYJSeuhITAkVhdT0suKaaPT74qW7gLuI8U/s1600/CS403-Assignment-no-2-solution-discussion-spring-2018.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment No 2 Solution and Discussion Spring 2018" border="0" data-original-height="669" data-original-width="944" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3qHYQaV-AkJrwzmdZGTBl836blYbv7BXn7DkE1xe01wNGFociZNO15VUBsuJVTIFx0nglY9XNzhJ_EnEzdvkoYYeowqa92xslC3bIWRhcwyYJSeuhITAkVhdT0suKaaPT74qW7gLuI8U/s320/CS403-Assignment-no-2-solution-discussion-spring-2018.png" title="CS403 Assignment No 2 Solution 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 2 Solution and Discussion Spring 2018</span></td></tr>
</tbody></table>
<h4 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment Uploading instructions: </span></h4>
<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>
<h4 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment Rules for Marking: </span></h4>
<span style="font-family: "verdana" , sans-serif;">It should be clear that your assignment will not get any credit if: </span><br />
<ol style="text-align: left;"><span style="font-family: "verdana" , sans-serif;">
<li>The assignment is submitted after due date </li>
<li>The assignment is copied </li>
<li>The assignment solution does not have own VU-ID as database name </li>
<li>The assignment solution has other student ID </li>
</span></ol>
<span style="font-family: "verdana" , sans-serif;">
</span>
<h4 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">CS403 Assignment Objectives</span></h4>
<span style="font-family: "verdana" , sans-serif;">The motive of this assignment is to enable students how to transform ER data model in to Relations with Primary Foreign key constrains. It will also help the students to understand Basic Operators of Relational Algebra and Join </span><span style="font-family: "verdana" , sans-serif;">Operations.</span><br />
<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/AVvXsEhjaNFrEaXEYOsRVQ3PDVvSrBbjIV5oZSxuoziZ5UUrf6FWYd7bjxGidK_Vfyrau71X7HlVrH0xEGda-sNUkSDhjdzJs6lqRNgaZPNc5q5vhyphenhyphenNjKrMtazyC5C8_MmX610DQbbl8xAez2f8/s1600/CS403-important-instructions-spring-2018.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment No 2 important instructions Spring 2018" border="0" data-original-height="549" data-original-width="425" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjaNFrEaXEYOsRVQ3PDVvSrBbjIV5oZSxuoziZ5UUrf6FWYd7bjxGidK_Vfyrau71X7HlVrH0xEGda-sNUkSDhjdzJs6lqRNgaZPNc5q5vhyphenhyphenNjKrMtazyC5C8_MmX610DQbbl8xAez2f8/s640/CS403-important-instructions-spring-2018.png" title="CS403 Assignment No 2 important instructions Spring 2018" width="492" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: "verdana" , sans-serif;">CS403 Assignment No 2 important instructions Spring 2018</span></td></tr>
</tbody></table>
<div>
<br />
<h3 style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Assignment Question:</span></h3>
<span style="font-family: "verdana" , sans-serif;">You are required to thoroughly observe the ERD as above ( solution of assignment No.1) and provide solution of the following tasks:</span><br />
<div>
<ol style="text-align: left;">
<li><span style="font-family: "verdana" , sans-serif;">Map all entities into Relations with Primary, Foreign key constrains where possible. </span></li>
<li><span style="font-family: "verdana" , sans-serif;">Consider the below populated relations. Perform the cross product on SERVICES and EVENT relations by providing the resultant relation. </span></li>
<li><span style="font-family: "verdana" , sans-serif;">Apply projection operation on SERVICES relation and provide resultant relation. I-I serID , serCharges (SERVICES)</span></li>
<li><span style="font-family: "verdana" , sans-serif;">Take Union of SERVICES and EVENT relations and provide output.</span></li>
</ol>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5XNaMUakQpTWwwF7MilWVStq4Bt-5UTS9M2aQdooid1g1amDH3HwFsqReP4RF1zOeQh0ZtTsguARXxKwW4QkJq70aDHpvEFrcttjRw-FTDQ3uFnVP08y-DhM3WJfTe2ofNz2zQmRADbI/s1600/CS403-assignment-question-spring-2018.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CS403 Assignment Question" border="0" data-original-height="272" data-original-width="382" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5XNaMUakQpTWwwF7MilWVStq4Bt-5UTS9M2aQdooid1g1amDH3HwFsqReP4RF1zOeQh0ZtTsguARXxKwW4QkJq70aDHpvEFrcttjRw-FTDQ3uFnVP08y-DhM3WJfTe2ofNz2zQmRADbI/s320/CS403-assignment-question-spring-2018.png" title="CS403 Assignment Question" width="320" /></a></div>
<div>
<br /></div>
<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 2 Solution Spring 2018</span></h3>
<span style="font-family: "verdana" , sans-serif;">You can see the Sample Preview </span><span style="font-family: "verdana" , sans-serif;"><span style="font-family: "verdana" , sans-serif;">of</span> (<u>Database Management Systems</u>) <b>CS403 Assignment No 2 Solution</b> </span><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;"></span><br />
<ul style="text-align: left;"><span style="font-family: "verdana" , sans-serif;">
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/cs001-assignment-no-2-solution-spring-2018.html">CS001 Assignment No 2 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/cs101-assignment-no-2-solution-spring-2018.html">CS101 Assignment No 2 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/eng001-assignment-no-2-solution-spring.html">ENG001 Assignment No 2 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/eng101-assignment-no-2-solution-spring-2018.html">ENG101 Assignment No 2 Solution Spring 2018</a></li>
<li><a href="https://virtualstudysolutions.blogspot.com/2018/05/eng201-assignment-no-2-solution-spring-2018.html">ENG201 Assignment No 2 Solution Spring 2018</a></li>
</span></ul>
<span style="font-family: "verdana" , sans-serif;">
</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 Sample Preview</span></span></h4>
<div>
<span style="font-family: "verdana" , sans-serif;">Idea Solution 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 in .docx format.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>Solution Idea - 1 Preview:</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<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/AVvXsEj90iCkpl-3MCjVjNUSgDtw9qNkNZBoGf-t2RGQnnvVmuRQny3UHA_g3fRIA7F9hxYJYeDnL6UHMick30n7lI_6Un1pFg-KtEzlG8cYLB8Du1qP_MoAiAOhdOOX4ASRxspQEaEBl47MsGc/s1600/CS403-Assignment-no-2-solution-idea-1-sample-preview-spring-2018.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment Solution Idea - 1 Sample Preview" border="0" data-original-height="603" data-original-width="963" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90iCkpl-3MCjVjNUSgDtw9qNkNZBoGf-t2RGQnnvVmuRQny3UHA_g3fRIA7F9hxYJYeDnL6UHMick30n7lI_6Un1pFg-KtEzlG8cYLB8Du1qP_MoAiAOhdOOX4ASRxspQEaEBl47MsGc/s640/CS403-Assignment-no-2-solution-idea-1-sample-preview-spring-2018.png" title="CS403 Assignment Solution Idea - 1 Sample Preview" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: "verdana" , sans-serif;">CS403 Assignment Solution Idea - 1 Sample Preview</span></td></tr>
</tbody></table>
<span style="font-family: "verdana" , sans-serif;"><b>Solution Idea - 2 Preview:</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<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/AVvXsEi9gkqNVJte2fAlBtlx8gRdgPLH4pWpkOPVkCLIdQheer3TT_bOihAQDDSIMLDN4Jk6ALAoI74VnKBJGW5fSEBQKBKFCWTGVNd1xUekFzI6atVx401k_0Ka3raa6TzrVfevLAXqPKml3ZQ/s1600/CS403-Assignment-no-2-solution-idea-2-sample-preview-spring-2018.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="CS403 Assignment Solution Idea - 2 Sample Preview" border="0" data-original-height="587" data-original-width="976" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9gkqNVJte2fAlBtlx8gRdgPLH4pWpkOPVkCLIdQheer3TT_bOihAQDDSIMLDN4Jk6ALAoI74VnKBJGW5fSEBQKBKFCWTGVNd1xUekFzI6atVx401k_0Ka3raa6TzrVfevLAXqPKml3ZQ/s640/CS403-Assignment-no-2-solution-idea-2-sample-preview-spring-2018.png" title="CS403 Assignment Solution Idea - 2 Sample Preview" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: "verdana" , sans-serif;">CS403 Assignment Solution Idea - 2 Sample Preview</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=1sp2iJFXcCCEHJAmWJVL13OP2JgGEUqVl" rel="nofollow" style="font-family: verdana, sans-serif;" target="_blank"> Download</a><span style="font-family: "verdana" , sans-serif;">  [ Solution Idea -1 Upload Status : <span style="color: lime;">Done </span>]</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><a class="bevel orange" href="https://drive.google.com/open?id=1z7rXx3jK2MWrdn5FICjXxj19dI4ISr7g" rel="nofollow" style="font-family: verdana, sans-serif;" target="_blank">Download</a><span style="font-family: "verdana" , sans-serif;">  [ Solution Idea -2 Upload Status : <span style="color: lime;">Done </span>]</span></span></div>
</div>
</div>
</div>

CS403 Assignment No 2 Solution Spring 2018

CS403 Assignment No 2 Spring 2018 Dear Students, Here you can read or Downl oad CS403 - Database Management Systems Assignment No 2 So...

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

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 Solution Spring 2018

CS403 Assignment No. 04 Fall 2016-17

CS403 Assignment No. 2 Solution Fall 2016

Trending

Archive