nptel database management system assignment 6 answers

• Announcements
• Explore Courses

Feedback for Database Management System

Best of luck for your exam.

Video recording on Interactive session

Dear All, There was an interaction session with some of the students for the course"Database Management System" The video recording is now available in the portal under the last unit"Interactive session" Those who are interested can take a look. -NPTEL Team

DBMS: Reevaluation in Assignment-8

Dear Students, We have re-evaluated the assignment-8 after changing the answers in Qs-7. Please check your updated new scores.

DBMS: Reevaluated Assignment-8

Dear Students, We have re-evaluated the assignment-8 after changing the answers in Qs-7 and 8 Please check your corrected new scores.

Database Management System : Hall ticket for April 28/29 NPTEL Online Certification exams is now available for download

Dear Candidate: If you have registered and paid successfully for the  April28/29  NPTEL Online certification exams, your Admit Card/Hall ticket is now available at   http://nptelonlinecourses.i itm.ac.in/ Login with your registered Google-enabled account email id (used to access the course on the portal and used for registering for the exam) and its password to access the link. Click on April exam to download the hall ticket(s) for the  April28/29   exams, from the link. 2. You can also download it from the alternate link given below: https://cdn3.digialm.com//EFor ms/configuredHtml/885/54105/lo gin.html     Please try to access both the links to download your hall ticket: if you are not able to find your hall ticket in both the links, kindly write to us at  [email protected]   Note that you will be able to login here, only if you have a valid registration for exams on April 28/29, 2018.   Please download hall ticket, take a print out and along with a original ID card, carry it with you to the exam venue (The exam centre address is displayed in the hall ticket). Read all instructions given in the admit card/ hall ticket carefully and follow them. Download hall tickets for all the exams you have registered for - in case you don't get the hall tickets for any particular course, please write to   [email protected]  . IMPORTANT: 1. Change of shift, course, exam center, exam city is NOT POSSIBLE. 2. You WILL NOT BE ALLOWED to write the exam if you are showing up at the exam center which is not allocated to you by mistake or by intention. 3. Candidates will not be allowed to write the exam without Hall ticket and proper id proof. Proof on the mobile phones or soft copy of hall ticket is NOT PERMITTED. NPTEL Team wishes you the very best for the certification exam.

DBMS: Assignment-8 Soon will be re-evaluated

Dear students, Assignment-8 will be re-evaluated, with corrected answer in QS-7 and 8. So please have patience.

DBMS: Assignment-8 Solution

Dear students, Assignment solution is available in the section " First Run Assignment Solutions "

DBMS: Assignment-7 Solution available

Dear Students, Assignment-7 is released.

DBMS: Assignment-6 Reevaluated

Dear students, We have removed the ambiguous Qs-3 from assignment-6 and re-evaluated. Kindly check your updated score.

DBMS: Assignment-8

Dear Students, Assignment-8 is released. the due date is 10/04/18 (Mid night 11:59PM). For this assignment no request of extension in due date will be considered.  Yes, Kindly remember, A MSQ can have single correct answer or multiple correct answers.

DBMS: Tutorial-2 RC System

Dear Students, The tutorial-2:  Retail Chain Management System (RCMS)   is released and practice.

DBMS: Live session-28th March PPT

Dear Students, The PPT of 28th March, Live session is available in the section " Interactive Session with Students ".

DBMS: Assignment-6 Solution

Dear students, The solution of assignment-6 is available in the section "First Run Assignment solution"

DBMS: Assignment-8 & live session-28th

Dear Students, For your kind information, The assignment-8 will be released by 29th March. Please post your queries and doubts for the live session on 28th March. The google form is given below: GOOGLE FORM:   https://goo.gl/forms/n17cfuVTPMgRleKO2 Yes in this session , we will be discussing HMS (The doc is already provided to you, It is available under the section "Interactive session..."). You may ask your doubts on that also.

Database Management System : Week 8 Videos are available !!

Dear Students,

                             Week 8 Videos are available in the COURSE OUTLINE section under Week 8!!

DBMS: Assignment-7 Released

Dear Students, Assignment-7 is released, The due date is 02/04/2018 (Midnight 11:59PM)

DBMS: Tutorial-1 HMS Released

Dear Students, Kindly go through the "Hospital Management System(HMS)" for tutorial discussion on 28th March. It is available in the section " Interactive Session with Students "  or you may get it on the link: https://drive.google.com/file/d/1Li4bxlOoTwAUFtjrgLBgX7MVNUhU8cJL/view Post your Queries after going through the Docs. Your queries will be discussed on that day. Yes the queries you asked already for tutorial also will be responded. Those who want to ask the QSs for Tutorial, please follow the link below. GOOGLE FORM:   https://goo.gl/forms/n17cfuVTPMgRleKO2 Kindly ask very specific QSs or problem statements. Tutorial Date & TIME:   March 28th, 2.00-3.00pm

DBMS: Assignment-6 Due date Extended

Dear Students, The due date of assignment-6 is extended till 27/03/18, Midnight 11:59PM.

DBMS: Assignment-5 Solution

Dear Students, Assignment-5 solution and explanation is available in the section " First Run Assignment Solutions "

DBMS: Assignment-7

Dear Students, For your kind information, The assignment-7 will be published by Wednesday. Kindly finish up your assignment-5 by tomorrow (20th March), no more extension will be given to you.

