nptel database management system assignment 2 answers 2022

• Review Assignment
• Announcements
• About the Course
• Explore Courses

NPTEL: Exam Registration is open now for July 2022 courses!

Dear Candidate, Here is a golden opportunity for those who had previously enrolled in this course during the Jan 2022 semester, but could not participate in the exams or were absent/did not pass the exam for this course. This course is being reoffered in July 2022 and we are giving you another chance to write the exam in October 2022 and obtain a certificate based on NPTEL norms. Do not let go of this unique opportunity to earn a certificate from the IITs/IISc. IMPORTANT instructions for learners - Please read this carefully   1. The exam date for this course:    October 29 2022 2. CLICK HERE to register for the exam. Please fill the exam form using the same Enrolled email id & make fee payment via the form, as before. 3. Choose from the Cities where exam will be conducted: Exam Cities 4. You DO NOT have to re-enroll in the courses.  5. You DO NOT have to resubmit Assignments OR participate in the non-proctored  programming exams in the previous semester 6. If you do enroll to July 2022 course, we will take the best average assignment scores/non-proctored programming exam score across the two semesters NOTE: Please check once if you have >= 40/100  in average assignment score and also participated and satisfied the criteria in the non-proctored programming exams that were conducted in Jan 2022 to become eligible for the e-certificate, wherever applicable. If not, please submit assignments again in the July 2022 course & and also participate in the non-proctored programming exams to become eligible for the e-certificate. We will not be having new assignments or unproctored exams in the previous semester's(Jan 2022) course.  You can also submit assignments again and participate in the non-proctored programming exams if you want to take fresh assignments or need to improve your previous scores. RECOMMENDATION: If you want to take new assignments and an unproctored exam or brush up on your lessons for the exam, please enroll in the July 2022 course. LINK to enroll in the current course:    https://onlinecourses.nptel.ac.in/noc22_cs91/preview 7. Exam fees:  If you register for the exam and pay before Sep 12, 2022, 10:00 AM , Exam fees will be Rs. 1000/- per exam.   If you register for exam before Sep 12, 2022, 10:00 AM and have not paid or if you register between Sep 12, 2022, 10:00 AM & Sep 16, 2022, 10:00 AM , Exam fees will be Rs. 1500/- per exam   8. 50% fee waiver for the following categories:  Students belonging to the SC/ST category: please select Yes for the SC/ST option and upload the correct Community certificate. Students belonging to the PwD category with more than 40% disability: please select Yes for the option and upload the relevant Disability certificate.  9. Last date for exam registration: Sep 16, 2022, 10:00 AM (Friday).   10. Mode of payment: Online payment - debit card/credit card/net banking/UPI. 11. HALL TICKET:  The hall ticket will be available for download tentatively by 2 weeks prior to the exam date . We will confirm the same through an announcement once it is published.  12. FOR CANDIDATES WHO WOULD LIKE TO WRITE MORE THAN 1 COURSE EXAM:- you can add or delete courses and pay separately till the date when the exam form closes. Same day of exam you can write exams for 2 courses in the 2 sessions. Same exam center will be allocated for both the sessions.  13. Data changes:  Last date for data changes: Sep 16, 2022, 10:00 AM:  All the fields in the Exam form except for the following ones can be changed until the form closes.  The following 6 fields can be changed ONLY when there are NO courses in the course cart. And you will be able to edit the following fields only if you: -  REMOVE unpaid courses from the cart And/or - CANCEL paid courses  1. Do you come under the SC/ST category? *  2. SC/ST Proof  3. Are you a person with disabilities? *  4. Are you a person with disabilities above 40%?  5. Disabilities Proof  6. What is your role ?  Note: Once you remove or cancel a course, you will be able to edit these fields immediately.  But, for cancelled courses, refund of fees will be initiated only after 2 weeks.  14. LAST DATE FOR CANCELLING EXAMS and getting a refund: Sep 16, 2022, 10:00 AM   15. Click here to view Timeline and Guideline : Guideline   Domain Certification Domain Certification helps learners to gain expertise in a specific Area/Domain. This can be helpful for learners who wish to work in a particular area as part of their job or research or for those appearing for some competitive exam or becoming job ready or specialising in an area of study.     Every domain will comprise Core courses and Elective courses. Once a learner completes the requisite courses per the mentioned criteria, you will receive a Domain Certificate showcasing your scores and the domain of expertise. Kindly refer to the following link for the list of courses available under each domain: https://nptel.ac.in/domains Outside India Candidates Candidates who are residing outside India may also fill the exam form and pay the fees. Mode of exam and other details will be communicated to you separately. Thanks & Regards,  NPTEL TEAM

Thank you for learning with NPTEL!!

Dear Learner, Thank you for taking the course with NPTEL!! Hope you enjoyed the journey with us. The results for this course have been published and we are closing this course now.  You will still have access to the contents and assignments of this course, if you click on the course name from the "Mycourses" tab on swayam.gov.in. The discussion forum is being closed though and you cannot ask questions here. For any further queries please write to [email protected] . - Team NPTEL

Data Base Management System : Result Published!

• Hard copies of certificates will not be dispatched.
• The duration shown in the certificate will be based on the timeline of offering of the course in 2022, irrespective of which Assignment score that will be considered.

Data Base Management System: Final Feedback Form

Dear student, We are glad that you have attended the NPTEL online certification course. We hope you found the NPTEL Online course useful and have started using NPTEL extensively. In this regard, we would like to have feedback from you regarding our course and whether there are any improvements, you would like to suggest.   We are enclosing an online feedback form and would request you to spare some of your valuable time to input your observations. Your esteemed input will help us in serving you better. The link to give your feedback is: https://docs.google.com/forms/d/15wAtuqR9WuYfw8LGbcIa-TTxZYzTQJSe69eoXjtC7Hc/viewform We thank you for your valuable time and feedback. Thanks & Regards, -NPTEL Team

Best of Luck for your Exam

Data Base Management System - Assignment-8 Solution Released

The  Assignment-8  of  Week-8  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. Link for assignment 8 solution:  https://drive.google.com/file/d/1MWjN5zLGpkLk6Z9epWDALDjj7wEgWGK3/view

Happy Learning!

Thanks & Regards,

Data Base Management System : Video recording on Interactive session 2

There was an interaction session with some of the students for the course Data Base Management System  .

The video recording is now available in the portal under the last unit "Live Interactive session"

Those who are interested can take a look.

Youtube link :  https://youtu.be/E0vV4eLAvVc

-NPTEL Team

Data Base Management System : Live Interactive session - 2

Dear Learner,

You can interact LIVE with the Course Instructor Prof. Samiran Chattopadhyay , IIT Kharagpur – " Data Base Management System" .

Date: 22 .03.2022

Time: 15 :00 

Link to login to: https://youtu.be/E0vV4eLAvVc

Enter your questions you want 

You can interact LIVE with the Course Instructor Prof. Samiran Chattopadhyay , to answer at :  https://docs.google.com/forms/d/e/1FAIpQLSe13K-Ezsi_C9eOwpBbIH-ZNbNH5UTyXDCl20An5h_iTNcxkQ/viewform

You can also ask your doubts during the session through the chat window... 

We would also like to hear from you after the session. Request you to share your thoughts in the forum. Learners are encouraged to visit bit.ly/NPTELLIVE  

for updates on the live sessions. 

Data Base Management System - Assignment-7 Solution Released

The  Assignment-7  of  Week-7  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. Link for assignment 7 solution:  https://drive.google.com/file/d/10P_0R8Xh_e1hVxarFhNH-43bFkCmTZ31/view

Data Base Management System - Week 8 Feedback Form

Dear Learners,

Thank you for enrolling in this NPTEL course and we hope you have gone through the contents for this week and also attempted the assignment.

We value your feedback and wish to know how you found the videos and the questions asked - whether they were easy, difficult, as per your expectations, etc

We shall use this to make the course better and we can also know from the feedback which concepts need more explanation, etc.

Please do spare some time to give your feedback - comprises just 5 questions - should not take more than a minute, but makes a lot of difference for us as we know what the Learners feel.

Here is the link to the form: https://docs.google.com/forms/d/e/1FAIpQLSeAc5g5Ugt3T0doSVycoGYiwyB0n8E5-pxKsvOYQpk9TU27zA/viewform

Data Base Management System - Week 8 content is live now!!

Dear Students

The lecture videos for Week 8 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=74&lesson=75

