introduction to database systems nptel assignment 2 answers 2023

Category: Nptel Assignment Answers 2024

Nptel database management system assignment 5 answers, ethical hacking nptel week 5 assignment answers, introduction to internet of things week 5 nptel answers, nptel introduction to industry 4 and industrial iot week 5 assignment answers, introduction to machine learning iit-kgp nptel week 5 assignment answers, digital circuits week 5 nptel assignment answers, problem solving through programming in c nptel week 5 assignment answers, programming in java nptel week 5 assignment answers, programming in modern c++ week 5 assignment answers, software engineering nptel week 5 assignment answers.

Data Base Management System | NPTEL 2023 | Week 4 Assignment Solutions

This set of MCQ(multiple choice questions) focuses on the  Data Base Management System NPTEL 2023 Week 4 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 2023 Week 4 Assignment Solution” contains 10 questions.

Now, start attempting the quiz.

Data Base Management System NPTEL 202 3 Week 4 Quiz Solutions

Q1. Consider the relational schema Office(Sector, Company, Building, Floor, Employees) with the following Functional Dependency set: {Sector, Company} -> {Building, Floor} {Company, Building} -> {Employee, Sector} Building -> Floor Which attribute is present in all the composite candidate keys of OfficeList?

a) Sector b) Company c) Building d) Floor

Answer: b) Company

Q2. Consider the relational schema: DeviceLogs(Device, OperatingSystem, Logins, DateOfRecord, DeviceLocation) with the following Functional Dependency set: {Device, OperatingSystem} -> DeviceLocation {Logins, DateOfRecord} -> OperatingSystem DeviceLocation -> DateOfRecord If X is the number of candidate keys of DeviceLogs and Y is its highest Normal Form, find the values of X and Y.

a) X=1, Y=2 b) X=2, Y=1 c) X=3, Y=3 d) X=2, Y=3

Answer: c) X=3, Y=3

Q3. Consider the relational schema DataLabelling(DataSetName, DataFeature1, DataFeature2, Label, Confidence, Annotators) with the following Functional Dependency set: DataSetName -> {Annotators, DataFeature2} {DataFeature1, DateFeature2} -> Label {Label, DataFeature1} -> Confidence DataFeature2 -> DataSetName Which attribute can NOT be derived directly or indirectly from DataFeature2?

a) DataSetName b) DataFeature1 c) Label d) Annotators

Answer: b), c)

Data Base Management System NPTEL 2023 week 1 Assignment Solutions

Q4. Consider the relational schema LuckyDraw(Box, Item, Picked, WinningPrize). Which of the following set of functional dependencies should be chosed so that LuckyDraw can be in 2NF but not in 3NF?

a) Box -> {Item, Price} Price -> WinningPrize Item -> Picked b) {Box, Item} -> Price Price -> WinningPrize Item -> Picked c) {Item, Box} -> Price {Item, Price} -> WinningPrize d) {Item, Box, Picked} -> Price {Item, Price} -> WinningPrize {WinningPrize, Price} -> {Item, Box}

Q5. Consider the relational schema Tournament(Champion, Category, Participants, Judges, Day) with the following Functional Dependency set F. {Category, Day} -> Champion {Category, Champion} -> {Participants, Judges} Day -> {Judges, Category} What is the canonical cover of F?

a) Category -> Champion Champion -> Participants Champion -> Judges Day -> Category b) Day -> Champion {Category, Champion} -> Participants {Category, Champion} -> Judges c) Day -> Champion {Category, Champion} -> Participants {Category, Champion} -> Judges Day -> Category d) {Category, Day} -> Champion {Category, Champion} -> Participants {Category, Champion} -> Judges Day -> {Judges, Category}

Q6. Consider the relational schema Gallery(GallerySection, ArtistID, ArtID, Sold, Theme) with the following functional Dependency set: {GallerySection, ArtistID} -> ArtID ArtID -> Sold {ArtID, ArtistID} -> Theme The relation is decomposed into the following: Gallery1(GallerySection, ArtistID, ArtID) Gallery2(GallerySection, ArtistID, Sold) Which of the following is true about the decomposition?

a) Both lossless and dependency preserving b) Neither lossless nor dependency preserving c) Lossless but not dependency preserving d) Lossy but dependency preserving

