Data Base Management System | NPTEL 2022 | Week 2 Assignment Solutions
This set of MCQ(multiple choice questions) focuses on the Data Base Management System NPTEL 2022 Week 2 Assignment Solutions .
The course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.
Course layout (Answers link)
Answers COMING SOON! Kindly Wait!
Week 0: Assignment answers Week 1: Course Overview. Introduction to RDBMS Week 2: Structured Query Language (SQL) Week 3: Relational Algebra. Entity-Relationship Model Week 4: Relational Database Design Week 5: Application Development. Case Studies. Storage and File Structure Week 6: Indexing and Hashing. Query Processing Week 7: Query Optimization. Transactions (Serializability and Recoverability) Week 8: Concurrency Control. Recovery Systems. Course Summarization.
NOTE: You can check your answer immediately by clicking show answer button. Data Base Management System NPTEL 2022 Week 2 Assignment Solution” contains 10 questions.
Now, start attempting the quiz.
Data Base Management System NPTEL 2022 Week 2 Assignment Solutions
Q1. Consider the following instance of the relation PAPER(ID, TYPE, AREA, CITATION)
ID | TYPE | AREA | CITATION |
145 | JOURNAL | MACHINE LEARNING | 567 |
146 | JOURNAL | MACHINE LEARNING | 167 |
1446 | CONFERENCE | MACHINE LEARNING | 43 |
986 | CONFERENCE | NETWORKING | 343 |
66 | CONFERENCE | BLOCK CHAIN | 243 |
Which of the following values will be present in all the tuples selected by the following query: SELECT ‘CITATION’ FROM PAPER WHERE CITATION>200
a) 567 b) CITATION c) 43 d) 167
Answer: b) CITATION
Q2. Consider the following instance of the relation PAPER(ID, TYPE, AREA, CITATION)
Select the correct query that displays the following output:
ID |
72 |
73 |
723 |
33 |
a) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “% %” b) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “%” c) SELECT ID-73 AS ID FROM PAPER WHERE AREA LIKE “%_%” d) SELECT ID-73 AS ID FROM PAPER WHERE AREA LIKE “%%”
Answer: a) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “% %”
Q3. Consider the following instance of the relation MAINTENANCE(WORK, DAYS, CHARGE, TEAM)
WORK | DAYS | CHARGE | TEAM |
EXT. PAINT | 7 | 100000 | 5 |
INT. PAINT | 7 | 100000 | 8 |
FLOOR | 1 | 5000 | 3 |
EXT. PAINT | 7 | 50000 | 2 |
WALL REPAIR | 10 | 80000 | 8 |
How many tuples will be returned by the following query: SELECT AVG(CHARGE) FROM MAINTENANCE GROUP BY DAYS
a) 1 b) 2 c) 3 d) 4
Answer: c) 3
Q4. Consider the following instance of the relation MAINTENANCE (WORK, DAYS, CHARGE, TEAM).
Which of the following queries will produce the following output (ordered):
WORK | TEAM |
WALL REPAIR | 8 |
EXT. PAINT | 5 |
INT. PAINT | 8 |
a) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM b) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM DESC c) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS, TEAM d) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS, TEAM DESC
Answer: a) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM
Q5. Consider the following schema. Primary keys are underlined. Employees( E_name , E_street, E_city) BankAccount( Ac_number , Branch_name, Balance) AccountUser( E_name , Ac_number ) Which is the correct SQL command to create the table AccountUser having two foreign keys E_name and Ac_number
a) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name, Ac_number), FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); b) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name), FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); c) CREATE TABLE AccountUser { E_name VARCHAR(20) PRIMARY KEY, Ac_number NUMERIC(12, 2) PRIMARY KEY, FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); d) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name, Ac_number), FOREIGN KEY Employees(E_name), FOREIGN KEY BankAccount(Ac_number));
Data Base Management System NPTEL Week 2 Assignment Solutions
Q6. Identify the correct SQL command(s) to create a new record for the Faculty table as given below. Primary key is underlined in the schema.
Faculty_name | Department | Degree |
Charline B | English | M.A. |
a) INSERT INTO FACULTY VALUES(‘Charline B’, ‘English’, ‘M.A.’); b) INSERT INTO FACULTY VALUE(”Charline B”, ”English”, ”M.A.”); c) INSERT INTO FACULTY VALUE(‘Charline B’, ‘English’, ‘M.A.’); d) INSERT INTO FACULTY (Faculty_name, Department, Degree) VALUES(‘Charline B’, ‘English’, ‘M.A.’);
Answer: a), d)
Q7. A role Admin has the privilege of select, insert, update and delete on all tables of database. A new role Users is created and the following statement is executed. grant Admin to Users; Which rights will Users inherit?
a) Only select b) Only select and delete c) Only select, and update but not delete d) All rights – select, insert, delete, and update
Answer: d) All rights – select, insert, delete, and update
Q8. Consider the following instance of EmployeeDetails(EmpName, Branch, Address, Salary) relation.
EmpName | Branch | Address | Salary |
Raja | Kolkata | Kolkata | 10000 |
Priyanka | Mumbai | Hyderabad | 12000 |
Arindam | Bangalore | Kolkata | 15000 |
Rumki | Hyderabad | Hyderabad | 20000 |
Sumit | Hyderabad | Bangalore | 10000 |
Sandip | Mumbai | Mumbai | 15000 |
Identify the correct statement(s) to get the following output:
EmpName | Branch | Address | Salary |
Raja | Kolkata | Kolkata | 10000 |
Arindam | Bangalore | Kolkata | 15000 |
Rumki | Hyderabad | Hyderabad | 20000 |
Sandip | Mumbai | Mumbai | 15000 |
a) SELECT * FROM EmployeeDetails WHERE Branch=Address OR Salary>=15000; b) SELECT * FROM EmployeeDetails WHERE Branch=Address AND Salary>=15000; c) (SELECT * FROM EmployeeDetails WHERE Branch=Address) UNION (SELECT * FROM EmployeeDetails WHERE Salary>=15000); d) (SELECT * FROM EmployeeDetails WHERE Branch=Address) INTERSECT (SELECT * FROM EmployeeDetails WHERE Salary>=15000);
Answer: a), c)
Q9. Consider the following instance of EmployeeDetails(EmpName, Branch, Address, Salary) relation.
Identify the correct SQL command that creates a view as EmployeeSalaryDetails in which columns EmpName and Salary for the tuples where the second character of EmpName is ‘r’ and the Salary is atleast 15000.
a) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) ON SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘%r%’ AND Salary>=15000; b) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) ON SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>15000; c) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) AS SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>=15000; d) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) AS SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>15000;
Q10. Consider the given relational schema: EmployeeDetails(EmpName, Branch, Address, Salary) Identify the correct statement to find the EmpName, Branch and Salary of all tuples in which Salary is greater than or equal to the average Salary of all employees or Salary is between 15000 and 20000 including 15000 and 20000.
a) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary LIKE(15000, 20000); b) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary IN(15000, 20000); c) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary AS(15000, 20000); d) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary BETWEEN 15000 AND 20000;
<< Prev- Data Base Management System Week 1 Assignment Solutions
>> Next- Data Base Management System Week 3 Assignment Solutions
NPTEL answers: Problem solving through programming in C
NPTEL answers: Principles of Management
Programming in Java NPTEL week 1 quiz answers
NPTEL – Python for Data Science assignment solutions
Nptel – Deep Learning assignment solutions
The above question set contains all the correct answers. But in any case, you find any typographical, grammatical or any other error in our site then kindly inform us . Don’t forget to provide the appropriate URL along with error description. So that we can easily correct it.
Thanks in advance.
For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.
Related Posts
Operating system fundamentals | nptel | week 0 assignment 0 solution, nptel operating system fundamentals week 1 assignment solutions, nptel operating system fundamentals week 10 answers, nptel operating system fundamentals week 2 assignment solutions, nptel operating system fundamentals week 3 assignment solutions, nptel operating system fundamentals week 4 assignment solutions, leave a comment cancel reply.
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
- 1st Central Law Reviews: Expert Legal Analysis & Insights
Category: Nptel Assignment Answers 2024
Nptel introduction to industry 4 and industrial iot week 3 assignment answers, ethical hacking nptel week 3 assignment answers, digital circuits week 3 nptel assignment answers, data structure and algorithms using java week 3 nptel answers, deep learning for computer vision week 3 nptel answers 2024, deep learning iit ropar week 3 nptel answers, artificial intelligence search methods for problem solving week 2, nptel data science for engineers assignment 3 answers, nptel database management system assignment 3 answers, cloud computing nptel week 3 assignment answers.
DOWNLOAD APP
SWAYAM SUPPORT
Please choose the SWAYAM National Coordinator for support. * :
Navigation Menu
Search code, repositories, users, issues, pull requests..., provide feedback.
We read every piece of feedback, and take your input very seriously.
Saved searches
Use saved searches to filter your results more quickly.
To see all available qualifiers, see our documentation .
nptel-solutions
Here are 59 public repositories matching this topic..., kishanrajput23 / nptel-the-joy-of-computing-using-python.
Study materials related to this course.
- Updated Oct 27, 2023
kishanrajput23 / NPTEL-Programming-In-java
- Updated Apr 14, 2022
omunite215 / NPTEL-Programming-in-Java-Ultimate-Guide
I am sharing my journey of studying a course on Programming in Java taught by Prof.Debasis Samanta Sir IIT Kharagpur
- Updated Dec 4, 2023
kadeep47 / NPTEL-Getting-Started-With-Competitive-Programming
[Aug - Oct 2023] Solutions for NPTEL Course Getting started with competitive programming weekly assignment.
- Updated Jul 24, 2024
Md-Awaf / NPTEL-Course-Getting-started-with-Competitive-Programming
Solutions for NPTEL Course Getting started with competitive programming weekly assignment.
- Updated Apr 20, 2023
rvutd / NPTEL-Joy-of-Computing-2020
Programming Assignment Solutions
- Updated May 5, 2020
guru-shreyansh / NPTEL-Programming-in-Java
The sole intention behind this repository is to help the beginners in Java with the course contents.
- Updated Aug 1, 2021
avinashyadav16 / The-Joy-of-Computing-Using-Pyhton
12 Weeks long NPTEL Elective MOOC Course's codes, assignments and solutions.
- Updated Oct 30, 2023
- Jupyter Notebook
gunjanmimo / NPTEL-The-Joy-of-Computing-using-Python
- Updated Jan 26, 2020
AdishiSood / The-Joy-of-Computing-using-Python
- Updated Apr 28, 2021
gxuxhxm / NPTEL-The-Joy-of-Computing-using-Python
NPTEL-The-Joy-of-Computing-using-Python with NOTES and Weekly quizes Answers
- Updated Jun 25, 2024
NPTEL-Course / Programming-Data-Structures-And-Algorithms-Using-Python
Nptel Course Solutions : Programming, Data Structures And Algorithms Using Python
- Updated Nov 30, 2020
tdishant / NPTEL-Joy-of-Computing-Using-Python
Python code from week-3 to week-12 for the NPTEL course The Joy of Computing using Python
- Updated Oct 26, 2021
TarunSehgal27 / NPTEL-JAVA-2020
this is a repo about the java program headed by Debasis Samantha during 2020
- Updated Apr 23, 2020
NPTEL-Course / Google-Cloud-Computing-Foundations
Nptel Course Solution : Google Cloud Computing Foundations
- Updated Nov 19, 2020
Anmol-PROgrammar / SWAYAM-Programming_In_Java-NPTEL
This site contains the weekly( i.e. 1-9) questions and their solution of NPTEL-SWAYAM course "Programming in Java".
- Updated Aug 19, 2021
lonebots / python-programming-joc-nptel
Python programming repository for NPTEL joy of computing course
- Updated Dec 21, 2020
CGreenP / NPTEL-Introduction-to-Programming-in-C-Assignment-4-Question-3
NPTEL Introduction to Programming in C Assignment 4 Question 3
- Updated Apr 7, 2024
CGreenP / NPTEL-Introduction-to-Programming-in-C-Assignment-4-Question-1
NPTEL Introduction to Programming in C Assignment 4 Question 1
- Updated Apr 2, 2024
Bigblue00 / Joy-of-computing-using-python-NPTEL
- Updated Sep 25, 2019
Improve this page
Add a description, image, and links to the nptel-solutions topic page so that developers can more easily learn about it.
Curate this topic
Add this topic to your repo
To associate your repository with the nptel-solutions topic, visit your repo's landing page and select "manage topics."
Course Name: Data Base Management System
- About Course
- Certificate Type
- Toppers list
- Registration
Course abstract
Databases form the backbone of all major applications today tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain. While DBMS’s differ in details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course would examine data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. It would also introduce query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client/server architectures based and Web-based database applications will also be introduced.
Course Instructor
Prof. Partha Pratim Das
Partha Pratim Das received his BTech, MTech and PhD degrees in 1984, 1985 and 1988 respectively from IIT Kharagpur. He served as a faculty in Department of Computer Science and Engineering, IIT Kharagpur from 1988 to 1998. In 1998, he joined Alumnus Software Ltd as a Business Development Manager. From 2001 to 2011, he worked for Interra Systems, Inc. as a Senior Director and headed its Kolkata Center. In 2011, he joined back to Department of Computer Science and Engineering, IIT Kharagpur as Professor. Dr. Das has also served as a Visiting Professor with Institute of Radio Physics and Electronics, Calcutta University from 2003 to 2013.
Teaching Assistant(s)
Amrita Chatterjee
B.tech, Information Technology
Smruti Rekha Das
M.Tech, Computer Science and Engineering
Himadri Bhuyan
PhD, IIT Kharagpur
Srijoni Majumdar
Research Scholar
RAJ KUMAR MOHANTA
M.TECH, COMPUTER SCIENCE
Munmun Bhattacharya
I am not a student
Course Duration : Feb-Apr 2019
view course, syllabus, enrollment : 15-nov-2018 to 25-feb-2019, exam registration : 25-feb-2019 to 19-apr-2019, exam date : 27-apr-2019, course statistics will be published shortly, certificate eligible, certified category count, successfully completed, participation.
Category : Successfully Completed
Category : Elite
Category : Silver
Category : Gold
>=90 - Elite + Gold 75-89 -Elite + Silver >=60 - Elite 40-59 - Successfully Completed <40 - No Certificate
Final Score Calculation Logic
- Assignment Score = Average of best 6 out of 8 assignments.
- Final Score(Score on Certificate)= 75% of Exam Score + 25% of Assignment Score
KSHITIJ PATHAK 98%
GOVERNMENT POLYTECHNIC COLLEGE MANDSAUR
KHWAJA BILKHIS 97%
SREENIDHI INSTITUTE OF SCIENCE AND TECHNOLOGY
KARTHIK.S 97%
RATHNAVEL SUBRAMANIAM COLLEGE OF ARTS AND SCEINCE
BIPLAB MAL 97%
NETAJI SUBHASH ENGINEERING COLLEGE
SAI KRISHNA MOTHE 97%
DIVYANK PRATAP TIWARI 96%
HALDIA INSTITUTE OF TECHNOLOGY
ATUL PRATAP SINGH 95%
FUTURE INSTITUTE OF ENGINEERING & TECHNOLOGY
PRIADARSINI M 95%
GOVERNMENT COLLEGE OF ENGINEERING, DHARMAPURI
BHASKAR BANERJEE 95%
GOVT. COLLEGE OF ENGINEERING & TEXTILE TECHNOLOGY SERAMPORE
ROSHAL SURESH MORAES 94%
ST.FRANCIS INSTITUTE OF TECHNOLGY
KANDULA DAMODHAR RAO 94%
NEJIYA A K 94%
COLLEGE OF ENGINEERING PATHANAPURAM
ABHISHEK RAJ 94%
TECHNO INDIA, SALT LAKE, WEST BENGAL
SUMIRAN NAMAN 94%
INSTITUTE OF ENGINEERING & MANAGEMENT
SARADIA SAMANTA 94%
TECHNO INTERNATIONAL NEW TOWN
K VINAY KUMAR 94%
SRI INDU COLLEGE OF ENGINEERING & TECHNOLOGY
SHIVANI SHAKYA 94%
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL
AVESH KUMAR AGRAWAL 94%
KIET GROUP OF INSTITUTIONS
GAUTAM SHARMA 94%
COOCHBEHAR GOVERNMENT ENGINEERING COLLEGE
SUBATHRA S 94%
VELALAR COLLEGE OF ENGINEERING AND TECHNOLOGY
VYAS SAHIL HIRALKUMAR 94%
DWARKADAS J.SANGHVI COLLEGE OF ENGINEERING
NARENDRA PAL SINGH RATHORE 93%
ACROPOLIS INSTITUTE OF TECHNOLOGY & RESEARCH
RITAM CHATTOPADHYAY 93%
KALYANI GOVT. ENGINEERING COLLEGE
RAKESH SINGH SAMBYAL 93%
COLLEGE OF ENGINEERING AND TECHNOLOGY, BABA GHULAM SHAH BADSHAH UNIVERSITY
PRIYANSH UPADHYAY 93%
BIRLA INSTITUTE OF APPLIED SCIENCES
ARAVINDA KASUKURTHI 93%
R.V.R. & J.C. COLLEGE OF ENGINEERING
NAINCY SAHU 93%
TANYA MAHTANI 93%
FUTURE INSTITUTE OF ENGINEERING AND MANAGEMENT
VIVEK KUMAR YADAV 93%
COLLEGE OF ENGINEERING & MANAGEMENT, KOLAGHAT
ABBURI VENKATESH 93%
QIS COLLEGE OF ENGINEERING AND TECHNOLOGY
SIBASIS BHATTACHARJEE 93%
ST.THOMAS COLLEGE OF ENGINEERING AND TECHNOLOGY
VUPPALA LALITH KIRAN 93%
RAHUL BISWAS 93%
TECHNO INDIA UNIVERSITY, WEST BENGAL
KIRTI JAIN 93%
INDERPRASTHA ENGINEERING COLLEGE
LAVANYA D 93%
MEGHA SAHA 93%
SUDIP DAS 93%
REBELLI DHAVALA RISHITHA 92%
K. MONIKA SREE SAANKHYA 92%
JULURI SAMATHA 92%
MATRUSRI ENGINEERING COLLEGE
VISHAL AGRAWAL 92%
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE
AARTHY B 92%
VV COLLEGE OF ENGINEERING
SHIVAM KUMAR CHAUDHARY 92%
DURGAPUR INSTITUTE OF ADVANCED TECHNOLOGY & MANAGEMENT
BIVIN VARKEY VARGHESE 92%
RAJIV GANDHI INSTITUTE OF TECHNOLOGY, KOTTAYAM, KERALA
ANKIT KUMAR SINHA 92%
SWAGATAM CHAKRABORTY 92%
VARTIKA KEDIA 92%
ASANSOL ENGINEERING COLLEGE
SUDARSHAN KUMAR PRAJAPATI 92%
RAJ KUMAR GOEL INSTITUTE OF TECHNOLOGY
ARINDAM CHATTOPADHYAY 92%
GOVERNMENT COLLEGE OF ENGINEERING AND TEXTILE TECHNOLOGY,SERAMPORE
AVNISH KUMAR 92%
SOUMO SUVRA NASKAR 91%
JALPAIGURI GOVT. ENGINEERING COLLEGE
AADITYA GARG 91%
CHIRAG GUPTA 91%
M B M ENGINEERING COLLEGE
BIKUMALLA SAIKIRAN 91%
SUMANTA NAG 91%
TALAPALLI VINEETH KUMAR 91%
N.KAVISANKAR 91%
SRI RAMAKRISHNA INSTITUTE OF TECHNOLOGY
SANGEETA GUPTA 91%
VARDHAMAN COLLEGE OF ENGINEERING
SHAKEEL AHMAD DAR 91%
DEPTT OF TECHNICAL EDUCATION ,J&K GOVT
RABI NARAYAN PANDA 91%
SUBHATAV DHALI 91%
YOGITA KHATRI 91%
JSS ACADEMY OF TECHNICAL EDUCATION
REEMA BANERJEE 91%
KHITISH KUMAR GADNAYAK 91%
GANDHI ENGINEERING COLLEGE
ARJUN RUPAVATIA 91%
CHAROTAR UNIVERSITY OF SCIENCE AND TECHNOLOGY
ANISHA GUPTA 91%
BABU BANARSI DAS ENGINEERING COLLEGE
MANKU KUMAR PATHAK 91%
NIT AGARTALA
CHAITANYA VAISHAMPAYAN 91%
DEBJANI MONDAL 91%
RCC INSTITUTE OF INFORMATION TECHNOLOGY
BETHINENI SARITHA 91%
VAAGDEVI COLLEGE OF ENGINEERING
RIYA GHOSH 91%
S USHA KIRUTHIKA 91%
S.R.M. INSTITUTE OF SCIENCE AND TECHNOLOGY
DR. KAMAL SETHI 90%
PALASH GOLE 90%
JABALPUR ENGINEERING COLLEGE, JABALPUR
SUMAN RANA 90%
MANALI CHANDRAKANT SETH 90%
ANUP BURNWAL 90%
RIYA B. GEORGE 90%
KUNAL KUMAR 90%
SHRUTI WASNIK 90%
MIRYALA SUPRAJA 90%
MANASA REDDY 90%
BASANI AISHWARYA 90%
RAJALAKSHMI D 90%
R.M.D. ENGINEERING COLLEGE
MAHESHWARI.G 90%
PONDICHERRY UNIVERSITY
CHIRADIP BHATTACHARYA 90%
M REVATHI 90%
HINDUSTHAN COLLEGE OF ENGINEERING & TECHNOLOGY
LATHA R 90%
THE OXFORD COLLEGE OF ENGINEERING
ANWESHA KAR 90%
SAYANTI DEY 90%
GOVERNMENT COLLEGE OF ENGINEERING & TEXTILE TECHNOLOGY , SERAMPORE
MADADI SAISREE 90%
SNEHA KEDIA 90%
SAYYADA HAJERA BEGUM 90%
MUFFAKHAM JAH COLLEGE OF ENGINEERING AND TECHNOLOGY
MANSI BHATT 90%
SUBHAM VERMA 90%
DONTHULA VIKAS 90%
ANIRUDDHA MAITY 89%
GOVT. COLLEGE OF ENGINEERING & TEXTILE TECHNOLOGY BERHAMPORE
K V SAI SNEHA 89%
B SURAJ 89%
SLESHA SANGHVI 89%
CHHOTUBHAI GOPALBHAI PATEL INSTITUTE OF TECHNOLOGY
RITU AGARWAL 89%
MANJEEMA GHOSH 89%
A. REGITA THANGAM 89%
ST.XAVIERS COLLEGE, PALAYAMKOTTAI
RITU VERMA 89%
HARCOURT BUTLER TECHNICAL UNIVERSITY
ROHIT KUNDU 89%
ASHISH GUNJAN 89%
PRIYANKA SAHA 89%
LEELAKRISHNA THIYAGARAJAN 89%
CHENNAI INSTITUTE OF TECHNOLOGY
RITU KUMARI SINGH 89%
RAVINDRA KUMAR MEHTA 89%
MEGHA MUKUNDRAO CHAITANYA 89%
PURANMAL LAHOTI GOVT POLY LATUR
YADLAPALLI.NAVYA 89%
OINDRILA DAS 89%
MUKESH SONI 89%
SMT. S R PATEL ENGINEERING COLLEGE
DIPTI PAWAR 89%
BHARATI VIDYAPEETH (DU) COLLEGE OF ENGINEERING, PUNE
PALAK AMIN 89%
SHILPA KUMARI 89%
SHREYA KUMARI 89%
PALIKA JAJOO 89%
KAUTILYA INSTITUTE OF TECHNOLOGY & ENGINEERING
A.R.MUHILRAAJ 89%
SONA COLLEGE OF TECHNOLOGY
ANKIT SHARMA 89%
MADAPANA JYOTSHNA 89%
AJIT KUMAR 89%
ABACUS INSTITUTE OF ENGINEERING AND MANAGEMENT
JAYANT KUMAR 88%
DRONACHARYA GROUP OF INSTITUTIONS
BIPIN BIHARI LAL 88%
PRATEEK TRIPATHI 88%
DEWAN V.S. INSTITUTE OF ENGINEERING AND TECHNOLOGY
KAVYAPONNAPATI 88%
GUDLAVALLERU ENGINEERING COLLEGE
P.PRANEETH 88%
NATIONAL INSTITUTE OF TECHNOLOGY ANDHRA PRADESH
ASHOK KUMAR 88%
SIVA NAGA PRASAD MANNEM 88%
BISHAL SHARMA 88%
JOYNATH BARMAN 88%
ASSAM UNIVERSITY
ESHANI GHOSH 88%
JULIE KUMARI 88%
MADHAV INSTITUTE OF TECHNOLOGY & SCIENCE
SNEHA GARG 88%
BHAGYA LAXMI K 88%
AKANKSHA PRIYADARSHNI 88%
T.ARUNA JYOTHI 88%
AASTHA MISHRA 88%
PALAK GUPTA 88%
JAGANNATH INTERNATIONAL MANAGEMENT SCHOOL
ANAND KUMAR SHUKLA 88%
PANKAJ KUMAR 88%
RAJKIYA ENGINEERING COLLEGE , SONBHADRA
BALU THOTA 88%
NAMRATA NIDHI 88%
BISWOJIT NAYAK 88%
UTKAL UNIVERSITY
DODDI SRILATHA 88%
HASEEB AHMAD QUADRI 88%
SRM INSITUTE OF SCIENCE AND TECHNOLOGY, DELHI-NCR CAMPUS
PRADHYUMNA KILEDAR 88%
SHEETAL KUMARI 88%
SHAHINA ANJUM 88%
ACCURATE INSTITUTE OF MANAGEMENT & TECHNOLOGY
GIBIN GEORGE 88%
SANTHIGIRI COLLEGE OF COMPUTER SCIENCES
ALKA PRASAD 88%
BHARGAVI CHEVVA 88%
AMAN SAHU 88%
MEDI-CAPS UNIVERSITY,INDORE
VILESH AGARWAL 88%
VISHWAKARMA INSTITUTE OF TECHNOLOGY
PRASHANT KUMAR SHARMA 88%
HINDUSTAN INSTITUTE OF MANAGEMENT AND COMPUTER STUDIES
DR. ABINASH TRIPATHY 88%
RAGHU ENGINEERING COLLEGE
PRIYANKA CHITLANGIA 88%
ALOK KUMAR GUPTA 88%
HEMANTH GADARLA 88%
A SAI RAM 88%
ITTE LAVANYA 88%
SRI VASAVI ENGINEERING COLLEGE
CHERUKU PRIYANKA 88%
MOTAPOTHULA JYOTHI PRIYA 87%
YAJUSHI DEY 87%
VIGNESH S 87%
REDDY SAISINDHUTHEJA 87%
SANGEETHA B 87%
PSG COLLEGE OF TECHNOLOGY
PRINCE KUMAR SINGH 87%
MCKV INSTITUTE OF ENGINEERING
MANSI KULKARNI 87%
ABHINAV RAJ 87%
SIR M. VISVESVARAYA INSTITUTE OF TECHNOLOGY
RITIKA KUMARI 87%
PRIYA SONI 87%
DR. D V LALITA PARAMESWARI 87%
G. NARAYANAMMA INSTITUTE OF TECHNOLOGY AND SCIENCE (FOR WOMEN)
SURBHI SHARMA 87%
GLA UNIVERSITY, MATHURA
ARADHI SUDHIR SADRANI 87%
SUCHITHRA VS 87%
GOVERNMENT ENGINEERING COLLEGE, PALAKKAD
MAYANK SHUKLA 87%
UNITED COLLEGE OF ENGINEERING AND MANAGEMENT
VIJAYALAKSHMI CHERUKU 87%
CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY,HYDERABAD
UJWALA BHOGA 87%
ANURAG GROUPS OF INSTITUTIONS
SHASHANK RAI 87%
DUDUKU VARUN 87%
CHAUHAN DHARMESH 87%
THANGADIPELLI APOORVA 87%
LAKSHMI BHASKARLA 87%
VELAGAPUDI RAMAKRISHNA SIDDHARTHA ENGINEERING COLLEGE
PIYUSH GUPTA 87%
NIVETHA B 87%
VINAY KUMAR GUPTA 87%
GUNJAN BHARADWAJ 87%
L. PRABAHAR 87%
KAMARAJ COLLEGE OF ENGINEERING AND TECHNOLOGY
SANJEEV KUMAR MISHRA 87%
GYANESH SHARMA 87%
NITIN PRASHANT 87%
ARYA COLLEGE OF ENGINEERING & INFORMATION TECHNOLOGY
JOYDEEP BISWAS 87%
RAMKRISHNA MAHATO GOVERNMENT ENGINEERING COLLEGE PURULIA
PRANAV PRAKASH 87%
SUBHRA GHATAK 86%
INSTITUTE OF ENGINEERING & MANAGEMENT (ASHRAM CAMPUS)
MANIKONDA VYSHNAVI 86%
ABHISHEK CHANDRA JHA 86%
GAURI DIPAK PATNE 86%
GOVERNMENT POLYTECHNIC OSMANABAD
SADAF R. SURYAWANSHI 86%
GOVERNMENT POLYTECHNIC, THANE
VENUGOPAL S 86%
ACE ENGINEERING COLLEGE
MD SIRAJUL HUQUE 86%
GURU NANAK INSTITUTIONS TECHNICAL CAMPUS
NITISH KUMAR SHARMA 86%
SHAIK MAHAMMAD IQBAL 86%
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY,KAKINADA
PARCHURI PAVAN SAI KRISHNA 86%
MALKAPURAM NIKHITHA 86%
PRITHWIJIT BHATTACHARYA 86%
UNIVERSITY OF ENGINEERING & MANAGEMENT (UEM)
GUNTUKU RAMYA 86%
PENUMAKA RAMA BHARGAVI 86%
VISHNU INSTITUTE OF TECHNOLOGY
VINAYAK SONI 86%
SUCHITH REDDY 86%
RADHIKA RATHI 86%
PANKAJ MITHANI 86%
EKTA GUPTA 86%
PRANVEER SINGH INSTITUTE OF TECHNOLOGY
ALAMPALLY SREEDEVI 86%
SRAVAN KUMAR G 86%
SPHOORTHY ENGINEERING COLLEGE
ABHISEK DAS 86%
B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY
SARIKONDA SACHIN GOUD 86%
THRISHA BANDI 86%
JNTU HYDERBAD COLLEGE OF ENGINEERING,JAGTIAL
ARCHANA K M 86%
GOVERNMENT ENGINEERING COLLEGE, THRISSUR
JHALAK GOYAL 86%
KORADA ABHISHEK 86%
MAHARAJ VIJAYARAM GAJAPATHI RAJ COLLEGE OF ENGINEERING
SUSHOBHAN GHOSH 86%
DR. B. C. ROY ENGINEERING COLLEGE
RUTVIK RUPAPARA 86%
SINDHURA BANDARU 86%
T.LALIT ADITYA 86%
THILAGU M 86%
AVINASHILINGAM INSTITUTE FOR HOME SCIENCE AND HIGHER EDUCATION FOR WOMEN
DEBDUTTA PAL 86%
CALCUTTA INSTITUTE OF ENGINEERING AND MANAGEMENT
RAVINDER SINGH 86%
LOVELY PROFESSIONAL UNIVERSITY
SUBHAM AGARWALLA 86%
MERUGUMALA DIVYA SRI 86%
K SAI SIDDHARTHA 86%
VASAVI COLLEGE OF ENGINEERING
NABONITA DEBNATH 86%
NATIONAL INSTITUTE OF TECHNOLOGY AGARTALA
SHAILZA KUMARI 86%
J. GEETHA PRIYA 86%
THALLURI VENKATA UMA MAHESWARA RAO 86%
PANKAJ KUMAR MUNDHRA 86%
ARUNA KUMARI BODALA 86%
SUSHANT KUMAR 86%
SWAMI KESHVANAND INSTITUTE OF TECHNOLOGY MANAGEMENT & GRAMOTHAN
SHIVANGI GARG 86%
GAURAB ROY 86%
INDRANIL CHOWDHURY 86%
KAKARLA DIVYA 86%
INSTITUTE OF AERONAUTICAL ENGINEERING
PREETIKA PRAKASH 86%
ABHISEK SAHA 86%
JONY SAHA 86%
TAMOJIT MITRA 86%
AYUSH KUMAR RAI 86%
Enrollment Statistics
Total enrollment: 42626, registration statistics, total registration : 6297, assignment statistics, score distribution graph - legend, assignment score: distribution of average scores garnered by students per assignment., exam score : distribution of the final exam score of students., final score : distribution of the combined score of assignments and final exam, based on the score logic..
IMAGES
VIDEO
COMMENTS
Welcome to our detailed walkthrough of the "NPTEL Data Base Management System Week 3 Assignment Solution for July 2024," presented by IIT Kharagpur. This vid...
Review the Answers: Each week-XX.md file provides detailed solutions and explanations for that week's assignments. Review these files to find the information you need. By following these steps, you can easily locate and use the assignment answers and solutions for the NPTEL courses provided in this repository.
#dbms #nptel #swayam #DatabseManagementSystemDBMS All Week Assignment Solution - https://www.youtube.com/playlist?list=PL__28a0xFM--2skDen7ZsIjI9tTikqkB2Pyth...
NPTEL DBMS 2024 assignment solutions. nptel exam 2024 assignment notes. Course. Database Management System (CSC502) 101 Documents. Students shared 101 documents in this course. University University of Mumbai. ... Question 1. Marks: 2 MCQ A relation R has 2 candidate keys with 1 attribute each. There are 6 possible super keys of R.
Data Base Management System NPTEL Week 3 Assignment Answers || Jan apr 2024 || @OPEducore Course: Data Base Management SystemOffered by: IIT KharagpurDurat...
In this background the course examines data structures, file organizations, concepts and principles of DBMS's, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data ...
noc19 cs46 assignment Week 7. swayam NPTEL » Database Management System Unit 9 - Week 7 Announcements About the Course [email protected] Mentor Ask a Question Progress Course outline How to access the portal Week O : Assignment week 1 week 2 week 3 week 4 week 5 week 6 week 7 Lecture 31 : Transactions/l Lecture 32: TransactionY2 ...
This set of MCQ (multiple choice questions) focuses on the Data Base Management System NPTEL 2022 Week 2 Assignment Solutions. The course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through ...
NPTEL » Database Management System Unit 3 - Week 1 Announcements About the Course [email protected] Mentor Ask a Question Progress Course outline How to access the portal Week O : Assignment week 1 Lecture 1 : Course Overview Lecture 2 . Introduction to Lecture 3 : Introduction to DBMS/2 Lecture 4 : Introduction to Relational Model/l
Nptel Assignment Answers 2024. Artificial Intelligence Search Methods For Problem solving Week 2. Nptel Data Science for Engineers Assignment 3 Answers. Nptel Database Management System Assignment 3 Answers. Cloud Computing Nptel Week 3 Assignment Answers. Computer Architecture Week 3 Assignment Nptel Answers 2024.
As per our records you have not submitted this assignment. Note : This assignment is for practice and it will not be graded. 1) Consider two sets A and 8. The set A — (A —B) is equivalent to An B AUB No, the answer is incorrect. Score: 0 Accepted Answers: 2) Suppose A is a set with 4 elements. The number of elements in the power set of A is ...
Database Management System: Assignment 1. Total Marks : 20. June 7, 2022 Question 1. Consider the following table: student student roll name dept code dept name project group CS121 Rohit D01 CSE Image Processing CS432 Sidra D03 IT Computer Architecture CS432 Sidra D03 IT Ethical Hacking CS133 Reeta D02 ECE Signal Processing CS133 Reeta D02 ECE Image Processing EE134 Rina D04 EE Image Processing
Answer: a), b) Explanation: As per the lecture notes (Module 02: Introduction to DBMS/1). Physical level: describes how a record is stored. Logical level: describes data stored in the database, and the relationships among the data. View level: application programs hide details of data types.
this video goes over assignment from week 2 in dbms nptel and explains each question...
The National Programme on Technology Enhanced Learning (NPTEL) offers a comprehensive course on Database Management Systems, which is a crucial subject in computer science and data management. This article provides the detailed answers and explanations for the Week 1 assignment of the NPTEL Database Management System course for the session July ...
Are you looking for NPTEL Week 1 assignment answers for 2024 for July Dec Session ! If you're enrolled in any of the NPTEL courses, this post will help you find the relevant assignment answers for Week 1. Ensure to submit your assignments by August 8, 2024.
As per our records you have not submitted this assignment. 1) Storing data and meta-data separately makes RDBMS general-purpose and flexible. True False No, the answer is incorrect. Score: 0 Accepted Answers: 2) "Data Model" is nothing but a data structure where data is stored. True False No, the answer is incorrect.
To associate your repository with the nptel-assignments topic, visit your repo's landing page and select "manage topics." GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects.
The Assignment- 1 & 2 of Week- 1 & 2 Solution for the course "Data Base Management System" has been released in the portal. Please go through the solution and in case of any doubt post your queries in the forum.
The NPTEL Programming in Java course, offered from July to October 2024, provides a solid foundation in Java programming. Week 2's assignment focuses on understanding key concepts and practices in Java. Below is a comprehensive guide to the assignment questions and their answers. Question 1:
NPTEL :: Computer Science and Engineering - NOC:Data Base Management System. Courses. Computer Science and Engineering. NOC:Data Base Management System (Video) Syllabus. Co-ordinated by : IIT Kharagpur. Available from : 2017-12-21.
Welcome to Swayam-NPTEL. Enhance skills that meet your need online. NPTEL Online Certification Courses NPTEL is a project of MHRD initiated by 7 IITs along with the IISc, Bangalore in 2003, to provide quality education to anyone interested in learning from the IITs. ...
java jdbc nptel jdbc-database nptel-solutions nptel-assignments nptel-course nptel-java-solutions Updated Dec 4, 2023; kadeep47 ... This site contains the weekly( i.e. 1-9) questions and their solution of NPTEL-SWAYAM course "Programming in Java". java nptel-solutions swayam Updated Aug 19, 2021;
Databases form the backbone of all major applications today tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc ...