Educational Wealth

Course: Database-I (3410) Semester: Autumn 2018 Level: BS (CS) solved assighnment

Abdullah 0 3410, aiou, autumn 2018, solved Assighnment Friday, March 15, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Course: Database-I (3410)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Semester: Autumn 2018</span><br />
<h2 dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Level: BS (CS)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Total Marks: 100</span></h2>
<h2 dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Pass Marks: 50</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span></h2>
<h2 dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 13.999999999999998pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 13.999999999999998pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 13.999999999999998pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">ASSIGNMENT No. 1</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 13.999999999999998pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span></h2>
<br />
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: italic; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Note: All questions are compulsory. Each question carries equal marks.</span></div>
<br />
<h3 style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Q. 1</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(a)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">What is the difference between data and information? Elaborate different types of data that we need to store.</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">(20)</span></h3>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(b)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Define database and database management system.</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(c)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Describe the advantages of database approach over the legacy filing system.</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span></div>
<br />
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Q. 2</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Differentiate the following:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">(20)</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(a)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Generalization and Categorization</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(b)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Entity and Relationship</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(c)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Strong Entity and Week Entity</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(d)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Data and Metadata</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Q. 3</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">The figure below shows a class list for AIOU. Convert this user view to a set of 3NF relations. Assume the following:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">(20)</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">a)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">An instructor has a unique location.</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">b)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">A student has a unique major</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">c)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">A course has a unique titl</span><br />
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span>
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
<div dir="ltr" style="margin-left: 27pt;">
<table style="border-collapse: collapse; border: none;"><colgroup><col width="119"></col><col width="127"></col><col width="127"></col><col width="119"></col></colgroup><tbody>
<tr style="height: 0pt;"><td colspan="4" style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 12pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Allama Iqbal Open University</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Class List – Spring 2013</span></div>
</td></tr>
<tr style="height: 0pt;"><td colspan="4" style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Course Code:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> 1431</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Course Title:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> Fundamental of Computers</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Instructor Name:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> ABC</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Instructor Location:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> R-0001</span></div>
</td></tr>
<tr style="height: 0pt;"><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Student ID</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Student Name</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Major</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Grade</span></div>
</td></tr>
<tr style="height: 0pt;"><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">25210</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">AA</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">SE01</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">A+</span></div>
</td></tr>
<tr style="height: 0pt;"><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">23735</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">BC</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">DF02</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">B+</span></div>
</td></tr>
<tr style="height: 0pt;"><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">27265</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">CD</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">SE03</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">C+</span></div>
</td></tr>
<tr style="height: 0pt;"><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">27399</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">DE</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">DB04</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">D+</span></div>
</td></tr>
<tr style="height: 0pt;"><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">...</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">...</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">...</span></div>
</td><td style="border-bottom: solid #000000 0.5pt; border-left: solid #000000 0.5pt; border-right: solid #000000 0.5pt; border-top: solid #000000 0.5pt; padding: 0pt 5.4pt 0pt 5.4pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">...</span></div>
</td></tr>
</tbody></table>
</div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Q. 4</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Draw E-R Model for the following scenario:</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">(20)</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: justify; text-indent: -27pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">A university offers a variety of programs at different levels, e. G., graduate, post graduate, etc. A large number of courses are offered in each program. Each course may have one or more courses as prerequisites. A faculty member teaches one or more courses and one course may be taught by more than one faculty members. The model should be able to preserve the complete information about the courses. The model should be able to preserve the complete information about the courses, programs and faculty members.</span></div>
<br />
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Q. 5</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(a)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Define logical database model. What are its types? Explain it in detail with the help of suitable examples.</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">(20)</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(b)</span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">    </span><span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Define physical database design. Explain its main components and major objective in detail.</span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="color: blue;"><b>click here for</b></span><br />
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://educational-wealth.blogspot.com/2019/03/aiou-course-database-i-3410-semester.html" target="_blank">assighnment #2 (3410) autumn 2018</a></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3-L2tKJqSbMh06wKtEduJyvgP-QbfH0u19SN1_VQnVZLtqQln6NEGsudPGk4dseG8Z5Jmrz6U4a4iq9JNTCS4Uw_BrR_EGcsms5yCytgUc3Xd_ladTEcuzb7TFaGfyxSDK-JFoJRp8pQ/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3-L2tKJqSbMh06wKtEduJyvgP-QbfH0u19SN1_VQnVZLtqQln6NEGsudPGk4dseG8Z5Jmrz6U4a4iq9JNTCS4Uw_BrR_EGcsms5yCytgUc3Xd_ladTEcuzb7TFaGfyxSDK-JFoJRp8pQ/s320/image.jpg" width="320" /></a></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMOhFqQdt42ZKfuNbs_YZOVlY6mE4IOe4fmUQu37YNcXH5k4_wrnni44aFAYQKwIKi7KPRCCb7yPKh3RyK-UZoTBOPSzMdSZTsRJkm2xL6edosFd9NF048yKfFEXbeB5o7XynyCcTGWjw/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMOhFqQdt42ZKfuNbs_YZOVlY6mE4IOe4fmUQu37YNcXH5k4_wrnni44aFAYQKwIKi7KPRCCb7yPKh3RyK-UZoTBOPSzMdSZTsRJkm2xL6edosFd9NF048yKfFEXbeB5o7XynyCcTGWjw/s320/image.jpg" width="320" /></a></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizRApepV8i-F6wYi5NlRSzEU2QrUDjmKHVesVXhyox1oeZZyif2kqaqgiGnigW4PlSf3oPiyfuKlahJtauZGMdniwbTnuJTJ0ivQ5LFC7T5J6_4n2TMg-2ZlRSMY39LktezKH2H9F7mGg/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizRApepV8i-F6wYi5NlRSzEU2QrUDjmKHVesVXhyox1oeZZyif2kqaqgiGnigW4PlSf3oPiyfuKlahJtauZGMdniwbTnuJTJ0ivQ5LFC7T5J6_4n2TMg-2ZlRSMY39LktezKH2H9F7mGg/s320/image.jpg" width="320" /></a></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY72c1LlaXN3eeUT8ZJ9SPg5NdmJnRtBIQt0aM4iBnFAiUMjdzFhdWDpHlwyOpzOcwBwQ0waedA1Uv8daYgHNh91eKQbX8e02Tnc8uZVC7gOSGCjw00M3fejpCgybrIH4yPLlk5fRXE6A/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY72c1LlaXN3eeUT8ZJ9SPg5NdmJnRtBIQt0aM4iBnFAiUMjdzFhdWDpHlwyOpzOcwBwQ0waedA1Uv8daYgHNh91eKQbX8e02Tnc8uZVC7gOSGCjw00M3fejpCgybrIH4yPLlk5fRXE6A/s320/image.jpg" width="320" /></a></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSFzw6rn0dtebUlYQENQM0ouDqHcViOAmEgc9vG-tISbEqS_DafTD60-rRxQyGdHGvpP0Qwkt1SUuIV_uVjV9gmS6aPCl86i1J0qM9NUZ9i-jHGip-J2tqdjhqqPWgAn_xSMHpztpW8o4/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSFzw6rn0dtebUlYQENQM0ouDqHcViOAmEgc9vG-tISbEqS_DafTD60-rRxQyGdHGvpP0Qwkt1SUuIV_uVjV9gmS6aPCl86i1J0qM9NUZ9i-jHGip-J2tqdjhqqPWgAn_xSMHpztpW8o4/s320/image.jpg" width="320" /></a></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_HH6nqL_ro4pwVVF_Vk2Pb0uYDtIPkJoJ8uH8-MKBgGoQvwsndIglmuGtlCj_I5MBxy4qf23UdVgp6FCeozSfzN8IDFXw7RtWJ8_2YCNjFkKrqAuIBJF2RFaYAWjNTxurjy8Nbl9nMqc/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_HH6nqL_ro4pwVVF_Vk2Pb0uYDtIPkJoJ8uH8-MKBgGoQvwsndIglmuGtlCj_I5MBxy4qf23UdVgp6FCeozSfzN8IDFXw7RtWJ8_2YCNjFkKrqAuIBJF2RFaYAWjNTxurjy8Nbl9nMqc/s320/image.jpg" width="320" /></a></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #351c75;"><span style="background-color: #eeeeee;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt6t3uxzHnfcmX62Z21duxOJDghViLlTUcGymyJgnnA7fzY7wdS1UeVPO4jXTWoGTb9CWqWkME2nOMqhtY5Zz7dzEy2AR6XdMZ-4pr0vhD7URSXSbj5_d4J0yMRFu41p398rgR7d3On6E/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt6t3uxzHnfcmX62Z21duxOJDghViLlTUcGymyJgnnA7fzY7wdS1UeVPO4jXTWoGTb9CWqWkME2nOMqhtY5Zz7dzEy2AR6XdMZ-4pr0vhD7URSXSbj5_d4J0yMRFu41p398rgR7d3On6E/s320/image.jpg" width="320" /></a></span></span></div>
</div>
</div>