Q7. Consider the relational schema Gallery(GallerySection, ArtistID, ArtID, Sold, Theme) with the following functional Dependency sets: S1 = { {GallerySection, ArtistID} -> ArtID Sold -> {ArtID, Theme} } S2 = { GallerySection -> {ArtistID, ArtID} Sold -> {GallerySection, Theme} } Which of the following is true?

a) Neither S1 covers S2 nor S2 covers S1 b) S1 covers S2 but S2 does not cover S1 c) S2 covers S1 but S1 does not cover S2 d) Both S1 covers S2 and S2 covers S1

Q8. Consider the relational schema Gallery(GallerySection, ArtistID, ArtID, Sold, Theme) with the following functional Dependency set: {GallerySection, ArtistID} -> ArtID ArtID -> Sold {ArtID, ArtistID} -> Theme Which of the following is true?

a) Gallery has 1 candidate key and is in 1NF b) Gallery has 1 candidate key and is in 2NF c) Gallery has 2 candidate key and is in 3NF d) Gallery has 2 candidate key and is in 1NF

Q9. In a relation FurnitureStore(FurnitureNo, FurnitureType, Price, Width, Height, Weight, DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent of FurnitureNo and Weight together. Which of the following are the non-prime attributes of FurnitureStore?

a) FurnitureNo b) Height c) Weight d) DeliveryCharge

Answer: b), d)

Q10. In a relation FurnitureStore(FurnitureNo, FurnitureType, Price, Width, Height, Weight, DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent of FurnitureNo and Weight together. The highest normal form of FurnitureStore is n. If the highest normal form of the relation has to be increased to n+1, which of the following changes should be made in its current functional dependency set?

a) FurnitureNo and Weight together, should identify FurnitureType and Price b) Only Width, Height and Weight should identify the DeliveryCharge c) Only FurnitureType, Height and Weight shoulld identify the DeliveryCharge d) Only Weight should identify the Width and Height

Data Base Management System NPTEL 2022 Week 4 Assignment Solutions

Answer: a) 1NF

Data Base Management System NPTEL Week 4 Assignment Solutions

Answer: a), d)

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

>> Next- Data Base Management System Week 5 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

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

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 60 public repositories matching this topic..., kishanrajput23 / nptel-the-joy-of-computing-using-python.

Study materials related to this course.

• Updated Oct 27, 2023

kishanrajput23 / NPTEL-Programming-In-java

• Updated Apr 14, 2022

omunite215 / NPTEL-Programming-in-Java-Ultimate-Guide

I am sharing my journey of studying a course on Programming in Java taught by Prof.Debasis Samanta Sir IIT Kharagpur

• Updated Dec 4, 2023

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

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

• Updated Jul 24, 2024

progiez / nptel-assignmnet-answers

NPTEL Assignment Answers and Solutions 2024 (July-Dec). Get Answers of Week 1 2 3 4 5 6 7 8 8 10 11 12 for all courses. This guide offers clear and accurate answers for your all assignments across various NPTEL courses

• Updated Aug 24, 2024

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

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

• Updated Apr 20, 2023

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

avinashyadav16 / The-Joy-of-Computing-Using-Pyhton

12 Weeks long NPTEL Elective MOOC Course's codes, assignments and solutions. If you want to contribute and keep it updated with the new content, then please fork and raise pull request.

• 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 Jun 25, 2024

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

• Updated Jan 26, 2020

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

• Updated Apr 28, 2021

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

iamrudhresh / NPTEL-JAVA-PROGRAMMING

Welcome to the NPTEL "Programming in Java" course repository! This repository hosts a comprehensive collection of programming assignments, quizzes, and test solutions for the NPTEL "Programming in Java" course offered in the years 2024, 2022, and 2020.

• Updated Apr 18, 2024

TarunSehgal27 / NPTEL-JAVA-2020

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

• Updated Apr 23, 2020

NPTEL-Course / Google-Cloud-Computing-Foundations

Nptel Course Solution : Google Cloud Computing Foundations

• Updated Nov 19, 2020

Anmol-PROgrammar / SWAYAM-Programming_In_Java-NPTEL

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

• Updated Aug 19, 2021

lonebots / python-programming-joc-nptel

Python programming repository for NPTEL joy of computing course

• Updated Dec 21, 2020

CGreenP / NPTEL-Introduction-to-Programming-in-C-Assignment-4-Question-3

NPTEL Introduction to Programming in C Assignment 4 Question 3

• Updated Apr 7, 2024

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

• 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)

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

NPTEL Introduction to Database Systems Assignment 2 Answers 2024

• by QuizXp Team
• February 4, 2024 February 7, 2024

Hello learners In this article we are going to discuss NPTEL Introduction to Database Systems Assignment 2 Answers . All the Answers provided below to help the students as a reference, You must submit your assignment with your own knowledge and use this article as reference only.

About the course:-

Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard

NPTEL Introduction to Database Systems Assignment 2 Answers 2024:

1. An attribute of an entity can be both simple as well as multi-valued

Answer :- a

2. Only entity sets/types can have attributes associated with them.

Answer :- b

3. An attribute of an entity can be both composite as well as single-valued.

4. An attribute of an entity can be both composite as well as simple.

5. Consider the statements:

S1: The key of an entity type always consists of a single attribute.

S2: The key of an entity type may have more than one attribute.

S3: An entity type has exactly one key.

S4: An entity type may have more than one key.

   Which of the following is correct?

6. Suppose X is a composite attribute of an entity type and has three components – C1, C2 and C3, where only C2 is multi-valued. If domain    sets of C1, C2 and C3 have 5, 3, and 4 elements respectively, what is the size of the domain of X?

7. Suppose R is a relationship type with three participating entity types E1, E2, E3. If the number of entities in E1, E2 and E3 are 5, 10,    and 4, respectively, the cardinality of the set of all possible instances of R is:

8. Suppose ​ isPartOf ​ is a relationship type with two participating entity types ​ District ​ and State . ​ What is the appropriate cardinality ratio    for District:State?

9. Suppose ​ Author ​ is a relationship type with two participating entity types ​ Person ​ and ​ Book . What is the appropriate cardinality ratio for Person:Book?

10. Consider the binary relationship type ​ BiologicalMother​ between entity types ​ Person​ and Woman ​ . Suppose the cardinality ratio    (Person: Woman) constraint of the relationship is expressed using (min,max) notation as (u,v) on the line connecting Person    to BiologicalMother and (x,y) on the line connecting Woman to BiologicalMother, which one of the following is correct:

11. Suppose entity set A = {a,b,c,d,e} and entity set B = {w,x,y,z} and they participate in a relationship R and the instances in R    are: { (a,w), (b,w), (c,x), (d,x), (e,y) }. Which one of the following is correct?

12. A weak entity can exist even if it is not related to any other entity.

13. Key of an entity set can be determined by examining current entities in the set.

14. A weak entity type can not be the owner of another weak entity type.

15. Weak entity type participates partially in the relationship that connects it to its owner.

16. Consider the following sets:

C = { p: weak entity type; q: multi-valued attribute; r: derived attribute: s: relationship type}

D = { w: dashed-line ellipse; x: diamond box; y: double-line rectangle; z: double-line ellipse}

   The correct match between elements of C and D is

NPTEL Data Base Management System Assignment 1 Answers 2023

NPTEL Data Base Management System Assignment 1 Answers: 2023 – All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.

NPTEL Data Base Management System Week 1 Assignment Answers 2023

1. Which of the following statements is (are) correct?

• a) Phsical level abstraction describes how a record is stored.
• b) View level abstraction hides details of data types.
• c) Physical level abstraction describ e s data stored in a database and their relationships.
• d) Logical level abstraction defines the physical schema.

2. Consider the following relations:

Subject (sid, sn a me, credit) Faculty (fid, sid) Which of the following is correct?

• a) RA 1 C RAz
• b) RAg C RAg
• c) RAI C RA g
• d) RA1 = RAg

3. What does the following Relational Algebra expression return?

• a) All heights except the maximum height from Mountain relation.
• b) All heights except the minimum height from Mountain relation.
• c) Minimum height from Mountain relation.
• d) Maximum height from Mountain relation.

4. Consider the relational schema PhoneBook (Name, PhoneNo, Location, LastCalled)

• Ankit 3222265783 Kolkata 15 Ju l
• Shreya 3222265783 Delhi 16 Jul
• Ankit 2222586110 Delhi 16 Jul
• Shreya 2222586110 K olkata 15 Jul

5. Consider the relation Flight (FlightNo, Source, Destination, Duration) where {FlightNo} and {Source, Destination, Duration} are the 2 candidate keys. What is the possible num- ber of superke y s of Flight?

6. Consider a truth table having the following columns P Q R= ((P V Q) – -P) S= ( (P V Q) – P) If the truth table, with all the values, is represented as a relational instance, which column(s) (attribute(s)) should be chosen as candidate keys?

7. Consider the following instance of ChatBox (SenderID, ReceiverID).

8. Consider the following table:

9. Consider the following table:

10. Which of the following can be a candidate k e y for the following instance?

About Data Base 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. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain. CRITERIA TO GET A CERTIFICATE Average assignment score = 25% of average of 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 score = Average assignment score + Exam score YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100. You can find Data Base Management System Assignment 1 Answers below.

NPTEL Data Base Management System Assignment 1 Answers July 2022

1. Identify the correct statement (s).

2. A relation R has 2 candidate keys withl and 2 attributes respectively. There are 40 super keys of R. What is the total number of attributes in R? a) 3 b) 4 c) 5 d) 6

Answers will be Uploaded Shortly and it will be Notified on Telegram, So  JOIN NOW

3. Which of the following relational operations will produce the following tuple only? a) (QB1 U QB2) x (QB2 U QB1) b) (QB1-QB2) n (QB2 QB1) c) (QB1 QB2) x (QB2 QB1) d) (QB1 n QB2) – (QB2 n QB1)

4. Which of the following is a Secondary Key in CelestialReport? a) {ReportBy, ReportScore}. b) {ReportBy, GroupLead}. c) {CroupLead, Celestial0bject}. d) {ReportScore, GroupLead}

5. Consider the following relational schema for a university: student (roll.no, name, dob) dept (deptNo, dName, location) project (proj-no, deptNo, rOllno, pName) What is the type of the key(s) that will be used to uniquely identify an entity of the project relation? a) simple key b) Alternate Key C)Composite Key d) Compound key

6. ldentity the correct relational algebraic expression for the following query: Find the names of students uho have selected any project offered by the department “CSE”. a) ||name ( (student a project) bM lHdeptNo dName= “CSE” (dept) )) b) ||name (aName=” “CSE” (dept project)) ) c) ||name (o dName=* “CSE” (student ba dept) ba (project) ) d) ||name (student ba (aName= “CSE” (project) ))

👇 For Week 02 Assignment Answers 👇

7. ldentify the correct operation(s) which will produce the following output from the above two relations. a) R1 R2 b) R2- -R1 c) (R1 UR2) n (Ri n Ra) d) (R1-R2) U (Ra- R)

8. ldentity the correct operation(s) which produces the following output from the above relation. a) ||(YEAR_PUB=2010) v (TOTAL SOLD_COPIES >15000) (BookDetalls) b) ||YEARPUB=2010) A (TOTAL.SOLD.cOPIES > 15000) (BookDetails) c) (YEAR_PUB=2010) v (TOTAL SOLD COPIES > 15000) (BookDetails) d) (YEARPUB=2010) (TOTAL SOLD.COPIES > 15000) (BookDetails)

9. Consider the following instannce:

10. Which of the following can be a candidate key for the following instance? a) (BOOKID, YEAR PUB} b) {BOOK_ID, BOOK TITLE} c) {BOOKTITLE, AUTHOR NAME} d) {B0OK_ID}

NPTEL Data Base Management System Assignment 1 Answers 2022: All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.

For More NPTEL Answers:-  CLICK HERE Join Our Telegram:-  CLICK HERE

NPTEL Data Base Management System Assignment 1 Answers Jan 2022

Q1. Identify the correct statement(s) from the following.

a) The overall physical structure of the database is called physical schema. b) The actual content of the database at a particular point in time is called an instance. c) Data dictionary does not contain any database schema. d) Physical schema describes how data is stored in the database and the relationships among the data.

Answer:- (A), (B)

Q2. Consider the following instance:

Identify the correct representation of MLDatabase schema.

a) MLDatabase (Model, Accuracy. Dataset, TrainingData). b) MLDatabase (Model, Accuracy, Datanet, TrainingData). c) MLDatabase (Model, Accuracy, Dataset, TrainingData). d) MLDatabase (Model, Accuracy, Dataset, TrainingData).

Answer:- (A)

Q3. Identify the incorrect statement(s).

a) A Super Key is a set of one or more attributes that, taken collectively, allows us to uniquely identify an entity in the entity set. b) A proper subset of a candidate key is called a Super Key. c) The minimal set of attributes that allows us to uniquely identify an entity in the entity set is called a candidate key. d) A proper subset of a Super Key is not always a Candidate Key.

