tag:blogger.com,1999:blog-91635985522422451402024-03-11T15:14:10.139+05:30TGTPGTCSThis website is for all students and teacher of computer science. Class 11 and 12 CS and IP , TGT and PGT CS, Helpful for DSSSB, KVS, APS, NVS, HTET, BSTET ExamsS P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.comBlogger648125tag:blogger.com,1999:blog-9163598552242245140.post-72169721363798003982024-03-11T15:13:00.001+05:302024-03-11T15:13:37.677+05:30कर्म और धर्म यह मेरे द्वारा सैकड़ों लोगों के केस स्टडी पर आधारित है ।युवाओं के साथ काफी समय बिताने के बाद मुझे लगता है यह स्थिति लगभग 90 प्रतिशत युवाओं की हैं..<div><br></div><div>जैसे जैसे हम युवावस्था में प्रवेश करते हैं वैसे वैसे साम्यवाद की ओर झुकाव होता है। फिर धीरे धीरे हम नास्तिक हो जाते हैं घोर आस्तिक पृष्ठभूमि से बंधे हों तो भी ईश्वरीय सत्ता पर प्रश्न खड़ा करने लगते हैं, कर्मकांड अब अंधविश्वास लगता है , कर्म के सिद्धांत के अतिवाद और पश्चिमी वैज्ञानिकता के प्रभाव में भारतीय धर्म के वैज्ञानिक पक्ष को नकार देते हैं। लेकिन जब दिन रात एक करके ईमानदारी से मेहनत करके भी वांछित परिणाम नही पाते तब मन मे क्रांति होता है और दृष्टिकोण में बदलाव आता है।यह क्रांति साम्यवाद से सनातन की ओर लाता है।</div><div>अंततः ज्ञात होता है कि सब ईश्वर का खेल है।कर्म तो प्रथम शर्त है ही लेकिन किसे क्या/कब/कितना देगा और किससे क्या लेगा यह सिर्फ वही जानता है इसमें आपकी इच्छा-अनिच्छा मायने नही रखता। </div><div>एक कहावत याद आ रहा है हालांकि इससे सीधे नही जुड़ा है..</div><div>" there is crime behind every fortune"</div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-32317207264540552932024-03-07T10:54:00.002+05:302024-03-07T10:55:00.577+05:307 मार्च की महत्त्वपूर्ण घटनाएँ*आज का इतिहास*<div><br></div><div>*7 मार्च की महत्त्वपूर्ण घटनाएँ :----*</div><div>रोमन सम्राट कॉन्स्टेंटाइन प्रथम ने 321 में रविवार को राजकीय विश्राम का दिन घोषित किया जो ईसाई मान्यताओं के अनुरूप था।</div><div>ब्रिटेन के बोस्टन पोर्ट को 1774 में सभी वाणिज्यिक गतिविधियों के लिए बंद कर दिया।</div><div>भारत में 1835 में यूरोपीय साहित्य और विज्ञान के प्रचार-प्रसार को बढ़ावा देने का प्रस्ताव लाया गया।</div><div>चार्ल्स मिलर ने सिलाई मशीन के लिए 1854 में पेटेंट हासिल किया था।</div><div>एलेक्ज़ेंडर ग्राहम बेल को 1876 में अपने टेलीफोन (दूरभाष) आविष्कार का पेटेंट मिला। 1906 से फिनलैंड में महिलाओं को वोट डालने का अधिकार मिला।</div><div>www.spsharmaclasses.com</div><div><br></div><div>मंगोलिया पर सोवियत रेड आर्मी ने 1925 में बाहरी कब्जा किया।</div><div>द्वितीय विश्व युद्ध के दौरान 1945 में अमेरिकी फौज ने जर्मनी की राइन नदी को पार किया।</div><div>1959 में अमेरिकी पायलट मेल्विन सी गार्लोव जेट विमानों से एक लाख मील की दूरी तय करने वाले पहले पायलट बने।</div><div>इसरायल ने 70 साल की गोल्डा मेयर को 1969 में अपनी पहली महिला प्रधानमंत्री चुना था।</div><div>शेख़ मुजिब-उर-रहमान ने 1971 में बांग्लादेश की स्वतंत्रता का आह्वान किया।</div><div>सन 1985 में एड्स का पहला एंटीबॉडी परीक्षण एलिसा-टाइप टेस्ट शुरु किया गया।</div><div>*7 मार्च को जन्मे व्यक्ति :-----*</div><div>रूसी चित्रकार बोरिस कुस्तोदीव का 1878 में जन्म।</div><div>प्रसिद्ध हिन्दी लेखक सच्चिदानंद हीरानंद वात्स्यायन ‘अज्ञेय’ का 1911 में जन्म।</div><div>भारत के प्रसिद्ध पूर्व क्रिकेट खिलाड़ी नरी कॉन्ट्रैक्टर का 1934 में जन्म।</div><div>राजनीतिज्ञ ग़ुलाम नबी आज़ाद का 1949 में जन्म।</div><div>वेस्टइंडीज के ऑलराइंडर सर विवियन रिचडर्स का 1952 में जन्म हुआ।</div><div>अभिनेता अनुपम खेर का 1955 में जन्म।</div><div>www.spsharmaclasses.com</div><div>*7 मार्च को हुए निधन :-----*</div><div>हिन्दी फ़िल्मों में प्रसिद्ध संगीतकार रवि का 2012 में निधन।</div><div>गुरु परमहंस योगानन्द जी का 1952 में निधन।</div><div>प्रसिद्ध स्वतंत्रता सेनानी और वरिष्ठ नेता गोविंद बल्लभ पंत का 1961 में निधन।</div><div>अमेरिकी फिल्म निर्देशक स्टैनली क्यूब्रिक का 1999 में निधन।</div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-43012686498865212452024-02-29T13:47:00.001+05:302024-02-29T13:47:51.365+05:30Sanchar Saathi Web Portal Kya haiSanchar Saathi portal दूरसंचार विभाग की एक नागरिक केंद्रित पहल है, जिसका उद्देश्य मोबाइल उपभोक्ताओं को सशक्त बनाना, उनकी सुरक्षा को मजबूत करना और सरकार की नागरिक केंद्रित पहलों के बारे में जागरूकता बढ़ाना है। Sanchar Saathi portal निम्नलिखित बातों को करने द्वारा नागरिकों को सशक्त बनाता है:<div><br></div><div>1. उनके नाम पर जारी किए गए मोबाइल कनेक्शन को जानना और उन्हें अपने मोबाइल नंबर का उपयोग करके लॉगिन करके अनुरोध करना। इसके लिए TAFCOP मॉड्यूल का उपयोग किया जाता है।</div><div><br></div><div>2. अपना खोया या चोरी हुआ मोबाइल ब्लॉक या ट्रैक करना। इसके लिए CEIR मॉड्यूल का उपयोग किया जाता है। </div><div><br></div><div>3. अपने वायरलाइन इंटरनेट सर्विस प्रोवाइडर को जानना। इसके लिए KYI मॉड्यूल का उपयोग किया जाता है। </div><div><br></div><div>4. भारतीय नंबर के साथ आने वाले अंतर्राष्ट्रीय कॉल को रिपोर्ट करना। इसके लिए RICWIN मॉड्यूल का उपयोग किया जाता है। </div><div><br></div><div>5. नए या पुराने मोबाइल फोन खरीदते समय डिवाइस की वास्तविकता की जांच करना। इसके लिए KYM मॉड्यूल का उपयोग किया जाता है।</div><div><br></div><div>संचार साथी एक सरकारी वेब पोर्टल है, जो भारतीय मोबाइल उपयोगकर्ताओं को उनके खोए गए स्मार्टफोन को ट्रैक और ब्लॉक करने में मदद करता है। इसका उद्देश्य है आईडेंटिटी चोरी, फॉर्ज्ड केवाईसी, और बैंकिंग धोखाधड़ी जैसे अपराधों को रोकना। इस पोर्टल का उपयोग करके मोबाइल फोन उपयोगकर्ताएं अपने नाम से जुड़े मोबाइल कनेक्शन को जान सकती हैं, उन्हें उनकी जरूरत न होने वाले कनेक्शन को डिस्कनेक्ट करने की अनुमति मिलती है, खोए गए मोबाइल फोन को ब्लॉक/ट्रेस कर सकती हैं, और नए/पुराने मोबाइल फोन खरीदते समय डिवाइस की असलीता को जान सकती हैं। संचार साथी में कई मॉड्यूल हैं जैसे CEIR, TAFCOP, KYI, RICWIN आदि। इसके अलावा, Keep Yourself Aware सुविधा अंत उपयोगकर्ता सुरक्षा, दूरसंचार, और जानकारी सुरक्षा से जुड़े नवीनतम अपडेट और जागरूकता सामग्री प्रदान करती है ।</div><div><br></div><div>इस पोर्टल के कुछ महत्वपूर्ण मॉड्यूल हैं:</div><div><br></div><div>CEIR (सेंट्रल इक्विपमेंट आईडेंटिटी रजिस्टर): इसमें आप अपने खोए या चोरी हुए मोबाइल को ब्लॉक कर सकते हैं।</div><div>TAFCOP (अपने मोबाइल कनेक्शन को जानें): इसमें आप अपने नाम से जुड़े मोबाइल कनेक्शन की संख्या जान सकते हैं।</div><div><br></div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-79745743349226681532024-02-29T13:46:00.001+05:302024-02-29T13:46:40.615+05:30Tarang Sanchar Web Portal Kya haiतरंग संचार एक वेब पोर्टल है, जो मोबाइल टॉवर्स और इलेक्ट्रोमैग्नेटिक फ्रीक्वेंसी (ईएमएफ) इमिशन कंप्लायंस के बारे में जानकारी साझा करने के लिए है। इसे दूरसंचार विभाग ने उद्योग के साथ सार्वजनिक निजी साझेदारी (पीपीपी) मोड में विकसित किया है। इस पोर्टल के माध्यम से लोग अपने क्षेत्र में मोबाइल टॉवर्स से निकलने वाले विकिरण को ट्रैक कर सकते हैं और उनकी नियमितता की जांच कर सकते हैं।S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-63188889589586830162024-02-28T02:28:00.015+05:302024-03-09T13:03:12.141+05:30S P SHARMA SIR! Who is S P SHARMA Sir? S P SHARMA SIR kon hai<p> </p><h1 style="text-align: left;"><span style="color: red;">S P SHARMA SIR </span><span style="color: red;">(Lecturer Computer Science)</span> Age, Wife, Family, Biography & More</h1><p>Full name of S P SHARMA SIR is Pandit Sachin Parashar Sharma Ji.</p><p>S P SHARMA SIR is Founder and Director of S P SHARMA CLASSES (SPSC), S P SHARMA FOUNDATION.</p><p>S P SHARMA SIR is a Computer Science Lecturer in Delhi.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJoFJB2Dv5b_4H9ZITDPcH2PIOClRntUvmfyvgd5zBtMhc5RgOavBZpOuLNOR8tohsEvO23fIYlwUd_Q1Tw-GP8RizB70ACKLTJGBj0_3sRw5oTl8eJeXEtJUL6twlWUCsdMv-D8WLZAoZVLJQla2LgGryLfMdghyVDY0RFsLihOsqnU6a6g9psY0p6IQ/s584/abc.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="584" data-original-width="584" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJoFJB2Dv5b_4H9ZITDPcH2PIOClRntUvmfyvgd5zBtMhc5RgOavBZpOuLNOR8tohsEvO23fIYlwUd_Q1Tw-GP8RizB70ACKLTJGBj0_3sRw5oTl8eJeXEtJUL6twlWUCsdMv-D8WLZAoZVLJQla2LgGryLfMdghyVDY0RFsLihOsqnU6a6g9psY0p6IQ/s320/abc.png" width="320" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzctxiuD2in5rN2RGyVoRnLFioKURzi8_wTDm3bwC29EDYV6idsl6J0-SElaobx0U9IdcgpeRZHgxp_uvrRXh9O0Qr8BhGwPjGzqGoT9p175vV6-mO4lV39xEyJTuqwl62bjDkwWVEQLgqWGrgBiPuGwT3vUS4SbaMpzw6eNAozlrEuRHW7BPvMLsVzwI/s640/Figure_2.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="640" data-original-width="640" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzctxiuD2in5rN2RGyVoRnLFioKURzi8_wTDm3bwC29EDYV6idsl6J0-SElaobx0U9IdcgpeRZHgxp_uvrRXh9O0Qr8BhGwPjGzqGoT9p175vV6-mO4lV39xEyJTuqwl62bjDkwWVEQLgqWGrgBiPuGwT3vUS4SbaMpzw6eNAozlrEuRHW7BPvMLsVzwI/s320/Figure_2.png" width="320" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8GNd9w7IiXwoOAS3qpEbwaFEJZPTckpGpq3Z_g8RpYc3_BrX-Vty77FroGPxzlJInCIq_v0nRvD3oAmfGN1QQzqxBBPX0WlB5DXRBBISMDLpshI8zSon4ew2TVt3ZfYUMrljBT6ZDh2PZIM6DTlwOgPrAcdP6CZZ7qSp75EA8dmC0XKOyuJlejSpEA3k/s577/sp%20sharma%20sir.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="577" data-original-width="427" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8GNd9w7IiXwoOAS3qpEbwaFEJZPTckpGpq3Z_g8RpYc3_BrX-Vty77FroGPxzlJInCIq_v0nRvD3oAmfGN1QQzqxBBPX0WlB5DXRBBISMDLpshI8zSon4ew2TVt3ZfYUMrljBT6ZDh2PZIM6DTlwOgPrAcdP6CZZ7qSp75EA8dmC0XKOyuJlejSpEA3k/s320/sp%20sharma%20sir.png" width="237" /></a></div><br /><p><br /></p><p><br /></p><p style="text-align: justify;">S P SHARMA SIR is a prominent and knowledgeable teacher in the field of Computer Science. His concepts are clear and his practical knowledge makes it even more interesting for students to understand and relate to technical topics. Their courses, video lectures, test series, and books can help students in their studies.</p><p style="text-align: justify;">S P SHARMA SIR कंप्यूटर विज्ञान के क्षेत्र में एक प्रमुख और ज्ञानवान शिक्षक हैं। उनके अवधारणाएँ स्पष्ट हैं और उनकी व्यावहारिक ज्ञान छात्रों को तकनीकी विषयों को समझने और संबंधित करने में और भी रोचक बनाता है। उनके कोर्स, वीडियो लेक्चर्स, टेस्ट सीरीज, और पुस्तकें छात्रों को उनकी पढ़ाई में मदद कर सकती हैं। </p><p style="text-align: justify;"><br /></p><h2 style="text-align: justify;"><span style="color: red;">Bio/Wiki</span></h2><p style="text-align: justify;"> <span> </span></p><table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;">
<tbody><tr>
<td style="padding: 0cm 5.4pt; width: 83.4pt;" valign="top" width="139">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">Names</span>:
<span lang="EN-IN"><o:p></o:p></span></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 13.5pt;">S P SHARMA SIR</span><span lang="EN-IN"><o:p></o:p></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 13.5pt;"><br /></span></p>
</td>
</tr>
<tr>
<td style="padding: 0cm 5.4pt; width: 83.4pt;" valign="top" width="139">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">Profession</span>:<span lang="EN-IN"><o:p></o:p></span></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="font-size: medium;"><span lang="EN-IN">Lecturer </span>Computer Science </span><span lang="EN-IN"><o:p></o:p></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><br /></p>
</td>
</tr>
<tr>
<td style="padding: 0cm 5.4pt; width: 83.4pt;" valign="top" width="139">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">Famous For</span>:<span lang="EN-IN"><o:p></o:p></span></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span style="font-size: medium;"><br /></span></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span style="font-size: medium;">Books:</span><span style="font-size: large;"> </span> </b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p style="text-align: justify;"><span style="font-size: 13.5pt;">His
simple and easy teaching style. Teaching Computer Science to TGT/PGT,
UGC NET Aspirants, S P SHARMA CLASSES<o:p></o:p></span></p><p style="text-align: justify;"><span style="font-size: 13.5pt;"><br /></span></p><p style="text-align: justify;"><span style="font-size: 13.5pt;">CS CRACKER Vol - 1 and CS CRACKER Vol - 2</span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN"> </span></p>
</td>
</tr>
</tbody></table><h2 style="text-align: justify;"><span style="color: red;">Physical Stats & More</span></h2><div><table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 836px;">
<tbody><tr>
<td style="padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">Height
(approx.) in centimetres :</span><span lang="EN-IN"><o:p></o:p></span></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;"><br /></span></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 13.5pt;">175 cm</span><span lang="EN-IN"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">in meters :</span><span lang="EN-IN"><o:p></o:p></span></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;"><br /></span></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 13.5pt;">1.75 m</span><span lang="EN-IN"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">in feet
& inches : </span><span lang="EN-IN"><o:p></o:p></span></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;"><br /></span></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 13.5pt;">5’ 9”</span><span lang="EN-IN"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">Eye Colour</span>
: <o:p></o:p></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><br /></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p style="text-align: justify;"><span style="font-size: 13.5pt;">Black</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 13.5pt;">Hair Colour</span>
:<o:p></o:p></b></p>
</td>
<td style="padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p style="text-align: justify;"><span style="font-size: 13.5pt;">Black</span><o:p></o:p></p><p style="text-align: justify;"><span style="font-size: 13.5pt;"><br /></span></p><p style="text-align: justify;"></p><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkGGEmw02FeJt5hEtxifXAR1cKyvo6vlOg2ZGf-tWzsN1NQg9LkcNjsNn-LVgCaVNA3LaA1W84yBDLU9lMZtl3XoOFq6ijCHs-G8gh65aLs5TjvXAkXD0jURSErHqN6RkEgkNOxoaCmqTCegEobbuyatTEhhrd2aFF14gIA1zI8lf7M5sU8fI7ArPeDNE/s960/WhatsApp%20Image%202024-02-28%20at%203.02.59%20AM%20(1).jpeg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="960" data-original-width="720" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkGGEmw02FeJt5hEtxifXAR1cKyvo6vlOg2ZGf-tWzsN1NQg9LkcNjsNn-LVgCaVNA3LaA1W84yBDLU9lMZtl3XoOFq6ijCHs-G8gh65aLs5TjvXAkXD0jURSErHqN6RkEgkNOxoaCmqTCegEobbuyatTEhhrd2aFF14gIA1zI8lf7M5sU8fI7ArPeDNE/s320/WhatsApp%20Image%202024-02-28%20at%203.02.59%20AM%20(1).jpeg" width="240" /></a></div><br /><span style="font-size: 13.5pt;"><br /></span><p></p>
</td>
</tr>
</tbody></table></div><p style="text-align: justify;"><br /></p><h2 style="text-align: justify;"><span style="color: red;">Personal Life</span></h2><table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 836px;">
<tbody><tr style="height: 19.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Date of Birth<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">19 Dec 1987<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 1;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Age (as of 2024)<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">36 Yrs<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 2;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Birthplace<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Khatauli,
Uttar Pradesh<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 3;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Nationality<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Indian<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 4;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Hometown<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Bhayangi,
Post – Khatauli, Distt. Muzaffarnagar, Uttar Pradesh<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 5;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">School<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Govt.
Primary School Bhayangi, Adarsh Janta Inter College Bhangela, JLNS Inter
College Khatauli, <o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"> </span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 6;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">College/University<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">K.K. Jain
P.G. College Khatauli (CCS University), Uttrakhand Technical University
Dehradun, CRSU Jind Haryana<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 7;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Educational
Qualification(s)<o:p></o:p></span></b></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;"><br /></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt;">B.Sc. (PCM), MCA, M.Tech.
(IT), B.Ed., ‘O’ Level, ‘A’ Level<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 8;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Govt. Exam Written Qualified<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">CTET, U P
Police Computer Operator, UGC NET<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">DSSSB PGT
Computer Science, KVS PGT Computer Science, Army Public School PGT CS<o:p></o:p></span></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 9; mso-yfti-lastrow: yes;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Religion/Religious Views<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt;">He follows Hinduism. He is
devotee of Lord Shiva, Krishna and Rama<o:p></o:p></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><br /></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7QjJ0yNsuLrKTYWjz7l090vs4l1pvz1PENciJIX-VgNm4Lo79P5qzCqRsnjOLgKLDi56MiyC4wkPXzYxFb9jgWgNOSzxbXdPXIhUSLqyz5V34Om6CAvhNgVLzzVzaPnVwUtNHYVKO-EtlueLDn_0YuH_Utg7OmsYvLFP6xtWR4wugo_o-Xm2_reaQcAo/s3840/IMG_20230612_134221.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="3840" data-original-width="2160" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7QjJ0yNsuLrKTYWjz7l090vs4l1pvz1PENciJIX-VgNm4Lo79P5qzCqRsnjOLgKLDi56MiyC4wkPXzYxFb9jgWgNOSzxbXdPXIhUSLqyz5V34Om6CAvhNgVLzzVzaPnVwUtNHYVKO-EtlueLDn_0YuH_Utg7OmsYvLFP6xtWR4wugo_o-Xm2_reaQcAo/w230-h320/IMG_20230612_134221.jpg" width="230" /></a> </div><br /><span lang="EN-IN" style="font-size: 12pt;"><br /></span><p></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt;"> </span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt;"> </span></p>
</td>
</tr>
</tbody></table><h2 style="text-align: justify;"><span style="color: red;">Relationships & More</span></h2><table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 836px;">
<tbody><tr style="height: 19.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0; mso-yfti-lastrow: yes;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt;">Marital Status :<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt;">Married<o:p></o:p></span></p>
</td>
</tr>
</tbody></table><h2 style="text-align: justify;"><span style="color: red;">Family</span></h2><table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 836px;">
<tbody><tr style="height: 19.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Wife/Spouse:<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Rita Sharma
(House Wife)<o:p></o:p></span></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMXLUb-Tli2NawLMfEwL0Gw6LDV7fkvMgiIGooibVrSuE_G2FIDzzOSS5hoCgwQVNgX3D3VlWs7E3Ps3QJE3aHI_eGEplJAw8ecMCn8dqtXhA1OQUq35dQs5ChupxFoTQkKj2vMMwwvVJ7wKVfQaUY6VfYmFT4Cu9MewMOR7h9kFnQrLkheDAkKwvctas/s1599/WhatsApp%20Image%202024-02-28%20at%203.07.09%20AM.jpeg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1599" data-original-width="899" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMXLUb-Tli2NawLMfEwL0Gw6LDV7fkvMgiIGooibVrSuE_G2FIDzzOSS5hoCgwQVNgX3D3VlWs7E3Ps3QJE3aHI_eGEplJAw8ecMCn8dqtXhA1OQUq35dQs5ChupxFoTQkKj2vMMwwvVJ7wKVfQaUY6VfYmFT4Cu9MewMOR7h9kFnQrLkheDAkKwvctas/s320/WhatsApp%20Image%202024-02-28%20at%203.07.09%20AM.jpeg" width="180" /></a></div><br /><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span><p></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 1;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Children:<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Daughter:
</span></b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Saanvi
Parashar Sharma<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Son:</span></b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"> Shiva Parashar Sharma<o:p></o:p></span></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9aHg64Xt5Yiv_VIBR0w_3ul8n7uW5RnG6kiFYB-_EojSO1IUTscdnbMFcG4Xu-dfbW8WBRrb-S6lJM2_WncDgDnr92Lg7kZFX8nswkoiBYNLo8MHrndnDsvN0zyLfGxfq-mtDE_qYtfOWFWD-AS7cZ-NWkdpVpAYHH7TNjmAD2qqDG25-tXkuNQJBXNc/s760/fmly.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="760" data-original-width="743" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9aHg64Xt5Yiv_VIBR0w_3ul8n7uW5RnG6kiFYB-_EojSO1IUTscdnbMFcG4Xu-dfbW8WBRrb-S6lJM2_WncDgDnr92Lg7kZFX8nswkoiBYNLo8MHrndnDsvN0zyLfGxfq-mtDE_qYtfOWFWD-AS7cZ-NWkdpVpAYHH7TNjmAD2qqDG25-tXkuNQJBXNc/s320/fmly.png" width="313" /></a></div><br /><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span><p></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 2;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Parents:<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Father:</span></b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"> Sh. Vinod Kumar Sharma
(Farmer)<o:p></o:p></span></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6L-sva_mAFadFafsaWg_cmZoD7KlPrWH551QUevoeJDhRfNSk1GmuZmU4ZH5bWZkok5lAzX4_1OhKgkY-gK6761IDUTwRsi6HpAgBoeTg1wqcvK0AjrOWPhI7FF4a_rsA1bNfBoNki_IgEdh1q0pdHF-JjjqPBjY1cj_u_3Lu5GhWzo9X6UJilfgZUVA/s544/fmly.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="232" data-original-width="544" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6L-sva_mAFadFafsaWg_cmZoD7KlPrWH551QUevoeJDhRfNSk1GmuZmU4ZH5bWZkok5lAzX4_1OhKgkY-gK6761IDUTwRsi6HpAgBoeTg1wqcvK0AjrOWPhI7FF4a_rsA1bNfBoNki_IgEdh1q0pdHF-JjjqPBjY1cj_u_3Lu5GhWzo9X6UJilfgZUVA/s320/fmly.png" width="320" /></a></div><br /><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span><p></p>
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Mother:</span></b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"> Late Mrs. Usha Sharma
(House Wife)<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Siblings
:<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">S P SHARMA
SIR has a brother and a sister. His brother name is Mohit Sharma<o:p></o:p></span></p><p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg73UvmmxEBXSBRDIzbd-mzLii60oiQ_6b3S0kZ13zn32jFvUVy2lVlEPqRE00bAkCLQKjYXOhNK69p_wxrbLU9aoRONWqsP64o6THLHAji-txl-hWBAtElasOilq6uWDlh1ZhsrJYTVxcik527hXK4RqDV2p_ZJcnSpMUvPCufbG8Veb1hFlarCo9Fbbs/s960/mohit.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="960" data-original-width="940" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg73UvmmxEBXSBRDIzbd-mzLii60oiQ_6b3S0kZ13zn32jFvUVy2lVlEPqRE00bAkCLQKjYXOhNK69p_wxrbLU9aoRONWqsP64o6THLHAji-txl-hWBAtElasOilq6uWDlh1ZhsrJYTVxcik527hXK4RqDV2p_ZJcnSpMUvPCufbG8Veb1hFlarCo9Fbbs/s320/mohit.jpg" width="313" /></a></div><br /><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;"><br /></span><p></p>
</td>
</tr>
</tbody></table><h2 style="text-align: justify;"><span style="color: red;">Favorites</span></h2><table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 836px;">
<tbody><tr style="height: 19.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Food :<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Curry Chawal<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 1;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Beverage :<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Milk<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 2;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Holiday
Destination:<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Vrindavan</span>
or any Spritual place<o:p></o:p></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 3;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Film(s) :<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Thriller and
Comedy<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 4;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Actor:<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Shahrukh
Khan, Sunny Deol<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 5;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Game : <o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Cricket
(Outdoor), Ludo (Indoor)<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 6;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Player :<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Sachin
Tendulkar, Rohit Sharma, Virat Kohli<o:p></o:p></span></p>
</td>
</tr>
<tr style="height: 19.85pt; mso-yfti-irow: 7; mso-yfti-lastrow: yes;">
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 125.9pt;" valign="top" width="210">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><b><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Color :<o:p></o:p></span></b></p>
</td>
<td style="height: 19.85pt; padding: 0cm 5.4pt; width: 375.6pt;" valign="top" width="626">
<p class="MsoNormal" style="line-height: 150%; margin-bottom: 0cm;"><span lang="EN-IN" style="font-size: 12pt; line-height: 150%;">Yellow<o:p></o:p></span></p>
</td>
</tr>
</tbody></table><p><br /></p><h2 style="text-align: center;"><span style="color: red;">Some Lesser Known Facts About S P SHARMA SIR</span></h2><p><br /></p><p></p><p style="text-align: left;"></p><ul style="text-align: left;"><li>S P SHARMA SIR is the founder and director of S P SHARMA CLASSES - SPSC an Authentic Platform for learners of Computer Science.</li></ul><ul style="text-align: left;"><li>S P SHARMA SIR grew up in a poor brahman family in a small village Bhayangi in Muzaffarnagar, Uttar Pradesh.</li></ul><ul style="text-align: left;"><li>S P SHARMA SIR father is a farmer and his mother was a house wife.</li></ul><ul style="text-align: left;"><li>He completed his schooling from the Govt. Primary school of his village. </li></ul><ul style="text-align: left;"><li>In his childhood, his favorite subject was Mathematics, but he was poor in English and other subjects. When he was in 9th class he stared coaching class in his village.</li></ul><ul style="text-align: left;"><li>He want to became a mathematics teacher since childhood. So When he was in 11th class, he started mathematics coaching and continue is coaching with his study.</li></ul><ul style="text-align: left;"><li>He passed his Bachelor in Science (B.Sc.) in Mathematics, Physics and Chemistry.</li></ul><p></p><p></p><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv3bsa5Bs7cLOGBM96la34gmADC7T3dcJvB_wfU4FcITXGLRh9VjK8feVfY3Hxjq2Ihnqa7r2YNgbY8YtbhKf6x_sVUfV2EGO_pAdyZ-aadhnpl5AIC16anx0yG1QfrBgG1hXi9fZS7fLS03bcOpFK9x1cjY9bCP5QnM7HihIqKA1mHa_oagxg9H0Q3A8/s74/s%20p%20sharma.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="74" data-original-width="74" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv3bsa5Bs7cLOGBM96la34gmADC7T3dcJvB_wfU4FcITXGLRh9VjK8feVfY3Hxjq2Ihnqa7r2YNgbY8YtbhKf6x_sVUfV2EGO_pAdyZ-aadhnpl5AIC16anx0yG1QfrBgG1hXi9fZS7fLS03bcOpFK9x1cjY9bCP5QnM7HihIqKA1mHa_oagxg9H0Q3A8/w134-h134/s%20p%20sharma.jpg" width="134" /></a></div><div class="separator" style="clear: both; text-align: center;">Mr. Sharma in 11th Class</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSNnnYxkYSmwfzqWdIgUvbHFMzUEy68aTx2jj4DNUGUskdpzhHQSfoHUV1tjGeRKyOAbRGVGTFWpVNI7T03kOCqXQBzJp2KJxiQc-7bBcn_7GV0nPa9RgF9DzNY4jv2V3cHUSd2RcQGynZgmDDmdziDo3E-fnsvx1F4dkkWEs-LZYGu4RaSoSy7TTo0ko/s600/s%20p%20sir.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="600" data-original-width="600" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSNnnYxkYSmwfzqWdIgUvbHFMzUEy68aTx2jj4DNUGUskdpzhHQSfoHUV1tjGeRKyOAbRGVGTFWpVNI7T03kOCqXQBzJp2KJxiQc-7bBcn_7GV0nPa9RgF9DzNY4jv2V3cHUSd2RcQGynZgmDDmdziDo3E-fnsvx1F4dkkWEs-LZYGu4RaSoSy7TTo0ko/s320/s%20p%20sir.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">Mr. Sharma during his college days</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><br /><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVv0X7JubfBI29H2AlLEQK-rRcqbLHbrTdYU6Wq3NEXRI2CXS8iW0uNii0_b2LvYgddX7T8R0k_wwbNFCzj-9YE7uhIFSr-KyziF5VVxjRy7YmKHDJGRT28HeylZHqP_qYcccxZsx_6YqBiF-EU3hXjrY_xiXhk7qaxOLq05MiBfPo6Jx5kVSY4iJi2fg/s2048/spsir.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="2048" data-original-width="1358" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVv0X7JubfBI29H2AlLEQK-rRcqbLHbrTdYU6Wq3NEXRI2CXS8iW0uNii0_b2LvYgddX7T8R0k_wwbNFCzj-9YE7uhIFSr-KyziF5VVxjRy7YmKHDJGRT28HeylZHqP_qYcccxZsx_6YqBiF-EU3hXjrY_xiXhk7qaxOLq05MiBfPo6Jx5kVSY4iJi2fg/s320/spsir.jpg" width="212" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">Mr. Sharma at the time his marriage</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGNq5sHKYWOqqvVkfUJcA_HCo6wOP9-MOwZdGsA47t7Ff2AJz6egbUf3EX3KtP6u-_rv4p8YUicqVPAbpuRWLio1K0_5vGAEjuzYb09YBVyEJyIR_fHnGJ1YOdEcynvUyt0kzEjrw58p9erA9yEQm6hw3n_LR6xHPrZDr6jI8GA0Y_DWhrMcY5HCCIvmk/s1000/sp1.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1000" data-original-width="1000" height="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGNq5sHKYWOqqvVkfUJcA_HCo6wOP9-MOwZdGsA47t7Ff2AJz6egbUf3EX3KtP6u-_rv4p8YUicqVPAbpuRWLio1K0_5vGAEjuzYb09YBVyEJyIR_fHnGJ1YOdEcynvUyt0kzEjrw58p9erA9yEQm6hw3n_LR6xHPrZDr6jI8GA0Y_DWhrMcY5HCCIvmk/w410-h410/sp1.jpg" width="410" /></a></div><br />S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-88125868554286370422024-02-20T20:29:00.008+05:302024-02-20T20:47:31.374+05:30Projection and Selection Practice Questions in relational algebra<h3 style="text-align: left;"> <b>Projection and Selection Practice Questions</b>:</h3><p style="text-align: center;"><b>Student</b></p><p></p><table align="left" border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 7.2pt; margin-right: 7.2pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-table-anchor-horizontal: margin; mso-table-anchor-vertical: margin; mso-table-left: left; mso-table-lspace: 9.0pt; mso-table-rspace: 9.0pt; mso-table-top: 39.0pt; mso-yfti-tbllook: 1184;">
<tbody><tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">S_ID</span></p>
</td>
<td style="border-left: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">NAME</span></p>
</td>
<td style="border-left: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">Branch</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">1</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">A</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">CS</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">2</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">B</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">IT</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">3</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">C</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">CS</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">4</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">D</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">CS</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 5;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">5</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">E</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">EE</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 6;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">6</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">F</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">EC</span></p>
</td>
</tr>
<tr style="mso-yfti-irow: 7; mso-yfti-lastrow: yes;">
<td style="border-top: none; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">7</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">G</span></p>
</td>
<td style="border-bottom: 1pt solid black; border-left: none; border-right: 1pt solid black; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt; width: 154.05pt;" valign="top" width="257">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; mso-element-anchor-horizontal: margin; mso-element-frame-hspace: 9.0pt; mso-element-top: 39.0pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;"><span lang="EN-IN">EE</span></p>
</td>
</tr>
</tbody></table>
<p></p><p class="MsoNormal"><br /></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"></p><ol style="text-align: left;"><li><b>Find the names of all students from CS
branch.</b></li></ol><p></p>
<p></p><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px;"><p></p><p class="MsoNormal" style="text-align: left;"><span face=""Arial","sans-serif"" lang="EN-IN" style="background: white; color: #333333; font-size: 9pt; line-height: 107%;">Π name (</span><strong><span face=""Arial","sans-serif"" lang="EN-IN" style="background: white; color: #303030; font-size: 8pt; line-height: 107%;">σ</span> Branch = ‘CS’ (Student))</strong></p><p></p></blockquote><p></p><p class="MsoNormal"><span lang="EN-IN"><br /></span></p><p class="MsoNormal"><br /></p><p class="MsoNormal"><span lang="EN-IN"></span></p><p class="MsoNormal"><span lang="EN-IN"><b>Account (account_no, branch_name, balance)</b></span></p>
<p class="MsoNormal"></p><ul style="text-align: left;"><li>Find those account numbers where balance is
less than 1000.</li></ul><p></p><p></p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p></p><p class="MsoNormal" style="text-align: left;"><span lang="EN-IN" style="background: white; color: #333333; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%;">Π </span><span lang="EN-IN">account_no</span><span lang="EN-IN" style="background: white; color: #333333; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%;"> (</span><strong><span lang="EN-IN" style="background: white; color: #303030; font-family: "Arial","sans-serif"; font-size: 8.0pt; line-height: 107%;">σ</span> balance<1000 (Account))</strong></p><p></p></blockquote><p><br /></p><p><b>Loan(loan_no, branch_name, amount) </b></p><div></div><p class="MsoNormal"></p><ul style="text-align: left;"><li>Find those loan numbers which are from
Delhi branch with amount greater than 1000.</li></ul><p></p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p class="MsoNormal" style="text-align: left;"><span lang="EN-IN" style="background: white; color: #333333; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%;">Π </span><span lang="EN-IN">loan_no</span><span lang="EN-IN" style="background: white; color: #333333; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%;"> (</span><strong><span lang="EN-IN" style="background: white; color: #303030; font-family: "Arial","sans-serif"; font-size: 8.0pt; line-height: 107%;">σ</span> branch_name=’Delhi’ ^ amount>1000 (Loan))</strong></p></blockquote><p> </p><p><b>Branch (Branch_name, Branch_city, assets)</b> </p><div></div><p class="MsoNormal"></p><ul style="text-align: left;"><li>Find branch_name and branch_city with
assets more than 100000.</li></ul><div></div><p></p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p class="MsoNormal" style="text-align: left;"><span lang="EN-IN" style="background: white; color: #333333; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%;">Π </span><span lang="EN-IN">branch_name , branch_city </span><span lang="EN-IN" style="background: white; color: #333333; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 107%;">(</span><strong><span lang="EN-IN" style="background: white; color: #303030; font-family: "Arial","sans-serif"; font-size: 8.0pt; line-height: 107%;">σ</span> assets>100000 (Branch))<o:p></o:p></strong></p></blockquote><p>
<br /></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-62666884148161148692024-02-20T20:11:00.005+05:302024-02-20T20:11:39.222+05:30Projection Operator in Relational Algebra<p> </p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Projection Operator-</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">Projection Operator (π) is a unary operator in relational algebra that performs a projection operation.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">It displays the columns of a relation or table based on the specified attributes.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">It is a fundamental / Basic operator</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">It is a unary operator</li></ul><div><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Syntax-</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><table border="1" style="background-color: white; border-collapse: collapse; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 10px auto; width: 513.025px;"><tbody style="box-sizing: inherit;"><tr style="box-sizing: inherit;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; padding: 8px 10px; text-align: center; width: 512.225px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">π<sub style="box-sizing: inherit;"><attribute list></sub>(R)</span></strong></td></tr></tbody></table><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Example-</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;">Consider the following Student relation-</p><table border="1" style="background-color: white; border-collapse: collapse; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; height: 113px; margin: 10px auto; width: 586.312px;"><tbody style="box-sizing: inherit;"><tr style="box-sizing: inherit; height: 25px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.375px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">ID</span></strong></td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.375px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">Name</span></strong></td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.375px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">Subject</span></strong></td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.387px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">Age</span></strong></td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">100</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Ashish</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Maths</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.387px;">19</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">200</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Rahul</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Science</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.387px;">20</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">300</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Naina</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Physics</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.387px;">20</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">400</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Sameer</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.375px;">Chemistry</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.387px;">21</td></tr></tbody></table><h4 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.125rem; font-weight: inherit; line-height: 1.5; text-align: center;"><strong style="box-sizing: inherit;">Student</strong></h4></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><h3 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.25rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Result for Query π<sub style="box-sizing: inherit;">Name, Age</sub>(Student)-</strong></span></h3><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><table border="1" style="background-color: white; border-collapse: collapse; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; height: 113px; margin: 10px auto; width: 293.15px;"><tbody style="box-sizing: inherit;"><tr style="box-sizing: inherit; height: 25px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.175px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">Name</span></strong></td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.175px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">Age</span></strong></td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Ashish</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">19</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Rahul</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">20</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Naina</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">20</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Sameer</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">21</td></tr></tbody></table><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><h3 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.25rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Result for Query π<sub style="box-sizing: inherit;">ID , Name</sub>(Student)-</strong></span></h3><div><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;"><table border="1" style="background-color: white; border-collapse: collapse; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; height: 113px; margin: 10px auto; width: 293.15px;"><tbody style="box-sizing: inherit;"><tr style="box-sizing: inherit; height: 25px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.175px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">ID</span></strong></td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 25px; padding: 8px 10px; text-align: center; width: 146.175px;"><strong style="box-sizing: inherit;"><span style="box-sizing: inherit; font-size: 12pt;">Name</span></strong></td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">100</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Ashish</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">200</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Rahul</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">300</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Naina</td></tr><tr style="box-sizing: inherit; height: 22px;"><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">400</td><td style="border: 1px solid rgb(170, 170, 170); box-sizing: inherit; font-size: 0.875rem; height: 22px; padding: 8px 10px; text-align: center; width: 146.175px;">Sameer</td></tr></tbody></table><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit;"><strong style="box-sizing: inherit;">Important Points-</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit;"><strong style="box-sizing: inherit;">Point-01:</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">The degree of output relation (number of columns present) is equal to the number of attributes mentioned in the attribute list.</li></ul></strong></span></div></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><span style="box-sizing: inherit;"><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Point-02:</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">Projection operator automatically removes all the duplicates while projecting the output relation.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">So, cardinality of the original relation and output relation may or may not be same.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">If there are no duplicates in the original relation, then the cardinality will remain same otherwise it will surely reduce.</li></ul><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Point-03:</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin: 4px 0px 12px;"> </p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; font-weight: 400; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">If attribute list is a super key on relation R, then we will always get the same number of tuples in the output relation.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">This is because then there will be no duplicates to filter.</li></ul><div><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Point-04:</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">Projection operator does not obey commutative property i.e.</li></ul><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px; text-align: center;"><span style="box-sizing: inherit; font-size: 12pt;">π <sub style="box-sizing: inherit;"><list2></sub> (π <sub style="box-sizing: inherit;"><list1> </sub>(R)) ≠ π <sub style="box-sizing: inherit;"><list1></sub> (π <sub style="box-sizing: inherit;"><list2> </sub>(R))</span></p><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px; text-align: center;"><span style="box-sizing: inherit; font-size: 12pt;"><br /></span></p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Point-05:</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;"><a href="https://www.gatevidyalay.com/selection-operator-relational-algebra-dbms/" rel="noopener noreferrer" style="box-sizing: inherit; color: #910000; cursor: pointer;" target="_blank"><strong style="box-sizing: inherit;">Selection Operator</strong></a> performs horizontal partitioning of the relation.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">Projection operator performs vertical partitioning of the relation.</li></ul><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><h2 style="background-color: white; box-sizing: inherit; clear: none; color: #303030; font-family: "Roboto Condensed", sans-serif; font-size: 1.375rem; font-weight: inherit; line-height: 1.5;"><span style="box-sizing: inherit; text-decoration-line: underline;"><strong style="box-sizing: inherit;">Point-06:</strong></span></h2><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"> </p><p style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin: 4px 0px 12px;"><span style="box-sizing: inherit; font-size: 12pt;"></span></p><ul style="background-color: white; box-sizing: inherit; color: #303030; font-family: Arimo, sans-serif; font-size: 15.008px; margin-bottom: 8px; margin-top: 4px; padding-left: 20px;"><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px; text-align: left;">There is only one difference between projection operator of relational algebra and SELECT operation of SQL.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px;">Projection operator does not allow duplicates while SELECT operation allows duplicates.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px; text-align: left;">To avoid duplicates in SQL, we use “distinct” keyword and write SELECT distinct.</li><li style="box-sizing: inherit; list-style-position: outside; list-style-type: disc; margin: 4px 0px 4px 15px; text-align: left;">Thus, projection operator of relational algebra is equivalent to SELECT operation of SQL.</li></ul></div></span></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div><div><strong style="box-sizing: inherit;"><br /></strong></div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-3420088217913358572024-02-20T20:03:00.003+05:302024-02-20T20:05:03.961+05:30Selection Operator in Relational Algebra<p> </p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Selection
Operator-</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l3 level1 lfo10; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Selection Operator (σ) is a unary operator in relational
algebra that performs a selection operation.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l3 level1 lfo10; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">It selects those rows or tuples from the relation that
satisfies the selection condition.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l3 level1 lfo10; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">It is a fundamentals / Basic operator<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l3 level1 lfo10; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">It is a Unary Operator<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> </span></b></p><p class="MsoNormal"><strong><span face=""Arial","sans-serif"" lang="EN-IN" style="background: white; color: #303030;">σ<sub style="box-sizing: inherit;"><selection_condition></sub>(R)</span><o:p></o:p></strong></p><p class="MsoNormal"><strong><span face=""Arial","sans-serif"" lang="EN-IN" style="background: white; color: #303030;"><o:p> </o:p></span></strong></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l5 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Select tuples from a relation “Books” where subject is
“database”<o:p></o:p></span></p><p align="center" class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt; text-align: center;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">σ<sub>subject = “database”</sub> (Books)</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l2 level1 lfo2; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Select tuples from a relation “Books” where subject is
“database” and price is “450”<o:p></o:p></span></p><p align="center" class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt; text-align: center;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">σ<sub>subject = “database” </sub></span><sub><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∧</span></sub><sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> price = “450”</span></sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> (Books)</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l1 level1 lfo3; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">S</span><span face="Arial, "sans-serif"" lang="EN-IN" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #303030; font-size: 9pt;">elect tuples</span>
<span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">from a relation “Books” where subject is “database” and
price is “450” or have a publication year after 2010<o:p></o:p></span></p><p align="center" class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt; text-align: center;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">σ<sub>subject = “database” </sub></span><sub><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∧</span></sub><sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> price =
“450” </span></sub><sub><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∨</span></sub><sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">
year >”2010″</span></sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> (Books)</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Important
Points-</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Point-01:</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l9 level1 lfo4; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">We may use logical operators like </span><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∧</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> , </span><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∨</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> , ! and relational operators
like = , ≠ , > , < , <= , >= with the selection
condition.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Point-02:</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l0 level1 lfo5; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Selection operator only selects the required tuples
according to the selection condition.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l0 level1 lfo5; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">It does not display the selected tuples.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l0 level1 lfo5; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">To display the selected tuples, projection operator is
used.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Point-03:</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l6 level1 lfo6; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Selection operator always selects the entire tuple. It
can not select a section or part of a tuple.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Point-04:</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l7 level1 lfo7; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Selection operator is commutative in nature i.e.<o:p></o:p></span></p><p align="center" class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt; text-align: center;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">σ <sub>A </sub></span><sub><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∧</span></sub><sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> B</span></sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> (R)
= σ <sub>B </sub></span><sub><span style="color: #303030; font-family: "Cambria Math","serif"; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Cambria Math"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">∧</span></sub><sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> A</span></sub><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> (R)</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p><p align="center" class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt; text-align: center;"><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">OR</span></b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p><p align="center" class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt; text-align: center;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 12pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">σ <sub>B </sub>(σ <sub>A</sub>(R))
= σ <sub>A </sub>(σ <sub>B</sub>(R))</span><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Point-05:</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 45.0pt; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 2.4pt 45pt; mso-list: l8 level1 lfo8; tab-stops: list 36.0pt; text-indent: -18pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Degree of the relation from a selection operation is same
as degree of the input relation.<o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"><b><u><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Point-06:</span></u></b><b><span face=""Arial","sans-serif"" style="color: #303030; font-size: 18pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.4pt; margin: 2.4pt 0cm 7.2pt;"><span face=""Arial","sans-serif"" style="color: #303030; font-size: 9pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: #303030; font-family: Symbol; font-size: 9pt; text-indent: -18pt;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><span style="color: #303030; font-family: Arial, "sans-serif"; font-size: 9pt; text-indent: -18pt;">The number of rows returned by a selection operation is
obviously less than or equal to the number of rows in the original table.</span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 27.0pt; margin-right: 0cm; margin-top: 2.4pt; mso-list: l0 level1 lfo1; tab-stops: list 27.0pt; text-indent: -18.0pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #303030; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Minimum Cardinality = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.4pt; margin-left: 27.0pt; margin-right: 0cm; margin-top: 2.4pt; mso-list: l0 level1 lfo1; tab-stops: list 27.0pt; text-indent: -18.0pt;"><!--[if !supportLists]--><span style="color: #303030; font-family: Symbol; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-bidi-font-size: 9.0pt; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: "Times New Roman"; font-feature-settings: normal; font-kerning: auto; font-optical-sizing: auto; font-size: 7pt; font-stretch: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-variant-position: normal; font-variation-settings: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #303030; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-ansi-language: EN-US; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Maximum Cardinality = |R|<o:p></o:p></span></p><ul style="margin-top: 0cm;" type="disc">
</ul><p class="MsoNormal"><span lang="EN-IN"> </span></p><p>
</p><p class="MsoNormal"><span lang="EN-IN"> </span></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-14680429302780988662024-02-16T00:14:00.007+05:302024-02-16T00:15:29.342+05:30Class 11 CS Practical - 52<p> </p><h3 style="text-align: left;"><span style="color: red;">52 - Write a program in Python to find the mean of numeric values stored in the given
tuple.</span></h3><div style="border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1pt 4pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">T=eval(input("Enter
a numeric tuple: "))</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">print("Tuple
is: \n", T)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">mean=sum(T)/len(T)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">print("Mean
of the numeric values of the tuple = ",mean)</span></p></div><p><br /></p><p><b>Output:</b></p><p>Enter a numeric tuple: (2, 8, 9, 6, 5)</p><p>Tuple is: </p><p> (2, 8, 9, 6, 5)</p><p>Mean of the numeric values of the tuple = 6.0</p><div><br /></div><p><br /></p><p><br /></p><p><br /></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-3991095201786282772024-02-15T23:55:00.000+05:302024-02-15T23:55:26.014+05:30Class 11 CS Practical - 51<p> </p><h3 style="text-align: left;"><span style="color: red;">51 - Write a program in Python to count the frequency of all elements of a tuple</span></h3><p><br /></p><p></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">T= (10,
20, 30, 20, 40, 30, 20, 50)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">print("Tuple
is: ",T)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">Uni= ()</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">for i in
T:</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>if i not in Uni:</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>Uni = Uni + (i,)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">for i in
Uni:</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>print(i,":",T.count(i))</span></p>
</div><br /><p></p><p><b>Output:</b></p><p>Tuple is: (10, 20, 30, 20, 40, 30, 20, 50)</p><p>10 : 1</p><p>20 : 3</p><p>30 : 2</p><p>40 : 1</p><p>50 : 1</p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-34253641533537407752024-02-15T15:39:00.004+05:302024-02-15T23:52:51.404+05:30Class 11 CS Practical - 50<p> </p><h3 style="text-align: left;"><b><span style="color: red;">50 - Write a program in Python to count the frequency of all elements of a list.</span></b></h3><p></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">L= [10,
20, 30, 20, 40, 30, 20, 50]</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">print("List
is: ",L)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">Uni= []</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">Freq= []</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">for i in
L:</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>if i in Uni:</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>index=Uni.index(i)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>Freq[index]+= 1</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>else:</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>Uni.append(i)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>Freq.append(1)</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN">for i in
range(len(Uni)):</span></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span lang="EN-IN"><span style="mso-spacerun: yes;"> </span>print(Uni[i],":",Freq[i])</span></p>
</div><br /><p></p><p><b>Output:</b></p><p>List is: [10, 20, 30, 20, 40, 30, 20, 50]</p><p>10 : 1</p><p>20 : 3</p><p>30 : 2</p><p>40 : 1</p><p>50 : 1</p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-47071211448769037292024-02-15T15:38:00.006+05:302024-02-15T15:52:52.991+05:30Class 11 CS Practical - 49<p> </p><h3 style="text-align: left;"><span style="color: red;">49 - WAP in the Python to create a list and find the mean of all numeric values stored in the list.</span></h3><p><br /></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">L=eval(input("Enter a
list: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=len(L)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">N=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in L:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> if isinstance(i,int) or
isinstance(i,float):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> N.append(i)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Mean of
numeric values stored in the list:")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print(sum(N)/len(N))</p>
</div><p><br /></p><p><b>Output:</b></p><p>Enter a list: [5,'A',9,6.5,'Python',3.5]</p><p>Mean of numeric values stored in the list:</p><p>6.0</p><p><br /></p><p><br /></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-12435371101233649892024-02-15T15:35:00.007+05:302024-02-15T15:35:47.873+05:30Class 11 CS Practical - 48<p> </p><p></p><h3 style="text-align: left;"><span style="color: red;">48 - WAP in Python to create a dictionary with name of employee, their salary and access them.</span></h3><p></p><p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><br /></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">Emp={}</p><p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">c='y'</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">while c in 'yY':</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> name=input("Enter the name of employee:
")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> salary=float(input("Enter the salary
of employee: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> Emp[name]=salary</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> c=input("Do you want to add more
emp(y/n): ")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Details of
Employee:")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print(Emp)</p>
</div><p></p><p class="MsoNormal"><b style="mso-bidi-font-weight: normal;">Output:<o:p></o:p></b></p>
<p class="MsoNormal">Enter the name of employee: Ram</p>
<p class="MsoNormal">Enter the salary of employee: 38545</p>
<p class="MsoNormal">Do you want to add more emp(y/n): y</p>
<p class="MsoNormal">Enter the name of employee: Raj</p>
<p class="MsoNormal">Enter the salary of employee: 45854</p>
<p class="MsoNormal">Do you want to add more emp(y/n): y</p>
<p class="MsoNormal">Enter the name of employee: Aman</p>
<p class="MsoNormal">Enter the salary of employee: 47825</p>
<p class="MsoNormal">Do you want to add more emp(y/n): n</p>
<p class="MsoNormal">Details of Employee:</p>
<p class="MsoNormal">{'Ram': 38545.0, 'Raj': 45854.0, 'Aman': 47825.0}</p><br /><p></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-3055079673576903482024-02-15T15:34:00.003+05:302024-02-15T15:34:16.677+05:30Class 11 CS Practical - 47<h3 style="text-align: left;"><span style="color: red;"> 47 - WAP in Python to input a string and display the frequency of each character using dictionary</span></h3><p><br /></p><p></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">S=input("Enter a
string: ")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">F={}</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in S:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>if i in F:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>F[i]+=1</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>else:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>F[i]=1</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Frequency of
characters in the given string: ")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i, j in F.items():</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>print(i,":",j)</p>
</div><br /><p></p><p><br /></p><p></p><p class="MsoNormal"><b style="mso-bidi-font-weight: normal;">Output:<o:p></o:p></b></p>
<p class="MsoNormal">Enter a string: S P SHARMA</p>
<p class="MsoNormal">Frequency of characters in the given string: </p>
<p class="MsoNormal">S : 2</p>
<p class="MsoNormal"><span style="mso-spacerun: yes;"> </span>: 2</p>
<p class="MsoNormal">P : 1</p>
<p class="MsoNormal">H : 1</p>
<p class="MsoNormal">A : 2</p>
<p class="MsoNormal">R : 1</p>
<p class="MsoNormal">M : 1</p><br /><p></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-69764720808943393262024-02-14T10:45:00.003+05:302024-02-15T15:03:47.571+05:30Class 11 CS Practical - 46<p> </p><h3><b><span style="color: red;">46 - Write a program in Python to input the value of x and n and print the sum of the following series:</span></b></h3><div><h3><span style="color: red;">x + x<sup>2</sup>/2! + x<sup>3</sup>/3! + x<sup>4</sup>/4! + -------- x<sup>n</sup> /n!</span></h3></div><div><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">import math as m</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">x=int(input("Enter
the value of x: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the value of n: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">sum=0</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(1,n+1):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> sum=sum+pow(x,i)/m.factorial(i)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> print("Sum of the series=",sum)</p>
</div></div><div><span style="color: red;"><br /></span></div><div><span style="color: red;"><br /></span></div><div><span style="color: red;">Output:</span></div><div><span style="color: red;"><br /></span></div><div><p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 3</p>
<p class="MsoNormal">Sum of the series= 5.333333333333333</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 4</p>
<p class="MsoNormal">Sum of the series= 6.0</p></div><div><span style="color: red;"><br /></span></div><div><span style="color: red;"><br /></span></div><div><span style="color: red;"><br /></span></div><div><span style="color: red;"><br /></span></div><div><span style="color: red;"><br /></span></div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-69220298265265860652024-02-14T10:44:00.025+05:302024-02-15T15:00:38.858+05:30Class 11 CS Practical - 45<p> </p><h3><b><span style="color: red;">45 - Write a program in Python to input the value of x and n and print the sum of the following series:</span></b></h3><div><h3 style="text-align: left;"></h3><h3 style="text-align: left;"><span style="color: red;">x + x<sup>2</sup>/2 + x<sup>3</sup>/3 + x<sup>4</sup>/4 +
-------- x<sup>n</sup> /n</span></h3></div><div><b><span style="color: red;"><br /></span></b></div><div><div style="border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1pt 4pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">x=int(input("Enter
the value of x: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the value of n: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">sum=0</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(1,n+1):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> sum=sum+pow(x,i)/i</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Sum of the
series=",sum)</p>
</div></div><div><b><span style="color: red;"><br /></span></b></div><div><b><span style="color: red;"><br /></span></b></div><div><b><span style="color: red;">Output:</span></b></div><div><b><span style="color: red;"><br /></span></b></div><div><p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 3</p>
<p class="MsoNormal">Sum of the series= 6.666666666666666</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 4</p>
<p class="MsoNormal">Sum of the series= 10.666666666666666</p></div><div><b><span style="color: red;"><br /></span></b></div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-53502543689435029132024-02-14T10:44:00.024+05:302024-02-15T14:57:50.419+05:30Class 11 CS Practical - 44<p> </p><h3><b><span style="color: red;">44 - Write a program in Python to input the value of x and n and print the sum of the following series:</span></b></h3><div><h3 style="text-align: left;"><span style="color: red;">1 - x + x<sup>2</sup> - x<sup>3</sup> +x<sup>4</sup> +
-------- x<sup>n</sup></span></h3></div><div><b><span style="color: red;"><br /></span></b></div><div><div style="border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1pt 4pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">x=int(input("Enter
the value of x: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the value of n: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">sum=0</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n+1):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> if i%2==0:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> sum=sum+pow(x,i)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> else:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> sum=sum-pow(x,i)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Sum of the
series=",sum)</p>
</div></div><div><b><span style="color: red;"><br /></span></b></div><div><b><span style="color: red;">Output:</span></b></div><br /><br /><p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 3</p>
<p class="MsoNormal">Sum of the series= -5</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 4</p>
<p class="MsoNormal">Sum of the series= 11</p><br /><br /><br /><br /><br />S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-63073359888777700922024-02-14T10:44:00.022+05:302024-02-15T14:57:18.209+05:30Class 11 CS Practical - 43<h3 style="text-align: left;"><b><span style="color: red;"> 43 - Write a program in Python to input the value of x and n and print the sum of the following series:</span></b></h3><h3 style="text-align: left;"><span style="color: red;">1 + x + x<sup>2</sup> + x<sup>3</sup> +x<sup>4</sup> +
-------- x<sup>n</sup></span></h3><p></p><div style="border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1pt 4pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">x=int(input("Enter
the value of x: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the value of n: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">sum=0</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n+1):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>sum=sum+pow(x,i)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Sum of the
series=",sum)</p>
</div><br /><p></p><p><b>Output:</b></p><p></p><p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 3</p>
<p class="MsoNormal">Sum of the series= 15</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Enter the value of x: 2</p>
<p class="MsoNormal">Enter the value of n: 4</p>
<p class="MsoNormal">Sum of the series= 31</p><br /><p></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-24079592009855518762024-02-14T10:44:00.015+05:302024-02-15T14:27:35.448+05:30Class 11 CS Practical - 42<p> </p><h3 style="text-align: left;"><span style="color: red;">42 - Write a program in Python to create a list of 10 random numbers between 1 to 100.</span></h3><p><br /></p><p></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">import random as r</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">L=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,10):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>a=r.randrange(1,100)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>L.append(a)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("List of 10
random numbers between 1 to 100:")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print(L)</p>
</div><br /><p></p><p><br /></p><p></p><p class="MsoNormal"><b style="mso-bidi-font-weight: normal;">Output:<o:p></o:p></b></p>
<p class="MsoNormal">List of 10 random numbers between 1 to 100:</p>
<p class="MsoNormal">[60, 67, 55, 66, 85, 82, 73, 67, 62, 57]</p><br /><p></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-30210029430786733162024-02-14T10:44:00.014+05:302024-02-15T14:25:52.439+05:30Class 11 CS Practical - 41<p> </p><h3 style="text-align: left;"><b><span style="color: red;">41 - Write a program in Python to input a list of numbers and find the mean, mode and median.</span></b></h3><p><br /></p><p></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">import statistics as s</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">L=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the size of the list: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>a=int(input("Enter element of List:
"))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>L.append(a)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("List is:
", L)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Mean of the
given data: ",s.mean(L))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Mode of the
given data: ",s.mode(L))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Median of the
given data: ",s.median(L))</p>
</div><br /><p></p><p></p><p class="MsoNormal"><b style="mso-bidi-font-weight: normal;">Output:<o:p></o:p></b></p>
<p class="MsoNormal">Enter the size of the list: 5</p>
<p class="MsoNormal">Enter element of List: 8</p>
<p class="MsoNormal">Enter element of List: 9</p>
<p class="MsoNormal">Enter element of List: 3</p>
<p class="MsoNormal">Enter element of List: 9</p>
<p class="MsoNormal">Enter element of List: 7</p>
<p class="MsoNormal">List is:<span style="mso-spacerun: yes;"> </span>[8, 9, 3, 9,
7]</p>
<p class="MsoNormal">Mean of the given data:<span style="mso-spacerun: yes;">
</span>7.2</p>
<p class="MsoNormal">Mode of the given data:<span style="mso-spacerun: yes;">
</span>9</p>
<p class="MsoNormal">Median of the given data:<span style="mso-spacerun: yes;">
</span>8</p>
<p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal"><o:p><br /></o:p></p>
<p class="MsoNormal">Enter the size of the list: 6</p>
<p class="MsoNormal">Enter element of List: 2</p>
<p class="MsoNormal">Enter element of List: 8</p>
<p class="MsoNormal">Enter element of List: 9</p>
<p class="MsoNormal">Enter element of List: 4</p>
<p class="MsoNormal">Enter element of List: 7</p>
<p class="MsoNormal">Enter element of List: 9</p>
<p class="MsoNormal">List is:<span style="mso-spacerun: yes;"> </span>[2, 8, 9, 4,
7, 9]</p>
<p class="MsoNormal">Mean of the given data:<span style="mso-spacerun: yes;">
</span>6.5</p>
<p class="MsoNormal">Mode of the given data:<span style="mso-spacerun: yes;">
</span>9</p>
<p class="MsoNormal">Median of the given data:<span style="mso-spacerun: yes;">
</span>7.5</p><br /><p></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-7543572502660951722024-02-14T10:43:00.024+05:302024-02-15T14:24:20.875+05:30Class 11 CS Practical - 40<div><br /></div><h3 style="text-align: justify;"><b><span style="color: red;">40 - Write a program in Python to create a dictionary with the roll number, name and marks of n students of a class and display the name of students who have marks above 75.</span></b></h3><div><br /></div><div><br /></div><div><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the number of students: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">D={}</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">RN=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">Name=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">Marks=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> roll_no = int(input("Enter the roll
number of the student: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> name=input("Enter the name of the
student: ")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> marks=int(input("Enter the marks of
the student: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> RN.append(roll_no)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> Name.append(name)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> Marks.append(marks)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">D["Roll
Number"]=RN</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">D["Name"]=Name</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">D["Marks"]=Marks</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Dictionary of
all students is: ",D)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Name of
students who have marks above 75: ")</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> if D["Marks"][i]>=75:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> print(D["Name"][i])</p>
</div></div><div><br /></div><div><br /></div><div><br /></div><div><p class="MsoNormal"><b style="mso-bidi-font-weight: normal;">Output:<o:p></o:p></b></p>
<p class="MsoNormal">Enter the number of students: 5</p>
<p class="MsoNormal">Enter the roll number of the student: 1</p>
<p class="MsoNormal">Enter the name of the student: Ram</p>
<p class="MsoNormal">Enter the marks of the student: 78</p>
<p class="MsoNormal">Enter the roll number of the student: 2</p>
<p class="MsoNormal">Enter the name of the student: Raj</p>
<p class="MsoNormal">Enter the marks of the student: 48</p>
<p class="MsoNormal">Enter the roll number of the student: 3</p>
<p class="MsoNormal">Enter the name of the student: Sam</p>
<p class="MsoNormal">Enter the marks of the student: 79</p>
<p class="MsoNormal">Enter the roll number of the student: 4</p>
<p class="MsoNormal">Enter the name of the student: John</p>
<p class="MsoNormal">Enter the marks of the student: 84</p>
<p class="MsoNormal">Enter the roll number of the student: 5</p>
<p class="MsoNormal">Enter the name of the student: Amit</p>
<p class="MsoNormal">Enter the marks of the student: 67</p>
<p class="MsoNormal">Dictionary of all students is:<span style="mso-spacerun: yes;"> </span>{'Roll Number': [1, 2, 3, 4, 5], 'Name':
['Ram', 'Raj', 'Sam', 'John', 'Amit'], 'Marks': [78, 48, 79, 84, 67]}</p>
<p class="MsoNormal">Name of students who have marks above 75: </p>
<p class="MsoNormal">Ram</p>
<p class="MsoNormal">Sam</p>
<p class="MsoNormal">John</p><br /></div>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-65630692358053240922024-02-14T10:43:00.021+05:302024-02-15T14:21:30.480+05:30Class 11 CS Practical - 37<h3><b><span> 37 - Write a program in Python to Input a list of numbers and swap elements at the even location with the elements at the odd location. </span></b></h3><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">L=[]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">n=int(input("Enter
the size of the list: "))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> a=int(input("Enter element of List:
"))</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> L.append(a)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("List is:
", L)</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">if n%2!=0:</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> n=n-1</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">for i in range(0,n,2):</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> L[i],L[i+1]=L[i+1],L[i]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Updated list
is: ", L)</p>
</div><p><br /></p><p><br /></p><p><br /></p><p><b>Output</b>:</p><p>Enter the size of the list: 5</p><p>Enter element of List: 2</p><p>Enter element of List: 8</p><p>Enter element of List: 6</p><p>Enter element of List: 4</p><p>Enter element of List: 7</p><p>List is: [2, 8, 6, 4, 7]</p><p>Updated list is: [8, 2, 4, 6, 7]</p><p><br /></p><p>Enter the size of the list: 6</p><p>Enter element of List: 2</p><p>Enter element of List: 8</p><p>Enter element of List: 6</p><p>Enter element of List: 4</p><p>Enter element of List: 7</p><p>Enter element of List: 9</p><p>List is: [2, 8, 6, 4, 7, 9]</p><p>Updated list is: [8, 2, 4, 6, 9, 7]</p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-76300169964279768902024-02-14T10:43:00.016+05:302024-02-14T11:21:20.225+05:30Class 11 CS Practical - 38<h3 style="text-align: left;"><b><span style="color: red;">38 - Write a program in Python to Input a list of numbers and find the index of a specific element. </span></b></h3><p><br /></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">L= [10, 20, 30, 40, 50]</p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"></p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("List is :
",L) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">c='Y' </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">while c=='Y' or c=='y': </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> n=int(input("Enter the number to be
search in the List: ")) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> found=False </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> for i in L: </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> if i==n: </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> print("Element found at index:
",L.index(i)) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> found=True </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> if found==False: </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> print("Number is not found in the
list") </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"> c=input("Do you want to search more
item (Y/N): ")</p>
</div><p><br /></p><p><b>Output:</b></p><p>List is : [10, 20, 30, 40, 50]</p><p>Enter the number to be search in the List: 30</p><p>Element found at index: 2</p><p>Do you want to search more item (Y/N): y</p><p>Enter the number to be search in the List: 50</p><p>Element found at index: 4</p><p>Do you want to search more item (Y/N): y</p><p>Enter the number to be search in the List: 15</p><p>Number is not found in the list</p><p>Do you want to search more item (Y/N): n</p><p><br /></p><p><br /></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-32630621519108690492024-02-14T10:43:00.015+05:302024-02-14T11:19:05.352+05:30Class 11 CS Practical - 39<h3 style="text-align: left;"><b><span style="color: red;">39 - Write a program in Python to Input a tuple of numbers and find the index of a specific element. </span></b></h3><p><br /></p><p></p><div style="border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1pt 4pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">T= (5, 8, 9, 2, 6) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Tuple is :
",T) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">c='Y' </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">while c=='Y' or c=='y': </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>n=int(input("Enter the number to be
search in the tuple: ")) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>found=False </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>for i in T: </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>if i==n: </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>print("Element found at index:
",T.index(i)) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>found=True </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>if found==False: </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>print("Number is not found in the
tuple") </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;"><span style="mso-spacerun: yes;"> </span>c=input("Do you want to search more
item (Y/N): ")</p>
</div><br /><p></p><p><b>Output:</b></p><p>Tuple is : (5, 8, 9, 2, 6)</p><p>Enter the number to be search in the tuple: 8</p><p>Element found at index: 1</p><p>Do you want to search more item (Y/N): y</p><p>Enter the number to be search in the tuple: 2</p><p>Element found at index: 3</p><p>Do you want to search more item (Y/N): y</p><p>Enter the number to be search in the tuple: 7</p><p>Number is not found in the tuple</p><p>Do you want to search more item (Y/N): n</p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0tag:blogger.com,1999:blog-9163598552242245140.post-90196155932393461352024-02-14T10:43:00.013+05:302024-02-14T11:06:51.296+05:30Class 11 CS Practical - 36<p> </p><h3 style="text-align: left;"><b><span style="color: red;">36 - Write a program in Python to Input a tuple of numbers and find the smallest number in a list.</span></b></h3><p><br /></p><p></p><div style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">T= (5, 8, 9, 6, 2, 5) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Tuple is:
\n", T) </p>
<p class="MsoNormal" style="border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt; padding: 0cm;">print("Minimum(Smallest)
number of the Tuple = ",min(T))</p>
</div><br /><p></p><p><b>Output:</b></p><p>Tuple is: </p><p> (5, 8, 9, 6, 2, 5)</p><p>Minimum(Smallest) number of the Tuple = 2</p><p><br /></p>S P SHARMA CLASSEShttp://www.blogger.com/profile/04942302452002418911noreply@blogger.com0