introduction to database systems nptel assignment answers 2022

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

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

The course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.

Course layout (Answers link)

Answers COMING SOON! Kindly Wait!

Week 0: Assignment answers Week 1:  Course Overview. Introduction to RDBMS Week 2: Structured Query Language (SQL)  Week 3: Relational Algebra. Entity-Relationship Model   Week 4: Relational Database Design Week 5:  Application Development. Case Studies. Storage and File Structure   Week 6: Indexing and Hashing. Query Processing   Week 7:  Query Optimization. Transactions (Serializability and Recoverability) Week 8:  Concurrency Control. Recovery Systems. Course Summarization.

NOTE:  You can check your answer immediately by clicking show answer button. Data Base Management System NPTEL 2022 Week 2 Assignment Solution” contains 10 questions.

Now, start attempting the quiz.

Data Base Management System NPTEL 2022 Week 2 Assignment Solutions

Q1. Consider the following instance of the relation PAPER(ID, TYPE, AREA, CITATION)

Which of the following values will be present in all the tuples selected by the following query: SELECT ‘CITATION’ FROM PAPER WHERE CITATION>200

a) 567 b) CITATION c) 43 d) 167

Answer: b) CITATION

Q2. Consider the following instance of the relation PAPER(ID, TYPE, AREA, CITATION)

Select the correct query that displays the following output:

a) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “% %” b) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “%” c) SELECT ID-73 AS ID FROM PAPER WHERE AREA LIKE “%_%” d) SELECT ID-73 AS ID FROM PAPER WHERE AREA LIKE “%%”

Answer: a) SELECT ID/2 AS ID FROM PAPER WHERE AREA LIKE “% %”

Q3. Consider the following instance of the relation MAINTENANCE(WORK, DAYS, CHARGE, TEAM)

How many tuples will be returned by the following query: SELECT AVG(CHARGE) FROM MAINTENANCE GROUP BY DAYS

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

Answer: c) 3

Q4. Consider the following instance of the relation MAINTENANCE (WORK, DAYS, CHARGE, TEAM).

Which of the following queries will produce the following output (ordered):

a) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM b) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM DESC c) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS, TEAM d) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS, TEAM DESC

Answer: a) SELECT WORK, TEAM FROM MAINTENANCE WHERE CHARGE>50000 ORDER BY DAYS DESC, TEAM

Q5. Consider the following schema. Primary keys are underlined. Employees( E_name , E_street, E_city) BankAccount( Ac_number , Branch_name, Balance) AccountUser( E_name , Ac_number ) Which is the correct SQL command to create the table AccountUser having two foreign keys E_name and Ac_number

a) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name, Ac_number), FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); b) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name), FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); c) CREATE TABLE AccountUser { E_name VARCHAR(20) PRIMARY KEY, Ac_number NUMERIC(12, 2) PRIMARY KEY, FOREIGN KEY(E_name) REFERENCES Employees, FOREIGN KEY(Ac_number) REFERENCES BankAccount); d) CREATE TABLE AccountUser { E_name VARCHAR(20), Ac_number NUMERIC(12, 2), PRIMARY EKY(E_name, Ac_number), FOREIGN KEY Employees(E_name), FOREIGN KEY BankAccount(Ac_number));

Data Base Management System NPTEL Week 2 Assignment Solutions

Q6. Identify the correct SQL command(s) to create a new record for the Faculty table as given below. Primary key is underlined in the schema.

a) INSERT INTO FACULTY VALUES(‘Charline B’, ‘English’, ‘M.A.’); b) INSERT INTO FACULTY VALUE(”Charline B”, ”English”, ”M.A.”); c) INSERT INTO FACULTY VALUE(‘Charline B’, ‘English’, ‘M.A.’); d) INSERT INTO FACULTY (Faculty_name, Department, Degree) VALUES(‘Charline B’, ‘English’, ‘M.A.’);

Answer: a), d)

Q7. A role Admin has the privilege of select, insert, update and delete on all tables of database. A new role Users is created and the following statement is executed. grant Admin to Users; Which rights will Users inherit?

a) Only select b) Only select and delete c) Only select, and update but not delete d) All rights – select, insert, delete, and update

Answer: d) All rights – select, insert, delete, and update

Q8. Consider the following instance of EmployeeDetails(EmpName, Branch, Address, Salary) relation.

Identify the correct statement(s) to get the following output:

a) SELECT * FROM EmployeeDetails WHERE Branch=Address OR Salary>=15000; b) SELECT * FROM EmployeeDetails WHERE Branch=Address AND Salary>=15000; c) (SELECT * FROM EmployeeDetails WHERE Branch=Address) UNION (SELECT * FROM EmployeeDetails WHERE Salary>=15000); d) (SELECT * FROM EmployeeDetails WHERE Branch=Address) INTERSECT (SELECT * FROM EmployeeDetails WHERE Salary>=15000);

Answer: a), c)

Q9. Consider the following instance of EmployeeDetails(EmpName, Branch, Address, Salary) relation.

Identify the correct SQL command that creates a view as EmployeeSalaryDetails in which columns EmpName and Salary for the tuples where the second character of EmpName is ‘r’ and the Salary is atleast 15000.

a) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) ON SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘%r%’ AND Salary>=15000; b) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) ON SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>15000; c) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) AS SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>=15000; d) CREATE VIEW EmployeeSalaryDetails(EmpName, Salary) AS SELECT EmpName, Salary FROM EmployeeDetails WHERE EmpName LIKE ‘_r%’ AND Salary>15000;

Q10. Consider the given relational schema: EmployeeDetails(EmpName, Branch, Address, Salary) Identify the correct statement to find the EmpName, Branch and Salary of all tuples in which Salary is greater than or equal to the average Salary of all employees or Salary is between 15000 and 20000 including 15000 and 20000.

a) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary LIKE(15000, 20000); b) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary IN(15000, 20000); c) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary AS(15000, 20000); d) SELECT EmpName, Branch, Salary FROM EmployeeDetails WHERE Salary>=(SELECT AVG(Salary) from EmployeeDetails) OR Salary BETWEEN 15000 AND 20000;

<< Prev- Data Base Management System Week 1 Assignment Solutions

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

NPTEL answers: Problem solving through programming in C

NPTEL answers: Principles of Management

Programming in Java NPTEL week 1 quiz answers

NPTEL – Python for Data Science assignment solutions

Nptel – Deep Learning assignment solutions

The above question set contains all the correct answers. But in any case, you find any typographical, grammatical or any other error in our site then kindly  inform us . Don’t forget to provide the appropriate URL along with error description. So that we can easily correct it.

Thanks in advance.

For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.

Related Posts

Operating system fundamentals | nptel | week 0 assignment 0 solution, nptel operating system fundamentals week 1 assignment solutions, nptel operating system fundamentals week 10 answers, nptel operating system fundamentals week 2 assignment solutions, nptel operating system fundamentals week 3 assignment solutions, nptel operating system fundamentals week 4 assignment solutions, leave a comment cancel reply.

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

• 1st Central Law Reviews: Expert Legal Analysis & Insights

• Computer Science and Engineering
• NOC:Introduction to Database Systems (Video) 
• Co-ordinated by : IIT Madras
• Available from : 2019-11-13
• Intro Video
• Introduction
• Database Architecture
• RDBMS Architecture
• Introduction to ER Model
• Entities and Relationships
• Modelling Weak Entities and Design Choices
• Relational Data Model and Notion of Keys
• Introduction to Relational Algebra
• Operators in Relational Model
• Uses of Renaming, Join and Division in Relation Algebra
• Example Queries in Relation Model and Outer Join Operation
• Convert ER-Model to a Relational Model
• Introduction to tuple relational calculus
• Example TRC queries
• Data definition using SQL
• Basic SQL query block and subqueries
• Correlated subqueries
• Aggregate functions
• Programmatic access of SQL
• Normal forms - Introduction
• Deriving new functional dependencies
• Proving soundness and completeness of Armstrong's Axioms
• Normal forms - 2 NF, 3NF, BCNF
• Properties of decompositions
• Normal forms - 4NF, 5NF
• Introduction to file orgranization
• File orgranization methods
• Dynamic File orgranization using Hashing
• Index structures
• B+ trees on Disks
• Performance and Reliability of Multiple Disks
• Relational Query Evaluation
• Join operator processing algorithms
• Query optimization
• ACID properties and operations in transactions
• Concurrency control using Locks
• Recovery using undo logging method
• Recovery using Redo and Undo-Redo logging methods
• Recoverable schdeules and transaction isolation levels
• Watch on YouTube
• Assignments
• Download Videos
• Transcripts
• Lecture Notes (1)

[Week 1] NPTEL Introduction to Database Systems Assignment Answers 2024

Nptel introduction to database systems week 1 assignment answers 2024.

1. Storing data and meta-data separately makes RDBMS general-purpose and flexible.

2. “Data Model” is nothing but a data structure where data is stored.

3. An RDBMS can typically manage more than one database.

4. A database can not be created unless an RDBMS is used.

5. Relational data model provides the concept of “Entity”.

6. ER Model is NOT a representational-level data model.

7. Three-schema architecture is part of the Entity-Relationship Data Model.

8. Transaction Manager takes control of the system when it recovers after a failure.

9. People who make use of application programs need to know the logical schema of the database completely.

10. People who develop the application programs need not know the physical schema of the database.

11. People who develop the application programs need to know the logical schema of the database completely.

12. A “log” in the RDBMS keeps track of update operations of all transactions.

13. Complete the sentence: Logical Data Independence is the ability to modify…

• physical-level schema without affecting the logical-level schema
• the logical-level schema with no effect on view-level schema.
• view-level schema without affecting logical-level schema.
• logical-level schema without affecting physical-level schema.

14. Complete the sentence: Physical Data Independence is the ability to modify…

15. An Entity-Relationship (ER) Model represents:

• The various entity types of interest and the relationships among them in the domain being modeled.
• Various tables and links among them in the domain being modeled.
• The various entity types of interest and the relationships among them in the domain being modeled along with operations to be performed on data.
• Various tables and links among them in the domain being modeled along with operations to be performed on data.

16. A person who develops a high-level language program that meets a functional requirement of the database is usually called:

• A naive user
• An application programmer
• A data analyst
• A DB administrator

17. The people playing the following role need​  NOT ​ have an understanding of the complete logical schema of the database:

• Data-entry Operator
• Application Programmer
• Data Analyst
• Database Administrator

Consider the following statements:

   S1: A view usually provides access to a part of the data relevant to a group of users    S2: A view usually provides access to the complete database    S3: The feature of defining views is to be compulsorily provided by the RDBMS    S4: The feature of defining views may not be provided by an RDBMS.

   Choose the correct option:

• S1 and S3 are TRUE
• S1 and S4 are TRUE
• S2 and S3 are TRUE
• S2 and S4 are TRUE

Consider the following sets:

   M = { p: RDBMS Run-time System; q: Transaction Manager; r: Buffer Manager;

    s: Recovery Manager}

   F = { w: Transaction Error Handling; x: Concurrency Control; y: Query Execution; z: Paging}

   What is the most appropriate matching between sets M and F?

• p — y; q — x; r — z; s — w;
• p — z; q — w; r — y; s — x;
• p — y; q — z; r — x; s — w;
• p — w; q — x; r — z; s — y;

Share your love

Related posts.

[Week 1 to 8] NPTEL Programming, Data Structures And Algorithms Using Python Assignment Answers 2023

[week 1] nptel air pollution and control assignment answers 2024.

NPTEL Global Marketing Management Assignment Answer (week 1-2) 2023

[Week 1-12] NPTEL Deep Learning Assignment Answers 2023

[Week 1 to 8] NPTEL Data Science For Engineers Assignment Answers 2023

[week 1] nptel water and waste water treatment assignment answers 2024, 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.

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

nptel-solutions

Here are 58 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

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

NPTEL-Course / Programming-Data-Structures-And-Algorithms-Using-Python

Nptel Course Solutions : Programming, Data Structures And Algorithms Using Python

• Updated Nov 30, 2020

tdishant / NPTEL-Joy-of-Computing-Using-Python

Python code from week-3 to week-12 for the NPTEL course The Joy of Computing using Python

• Updated Oct 26, 2021

TarunSehgal27 / NPTEL-JAVA-2020

this is a repo about the java program headed by Debasis Samantha during 2020

• Updated Apr 23, 2020

NPTEL-Course / Google-Cloud-Computing-Foundations

Nptel Course Solution : Google Cloud Computing Foundations

• Updated Nov 19, 2020

Anmol-PROgrammar / SWAYAM-Programming_In_Java-NPTEL

This site contains the weekly( i.e. 1-9) questions and their solution of NPTEL-SWAYAM course "Programming in Java".

• Updated Aug 19, 2021

lonebots / python-programming-joc-nptel

Python programming repository for NPTEL joy of computing course

• Updated Dec 21, 2020

CGreenP / NPTEL-Introduction-to-Programming-in-C-Assignment-4-Question-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-Introduction-to-Programming-in-C-Assignment-2-Question-2

NPTEL Introduction to Programming in C Assignment 2 Question 2

• Updated Mar 21, 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.

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

NPTEL: Exam Registration date is extended for 12 week courses of Jan 2024!

• No further extension will be provided.
• This extension is only applicable for 12-week courses.

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

Dear Candidate,

Here is a golden opportunity for those who had previously enrolled in this course during the Jan 2023 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 2024 and we are giving you another chance to write the exam in April 21, 2024 a nd 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: April 21, 2024

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(if applicable) in the previous semester

6. If you do enroll in the Jan 2024 course, we will take the best average assignment scores/non-proctored programming exam(if applicable) score across the two semesters.

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(if applicable) that were conducted in Jan 2023 to become eligible for the e-certificate, wherever applicable.

If not, please submit assignments again in the Jan 2024 course and also participate in the non-proctored programming exams(if applicable) to become eligible for the e-certificate.

We will not be having new assignments or unproctored exams(if applicable) in the previous semester's (Jan 2023) course. 

RECOMMENDATION: If you want to take new assignments and an unproctored exam(if applicable) or brush up on your lessons for the exam, please enroll in the Jan 2024 course.

Click here to enroll in the current course, links are provided corresponding to the course name.

7. Exam fees: 

If you register for the exam and pay before March 11, 2024 - 5:00 PM, Exam fees will be Rs. 1000/- 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: March 15, 2024 - 5:00 PM (Friday). 

10. Between March 11, 2024 - 5:00 PM & March 15, 2024 - 5:00 PM late fee will be applicable.

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

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

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

14. Data changes: 

Last date for data changes: March 15, 2024 - 5:00 PM :  

We will charge an additional fee of Rs. 200 to make any changes related to name, DOB, photo, signature, SC/ST and PWD certificates after the last date of data changes.

The following 6 fields can be changed (until the form closes) ONLY when there are NO courses in the course cart. And you will be able to edit those 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 canceled courses, refund of fees will be initiated only after 2 weeks. 

15. LAST DATE FOR CANCELING EXAMS and getting a refund: March 15, 2024 - 5:00 PM  

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

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. For any further queries please write to [email protected] . - Team NPTEL

Introduction to Database Systems : Result Published!!

                                      ***THIS IS APPLICABLE ONLY FOR EXAM REGISTERED CANDIDATES***                             ****Please don't click on below link, if you are not registered/not present for the Exam****                          Dear Candidate, The exam scores and E Certificates have been released for April 2023 Exam(s). Step 1 - Are the results of my courses released? Please check the Results published courses list in the below links.:- Apr 2023 Exam - Click here Step 2 - How to check Results? Please login to internalapp.nptel.ac.in/ . and check your exam results. Use the same login credentials as used to register to the exam. What's next? Please read the pass criteria carefully and check against what you have gotten. If you still have any issues, please report the same here. internalapp.nptel.ac.in/ . We will reply within a week. Last date to report queries: 3 days within publishing of scores. Note : 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 2023, irrespective of which Assignment score that will be considered. Thanks and Best wishes. NPTEL Team

Survey on Problem Solving sessions - Introduction to Database Systems - (noc23-cs29)

Dear Learners, We would like to know if the expectations with which you attended this problem solving session are being met and hence please do take 2 minutes to fill out our feedback form. It would help us tremendously in gauging the learner experience. Here is the link to the form:  https://docs.google.com/forms/d/1UvzjHY1vRQCjC9GXNcT-2E8bECZUKl4zj2l4IuQ1jt0/viewform -NPTEL TEAM

Introduction to Database Systems : Final Feedback Form !!!

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

April 2023 NPTEL Exams - Hall Tickets Released!

***THIS IS APPLICABLE ONLY FOR EXAM REGISTERED CANDIDATES***     ****Please don't click on below link, if you are not registered for the Exam**** Dear Candidate, Your Hall Ticket / admit card for the NPTEL Exam(s) in April, 2023 has been released. Please login to https://internalapp.nptel.ac.in/ using your exam registered email id and download your hall ticket. Note:  Requests for changes in exam city, exam center, exam date, session, or course will NOT be entertained. Please write to [email protected] for any further queries. All the best for your exams! Warm Regards NPTEL Team

Introduction to Database Systems : Problem solving Session Reminder !!

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: April 21, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: April 14, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 12 Feedback Form: Introduction to Database Systems

Dear Learners, Thank you for continuing with the course and hope you are enjoying it. We would like to know if the expectations with which you joined this course are being met and hence please do take 2 minutes to fill out our weekly feedback form. It would help us tremendously in gauging the learner experience. Here is the link to the form:    https://docs.google.com/forms/d/1Q3XWdYwWeBHBrsgvrm8FhF2nx1i5G9WctCF021cZWvM/viewform Thank you -NPTEL team

Exam Format - April, 2023 !!

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. Thank you! -NPTEL Team

Introduction to Database Systems : Assignment 12 is live now!!