Answer:- (B)

Q4. Consider two relations below. The primary keys are underlined. Identify all possible foreign key (s) from the options. Employee (EmpID, Enano, Salary) where EmpID is of type integer, Ename is of type string. and Salary is of type decimal number. Project (EmpID, Pnumber) where ExpID is of type integer, and Pnumber is of type string.

a) Ename b) EmpID c) Paunber d) EmpID, Pnumber

Q5. Consider the following instance of ImageRec (31. DepthImage, Coordi, Coord2))

Which of the following is a Secondary Key in InageRec?

a) (S1. Depth Image). b) (Coord1, Coord2). c) (Coord2, DepthImage). d) (Coord1. DepthImage).

Answer:- (C)

Q6. Consider the following instances:

How many tuples will be selected by aplayer=Gamer (Game1 x Game2) ?

a) 3 b) 4 c) 8 d) 9

Q7. Consider the two tables given below.

Identify the correct statement from the following.

a) Cartesian product of Student and Teacher has six tuples b) Cartesian product of Student and Teacher is not possible. c) There will be three tuples in the result of the natural join between Student and Teacher. d) Natural Join between Student and Teacher is not possible.

Answer:- (D)

Q8. Consider the following table:

Identify the correct operation(s) which produces the following output from the above relation.

a) II (Branch-Address) (Salary>10000) (EmployeeDetails) b) II (Branch-Address) v (Salary>10000) (EmployeeDetails) c) (Branch-Address) (Salary>10000) (EmployeeDetails) d) (Branch-Address) v (Salary>10000) (EmployeeDetails)

Q9. Consider the following tables:

Identify the correct operation(s) which will produce the following output from the above two relations.

a) R₁-R₂ b) R 2 -R 1 c) (R 1 UR₂) ∩ (R 1 ∩R₂) d) (R 1 -R₂) U (R₂-R₁)

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

a) {EmpName} b) (Branch) c) (EmpName, Address) d) (Emplame, Branch)

Answer:-(D)

READ IT ALSO:-

NPTEL English Literature for competitive exams Assignment 1 Answers

NPTEL Data Analytics with Python Assignment 1 Answers 2022

NPTEL Introduction To Internet Of Things Assignment 1 Answers

NPTEL Cloud Computing Week 1 Assignment Answers 2022

NPTEL Python for Data Science Assignment 1 Answers 2022

NPTEL The Joy of Computing using Python Assignment 1 Answers

NPTEL Data Base Management System Assignment 1 Answers:- All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.

Leave a Comment Cancel reply

You must be logged in to post a comment.

Please Enable JavaScript in your Browser to Visit this Site.

Please do not message repeatedly. You will get the answer before the deadline.