Database Management System : Week 7 Videos are available !!

                             Week 7 Videos are available in the COURSE OUTLINE section under Week 7!!

DBMS: Assignment-5 Due date extended

Dear Students, Assignment-5 due date is extended till 20th March (11:59PM Midnight)

Upcoming LIVE streaming of NPTEL Online Certification Course Session: Database Management System

Dear Learners, Kindly note that we are LIVE streaming one session of the course. Details are shown below.  Please click on the following link and clarify your doubts. ****************************** ******** TIME:   March 28th, 2.00-3.00pm LINK:   https://www.youtube.com/watch?v=wDQt66pIIDA GOOGLE FORM:   https://goo.gl/forms/n17cfuVTPMgRleKO2 ****************************** ****************************** ********* Request you to share this news with students and faculty. Suggestion - Students/faculty can perhaps assemble in one room/lab, watch the session together and post their doubts. Click on the above link to fill the Google form and share questions you may want to ask the  Professor.  We would also like to hear from you after the session. Request you to share your thoughts. -NPTEL

DBMS: Assignment-4 Score Updated

Dear Students, As per the forum feed back, we have removed three ambiguous QSs (6, 10 and 18) from the assignment and re-evaluated the score so that you will not be loosing any mark. Kindly check your updated scores. Yes, There is no issue in Qs-7. It's explanation is given below: It is getting converted to BCNF is fine, but the type of redundancies handled is partial dependency.       It may happen that obviously the schema may in turn also be in 3 NF, or BCNF      but the conversion type is different.      The functional dependencies of the parent table violated 2 NF       Partial dependency: 2 NF       transitive dependency: 3 NF       superkey and non prime attribute: BCNF You need to understand the violation is happening for which normal form. It is not other than 2NF. So the most correct answer is 2NF

DBMS: Week-6 Assignment Released

Dear Students, Assignment-6 is released. The Due date is 24/03/18 (11:59 Midnight). It is available in the section "Week-6"

Last date for Exam registration extended till March 15, 2018 - 1 pm (Thursday) - Hurry up and register today!!

Dear Candidate, Due to a  technical  issue, there was some problem with the exam form since yesterday. Now the issue has been fixed. The last date for exam registration has been extended  till   March 15, 2018 - 1 pm (Thursday) Last date for making the payment individually -  March 16, 2018 - 1:00 PM  ( Friday ) If you have not yet registered for the exam,  login  to the form and apply for the exam today! If you have filled the form but not done the payment, Please complete the payment before  March 16 1:00 pm . Register for the exam today  at:   http:// nptelonlinecourses.iitm.ac.in/ For other details about exam registration, please check our previous announcement. NOTE :   NO EXTENSIONS BEYOND THESE DATES WILL BE GIVEN. -NPTEL Team

Last date for Exam registration extended

Dear Students There seems to be some technical issue with exam registration form, we are looking into that. We will be extending the date for registration and the extension date will be announced shortly.  Thank you

DBMS: Assignment-6

Dear Students, FYI, Assignment-6 will be released by Wednesday(14th April).

DBMS: Assignment-4 solution

Dear Students, Week-4 Assignment solution is released. It is available in in the section:  First Run Assignment Solutions.

Database Management System : Week 6 Videos are available !!

                             Week 6 Videos are available in the COURSE OUTLINE section under Week 6!!

Database Management System :Video recording on Interactive session

Dear All, There was an interaction session with some of the students for the course "Database Management System" The video recording is now available in the portal under the last unit "Interactive session with students" Those who are interested can take a look. https://youtu.be/dPpsz2tZCJM -NPTEL Team

DBMS: Assignment-5 is available

Dear Students, Week-5 Assignment is available under the section "week-5". The due date is 17/03/18 (Mid night 11:59PM).

8th March Live session Video & PPT is available

Dear students, 8th March Live session video is available. Kindly Follow the link : www.youtube.com/watch?v=BZgDsGj1CGA The PPT is also available under the section "Week 4" in the name of  " Live Session 8th March PPT "

Database Management System: Exam and Certificate Format

Dear student The certification exam will be conducted at designated centres in the city chosen by you. You have to register for the exam by filling up the form, paying the exam fee, appear in person and score >= 40% to get the certificate. Register for the exam today at:  http://nptelonlinecourses.iitm.ac.in/ Exam registration form closes on  March 14, 2018 - 5 pm (Wednesday). For other details about exam registration, please check our previous announcement. Type of exam: Computer based exam  You will have to appear at the allotted exam centre 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 allotted exam center details in the hall ticket. 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 The hall ticket will be available for download tentatively around  10 - 16th April 2018 . We will notify the same through email.   FINAL CERTIFICATE: The final score = 25% assignment score + 75% final certification exam score. The final score will determine if you will/will not receive a certificate. 1. Final score < 40%:  NO certificate 2. Final score between 40% -59%: Certificate of type  "Successfully completing the course" 3. Final score between 60% -89%: Certificate with tag  "Elite"  printed at the top 4. Final score of 90% and above: Certificate with  "Elite" tag and the gold medal  printed on it. Please click the link here for certificate format:  https://goo.gl/Wfz9n2 -NPTEL Admin

DBMS: Assignment-5

Dear Students, The assignment-5 will be released very soon.

DBMS: Assignment-4