Dear Learners, The lecture videos for Week 12 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=99&lesson=100 The other lectures in 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). Practice Assignment-12 for Week-12 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=99&assessment=124 Assignment-12 for Week-12 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=99&assessment=142 The assignment has to be submitted on or before Wednesday,[19/04/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: April 07, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 11 Feedback Form: Introduction to Database Systems

Introduction to database systems : assignment 9 reevaluations.

Dear Learners, Assignment 9 submission of all students has been reevaluated by making the weightage as 0 for Question 10. Students are requested to find their revised scores of Assignment 9 on the Progress page. -NPTEL Team

Introduction to Database Systems - Week 11 content is live now !!

Dear Learners, The lecture videos for Week 11  have been uploaded for the course " Introduction to Database Systems ". The lectures can be accessed using the following link.   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=91&lesson=92 The other lectures in 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). Practice Assignment-11  for Week-11  is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=91&assessment=123 Assignment-11  for Week-11  is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=91&assessment=141 The assignment has to be submitted on or before Wednesday,[12/04/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: March 31, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 10 Feedback Form: Introduction to Database Systems

Introduction to database systems : assignment 10 is live now.

Dear Learners, The lecture videos for Week 10 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=84&lesson=85 The other lectures in 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). Practice Assignment-10 for Week-10 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=84&assessment=122 Assignment-10 for Week-10 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=84&assessment=140 The assignment has to be submitted on or before Wednesday,[05/04/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: March 24, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Potential additional date (April 28th) for the April 2023 NPTEL exams

***THIS IS APPLICABLE ONLY FOR EXAM REGISTERED CANDIDATES*** Dear Student, Greetings from NPTEL! The Jan 2023 session is coming to an end soon and it’s time to put all your best efforts for the certification exam. The NPTEL team has always been there to make your learning process a joyful one and we hope that with your support we will be able to overcome the challenges of conducting a nation-wide exam of this magnitude. With the closure of exam registration form for the NPTEL April 2023 exams, the final registration count stands at 5.1 Lakh compared to 3.7 Lakh reported during the Jul-Dec 2022 semester. Based on the previous semester data, seats at the certification exam centres are booked by NPTEL at the beginning of the exam registration process. As the semester progresses, sometimes these numbers exceed our estimate, especially on certain dates and certain exam cities. Our goal is to allocate the chosen exam cities to all our learners. And by and large, we are able to allocate the chosen cities and dates with active support from our exam partner and our partner colleges. All efforts are being made to allocate the city of choice or the next nearest exam city for the April 29th/30th 2023 exams, as scheduled. However, in view of the unexpectedly large volume of exam registrations & limitation of seats at certain cities on a particular date, we may be compelled to shift the exam date of certain candidates to 28th April 2023 (Friday) as a last resort, only after exhausting all possibilities. We hope that you will appreciate our logistical constraints of such rescheduling and extend all necessary support as before and participate in the exam. With best wishes for the forthcoming exam(s), Warm regards, NPTEL Team

Week 9 Feedback Form: Introduction to Database Systems

Introduction to database systems : assignment 9 is live now.

Dear Learners, The lecture videos for Week 9 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=76&lesson=77 The other lectures in 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). Practice Assignment-9 for Week-9 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=76&assessment=121 Assignment-9 for Week-9 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=76&assessment=139 The assignment has to be submitted on or before Wednesday,[29/03/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: March 17, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 8 Feedback Form: Introduction to Database Systems

We would like to know if the expectations with which you attended this problem solving session are being met and hence please do take 2 minutes to fill out our feedback form. It would help us tremendously in gauging the learner experience. Here is the link to the form:  https://docs.google.com/forms/d/1UvzjHY1vRQCjC9GXNcT-2E8bECZUKl4zj2l4IuQ1jt0/viewform

Introduction to Database Systems : Assignment 8 is live now!!

Dear Learners, The lecture videos for Week 8 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=69&lesson=70 The other lectures in 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). Practice Assignment-8 for Week-8 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=69&assessment=120 Assignment-8 for Week-8 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=69&assessment=138 The assignment has to be submitted on or before Wednesday,[22/03/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: March 10, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 7 Feedback Form: Introduction to Database Systems

Introduction to database systems : assignment 7 is live now.

Dear Learners, The lecture videos for Week 7 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=62&lesson=63 The other lectures in 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). Practice Assignment-7 for Week-7 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=62&assessment=119 Assignment-7 for Week-7 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=62&assessment=136 The assignment has to be submitted on or before Wednesday,[15/03/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: March 03, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 6 Feedback Form: Introduction to Database Systems

Introduction to database systems : assignment 6 is live now.

Dear Learners, The lecture videos for Week 6 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=54&lesson=55 The other lectures in 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). Practice Assignment-6 for Week-6 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=54&assessment=118 Assignment-6 for Week-6 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=54&assessment=134 The assignment has to be submitted on or before Wednesday,[08/03/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: February 24, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

REMINDER - Introduction to Database Systems : Live interaction 2 with Course Instructor !!!

Dear Learner, You can interact LIVE with the Course Instructors   Prof. Sreenivasa Kumar  of the course – Introduction to Database Systems Date:  23-02-2023 Time: 05:00 PM Link to login:  https://us02web.zoom.us/j/ 86999848131?pwd= V2gwTlBnOFZSV0FuSzZ4VzFNcnhQQT 09 Meeting ID: 869 9984 8131 Passcode: 112233   Enter your questions you want Professor to answer a  https://docs.google.com/forms/ d/1wM- ZSyMIuD7UZGhEDRoB5pqoERC7JTwEh ZX3H7UqItw/edit You can also ask your doubts during the session through the chat window. We would also like to hear from you after the session. we request you to share your thoughts in the forum. Learners are encouraged to visit bit.ly/NPTELLIVE for updates on the live sessions. Subscribe to " Interactive Sessions with IIT Profs - NPTEL " for Updates on our Live Sessions -NPTEL team

Introduction to Database Systems : Live interaction 2 with Course Instructor !!!

Week 5 feedback form: introduction to database systems, introduction to database systems : assignment 5 is live now.

Dear Learners, The lecture videos for Week 5 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=47&lesson=48 The other lectures in 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). Practice Assignment-5 for Week-5 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=47&assessment=117 Assignment-5 for Week-5 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=47&assessment=130 The assignment has to be submitted on or before Wednesday,[01/03/2023], 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

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: February 17, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 4 Feedback Form: Introduction to Database Systems