[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 (free), 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.

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

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

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

Dear Candidate, Here is a golden opportunity for those who had previously enrolled in this course, 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 2023 and we are giving you another chance to write the exam in April 2023 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: April 29,2023 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 the exam will be conducted:  Exam Cities 4. You DO NOT have to re-enroll in the courses if you have enough assignment scores in the previous immediate semester when the course was run to obtain a certificate.  5. You DO NOT have to resubmit Assignments in the previous semester if you have enough assignment scores in the previous immediate semester when the course was run to obtain a certificate.  6. If you do enroll to Jan 2023 course, we will take the best average assignment scores across this  semester & the immediate previous semester when the course was run.     NOTE:   Please check once if you have >= 40/100  in average assignment score that were conducted in this course to become eligible for the e-certificate, wherever applicable. If not, please submit assignments again in the Jan 2023 course to become eligible for the e-certificate. We will not be having new assignments in the previous semester's course. It is mandatory to enroll again in the Jan 2023 semester if you want to receive the fresh assignments of this current Jan 2023 semester. You can also submit assignments again if you want to take fresh assignments or need to improve your previous scores.   RECOMMENDATION: If you want to take new assignments or brush up on your lessons for the exam, please enroll in the Jan 2023 course.   LINK to enroll in the current course:    https://onlinecourses.nptel.ac.in/noc23_cs29/preview   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:    Students belonging to the SC/ST category: please select Yes for the SC/ST option and upload the correct Community certificate.   Students belonging to the PwD category with more than 40% disability: please select Yes for the option and upload the relevant Disability certificate.      6. Last date for exam registration: 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 if you are registering for the exam with the same email ID.     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: -    REMOVE unpaid courses from the cart And/or - CANCEL paid courses    1. Do you come under the SC/ST category? *  2. SC/ST Proof  3. Are you a person with disabilities? *  4. Are you a person with disabilities above 40%?  5. Disabilities Proof  6. What is your role ?    Note: Once you remove or cancel a course, you will be able to edit these fields immediately.  But, for cancelled courses, refund of fees will be initiated only after 2 weeks.    11. LAST DATE FOR CANCELLING EXAMS and getting a refund: Mar 17, 2023, 5:00 PM     12. Click here to view Timeline and Guideline : Guideline   Domain Certification Domain Certification helps learners to gain expertise in a specific Area/Domain. This can be helpful for learners who wish to work in a particular area as part of their job or research or for those appearing for some competitive exam or becoming job ready or specialising in an area of study.     Every domain will comprise Core courses and Elective courses. Once a learner completes the requisite courses per the mentioned criteria, you will receive a Domain Certificate showcasing your scores and the domain of expertise. Kindly refer to the following link for the list of courses available under each domain: https://nptel.ac.in/domains   Outside India Candidates Candidates who are residing outside India may also fill the exam form and pay the fees. Mode of exam and other details will be communicated to you separately.   Thanks & Regards,  NPTEL TEAM

Thank you for learning with NPTEL!!

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

Introduction to Database Systems : Result Published!

Dear Candidate, The exam scores and E Certificates have been released for April 2022 Exam(s). Step 1 - Are the results of my courses released? Please check the Results published courses list in the below links.:- April 2022 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 2022, irrespective of which Assignment score that will be considered. Thanks and Best wishes. NPTEL Team

Introduction to Database Systems : Final Feedback Form

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

NPTEL April Exams

Dear Leaner,

_NPTEL Team

Hall Tickets for April Exams are released !

• If there are any mistakes in the hall ticket such as another person's photo/sign/name, please fill the following Google form & mark the corrections.
• GForm Link -  https://forms.gle/aqeMCN15MpnTQPpV9 (Deadline - April 22, 2022 at 11.00 AM)
• These corrections will be reflected in your e-certificate only.
• No changes will be made in the hall ticket.
• We will check and verify the same and send an email confirmation.
• You will still be allowed to write the exam. We will NOT make any changes in the hall ticket issued to you. Please come to the exam centre with the printout of the same hall ticket, along with a valid govt. approved photo id card.
•  If the photo/sign/name is yours, we WILL NOT upload any updated photo/sign, etc.
•  Requests for changes in exam city, exam center, session, or course will NOT be entertained.

Introduction to Database Systems : Reevaluation!!

Dear Learners, Assignment 6 submission of all students has been reevaluated by making the weightage as 0 question number 4.  Students are requested to find their revised scores of Assignment 6 on the Progress page. -NPTEL

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

Dear Learner, You can interact LIVE with the Course Instructor Prof. Sreenivasa Kumar, IIT Madras of the course – Introduction to Database Systems Date: 18-04-2022 Time: 4:00 PM Link to login:  https://iitmadras.webex.com/iitmadras/j.php?MTID=ma7b000bec7983869fcb951985bc737ec Meeting ID: 2644 248 0679 Passcode: 1234 Enter your questions you want Professor to answer at  https://docs.google.com/forms/d/e/1FAIpQLSe_hmDLe3vSGXqKWvdV5IKuOA5rGDgCmkqA2pZtrOROlc32Fg/viewform 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

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

Introduction to Database Systems : Week 12 Feedback Form

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/1gkA3gJE8jAwtPe3jN6iRLdMq8B3Ydcap3jjsVm4FSS0/viewform Thank you. -NPTEL team

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

Dear Learner, You can interact LIVE with the Course Instructor Prof. Sreenivasa Kumar, IIT Madras of the course – Introduction to Database Systems Date: 11-04-2022 Time: 4:30 PM Link to login:  https://iitmadras.webex.com/iitmadras/j.php?MTID=mcc04191b547b2b0b24ebec32acca8221 Meeting ID: 2644 640 3043 Passcode: 1234 Enter your questions you want Professor to answer at  https://docs.google.com/forms/d/e/1FAIpQLSd6cfC-k8A5uDKhXBctStWueKSg46cShnMK_KEMn8IxiceeWQ/viewform 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 : Week 12 content 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/noc22_cs57/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- for Week 12 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=99&assessment=120 Assignment-12 for Week 12 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=99&assessment=133 The assignment has to be submitted on or before Wednesday,[20/04/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 11 Feedback Form

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/noc22_cs57/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- for Week 11 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=91&assessment=119 Assignment-11 for Week 11 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=91&assessment=132 The assignment has to be submitted on or before Wednesday,[13/04/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Exam Format - April 23, 2022

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

Introduction to Database Systems : Week 10 Feedback Form

Introduction to database systems : week 10 content 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/noc22_cs57/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- for Week 10 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=84&assessment=118 Assignment-9 for Week 10 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=84&assessment=131 The assignment has to be submitted on or before Wednesday,[06/04/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 9 Feedback Form

Introduction to database systems : week 9 content 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/noc22_cs57/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- for Week 9 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=76&assessment=117 Assignment-9 for Week 9 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=76&assessment=130 The assignment has to be submitted on or before Wednesday,[30/03/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 8 Feedback Form

Introduction to database systems : week 8 content 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/noc22_cs57/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/noc22_cs57/unit?unit=69&assessment=116 Assignment-8 for Week 8 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=69&assessment=129 The assignment has to be submitted on or before Wednesday,[23/03/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 7 Feedback Form

Introduction to database systems : week 7 content 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/noc22_cs57/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/noc22_cs57/unit?unit=62&assessment=115 Assignment-7 for Week 7 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=62&assessment=128 The assignment has to be submitted on or before Wednesday,[16/03/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 6 Feedback Form

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/1gkA3gJE8jAwtPe3jN6iRLdMq8B3Ydcap3jjsVm4FSS0/viewform Thank you. _NPTEL team

Introduction to Database Systems : Week 6 content 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/noc22_cs57/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_5 for Week 6 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=54&assessment=114 Assignment-6 for Week 6 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=54&assessment=127 The assignment has to be submitted on or before Wednesday,[09/03/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, _NPTEL Team

Introduction to Database Systems : Week 5 Feedback Form

Introduction to database systems : week 5 content 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/noc22_cs57/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/noc22_cs57/unit?unit=47&assessment=113 Assignment_5 for Week 5 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=47&assessment=126 The assignment has to be submitted on or before Wednesday,[02/03/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, _NPTEL Team

Introduction to Database Systems : Week 4 Feedback Form

Introduction to database systems : week 4 content 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/noc22_cs57/unit?unit=39&lesson=40 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/noc22_cs57/unit?unit=39&assessment=112 Assignment-4 for Week 4 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=39&assessment=125 The assignment has to be submitted on or before Wednesday,[23/02/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 3 Feedback Form

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

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

Introduction to Database Systems : Week 3 content 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/noc22_cs57/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/noc22_cs57/unit?unit=31&assessment=111 Assignment-3 for Week 3 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=31&assessment=124 The assignment has to be submitted on or before Wednesday,[16/02/2022], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 2 Feedback Form

Introduction to database systems - week-2 content 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/noc22_cs57/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/noc22_cs57/unit?unit=24&assessment=110 Assignment- 2 for Week-2 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=24&assessment=123 The assignment has to be submitted on or before Wednesday,[09/02/2022], 23:59 IST . As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Introduction to Database Systems : Week 1 Feedback form

Attention: regarding the social media groups.

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

Introduction to Database Systems - Week-1 content 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/noc22_cs57/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/noc22_cs57/unit?unit=17&assessment=109 Assignment-1 for Week-1 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc22_cs57/unit?unit=17&assessment=122 The assignment has to be submitted on or before Wednesday,[09/02/2022], 23:59 IST . As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

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/noc22_cs57/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/noc22_cs57/unit?unit=16&assessment=121   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 2022 courses!

Dear Learner, 

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

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

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

3 . Date of exam: April 23, 2022

CLICK HERE to register for the exam.

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

4. Exam fees: 

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

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

5. 50% fee waiver for the following categories: 

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

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

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

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

8. HALL TICKET: 

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

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

10. Data changes: 

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

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

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

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

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

2. SC/ST Proof 

3. Are you a person with disabilities? * 

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

5. Disabilities Proof 

6. What is your role ? 

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

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

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

12. Click here to view Timeline and Guideline : Guideline  

Domain Certification

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

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

Thanks & Regards, 

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

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

A project of

In association with