The other lectures of this week are accessible from the navigation bar to the left. Please remember to login into the website to view contents (if you aren't logged in already).

Assignment 8 for Week 8 is also released and can be accessed from the following link:  https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=74&assessment=132

The assignment has to be submitted on or before Wednesday,23-03-2022 , 23:59 IST.

As we have done so far, please use the discussion forums if you have any questions on this module.

Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately.

Thanks and Regards,

--NPTEL Team

Data Base Management System - Assignment-6 Solution Released

The  Assignment-6  of  Week-6  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. Link for assignment 6 solution:  https://drive.google.com/file/d/1ZKXyt6VNzHjT8zzGRgjkLczCEXVIGDAn/view

Data Base Management System - Week 7 Feedback Form

Data base management system - week 7 content is live now.

The lecture videos for Week 7 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=66&lesson=67

Assignment 7 for Week 7 is also released and can be accessed from the following link:  https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=66&assessment=130

The assignment has to be submitted on or before Wednesday, 16-03-2022 , 23:59 IST.

Data Base Management System - Download video links are available now!!

Dear Learners, The download video link for the course Data Base Management System  is available now in the course outline. Please check the download video link:  https://nptel.ac.in/courses/106105175/ -NPTEL Team

Data Base Management System - Assignment-5 Solution Released

The  Assignment-5  of  Week-5  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. Link for assignment 5 solution:  https://drive.google.com/file/d/1_S0BNrrxDnPOYM_R7qp-4VQMNttBV_0z/view

Data Base Management System - Week 6 Feedback Form

Here is the link to the form: https://docs.google.com/forms/d/1qtHVGXjHCGwH305eOHrcaPsyf5SFO6g6zYgLcmH8hk8/viewform

Exam Format - March 27,2022

Dear Candidate, ****This is applicable only for the exam registered candidates**** Type of exam will be available in the list: Click Here You will have to appear at the allotted exam center and produce your Hall ticket and Government Photo Identification Card (Example: Driving License, Passport, PAN card, Voter ID, Aadhaar-ID with your Name, date of birth, photograph and signature) for verification and take the exam in person.  You can find the final allotted exam center details in the hall ticket. The hall ticket is yet to be released . We will notify the same through email and SMS. Type of exam: Computer based exam (Please check in the above list corresponding to your course name) The questions will be on the computer and the answers will have to be entered on the computer; type of questions may include multiple choice questions, fill in the blanks, essay-type answers, etc. Type of exam: Paper and pen Exam  (Please check in the above list corresponding to your course name) The questions will be on the computer. You will have to write your answers on sheets of paper and submit the answer sheets. Papers will be sent to the faculty for evaluation. On-Screen Calculator Demo Link: Kindly use the below link to get an idea of how the On-screen calculator will work during the exam. https://tcsion.com/ OnlineAssessment/ ScientificCalculator/ Calculator.html NOTE: Physical calculators are not allowed inside the exam hall. -NPTEL Team

Data Base Management System : Video recording on Interactive session 1

There was an interaction session with some of the students for the course Data Base Management System .

Youtube link :  https://youtu.be/hw4YdfVV6Eg

Data Base Management System : Live Interactive session - 1

Date: 28 .02.2022

Time: 17 :00 

Link to login to: https://youtu.be/hw4YdfVV6Eg

You can interact LIVE with the Course Instructor Prof. Samiran Chattopadhyay , to answer at :  https://docs.google.com/forms/d/e/1FAIpQLSc-fPe_7MdaRJ10zec2iUAjMCoTmzX9uYuXBmq6uQvGFNVVug/viewform

Data Base Management System - Week 6 content is live now!!

The lecture videos for Week 6 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=58&lesson=59

Assignment 6 for Week 6 is also released and can be accessed from the following link:  https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=58&assessment=127

The assignment has to be submitted on or before Wednesday,09-03-2022, 23:59 IST.

Data Base Management System - Assignment-4 Solution Released

The  Assignment-4  of  Week-4  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. Link for assignment 4 solution:  https://drive.google.com/file/d/1lvA3Gd_uRapz4ND5bl655-97hPEStq1F/view

Data Base Management System - Week 5 Feedback Form

Data base management system - week 5 content is live now.

The lecture videos for Week 5 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=50&lesson=51

Assignment 5 for Week 5 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=50&assessment=123

The assignment has to be submitted on or before Wednesday, 02-03-2022 , 23:59 IST.

Data Base Management System - Assignment-3 Solution Released

The  Assignment-3  of  Week- 3  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. Link for assignment 3 solution:  https://drive.google.com/file/d/1NLDRiVW8doNp065xyF8YFsbCRDmoGz5F/view

Data Base Management System - Week 4 Feedback Form

Data base management system - assignment-1 & 2 solution released.

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. Link for assignment 1 solution:  https://drive.google.com/file/d/175s0rjWA5PGniDg2BuOWqUY3qBOVVaJI/view Link for assignment 2 solution:  https://drive.google.com/file/d/1MPNIu-RdvJ2U-uVfLWNbzxvg9gNbnn1F/view

Data Base Management System - Week 4 content is live now!!

The lecture videos for Week 4 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=41&lesson=42

Assignment 4 for Week 4 is also released and can be accessed from the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=41&assessment=118

The assignment has to be submitted on or before Wednesday, 23-02-2022 , 23:59 IST.

Data Base Management System - Week 3 Feedback Form

Assignments for week 1 & 2 due on feb 9 2022 .

Dear Learner, Assignments for Week 1 & 2 are open for submission .The last date for submission is Feb 9 2022 IST 23:59 . If you have not submitted the assignments ,kindly submit the same before the due date. -NPTEL Team.

Data Base Management System - Week 3 content is live now!!

The lecture videos for Week 3 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=33&lesson=34

Assignment 3 for Week 3 is also released and can be accessed from the following link:  https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=33&assessment=117

The assignment has to be submitted on or before Wednesday, 16-02-2022 , 23:59 IST.

Data Base Management System - Week 2 Feedback Form

Data base management system - week 2 content is live now.

The lecture videos for Week 2 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=25&lesson=26

Assignment 2 for Week 2 is also released and can be accessed from the following link:  https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=25&assessment=109

The assignment has to be submitted on or before Wednesday, 09-02-2022 , 23:59 IST.

Data Base Management System - Assignment-0 Solution Released

The  Assignment-0  of  Week-0  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. Link :  https://drive.google.com/file/d/1pMXdl2bxBv3D-yGGiZBYLUlRBEDnCTQ8/view

Data Base Management System - Week 1 Feedback Form

Attention: regarding the social media groups.

Dear Learners, The discussion forum, which is embedded on the course portal,  is the only authentic medium to communicate regarding this course . This Forum is monitored by the Faculty coordinator and team and on which we will respond. NPTEL is NOT responsible for any whatsapp group or any other group created in any social media platform.  Request the learners to refrain from sharing phone numbers and other details which may be misused as this is a public group and this information is available to all members in this group. This kind of activity is strictly prohibited and NPTEL will not be responsible for misuse of any such information. All the best, Happy Learning! -NPTEL Team

Data Base Management System - Week 1 content is live now!!

The lecture videos for Week 1 have been uploaded for the course Data Base Management System . The lectures can be accessed using the following link: https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=17&lesson=18

Assignment 1 for Week 1 is also released and can be accessed from the following link:  https://onlinecourses.nptel.ac.in/noc22_cs51/unit?unit=17&assessment=106

NPTEL: Exam Registration is open now for Jan 2022 courses!

Dear Learner, 

Here is the much-awaited announcement on registering for the Jan 2022 NPTEL course certification exam. 

1. The registration for the certification exam is open only to those learners who have enrolled in the course. 

2. If you want to register for the exam for this course, login here using the same email id which you had used to enroll to the course in Swayam portal. Please note that Assignments submitted through the exam registered email id ALONE will be taken into consideration towards final consolidated score & certification. 

3 . Date of exam: March 27, 2022

CLICK HERE to register for the exam.

Choose from the Cities where exam will be conducted: Exam Cities  

4. Exam fees: 

If you register for the exam and pay before Feb 14, 2022, 10:00 AM, Exam fees will be Rs. 1000/- per exam . 

If you register for exam before Feb 14, 2022, 10:00 AM and have not paid or if you register between Feb 14, 2022, 10:00 AM & Feb 18, 2022, 10:00 AM, Exam fees will be Rs. 1500/- per exam 

5. 50% fee waiver for the following categories: 

Students belonging to the SC/ST category: please select Yes for the SC/ST option and upload the correct Community certificate.

Students belonging to the PwD category with more than 40% disability: please select Yes for the option and upload the relevant Disability certificate. 

6. Last date for exam registration: Feb 18, 2022 10:00 AM (Friday). 

7. Mode of payment: Online payment - debit card/credit card/net banking. 

8. HALL TICKET: 

The hall ticket will be available for download tentatively by 2 weeks prior to the exam date . We will confirm the same through an announcement once it is published. 

9. FOR CANDIDATES WHO WOULD LIKE TO WRITE MORE THAN 1 COURSE EXAM:- you can add or delete courses and pay separately – till the date when the exam form closes. Same day of exam – you can write exams for 2 courses in the 2 sessions. Same exam center will be allocated for both the sessions. 

10. Data changes: 

Last date for data changes: Feb 18, 2022 10:00 AM :  

All the fields in the Exam form except for the following ones can be changed until the form closes. 

The following 6 fields can be changed ONLY when there are NO courses in the course cart. And you will be able to edit the following fields only if you: - 

REMOVE unpaid courses from the cart And/or - CANCEL paid courses 

1. Do you come under the SC/ST category? * 

2. SC/ST Proof 

3. Are you a person with disabilities? * 

4. Are you a person with disabilities above 40%? 

5. Disabilities Proof 

6. What is your role ? 

Note: Once you remove or cancel a course, you will be able to edit these fields immediately. 

But, for cancelled courses, refund of fees will be initiated only after 2 weeks. 

11. LAST DATE FOR CANCELLING EXAMS and getting a refund: Feb 18, 2022 10:00 AM  

12. Click here to view Timeline and Guideline : Guideline  

Domain Certification

Domain Certification helps learners to gain expertise in a specific Area/Domain. This can be helpful for learners who wish to work in a particular area as part of their job or research or for those appearing for some competitive exam or becoming job ready or specialising in an area of study.  

Every domain will comprise Core courses and Elective courses. Once a learner completes the requisite courses per the mentioned criteria, you will receive a Domain Certificate showcasing your scores and the domain of expertise. Kindly refer to the following link for the list of courses available under each domain: https://nptel.ac.in/noc/Domain/discipline.html

Outside India Candidates

Candidates who are residing outside India may also fill the exam form and pay the fees. Mode of exam and other details will be communicated to you separately.

Thanks & Regards, 

Data Base Management System - Assignment-0-RELEASED

We welcome you all to this course. The assignment 0 for the course Data Base Management System has been released. This assignment is based on a prerequisite of the course. Kindly note that marks obtained in this assignment will not be considered for the final assessment. You can find the assignment under Week 0 unit on the left-hand side of your screen You can submit the assignment multiple times before the due date. All the best !!    

Data Base Management System: Welcome to NPTEL Online Course - Jan 2022!!

• Every week, about 2.5 to 4 hours of videos containing content by the Course instructor will be released along with an assignment based on this. Please watch the lectures, follow the course regularly and submit all assessments and assignments before the due date. Your regular participation is vital for learning and doing well in the course. This will be done week on week through the duration of the course.
• Please do the assignments yourself and even if you take help, kindly try to learn from it. These assignments will help you prepare for the final exams. Plagiarism and violating the Honor Code will be taken very seriously if detected during the submission of assignments.
• The announcement group - will only have messages from course instructors and teaching assistants - regarding the lessons, assignments, exam registration, hall tickets, etc.
• The discussion forum (Ask a question tab on the portal) - is for everyone to ask questions and interact. Anyone who knows the answers can reply to anyone's post and the course instructor/TA will also respond to your queries.
• Please make maximum use of this feature as this will help you learn much better.
• If you have any questions regarding the exam, registration, hall tickets, results, queries related to the technical content in the lectures, any doubts in the assignments, etc can be posted in the forum section
• The course is free to enroll and learn from. But if you want a certificate, you have to register and write the proctored exam conducted by us in person at any of the designated exam centres.
• The exam is optional for a fee of Rs 1000/- (Rupees one thousand only).
• Date and Time of Exams: March 27, 2022 Morning session 9am to 12 noon; Afternoon Session 2 pm to 5 pm.
• Registration URL: Announcements will be made when the registration form is open for registrations.
• The online registration form has to be filled and the certification exam fee needs to be paid. More details will be made available when the exam registration form is published. If there are any changes, it will be mentioned then.
• Please check the form for more details on the cities where the exams will be held, the conditions you agree to when you fill the form etc.
• Once again, thanks for your interest in our online courses and certification. Happy learning.

A project of

In association with

Data Base Management System | NPTEL 2022 | Week 0 Assignment Solutions

This set of MCQ(multiple choice questions) focuses on the  Data Base Management System NPTEL 2022 Week 0 Assignment Solutions .

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.

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 0 Assignment Solution” contains 20 questions.

Now, start attempting the quiz.

Data Base Management System NPTEL 2022 Week 0 Assignment Solutions

Q1. If A={a, b, c}, which of the following represent all possible proper subsets of A?

a) 𝛟, {a}, {b}, {c}, {a,b}, {a,c}, {b,c} b) 𝛟, {a}, {b}, {c}, {a,b}, {a,c}, {b,c}, {a,b,c} c) {a}, {b}, {c}, {a,b}, {a,c}, {b,c} d) {a}, {b}, {c}, {a,b}, {a,c}, {b,c}, {a,b,c}

