nptel dbms assignment 1 answers 2020

• Week0 Assignment
• Week1 Assignment
• Week2 Assignment
• Week3 Assignment
• IO Operations
• Typecasting
• Conditional Statements
• Loop Statements
• Break Continue

• Files Function & Methods
• Command-Line Arguments
• File System
• Exception handling
• Raise & Assert Statement
• Regular Expressions
• RegEx Module

Week 1:Assignment 1

a. int b. boolean c. String d. char

Show Answer

    a) Physical level abstraction describes how a record is stored.     b)View level abstraction hides details of data types.

    b) RA 2 c_ RA 1

    b) All heights except the minimum height from Mountain relation.

    b. 9

    b) {P,Q}

    d) (Altitude>=7750) (

    c) (MountainDetails 1 U MountainDetails 2 ) n (MountainDetails 1 n MountainDetails 2 )

    b) {MountainName}

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

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

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

• Updated Apr 28, 2021

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

• Updated Jan 26, 2020

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

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

• Updated Oct 30, 2023
• Jupyter Notebook

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

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

• Updated Nov 30, 2020

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

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

• Updated Oct 26, 2021

TarunSehgal27 / NPTEL-JAVA-2020

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

• Updated Apr 23, 2020

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

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

Gangaduraie / Introduction-to-IoT-and-Industry-4.0

NPTEL- Introduction to IoT and Industry 4.0

• Updated Jan 27, 2024

CGreenP / NPTEL-Programming-Assignment-Road-Trips-and-Museums

NPTEL Programming Assignment: Road Trips and Museums.

• Updated Mar 3, 2024

Improve this page

Add a description, image, and links to the nptel-solutions topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the nptel-solutions topic, visit your repo's landing page and select "manage topics."

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

Data Base Management System Assignment 1 Answers 2022 | Week 1 Answers: QUIZXP

• by QuizXp Team
• January 22, 2022 January 23, 2022

Are you looking for the Answers to NPTEL Data Base Management System Assignment 1 – IIT Delhi? This article will help you with the answer to the  Nation al Programme on Technology Enhanced Learning  ( NPTEL )  Course “ Data Base Management System Assignment 1 “

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

While DBMS’s differ in the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation.

CRITERIA TO GET A CERTIFICATE

Average assignment score = 25% of the 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 THE 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.

Below you can find the answers for Data Base Management System Assignment 1

Data Base Management System Assignment 1 Answers:-

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

Answer:- a,b

Q2. Consider the following instance:

Q3. Identify the incorrect statement(s).

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.

???? Next Week Answers: Assignment 02 ????

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

Q6. Consider the following instances:

Q7. Consider the two tables given below.

Q8. Consider the following table:

Q9. Consider the following tables:

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

For other courses answers:- Visit

For Internship and job updates:- Visit

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. While DBMS’s differ in the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, 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.

Note: This exam date is subjected to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits

Course layout, books and references, instructor bio.

Prof. Partha Pratim Das

Prof. Samiran Chattopadhyay

Course certificate.

DOWNLOAD APP

SWAYAM SUPPORT

Please choose the SWAYAM National Coordinator for support. * :

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

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

Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.

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

Course layout (Answers link)

Answers COMING SOON! Kindly Wait!

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

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

Now, start attempting the quiz.

Data Base Management System NPTEL 2022 Week 0 Assignment Solutions

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

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

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

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

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

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

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

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

Answer: d) (5,5)

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

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

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

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

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

Answer: b) {0, 2}

Data Base Management System NPTEL Assignment Solutions

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

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

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

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

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

Answer: b), c)

Q8. Look at the following truth table

Which binary operation has been carried out?

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

Answer: b) ¬ (P v Q)

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

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

Answer: d) S is an equivalence relation

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

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

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

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

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

Answer: a), c)

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

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

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

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

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

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

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

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

Answer: b) 3, 1, 2

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

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

Answer: b) 8

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

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

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

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

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

Answer: c) 275

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

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

Answer: b) reflexive and symmetric

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

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

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

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

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

Answer: d) 512

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

NPTEL answers: Problem solving through programming in C

Programming in Java NPTEL week 1 quiz answers

NPTEL – Python for Data Science assignment solutions

Nptel – Deep Learning assignment solutions

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

Thanks in advance.

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

Related Posts

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

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

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

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

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

• C - Programming
• Data Mining
• Neural Networks
• Deep Learning
• JAVA SCRIPT

• Item 3 Subitem 1 Subitem 1 a Subitem 2 b Subitem 3 c Sub sub item 1 Sub sub item 2 Subitem 4 d Subitem 2 Subitem 3
• Subitem 1 Subitem 2 Subitem 3

NPTEL - Programming in Java - QUIZ : Week 1:Assignment 1 - 2022

☞ Programming in Java NPTEL QUIZ : Week 1: Assignment 1 - 2022

QUIZ : Week 1:Assignment 1 - NPTEL >> Programming In Java - 2022