Introduction to database systems - problem solving session recording is available.

Dear Learner, We have uploaded the Recorded videos of the Live Interaction Session - Problem solving Session of Week 1 . Videos are uploaded inside the Separate Unit called " Problem solving Session " along with the slides used wherever applicable. Login to the course on swayam.gov.in to check the same. -NPTEL Team

Introduction to Database Systems : Assignment 4 is live now!!

Dear Learners, The lecture videos for Week 4 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=39 The other lectures in 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). Practice Assignment-4 for Week-4 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=39&assessment=116 Assignment-4 for Week-4 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=39&assessment=129 The assignment has to be submitted on or before Wednesday,[22/02/2023], 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

Introduction to Database Systems : Problem solving Session

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: February 10, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Week 3 Feedback Form: Introduction to Database Systems

Reminder : introduction to database systems : live interaction 1 with course instructor .

Dear Learner, You can interact LIVE with the Course Instructors   Prof. Sreenivasa Kumar  of the course – Introduction to Database Systems Date: 06-02-2023 Time: 05:00 PM Link to login:  https://us02web.zoom.us/j/83223792434?pwd=cHdlR2FtVHJPREk1aU9WWFNSczRBUT09 Meeting ID: 832 2379 2434 Passcode: 112233   YouTube link : https://youtube.com/live/XICFCxAuhxE?feature=share Enter your questions you want Professor to answer a  https://docs.google.com/forms/d/1yq9u-x2o3VN2soavdtLx2FYzlPeNa1xPnJJZXFcqvSg/edit You can also ask your doubts during the session through the chat window. We would also like to hear from you after the session. we request you to share your thoughts in the forum. Learners are encouraged to visit bit.ly/NPTELLIVE for updates on the live sessions. Subscribe to " Interactive Sessions with IIT Profs - NPTEL " for Updates on our Live Sessions -NPTEL team

Introduction to Database Systems : Live interaction 1 with Course Instructor !!!

Dear learners, There will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Date: February 3, 2023 - Friday Time:06.00 PM - 08.00 PM Link to join: https://meet.google.com/edr-vddz-few Happy Learning. -NPTEL Team

Introduction to Database Systems : Assignment 3 is live now!!

Dear Learners, The lecture videos for Week 3 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=31&lesson=32 The other lectures in 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). Practice Assignment-3 for Week-3 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=31&assessment=115 Assignment-3 for Week-3 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=31&assessment=128 The assignment has to be submitted on or before Wednesday,[15/02/2023], 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

Dear learner, Every week there will be a live interactive session where a Course team member will explain some sample problems, how they are solved - that  will help you solve the weekly assignments. We invite you to join the session and get your doubts cleared and learn better. Start Date:   February 3, 2023 When: Every Friday Time: 06.00 PM - 08.00 PM Link to join:   meet.google.com/edr-vddz-few Thank you. -NPTEL Team