Answer: a) 𝛟, {a}, {b}, {c}, {a,b}, {a,c}, {b,c}

Q2. If X={{a, b}, {c}}, which of the following is the power set of X?

a) { 𝛟,{a},{b,c}} b) { 𝛟,{a},{b},{c}} c) { 𝛟,{a, b},{c},{{a, b},{c}}} d) { 𝛟,{a},{b},{c},{a,b},{b,c},{a,c}}

Answer: c) { 𝛟,{a, b},{c},{{a, b},{c}}}

Q3. Let A={4,5,6} and B={6,7,8}. Which of the following pairs is not included in A x B, where x defines cartesian product?

a) (6,6) b) (5,7) c) (6,8) d) (5,5)

Answer: d) (5,5)

Q4. Let a given function be f: R -> R given by f(x) = [x] where [x] is the greatest integer less than or equal to x. Which of the following statements is/are true?

a) It is a one-one function but not onto. b) It is an onto function but not one-one. c) It is both one-one and onto. d) It is neither one-one nor onto.

Answer: d) It is neither one-one nor onto.

Q5. S=[-2, -1, 0, 1, 2] and f: S -> Z given by f(x) = x 2 – 2x – 3. What is/are the pre-image(s) of -3?

a) -2 b) {0, 2} c) 1 d) {1, -2}