Dear Students, There are two typo in the Assignment-4. Qs-13, It will be a MCQ question not MSQ. Qs-25:  Consider the set of functional dependencies {A → BC; CD → E; B → D; E → Ag } Here the last FD would be  E → A. The extra 'g' is an typo.

NPTEL: LIVE streaming of Online Certification Course on Database Management System

Dear Learners, Kindly note that we are LIVE streaming one session of the course. Details are shown below.  Please click on the following link and clarify your doubts. ****************************** ****************************** ********** COURSE:  Database Management System    TIME:   8th March 2018, 3.00PM to 4.00PM    LINK:  https://www.youtube.com/ watch?v=BZgDsGj1CGA PROFESSOR:  Prof. Partha Pratim Das   GOOGLE FORM:  https://goo.gl/forms/Lcc 593Dsfq1EJ7Us1 ****************************** ****************************** ********* Request you to share this news with students and faculty. Suggestion - Students/faculty can perhaps assemble in one room/lab, watch the session together and post their doubts. Click on the above link to fill the Google form and share questions you may want to ask the  Professor.  We would also like to hear from you after the session. Request you to share your thoughts. NPTEL TEAM IIT MADRAS

Last date for Exam registration extended - Hurry up and register today!!

Dear Candidates Last date for exam registration has been extended till  March 14, 2018 - 5 pm  ( Wednesday ) Last date for making the payment individually -  March 15, 2018 - 5 PM  ( Thursday ) The certification exam will be conducted at designated centers in the city chosen by you. You have to register for the exam by filling up the form, paying the exam fee and appear in person to get the certificate. Hard and soft copy of Certificate will be awarded only to those candidates who register for the exam, attend the certificate examination and whose Final score > 40% Register for the exam today at:  http://nptelonlinecourses. iitm.ac.in/ For other details about exam registration, please check our previous announcement. -NPTEL Team

DBMS: Assignment-3 Solution

Dear Students, DBMS Week-3 Assignment solution is released. It is available in the section " First Run Assignment Solutions "

Dear students, The assignment-5 will be released by Tuesday(6/03/18) evening. 

Database Management System : Week 5 Videos are available !!

                             Week 5 Videos are available in the COURSE OUTLINE section under Week 5!!

DBMS: Assignment Scoring scheme