Week 2 Feedback Form: Introduction to Database Systems

Introduction to database systems : assignment 2 is live now.

Dear Learners, The lecture videos for Week 2 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=24&lesson=25 The other lectures in 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). Practice Assignment-2 for Week-2 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=24&assessment=114 Assignment-2 for Week-2 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=24&assessment=127 The assignment has to be submitted on or before Wednesday,[08/02/2023], 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

Week 1 Feedback Form: Introduction to Database Systems

Dear Learner Thank you for continuing with the course and hope you are enjoying it. We would like to know if the expectations with which you joined this course are being met and hence please do take 2 minutes to fill out our weekly feedback form. It would help us tremendously in gauging the learner experience. Here is the link to the form:  https://docs.google.com/forms/d/1Q3XWdYwWeBHBrsgvrm8FhF2nx1i5G9WctCF021cZWvM/viewform Thank you -NPTEL team

Introduction to Database Systems : Assignment 1 is live now!!

Dear Learners, The lecture videos for Week 1 have been uploaded for the course "Introduction to Database Systems" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=17&lesson=18 The other lectures in 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). Practice Assignment-1 for Week-1 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=17&assessment=113 Assignment-1 for Week-1 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=17&assessment=126 The assignment has to be submitted on or before Wednesday,[08/02/2023], 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

Introduction to Database Systems - Week-1 video is live now !!

Dear Learners, The lecture videos for Week 1 have been uploaded for the course “ Introduction to Database Systems ”. The lectures can be accessed using the following link: Link:  https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=17&lesson=18 The other lectures in 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 will be released shortly. As we have done so far, please use the discussion forums if you have any questions on this module. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Assignment 0 is live now!!

Dear Learners, We welcome you all to this course "Introduction to Database Systems". The assignment 0 has been released. This assignment is based on a prerequisite of the course. You can find the assignment in the link :   https://onlinecourses.nptel.ac.in/noc23_cs29/unit?unit=16&assessment=112 Please note that this assignment is for practice and it will not be graded. Thanks & Regards   -NPTEL Team

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

Dear Learner, 

Here is the much-awaited announcement on registering for the Jan 2023 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: Apr 29, 2023

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 Mar 17, 2023, 5:00 PM, Exam fees will be Rs. 1000/- per exam .

5. 50% fee waiver for the following categories: 

6. Last date for exam registration: Mar 17, 2023, 5:00 PM (Friday). 

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

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: Mar 17, 2023, 5:00 PM :  

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

6. What is your role ? 

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

11. LAST DATE FOR CANCELLING EXAMS and getting a refund: Mar 17, 2023, 5:00 PM  

12. Click here to view Timeline and Guideline : Guideline

Introduction to Database Systems: Welcome to NPTEL Online Course - Jan 2023!!

• 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: April 29, 2023  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

If You Are Facing Any Problem In Payment Then Email On : [email protected]

[week 1-12] nptel introduction to database systems assignment answers 2024.

About Course

This course will provide you with access to all 12 weeks of assignment answers for NPTEL Introduction to Database Systems . As of now, we have uploaded the answers of Week 1 to 12.

Note:- Buy this plan if you have not yet. Our answers will be visible to only those who buy this plan.

Course Content

Week 1 answers, week 1 assignment answers, week 2 answers, week 2 assignment answers 2024, week 3 answers, week 3 assignment answers 2024, week 4 answers, week 4 assignment answers 2024, week 5 answers, week 5 assignment answers 2024, week 6 answers, week 6 assignment answers 2024, week 7 answers, week 7 assignment answers 2024, week 8 answers, week 8 assignment answers 2024, week 9 answers, week 9 assignment answers 2024, week 10 answers, week 10 assignment answers 2024, week 11 answers, week 11 assignment answers 2024, week 12 answers, week 12 assignment answers 2024, student ratings & reviews.

Want to receive push notifications for all major on-site activities?

Insert/edit link

Enter the destination URL

Or link to existing content

404 Not found