Answer: b) {0, 2}

Data Base Management System NPTEL Assignment Solutions

Q6. Let the cartesian product of two set X and Y be {(a,2), (a,-6), (a,5), (b,2), (b,-6), (b,5), (s,2), (s,-6), (s,5)}. Considering distinct elements in each set and n(X) = n(Y) = 3, find the two sets X and Y.

a) X = {a, b, s}, Y = {2, -2, 5} b) X = {a, b, s}, Y = {2, -6, 5} c) X = {a, b, 2}, Y = {2, -2, 5} d) X = {a, -2, s}, Y = {2, -2, 5}

Answer: b) X = {a, b, s}, Y = {2, -6, 5}

Q7. Consider the predicates R(x): x is red. G(x): x is green. Which of the following quantified statements represent “Either everything is red or everything is green”?

a) ∀(x)(R(x) v G(x)) b) ∀(x)(R(x) v ∀(x)G(x)) c) ∀(x)(R(x)) v ∀(x)(G(x)) d) ∀(x)( ¬ R(x) → G(x))

Answer: b), c)

Q8. Look at the following truth table

Which binary operation has been carried out?

a) ¬ P v Q b) ¬ (P v Q) c) ¬ (P Λ Q) d) ¬ P Λ Q

Answer: b) ¬ (P v Q)

