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

<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

Abdullah 0 Friday, March 15, 2019

Course: Database-I (3410)    Semester: Autumn 2018 Level: BS (CS)    Total Marks: 100         Pass Marks: 50            ASSIGNMENT No. 1    Note: All questions are compulsory. Each question carries…

Continue Reading »

database-1 outline (3410) assighnment autumn 2018

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

database-1 outline (3410) assighnment autumn 2018

Abdullah 0 Friday, March 15, 2019

database-1 outline (3410) click for assighnment autumn 2018 here 3410 1st assighnment 3410 2nd assighnment Unit# Entity-Relationship Modeling …

Continue Reading »

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

<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> <br /> <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: 13.999999999999998pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">ASSIGNMENT No. 2</span></div> <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;">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></h2> <br /> <div dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 0pt 27pt; text-align: center; 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 /> <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. 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;">Briefly explain the term normalization. And apply normalization on a real life example. </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;">Also write down the importance of normalization.</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;">What is an anomaly?  Explain inset, delete and update anomaly with a suitable example.</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> <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. 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;">(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;">Differentiate data administrator and database administrator. Also write down the </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;">responsibilities of each in detail.</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;">Write down the steps to create a simple form application to maintain information of </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;">employees of a company.</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. 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;">Describe the following SQL commands with a suitable example:</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;">Select, Where clause, order By, Insert Into, Update and Delete, Like, Between, SQL Joins </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;">(Inner, Left, Right, Full, Self), Union, Group By, Having and Select Into</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. 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;">(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 do you mean by a report object navigator and object type? Give list of different </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;">object types and their description.</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;">What are the advantages of using the forms?</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;">What are different joins available in SQL? Explain any three of them with 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: 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><br /> <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;"><br /></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;">What are the advantages of join?</span></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo4abl12RgTOYHylt4VZLB3-aLXlPUNlPQg6SNc5lFT1169cZYGwhsPDsTSxPwv3kCOd919r-PapiyPbl_3qvha11prORwR_Mfvyka-XDuZNsoJysqLUzwP0Kgi0Zg7fsHFaBu3SUkGgw/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/AVvXsEgo4abl12RgTOYHylt4VZLB3-aLXlPUNlPQg6SNc5lFT1169cZYGwhsPDsTSxPwv3kCOd919r-PapiyPbl_3qvha11prORwR_Mfvyka-XDuZNsoJysqLUzwP0Kgi0Zg7fsHFaBu3SUkGgw/s320/image.jpg" width="320" /></a></div> <br /> <div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkDCHTUB596oA0Uu2SVcekB_iFsaxekS1RvxlqVTLxsz3hbnsMy2gBNouv92VryvI6Dr8oYTiEWh94CO6ShNRoRVQWYJNZM1pkHyjFW1m0UrZh8JYsh8j74p77qDcf_8b3z1YKh5zgAA8/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkDCHTUB596oA0Uu2SVcekB_iFsaxekS1RvxlqVTLxsz3hbnsMy2gBNouv92VryvI6Dr8oYTiEWh94CO6ShNRoRVQWYJNZM1pkHyjFW1m0UrZh8JYsh8j74p77qDcf_8b3z1YKh5zgAA8/s400/image.jpg" width="400" /></a></div> <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-left: -13.5pt; margin-top: 0pt; padding: 0pt 0pt 0pt 67.5pt; text-align: justify; text-indent: -67.5pt;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikbXtk9fKvf9XFYaMVsWCXX2idpCQSmRn44i-93DYtRCJKxcS5pvzrDLJFMy9EEm0LKya4xh0_T6zk28z28kNJdmBO_I6OVT_cjFRDb-XykNH9cqgVUClA0PzS8BiNcmuYCSrbPLnCIPk/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikbXtk9fKvf9XFYaMVsWCXX2idpCQSmRn44i-93DYtRCJKxcS5pvzrDLJFMy9EEm0LKya4xh0_T6zk28z28kNJdmBO_I6OVT_cjFRDb-XykNH9cqgVUClA0PzS8BiNcmuYCSrbPLnCIPk/s400/image.jpg" width="400" /></a></div> <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><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" /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj23Sdi6TX5YN-En4XtDKkSlDNgsnEVfSZ_hISvgTD2T0W5lOfZ25A0maFGhrZRnKnUWv70EQE1Ruc_8H7qGzW1tnE8cMNEyUxG0JGBF1VQ8xgJNR25JwWRej-iSeJhRzqdt9Cg8uD_CIs/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj23Sdi6TX5YN-En4XtDKkSlDNgsnEVfSZ_hISvgTD2T0W5lOfZ25A0maFGhrZRnKnUWv70EQE1Ruc_8H7qGzW1tnE8cMNEyUxG0JGBF1VQ8xgJNR25JwWRej-iSeJhRzqdt9Cg8uD_CIs/s400/image.jpg" width="400" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_WQ8jsTo0oP-ffwQWWabzs7eX2-QIYm_oYaz_D8i5lcUagtdGPi6Q6XXKbdMJwSR132TmrAY2nNAd1iDP7XUK1n0A2yjZsRE3OU7tcDgXh6VYuhPqcaPbnkhyphenhyphensDqcK5yMyYVlRwDjZrw/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_WQ8jsTo0oP-ffwQWWabzs7eX2-QIYm_oYaz_D8i5lcUagtdGPi6Q6XXKbdMJwSR132TmrAY2nNAd1iDP7XUK1n0A2yjZsRE3OU7tcDgXh6VYuhPqcaPbnkhyphenhyphensDqcK5yMyYVlRwDjZrw/s400/image.jpg" width="400" /></a></div> <br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5LgHHjfV6ygpINH33CcoHoMPESzgQOXr675fKeKqKVIe8rcNeRHzO5EFLfseUOsPJxo27PBsgxca0o5o9li3NmaEagaMbe07p0nS-a3ICrrrhv6064fi66xuFxzYSwRycMJ-bsirKX8A/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5LgHHjfV6ygpINH33CcoHoMPESzgQOXr675fKeKqKVIe8rcNeRHzO5EFLfseUOsPJxo27PBsgxca0o5o9li3NmaEagaMbe07p0nS-a3ICrrrhv6064fi66xuFxzYSwRycMJ-bsirKX8A/s400/image.jpg" width="400" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuNrDJW49q4fMJhzwMXDjqXgiayJhhjuB7GO01DRV79qNfBF0mHwxK8GxHVlFPclZPQBO_7uY9itRsKzayWAUscLna56BtOoYGZ7cJWhp_tlqjKdkIWMszC3AVd-9BPFwsE1h_2UJtWIk/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuNrDJW49q4fMJhzwMXDjqXgiayJhhjuB7GO01DRV79qNfBF0mHwxK8GxHVlFPclZPQBO_7uY9itRsKzayWAUscLna56BtOoYGZ7cJWhp_tlqjKdkIWMszC3AVd-9BPFwsE1h_2UJtWIk/s400/image.jpg" width="400" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPp3K9x_h6VRJW5PlL5wFOU2JGZ6p8Y1z3jZWIYm2HJiPIdIqh9yjHDHkOBoOX3pk6i1_Mftf-xjOhezQYdEgxp0b2-npkDtjJ5mUOYnbL-BQVMmyJz559t6vcQfOqF_QaS3IbbgFHcc0/s1600/image.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1196" data-original-width="1600" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPp3K9x_h6VRJW5PlL5wFOU2JGZ6p8Y1z3jZWIYm2HJiPIdIqh9yjHDHkOBoOX3pk6i1_Mftf-xjOhezQYdEgxp0b2-npkDtjJ5mUOYnbL-BQVMmyJz559t6vcQfOqF_QaS3IbbgFHcc0/s400/image.jpg" width="400" /></a></div> <br /> <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 /> <a href="https://www.blogger.com/blogger.g?blogID=4540382126610807499#editor/target=post;postID=4339436805747722577;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=link" target="_blank"><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></a><br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <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;"> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <span style="background-color: transparent; color: black; font-family: "arial"; font-size: 8pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"></span></div> </div> </div>

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

Abdullah 0 Monday, March 11, 2019

Course: Database-I (3410)    Semester: Autumn 2018 Level: BS (CS)    Total Marks: 100         Pass Marks: 50    ASSIGNMENT No. 2         Total Marks: 100         Pass Marks: 50 Note: All questions a…

Continue Reading »