Course: Database-I (3410) Semester: Autumn 2018 Level: BS (CS) solved assighnment

Course: Database-I (3410) Semester: Autumn 2018 Level: BS (CS) Total Marks: 100 Pass Marks: 50 ASSIGNMENT...

database-1 outline (3410) assighnment autumn 2018

Abdullah 0 Friday, March 15, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> database-1     outline (3410)</span><br />
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">click for assighnment autumn 2018 here</span><br />
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">3410 1st assighnment</span><br />
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">3410 2nd assighnment </span></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-left: -13.5pt; margin-top: 0pt; padding: 0pt 0pt 0pt 67.5pt; text-align: justify; text-indent: -67.5pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><img alt="3410-oUTLINE.jpg" height="770" src="https://lh5.googleusercontent.com/JQmQiIMcpK3xqkm8L8SPAZdVh8m10Iu5TC5PcbUO6HWbdeTyn-dxqCWrGGo91PIEYqS0dM8CX-5b6hHs-7xgBINi5pA2Y-v1ufbKqj3ks5JrMqMHBMUUm5FLPsOFvQ2-P-QWn0qA0DRI9QRzsg" style="border: medium none; transform: rotate(0rad);" width="561" /></span><img height="19" src="https://docs.google.com/drawings/d/si3XHKLhDtNabqCDeNtEipw/image?w=32&h=19&rev=1&ac=1&parent=14__ODz4KljR2PdKFAERXtPvTC2wLRCD8xlhojKXsUFg" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="32" /><img height="19" src="https://docs.google.com/drawings/d/sFenAFZSACtok9iRe1EPKng/image?w=32&h=19&rev=1&ac=1&parent=14__ODz4KljR2PdKFAERXtPvTC2wLRCD8xlhojKXsUFg" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="32" /><img height="19" src="https://docs.google.com/drawings/d/sfST3OPO6KJ2YwgnF3a_qbg/image?w=32&h=19&rev=1&ac=1&parent=14__ODz4KljR2PdKFAERXtPvTC2wLRCD8xlhojKXsUFg" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="32" /><img height="19" src="https://docs.google.com/drawings/d/sAtV3sSRD5VBo-aNBiUu-VQ/image?w=32&h=19&rev=1&ac=1&parent=14__ODz4KljR2PdKFAERXtPvTC2wLRCD8xlhojKXsUFg" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="32" /></div>
<div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 54pt; text-align: justify; text-indent: -54pt;">
<span style="background-color: transparent; color: black; font-family: "times new roman"; font-size: 10pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Unit# Entity-Relationship Modeling</span></div>
<br />
<img height="488" src="https://lh4.googleusercontent.com/qDoSaiku2R5hfD-YLNcfG5YGZ_61jKdyoVlxvp5dnhV-bIvB3XseJ9nZW2_HqJn8NxpGwe7_hPtp30-IoWBm1U8N7ebaHdCBq5WK2CbA9Xcnui8MKBq2Ma7hKkHWKxOylq_Pv71A7RATjTWO5w" style="border: medium none; transform: rotate(0rad);" width="538" /></div>