Q9. Consider the relation: S={(a,b), (b,c), (a,a), (b,b), (c,c), (b,a), (c,b), (a,c), (c,a)}. Which of the following is TRUE?

a) S is reflexive only b) S is transitive only c) S is symmetric only d) S is an equivalence relation

Answer: d) S is an equivalence relation

Q10. Consider the following: a: Pandemic causes global crisis. b: Cyclone causes global crisis. c: Rescue teams are sent. Consider the statement: “If pandemic causes global crisis or cyclone causes global crisis, then rescue teams are sent.” Which of the following is equivalent to the inverse of the statement?

a) ¬ a Λ ¬ b → ¬ c b) ¬ c → ¬ a v ¬ b c) b v c → ¬ a d) ¬ a → b v c

Answer: a) ¬a Λ ¬b → ¬c

Q11. Why is not binary search suitable for a sorted linked list of numbers?

a) Worst case time complexity of binary search on a linked list is O(n). b) Both halves of the list (to the left and the right of the middle element) may have to be explored to search for an element. c) The middle element in a sorted linked list cannot be found out in O(1) time. d) Size of a node in a linked list is more.

Answer: a), c)

Q12. Consider a max-heap of some numbers. Which of the following is not true about a max-heap of numbers?

a) The second largest element is the number stored at the left or right child of the root node of the max-heap. b) The smallest element is found only at the leaf nodes of the max-heap. c) The number of swap operations to initialize a max-heap is O(nlogn). d) The number of swap operations to find out the least number in a max-heap is O(logn).

Answer: d) The number of swap operations to find out the least number in a max-heap is O(logn).

Q13. A single array A[n] (index range is from 0 to n-1) is used to implement two stacks. The two stacks grow from opposite ends of the array. Variables top1 and top2 (top1 < top2) point to the topmost element in each stack. The space is to be used efficiently. Which of the following statements is wrong?

a) top1 is initialized to -1 and top2 in initialized to n. b) Stack full condition for any stack is top1 = top2 – 1. c) In each push operation in the second stack, top2 is decremented by 1. d) Size of each stack must not be more than n/2.

Answer: d) Size of each stack must not be more than n/2.

Q14. Numbers 1, 2, 3 are pushed into a stack in that order but these three PUSH operations are intermixed with POP operations as well. Whenever a number is popped, it is printed. Which of the following permutation cannot be printed by such PUSH and POP operations?

a) 1, 2, 3 b) 3, 1, 2 c) 2, 1, 3 d) 1, 3, 2

Answer: b) 3, 1, 2

Q15. Consider the set X={1, 2, 3, 4, 5} and R be a set such that R={(a,b): a 2 +b 2 <= 13}. What is n(R)?

a) 5 b) 8 c) 4 d) 10

