dbms assignment nptel

• Announcements
• Explore Courses

Database Management System

27562 students have enrolled already!!

In association with

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

Here are 64 public repositories matching this topic..., kishanrajput23 / nptel-the-joy-of-computing-using-python.

Study materials related to this course.

• Updated Oct 27, 2023

souraavv / NPTEL-DAA-Programming-Assignment-Solutions

Programming assignments of NPTEL DAA course taken by Prof. Madhavan Mukund of Chennai Mathematical Institute.

• Updated Dec 8, 2022

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 Sep 6, 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

rvutd / NPTEL-Joy-of-Computing-2020

Programming Assignment Solutions

• Updated May 5, 2020

guru-shreyansh / NPTEL-Programming-in-Java

The sole intention behind this repository is to help the beginners in Java with the course contents.

• Updated Aug 1, 2021

biophilic16 / NPTEL-Answers

Nptel assignment answer for Java Programming.

• Updated Apr 12, 2024

roopeshsn / embedded-system-design-nptel

Embedded System Design Course Materials - NPTEL

• Updated May 6, 2022

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

12 Weeks long NPTEL Elective MOOC Course's codes, assignments and solutions.

• Updated Oct 30, 2023
• Jupyter Notebook

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

• Updated Jan 26, 2020

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

• Updated Apr 28, 2021

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

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

• Updated Jun 25, 2024

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

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

• Updated Nov 30, 2020

ShishiraB / Programming-Data-Structures-And-Algorithms-Using-Python

This is a repository where i have tried to give explaination

• Updated Mar 1, 2023

NPTEL-Course / Google-Cloud-Computing-Foundations

Nptel Course Solution : Google Cloud Computing Foundations

• Updated Nov 19, 2020

code-reaper08 / NPTEL-Practice-Repo

Practice repo for NPTEL 📚 Programming, Data Structures and Algorithms.

• Updated Aug 27, 2021

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

lonebots / python-programming-joc-nptel

Python programming repository for NPTEL joy of computing course

• Updated Dec 21, 2020

Improve this page

Add a description, image, and links to the nptel-assignments 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-assignments topic, visit your repo's landing page and select "manage topics."

Category: NPTEL

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

DOWNLOAD APP

SWAYAM SUPPORT

Please choose the SWAYAM National Coordinator for support. * :

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.