Dear students, Most of you are confused the way assignment score is calculated. So we are clarifying this. 1. The assignment score you are getting in %age not in form of mark.      Example: Suppose there are 10 QSs (let's say each of two mark: 10X2=20marks in total) and you corrected 8 out of 10, your score will be 80% (= [16/20] * 100). 2. Now next question come up in your mind: some of you are getting score like 75% or 73%, then how does it happen.      It happens due to partial marking in multiple select QSs(MSQ), where there can be multiple correct answers.      Example-1: Let's say out of 10 QSs, there is only one MSQ type question (where two correct answers are allowed). Now let's take same example as above.                         you corrected 7QSs fully and you chose only one correct answer out of two in the 8th QS which is MSQ type. The total mark you scored = 7X2+1x1 = 15                         So in %age of your score = [15/20]*100 = 75%      Example-2: Let's say out of 10 QSs, there is only one MSQ type question (where three correct answers are allowed). Now let's take same example as above.                         you corrected 7QSs fully and you chose only one correct answer out of three in the 8th QS which is a MSQ type. The total mark you scored = 7X2+1x0.6 = 14.6                         So in %age of your score = [14.6/20]*100 = 73% Note: in MSQ type, if you select any wrong answer along with the correct answer then you will be getting zero for that QS. i.e no partial marking is done on the selection of any wrong answer.

DBMS: Week-4 Assignment

                             Week 4 Assignment is available in the COURSE OUTLINE section under Week 4. Due date is 11/03/2018 , 11:59PM (i.e mid night)

Dear Students, Assignment-4 will be released by tomorrow. Since week-4 having more concepts and content, you will be getting around 25 QSs and will be given more time(around 14 days) to solve it.

Database Management System : Week 4 Videos are available !!

                             Week 4 Videos are available in the COURSE OUTLINE section under Week 4!!

DBMS: Assignment-1&2 Solution

Dear students, Assignment solution of week-1 & 2 is available in the section named " First Run Assignment Solutions "

Reminder2:REGISTER TODAY - CERTIFICATION EXAM FORM IS NOW OPEN!

Dear student:, dbms: important announcement.

Dear Students, In week-2 Assignment, Qs-9 The SQL Statement should be " grant Employee to Manager; " in place of " grant Manager to Employee; " Now choose/correct your answer accordingly. Reagrds TAs of DBMS

DBMS: Week-3 Assignment Released

Dear Students, Week-3 assignment is available under the section week-3. The due date is 28/02/2012 mid night 11:59PM

DBMS: Week-3 Assignment

Dear students, We will be releasing the week-3 assignment by today midnight or tomorrow morning. Sorry for inconvenience. 

Database Management System : Week 3 Videos are available !!

                             Week 3 Videos are available in the COURSE OUTLINE section under Week 3!!

DBMS: Don't spam the Forum

Dear students We are really sorry about this, but we have to make clear that this is  strictly a discussion forum  only  for  DBMS  course related tasks. You can ask questions, get clarifications, participate in discussion forum and help others who really need help to digest the concepts which are discussed in the course material. Please don't spam the forum with the LinkedIn, Wahtsapp or any other kind of requests. We hope that all of you abide by the purpose of discussion forum !!! Regards TAs, DBMS Course

DBMS: Week-2 Assignment

                             Week 2 Assignment is available in the COURSE OUTLINE section under Week 2. Due date is 21/02/2018 , 11:59PM (i.e mid night)

Database Management System : Week 2 Videos are available !!

                             Week 2 Videos are available in the COURSE OUTLINE section under Week 2!!

DBMS: Video Download Link

Dear Students,             You can download the DBMS Video lectures by using the following link:              http://nptel.ac.in/courses/106105175/  

DBMS: Solution of Prerequisite Assignment-0

Dear Students, Solution of Assignment-0 is released. It is available in the course outline under the section " First Run Assignment Solutions ".

DBMS: Week-1 Assignment Released

Dear Students,                               DBMS Week-1 Assignment is released. It is available in the course outline section under Week 1. The due date is 21/02/2018, midnight 11:59PM(IST). The same will be reflected at the beginning  of the Assignment. Kindly watch the video properly to answer the assignment QSs.  TAs who will be addressing your QSs in the forum are given below Mrs Srijoni Majumdar Mr. Himadri Bhuyan Mr. Gurunath Reddy.

Database Management System : Week 1 Videos are available !!

Dear Students,                               Week 1 Videos are available now in the course outline section under Week 1. 

DBMS: Assignment-0 Released

Dear students, Assignment-0 is released for your practice. It doesn't carry any weightage. It is available under the "course outline"-->  "How to Access the portal" All the QSs in the assignment are from the prerequisite of this course. Kindly visit to  https://nptel.ac.in/course. php Select discipline (in LHS of the page look at " List by discipline ") " Computer Science and Engineering ". Now chose your required subject you would like to study for prerequisite.

DBMS: Prerequisite for the course

Dear students, The following are the prerequisites and study link to strength your knowledge. Set Theory, Relation function, Propositional Logic, Predicate Logic: https://nptel.ac.in/noc/individual_course.php?id=noc16-ma01  Design and Analysis of Algorithms: https://nptel.ac.in/noc/individual_course.php?id=noc17-cs27 Fundamental Algorithms – Design and Analysis: https://nptel.ac.in/noc/individual_course.php?id=noc16-cs24  Introduction to Programming in C: https://nptel.ac.in/noc/individual_course.php?id=noc17-cs43  Object-Oriented Analysis and Design: https://nptel.ac.in/noc/individual_course.php?id=noc17-cs25  Programming in C++: https://nptel.ac.in/noc/individual_course.php?id=noc17-cs24 

Reminder 1:REGISTER TODAY - CERTIFICATION EXAM FORM IS NOW OPEN!

Dear Student: Here is the much-awaited announcement on registering for the  April 2018 certification exam .  The registration for the certification exam is open only to students who have enrolled in the course. Registration is open from  09th January 2018 (Tuesday) until March 07, 2018 10:00 AM (Wednesday) .  The certification exam registration URL is:  http://nptelonlinecourses.iitm.ac.in/ (If you want to register for the exam for this course, login here using the same email id used to enroll to the course) Dates of exam:  April 28 and April 29, 2018  Session:  [ Forenoon ]   For this course there is no ” Afternoon ” Session. You can register for a maximum of 4 course exams (same day of exam – 2 sessions. Same center will be allocated for both the sessions). Exam Session time:   Forenoon: 9.00 AM -12.00 PM ; Afternoon: 2.00 PM - 5.00 PM Examination Cities:  The exam is to be conducted in several cities across India whose list is available on the registration form.  Click here to access the list of exam cities:   http://nptel.ac.in/pdf/examcities_final.pdf Registration fees:  Rs 1100/ - (Students belonging to the SC/ST category can avail a 50% fee waiver - please select Yes for the SC/ST option and upload the correct Community certificate) Students belonging to the PwD category can avail a 50% fee waiver - please select Yes for the option and upload the relevant Disability certificate. Mode of payment:  Online payment - debit card/credit card/net banking or via SPOC of college HALL TICKET: The hall ticket will be available for download tentatively between  10 - 16th April 2018 . We will confirm the same through an announcement once it is published. Final score on certificate:   25% of assignment score + 75% of certification exam score. Award of certificate:  Hard and soft copy of Certificate will be awarded only to those candidates who register for the exam, attend the certificate examination and whose Final score  >= 40% The final score, assignment score and exam score will be printed on the certificate. The certificate will also have a link to the NPTEL website ( http://nptel.ac.in/noc ), where on logging in, your scores and e-certificate will be available for verification  (Appropriate announcements will be made). Please do regularly submit assignments to get a good final score. IMPORTANT NOTES 1) 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. No changes will be entertained after that.   2) FOR CANDIDATES WHO ARE PAYING VIA THE LOCAL CHAPTER OF YOUR COLLEG E:-  1. In the exam form, you will fill all the details and also upload photo, signature. 2. Ensure that you had selected your college name correctly from the drop-down list in the form. 3. Payment of exam fees - click on the tab - 'PAY VIA SPOC'. The SPOC has to now confirm to NPTEL that he/she will pay fees on your behalf. If the SPOC says NO, you will be intimated via email. Then it becomes your responsibility to come back to the exam form and make the payment. If you do not pay the exam fees within the prescribed time, you will not be able to write the exam. Please read the instructions carefully before submitting the form. In case of any queries please write to us at [email protected] Thanks & Regards, NPTEL TEAM

Welcome to NPTEL Online Course: Database Management System

A project of.

In association with

NPTEL Introduction to Database Systems Week 6 Assignment Answers 2024

1. Which of the following SQL clauses can have a subquery?

(i) FROM (ii) GROUP BY (iii) HAVING

• Only (i) and (ii)
• Only (i) and (iii)
• All (i), (ii) and (iii)

2. Views can never be used in an update query

3. Views are materialized into tables if the view definition has only one table

4. Views can be used in the definition of other views

5. Aggregate operators can be used to define views

Consider the relation stud (C1, C2, C3, C4, C5, C6). A SQL query Q created using stud has the columns C1, C2, and C3 in the group by clause. Assuming Q is a syntactically correct query,state whether the following statements are true or false.

6. The column C4 can be used in the HAVING clause without aggregate operator

7. The column C4 can be used in the WHERE clause without aggregate operator

8. The column C3 can be used in the SELECT clause without aggregate operator

9. The column C3 can be used in the SELECT clause with aggregate operator

10. Consider the following schema of the relation stud:

stud(​ K ​ , C1)

Which of the following queries would find the number of NULLs in the column C1 of the stud relation.

• SELECT COUNT(C1) FROM stud WHERE C1 IS NOT NULL
• SELECT COUNT(*) – COUNT(C1) FROM stud WHERE C1 IS NOT NULL
• SELECT COUNT() FROM stud WHERE C1 = NULL
• SELECT COUNT(*) – COUNT(C1) FROM stud

11. Consider two instances of the relations R1 and R2 with the number of rows 10 and 8, respectively. The minimum number of tuples in the result of the following query is

SELECT * FROM R1 FULL OUTER JOIN R2

12. DLETE keyword can be used to do which of the following operations?

(i) delete all rows (ii) delete specific rows (iii) delete table definition

14. Consider the following query

Suppose total-credits of a department is the sum of the credits of the courses offered by the department. Which of the following statements is correct about the above query?

• It finds the department(s) with the highest number of total-credits across all the departments.
• It finds the department(s) with total-credits greater than or equal to the sum of the total-credits of all the departments.
• It finds the department(s) with total-credits greater than or equal to the credits of the course with the highest number of credits across the institute.
• It lists all the departments in the institute.

15. Which one of the following queries would find the senior-most professor(s) of each department?

16. Consider the following sets about different approaches to programmatic access of databases and the properties that may apply to these approaches.

{1: Embedded SQL approach; 2: API based approach; 3: Database language approach} {p: Syntax-check during compilation q: driver; r: cursors; s: No impedance mismatch; t: Multiple active connections }

Identify the correct matching between the sets:

• 1–p; 2–t; 3–q
• 1–t; 2–q; 3–s
• 1–s; 2–q; 3–t
• 1–p; 2–t; 3–s

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

kadeep47 / NPTEL-Getting-Started-With-Competitive-Programming

[Aug - Oct 2023] Solutions for NPTEL Course Getting started with competitive programming weekly assignment.

• Updated Sep 6, 2023

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

Md-Awaf / NPTEL-Course-Getting-started-with-Competitive-Programming

Solutions for NPTEL Course Getting started with competitive programming weekly assignment.

• Updated Apr 20, 2023

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

rvutd / NPTEL-Joy-of-Computing-2020

Programming Assignment Solutions

• Updated May 5, 2020

gunjanmimo / NPTEL-The-Joy-of-Computing-using-Python

• Updated Jan 26, 2020

AdishiSood / The-Joy-of-Computing-using-Python

• Updated Apr 28, 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

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

gxuxhxm / NPTEL-The-Joy-of-Computing-using-Python

NPTEL-The-Joy-of-Computing-using-Python with NOTES and Weekly quizes Answers

• Updated Dec 31, 2023

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

NPTEL Introduction to Programming in C Assignment 4 Question 1

• Updated Apr 2, 2024

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-Programming-Assignment-Road-Trips-and-Museums

NPTEL Programming Assignment: Road Trips and Museums.

• Updated Mar 3, 2024

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

• Amazon Quiz
• Flipkart Quiz
• Play & Win 50,000 Coins
• Privacy Policy

NPTEL DataBase Management System ASSIGNMENT ANSWERS 2021

• by QuizXp Team
• August 1, 2021 September 22, 2021

NPTEL DataBase Management System Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet-based, financial, social, administrative, and so on.

NPTEL Database Management System is a MOOC course offered by IIT Madras on the NPTEL platform. Through this DBMS course, 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. The course is developed by Prof. 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

• INTENDED AUDIENCE: ALL UG STUDENTS
• Requirements/Prerequisites:  NIL
• INDUSTRY SUPPORT:  All compaines or industry

CRITERIA TO GET A CERTIFICATE

Students have to score Average assignment score = 25% of the average of the best 6 assignments out of the total 8 assignments given in the course. Exam score = 75% of the proctored certification exam score out of 100 Final scores = Average assignment score + Exam score

Students will be eligible for CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If any of the 2 criteria are not met, the student will not get the certificate even if the Final score >= 40/100.

DataBase Management System ASSIGNMENT WEEK 8 ANSWERS:-

Answer:- a,d

Answer:- b,c

DataBase Management System ASSIGNMENT WEEK 7 ANSWERS:-

Answer:- a,c

DataBase Management System ASSIGNMENT WEEK 5 ANSWERS:-

Answer:- ,c

DataBase Management System ASSIGNMENT WEEK 4 ANSWERS:-

Database management system assignment week 3 answers:-.

Q1. Consider the following instance of the relation MovieBooking (Movie Name, TheatrID, HallNo, Glasses 3D, MLanguage, Showtime ID, ShowDay)

Answer:- c,d

Q2. Consider the following two Relational Algebra expressions: R1: IlMovieName, HallNo (MovieBooking) R2: IIM2. HallNo (OM1.Theatr ID-M2. TheatrIDAM1.MLanguage/M2.MLanguage (PM1 (MovieBooking) x PM2 (MovieBooking))) What is the output of R1 + R2?

Q3. A C program, with embedded SQL allows the users to enter their username and password which are stored in the variables uname and pwd respectively. With the help of an embedded SQL query, the program then selects the user’s Rank and Marks from a database with the following schema: ChckRes (User, Passwd, Department, Year, Rank, Marks). Select the correct Embedded SQL query that should be present in this C program.

Q4. Consider the relation TicTac (Player, Game, Mark, PositionFilled) What is the Tuple Relational Calculus expression equivalent to the statement “Select those games where Central position has been filled”?

Note:- WE NEVER PROMOTE COPYING AND We do not claim 100% surety of answers, these answers are based on our sole knowledge, and by posting these answers we are just trying to help students to reference, so we urge do your assignment on your own.

Q5. Consider the following Entity Relationship Diagram:

Q6. Consider the relation TicTac (Player, Game, Mark, PositionFilled) What is the Domain Relational Calculus equivalent to the statement “Select those players who are playing with Cross mark”?

Q7. Choose the correct Entity Relationship Diagram representing the following scenario: In a game club, membership cards are issued to some of the visitors. A visitor can have only one membership card and that card cannot be shared with any other member. A membership card can be identified with its membership number. The card also has member type, validity and access zone that are available to the member. The access zone is composed of zone code and zone games. A visitor of this game club is identified by the visitor’s ID and name together. A visitor can have multiple email IDs which are also registered.

Q8. If n [Payment] is the set of attributes present in the relational schema of Payment, n[In Cash] is the set of attributes present in the relational schema of In Cash and n[In_Cheque] is the set of attributes present in the relational schema of In Cheque, which of the following options can be true?

Q9. How many tuples will be generated by the Relational Algebra expression equivalent to the following Domain Relational Calculus?

Q10. Which of the following Relational Algebra expression produces exactly the same tuples as present in this instance of Presentation?

DataBase Management System ASSIGNMENT WEEK 2 ANSWERS:-

Q1. Consider the following instance of the relation weather (day, year, month, temperature, city)

Q2. Consider the following table Customer: Identify the correct SQL statement from the following options for creating the table Customer.

Q3. Consider the following instance of the relation weather (day, year, month, temperature, city)

Q4. Consider the following instance of the relation RankHolder (UnivID, Dept, Name, Roll, Rank)

Q5. Consider the following instance of the relation RankHolder (UnivID, Dept, Name, Roll, Rank)

Q6. Consider the following CREATE statement

Q7. Consider the following two schema: Product (Product_id, Pname, Uprice), Department (Dno, Dname, Product_id, year). If we execute the following SQL statement:

Q8. Consider the following instance of Student Details (StudName, Marks, Permanent Address, Correspondence Address) relation.

Answer:- b,d

Q9. Consider the following instance of Student Details (StudName, Marks, Permanent Address, Correspondence Address) relation.Student Details

Q10. Consider the given relational schema: Student Details (Stud ID, StudName, Marks, Permanent Address, Correspondence Address).

DataBase Management System ASSIGNMENT WEEK 1 ANSWERS:-

Q1. What is Physical Data Independence?

Answer:- D JOIN US ON TELEGRAM WE UPDATE ANSWERS AND NOTIFY THERE

Q2. what is a collection of data called that consists of roll number ,name, class and phone number of a student?

Q3. Consider the relational schema Virtual Conf (Conf ID, Participants, Admin, Day, Subject). Which of the following is not a valid instance of VirtualConf?

Answer:- D JOIN US ON TELEGRAM ONCE WE UPDATE ANSWERS WILL NOTIFY THERE

Q4. Consider the following instance: Based on this instance of Storage, if RoomNo is one of the attributes of the primary key (composite in nature), which of the following attribute(s) complete the primary key?

Q5. Consider the following instances: Which of the following tuples will not be present in bag1 x bag2?

Answer:- B,C

Q6.  Suppose there are two relations R and S as follows: After performing a relational expression involving ‘X’ on R and S, we get the following result:

Q7.  Choose the incorrect statement(s) related to database languages.

Answer:- A,B,C,D

NOTE:- IF THERE IS ANY CHANGE IN ANSWERS OF NPTEL Database management system assignment answers WILL UPDATE BEFORE LAST DATE AND NOTIFY ON TELEGRAM OR WHATSAPP. SO KINDLY JOIN US, CLICK ON BELOW IMAGE AND JOIN US.

Q8. Consider the following table: Identify the correct operation(s) which produces the following output from the above relation.

Q9. Consider the following table: Identify the correct operation(s) which produces the following output from the above relation.

Q10. Which of the following can be a candidate key for the following instance?

Also check :- Internship oppurtinites

Note:- We do not claim 100% surety of answers, these answers are based on our sole knowledge and by posting these answers we are just trying to help students, so we urge do you assignment own your own.

Category: NPTEL

Programming in modern c++ | week 12, introduction to internet of things week 12, introduction to industry 4.0 and industrial internet of things | week 12, an introduction to artificial intelligence | week 12, the joy of computing using python | week 12, quantum mechanics 1 | week 12, programming in java | week 12, principles of management | week 12, leadership and team effectiveness | week 12, introduction to machine learning | week 12.

• 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 July 2021 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 July 2021 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(July 2021) 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

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

Dear Candidate,

Here is a golden opportunity for those who had previously enrolled in this course during the July 2021 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 Jan 2022 and we are giving you another chance to write the exam in March 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: March 27, 2022

2. Certification exam registration URL is: CLICK HERE

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.

6. If you do enroll to Jan 2022 course, we will take the best average assignment scores/non-proctored programming exam score across the two semesters

Our suggestion:

- Please check once if you have >= 40/100  in average assignment score and also participate in the non-proctored programming exams that will be conducted during this semester in the course to become eligible for the e-certificate, wherever applicable.

- If not, please submit Assignments again in the Jan 2022 course & and also participate in the non-proctored programming exams to become eligible for the e-certificate.

- You can also submit Assignments again and participate in the non-proctored programming exams if you want to better your previous scores.

RECOMMENDATION: Please enroll to the Jan 2022 course and brush up your lessons for the exam.

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

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: Feb 18, 2022 10:00 AM (Friday). 

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

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

14. LAST DATE FOR CANCELLING EXAMS and getting a refund: Feb 18, 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/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, 

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 : Results 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 2021, irrespective of which Assignment score that will be considered.

Reminder: Feedback for Data Base Management System

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/1_a3bNLC9BNjx4LL-I1_KAa50WIfTyA56YglH0mnSxkY/viewform We thank you for your valuable time and feedback. Thanks & Regards, -NPTEL Team

Feedback for Data Base Management System

Best of luck for your exam.

Dear Learners,

Best of luck for your examination!

Data Base Management System - Assignment-8 Solution Released

Dear Participants,

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: https://drive.google.com/file/d/1MWjN5zLGpkLk6Z9epWDALDjj7wEgWGK3/view

Happy Learning!

Thanks & Regards,

Hall Ticket for September 26,2021 has been released!!

• Please come to the exam centre with the printout of the same hall ticket, along with a valid govt. approved photo id card.
• Please read the instructions that are given on the hall ticket before coming to the exam.
• Requests for changes in exam city, exam center, session, or course will NOT be entertained. 
• Please write to [email protected] for any further queries.

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

-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: 21 .09.2021

Time: 4 :00 PM

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

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/1FAIpQLSehgXezHi8euUosaFY_-fXVfryk7GKdOgH0FFtPOvYNyXq9LQ/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: https://drive.google.com/file/d/1_Kk8Q-Otthx0EtLaG6Y8-A-1fLKiNlLV/view

Data Base Management System - Week 8 Feedback Form

Thank you for enrolling to 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/1FAIpQLScWDg5TzGq43UVGZbbB_pOQk25ZqLcM5RpIcDM2EDtXbr-VNw/viewform

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

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/noc21_cs58/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/noc21_cs58/unit?unit=74&assessment=113

The assignment has to be submitted on or before Wednesday, [22/09/2021], 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: https://drive.google.com/file/d/1ugE2uvPsw6n9Ro2x4H6O_34wR8-3Dj9J/view?usp=sharing

Data Base Management System - Week 7 Feedback Form

Data base management system - week 7 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/noc21_cs58/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/noc21_cs58/unit?unit=66&assessment=112

The assignment has to be submitted on or before Wednesday, [15/09/2021], 23:59 IST.

Data Base Management System : Video recording on Interactive session 1

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

Data Base Management System - Assignments-4 & 5 Solution Released

Dear Participants, The Assignments- 4 & 5 of Week- 4 & 5 Solution for the course " Data Base Management System " have 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/1kGvzIbExDhd6S7pOSiLLmn8dEsQcnc4o/view Link for assignment 5 solution:  https://drive.google.com/file/d/19_K3XiDDxi85xCKcIfAZAa-V-LvqdCn0/view Happy Learning! Thanks & Regards, NPTEL Team

Data Base Management System - Week 6 Feedback Form

Exam format - sep 26, 2021.

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 - Assignments-1 & 2 Solution Released

Dear Participants, The Assignments- 1 & 2 of Week- 1 & 2 Solution for the course " Data Base Management System " have 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/1EIqZ6ELms55riIyw0IWqR761PaEhlSdY/view Link for assignment 2 solution:  https://drive.google.com/file/d/1FLKdrldIcLLMcTXuKqAa2oDiQOuIqU-j/view Happy Learning! Thanks & Regards, NPTEL Team

Data Base Management System : Live Interactive session - 1

Date: 30 .08.2021

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

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

Today is the last date to register for September 26 exam !!!

Read below for more details: 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 the 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: September 26, 2021. Certification exam registration URL is:  https://examform.nptel.ac. in/   Choose from the Cities where exam will be conducted:   Exam cities 4. Last date for exam registration  : August 29, 2021, 23:59 PM (Sunday). 

Exam fees will be Rs. 1000/- per exam. 

(We are not changing it to Rs 1500/- this time due to covid exemption ; it will be Rs 1000/- till August 29,2021)

Data Base Management System - Week 6 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/noc21_cs58/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/noc21_cs58/unit?unit=58&assessment=111

The assignment has to be submitted on or before Wednesday, [08/09/2021], 23:59 IST.

Exam Registration for September exams is Extended till Aug 29 - Register Today!!

Read below for more details: 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 the 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: September 26, 2021. Certification exam registration URL is:  https://examform.nptel.ac. in/   Choose from the Cities where exam will be conducted:   Exam cities 4. Last date for exam registration extended till : August 29, 2021, 23:59 PM (Sunday).  EXAM FEES:

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: https://drive.google.com/file/d/15J_VVwuD7-EdSdmUp2EYDbdt8MoWFK93/view

Data Base Management System - Week 5 Feedback Form

Data base management system - week 5 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/noc21_cs58/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/noc21_cs58/unit?unit=50&assessment=110

The assignment has to be submitted on or before Wednesday, [01/09/2021], 23:59 IST.

Data Base Management System - Week 4 Feedback Form

Exam registration for september exams is extended- register today.

Read below for more details: 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 the 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: September 26, 2021. Certification exam registration URL is:  https://examform.nptel.ac. in/   Choose from the Cities where exam will be conducted:  Exam cities 4. Last date for exam registration extended till : August 27, 2021, 5:00 PM (Friday).  EXAM FEES:

(We are not changing it to Rs 1500/- this time due to covid exemption ; it will be Rs 1000/- till August 27,2021)

Data Base Management System - Week 4 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/noc21_cs58/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/noc21_cs58/unit?unit=41&assessment=109

The assignment has to be submitted on or before Wednesday, [01/09/2021] , 23:59 IST.

Data Base Management System - Week 3 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/noc21_cs58/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/noc21_cs58/unit?unit=33&assessment=108

The assignment has to be submitted on or before Wednesday, [25/08/2021] , 23:59 IST.

Data Base Management System - Week 2 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/noc21_cs58/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/noc21_cs58/unit?unit=25&assessment=107

The assignment has to be submitted on or before Wednesday, [18/08/2021] , 23:59 IST.

Data Base Management System - Week 1 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/noc21_cs58/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/noc21_cs58/unit?unit=17&assessment=106

The due date of Assignment 1 for Week 1 has been extended and it can be submitted on or before Wednesday, 18-08-2021 , 23:59 IST.

Data Base Management System - Week 3 Feedback Form

Data base management system - week 2 feedback form, data base management system - week 1 feedback form, 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/1_u3yrGoaDhR8V9jIEjvmG5YokP99Tvn6/view

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

The download video links for the course Data Base Management System  are available now in the course outline. Please check the download video link: https://nptel.ac.in/courses/106/105/106105175/

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

April 2021 exams: Due to the continued pandemic situation, April course exams for the Jan - April 2021 semester stand postponed until further notice. We will announce the exam dates once they are confirmed.

July 2021 exams: As per our calendar, the exams for the July 2021 semester are being planned as mentioned in the Timelines document; and so we have opened the exam registration form for the same. As of now, the exam dates stay the same; if there is any change in the future we will announce it.

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: September 26, 2021

Certification exam registration URL is: https://examform.nptel.ac.in/  

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

4. Exam fees: 

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

If you register for exam before August 16, 2021, 10:00 AM and have not paid or if you register between August 16, 2021, 10:00 AM & August 20, 2021, 5:00 PM, Exam fees will be Rs. 1500/- per exam 

5. 50% fee waiver for the following categories: 

6. Last date for exam registration: August 20, 2021, 5:00 PM (Friday). 

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

8. HALL TICKET: 

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: August 20, 2021, 5:00 PM: 

11. LAST DATE FOR CANCELLING EXAMS and getting a refund: August 20, 2021, 5:00 PM 

12. Click here to view Timeline and Guideline : Guideline  

NPTEL TEAM.

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

The due date of Assignment 0 is on or before 26-07-2021 , 23:59 IST.

Welcome to NPTEL Online Course - July 2021!!

• 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: 26 September 2021  Morning session 9am to 12 noon; Afternoon Session 2pm to 5pm.
• 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

[Week 1] NPTEL Data Base Management System Assignment Answers 2024

Nptel data base management system week 1 assignment answers 2024.

1. relation R has 2 candidate keys with 1 attribute each. There are 6 possible super keys of R What is the total number of attributes in R?

1) 2 9) 3 3) 4 1) 5

Share your love

Related posts, [week 1] nptel emotional intelligence assignment answers 2024.

[Week 1-12] NPTEL E-Business Assignment Answers 2023

[Week 1-12] NPTEL Natural Language Processing Assignment Answers 2023

[Week 1-10] NPTEL Introduction To Industry 4.0 And Industrial Internet Of Things Assignment Answers 2023

[Week 1-12] NPTEL Introduction To Machine Learning Assignment Answer 2023

[Week 1] NPTEL Electrophysiology Of Heart Assignment Answers 2023

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.