Answer: b) 8

Q16. Let P={2, 3, 5}, Q={3, 4, 7, 8}, R={2, 1}. Find (P – Q) x (P ∩ R).

a) {(2, 2), (3, 2), (5, 2)} b) {(4, 2), (7, 2), (8, 2)} c) {(2, 2), (5, 2)} d) {(2, 2), (3, 5), (5, 2), (4, 2), (7, 2), (8, 2)}

Answer: c) {(2, 2), (5, 2)}

Q17. Let U be the universal set. n(U) = 500. If A, B are subsets of U such that n(A) = 100, n(B) = 200 and n(A ∩ B) = 75, what is the value of n( ¬ A ∩ ¬ B)?

a) 100 b) 225 c) 275 d) 0

Answer: c) 275

Q18. Let a relation R in the set R of real numbers be defined as (p,q) ∈ R if and if only if 1+pq > 0 for all p, q ∈ R. Which of the following is TRUE about the relation R?

a) reflexive only b) reflexive and symmetric c) transitive d) Equivalence relation

Answer: b) reflexive and symmetric

Q19. Consider two sets X and Y. Which of the following statement is false?

a) X – Y = X ∩ ¬ Y b) X – Y = X – (X ∩ Y) c) X – Y = X – ¬ Y d) X – Y = (X U Y) – Y

Answer: c) X – Y = X – ¬Y

Q20. Let P = {1, 2, 3} and Q = {2, 3, 4}. How many relations are possible from P to Q?

a) 8 b) 64 c) 256 d) 512

Answer: d) 512

>> Next- Data Base Management System Week 1 Assignment Solutions

NPTEL answers: Problem solving through programming in C

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

NPTEL Previous Year Question Papers, Download PDF Here

Nptel previous year question papers | previous year nptel question papers | download previous year question papers with answers pdf.

NPTEL Previous Year Question Papers: National Programme on Technology Enhanced Learning ( NPTEL ) is a portal for learning courses on various subjects in partnership with IITs and IISc. Government of India is also contributing its funds for NPTEL by Ministry of Education. They are continuously conducting certification exam for all of their courses. Courses learning of NPTEL platform is completely free. But if you need certification you have to pay the certification examination fee and take exams to get certified.

Generally, NPTEL certification exam cost is Rs 1000 for per course examination. Candidates who are applied for the course certification exam have to take test on the allotted centers. Preparing using Previous Year Question Papers gives you more advantages during the exam. Applicants who are searching for National Programme on Technology Enhanced Learning Previous Year Question Papers with Answers PDF can find download here . Continue reading to learn more about the previous year question papers and certification test.

Previous Year NPTEL Question Papers

NPTEL is offering six hundred plus online courses on various departments and subjects. Online courses duration is about 4 weeks, 8 weeks or 12 weeks on the end of course completion a student can takes exam. Taking certification examination is optional . Students whoever wants certificate can a apply and attend exam. Else, students who does not want certificate does not require to take exam. Examination consists of MCQ and Written Part.

Aerospace Engineering, Biotechnology, Chemical Engineering, Chemistry & Biochemistry, Civil Engineering, Computer Science & Engineering, Engineering Design, Electrical Engineering, Humanities & Social Sciences, Management, Mathematics, Mechanical Engineering, Metallurgy & Material Science, Ocean Engineering, Physics, Textile Engineering, Electronics & Communication Engineering, Nanotechnology, Atmospheric Science, Environmental Science, General, Mining Engineering and courses.

Download NPTEL Question Papers with Answers PDF

Keep visiting at www.dailyrecruitment.in to know recent recruitment updates, required syllabus, important question papers, admit card, results updates and more.

Share this:

• Click to share on WhatsApp (Opens in new window)
• Click to share on Facebook (Opens in new window)
• Click to share on Telegram (Opens in new window)

Govt Jobs by Qualifications

Find More Govt Jobs in

Nptel Database Management System Assignment 2 Answers

Are you looking for the Nptel Database Management System Assignment 2 Answers 2024 (July-Dec)? You’ve come to the right place! Our detailed and accurate solutions are designed to assist you in mastering the concepts of DBMS, including SQL queries, database design, normalization, and more.

Course Link: Click Here

Session: JUL-DEC 2024

Q1. In a particular messenger application, the instance of Chat Details is as follows:

For the instance, the Total_Text values need to be updated to increase by 500 for those entries whose current values are less than 1000. What is the correct SQL Query for updating the current instance? a) MODIFY ChatDetails Total_Text=Total_Text+500 where Total_Text<1000; b) UPDATE ChatDetails set Total_Text=Total_Text+500 where Total_Text<1000; c) UPDATE ChatDetails Total_Text=Total_Text+500 where Total_Text<1000; d) ALTER ChatDetails set Total_Text=Total_Text+500 where Total_Text<1000;

Answer: b) UPDATE ChatDetails set Total_Text=Total_Text+500 where Total_Text<1000;

Q2. In a particular messenger application, the instances of ChatDetails and UserDetails are as follows:

What is the output of the following SQL Query? SELECT COUNT(Address) FROM ChatDetails, UserDetails GROUP BY Address; a) 4 3 b) 4 8 c) 4 d) 3

Answer: b) 4 8

For answers or latest updates join our telegram channel: Click here to join

These are Nptel Database Management System Assignment 2 Answers

Q3. In a particular messenger application, the instance of UserDetails is as follows:

Which of the options will not be present in the output generated by the SQL query: SELECT Address FROM UserDetails WHERE Address LIKE ‘%’ OR Address LIKE ‘M%’; a) Agartala b) Kolkata c) Mumbai d) Delhi

Answer: a) ALTER command is used to add remove\modify rows to a relation. c) DROP command is used to delete all data from a relation.

Q4. Which of the following statements is incorrect?

a) ALTER command is used to add remove\modify rows to a relation. b) ALTER command is used to add remove\modify attributes to a relation. c) DROP command is used to delete all data from a relation. d) DROP command is used to delete a relation.

Answer: a) ALTER command is used to add remove\modify rows to a relation.

Q5. Let students (student_id, student name, address, emailid) and enrolment (student_id, dept name, enrolment_date) be two relations in a schema. The primary keys are shown underlined. Let student_id be a foreign key in enrolment relation referring to students relation. Suppose, there is no violation of the above referential integrity constraint in the corresponding relation instances of students and enrolment. Which one of the following relational algebra expressions would necessarily produce an empty relation? a) Istudent_id (enrolment) Istudent_id (students) b) Istudent_id (students) Istudent_id (enrolment) c) Istudent_id(enrolment <> students) d) Istudent_id (enrolment students)

Answer: a) Istudent_id (enrolment) Istudent_id (students)

Q6. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation. What will be the output of the following query? SELECT MountainName, Altitude FROM MountainDetails md1 WHERE Altitude = ( SELECT MAX(Altitude) FROM MountainDetails md2 WHERE md1.StateName = md2. StateName);

Q7. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation.

What will be the output of the following query? SELECT MountainName, Altitude FROM MountainDetails WHERE Altitude > ( SELECT Altitude FROM MountainDetails WHERE StateName = “Uttarakhand”);

Q8. Consider the following instance UserDetails of a messenger application

a) SELECT * FROM UserDetails WHERE Address AS (‘Delhi’, ‘Mumbai’); b) SELECT * FROM UserDetails WHERE Address IN (‘Delhi’, ‘Mumbai’); c) SELECT * FROM UserDetails WHERE Address FOR (‘Delhi’, ‘Mumbai’); d) SELECT * FROM UserDetails WHERE Address TO (‘Delhi’, ‘Mumbai’);

Answer: b) SELECT * FROM UserDetails WHERE Address IN (‘Delhi’, ‘Mumbai’);

Q9. Consider the following instance UserDetails of a messenger application:

Identify the correct statement to create an index on SenderID and Address of UserDetails relation named as ‘View_UserDetails’ a) Create View_UserDetails AS UserDetails (Sender ID, Address); b) Create index View_UserDetails AS UserDetails (Sender ID, Address); c) Create index View_UserDetails ON UserDetails (Sender ID, Address); d) Create index View_UserDetails TO UserDetails (SenderID, Address);

Answer: c) Create index View_UserDetails ON UserDetails (Sender ID, Address);

Q10. Consider the following instance UserDetails of a messenger application:

Identify the correct statement to find the SenderID, Receiver ID, and Address of UserDetails table whose Total_Text is in between 700 and 1200. a) SELECT SenderID, ReceiverID, Address FROM UserDetails WHERE Total_Text AS (700, 1200); b) SELECT SenderID, ReceiverID, Address FROM UserDetails WHERE Total_Text IN (700, 1200); c) SELECT SenderID, ReceiverID, Address FROM UserDetails WHERE Total_Text BETWEEN (700, 1200); d) SELECT SenderID, ReceiverID, Address FROM UserDetails WHERE Total_Text BETWEEN 700 AND 1200;

Answer: d) SELECT SenderID, ReceiverID, Address FROM UserDetails WHERE Total_Text BETWEEN 700 AND 1200;

All Weeks of Database Management System: Click here

For answers to additional Nptel courses, please refer to this link:  Check here