nptel database management system assignment 6 answers

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

Study materials related to this course.

• Updated Nov 18, 2022

kishanrajput23 / NPTEL-Programming-In-java

• Updated Apr 14, 2022

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

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

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

• Updated Aug 24, 2023

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

• Updated Apr 28, 2021

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

• Updated Jan 26, 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

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

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

• Updated Jul 27, 2023

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

Rahulnisanth / python-journey

Complete Python codes practiced in my Zero to Mastery Journey

• Updated Aug 28, 2023

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

NPTEL-Course / Google-Cloud-Computing-Foundations

Nptel Course Solution : Google Cloud Computing Foundations

• Updated Nov 19, 2020

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

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

• Updated Nov 30, 2020

lonebots / python-programming-joc-nptel

Python programming repository for NPTEL joy of computing course

• Updated Dec 21, 2020

Bigblue00 / Joy-of-computing-using-python-NPTEL

• Updated Sep 25, 2019

sibashish99 / NPTEL-JAVA-ASSESMENT

• Updated Mar 22, 2021

tg-100 / Popular-Gothic-Novel-NPTEL

This repo will help you with the assignment solutions to NPTEL's 12-week long Popular Gothic Novel course.

• Updated Nov 3, 2022

satvikchachra / NPTEL-Prep

Joy of Computing using Python

• Updated Nov 21, 2019

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

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.

• Computer Science and Engineering
• NOC:Data Base Management System (Video) 
• Co-ordinated by : IIT Kharagpur
• Available from : 2017-12-21
• Intro Video
• Lecture 1: Course Overview
• Lecture 2 : Introduction to DBMS/1
• Lecture 3 : Introduction to DBMS/2
• Lecture 4 : Introduction to Relational Model/1
• Lecture 5 : Introduction to Relational Model/2
• Lecture 6 : Introduction to SQL/1
• Lecture 7 : Introduction to SQL/2
• Lecture 8 : Introduction to SQL/3
• Lecture 9 : Intermediate SQL/1
• Lecture 10 : Intermediate SQL/2
• Lecture 11 : Advanced SQL
• Lecture 12 : Formal Relational Query Languages
• Lecture 13 : Entity-Relationship Model/1
• Lecture 14 : Entity-Relationship Model/2
• Lecture 15 : Entity-Relationship Model/3
• Lecture 16 : Relational Database Design
• Lecture 17 : Relational Database Design (Contd.)
• Lecture 18 : Relational Database Design /3
• Lecture 19 : Relational Database Design (Contd.)
• Lecture 20 : Relational Database Design /5
• Lecture 21: Application Design and Development/1
• Lecture 22: Application Design and Development/2
• Lecture 23: Application Design and Development/3
• Lecture 24: Storage and File Structure/1: Storage
• Lecture 25: Storage and File Structure/2: File Structure
• Lecture 26 : Indexing and Hashing/1 : Indexing/1
• Lecture 27: Indexing and Hashing/2 : Indexing/2
• Lecture 28 : Indexing and Hashing/3 : Indexing/3
• Lecture 29 : Indexing and Hashing/4 : Hashing
• Lecture 30 : Indexing and Hashing/5 : Index Design
• Lecture 31: Transactions/1 : Serializability
• Lecture 32 : Transactions/2 : Serializability
• Lecture 33 : Transactions/3 : Recoverability
• Lecture 34 : Concurrency Control/1
• Lecture 35 : Concurrency Control/2
• Lecture 36 : Recovery/1
• Lecture 37 : Recovery/2
• Lecture 38 : Query Processing and Optimization/1 : Processing
• Lecture 39 : Query Processing and Optimization/2 : Optimization
• Lecture 40 : Course Summarization
• Live Session
• Live Session - 2
• Live Session 30-08-2021
• Live Session 21-09-2021
• Live Session 18-02-2021
• Live Session 09-03-2021
• Live Session 20-10-2020
• Live Session 11-11-2020
• Live Session 04-03-2020
• Live Session 19-03-2020
• Live Session 12-09-2019
• Live Session 23-09-2019
• Watch on YouTube
• Assignments
• Download Videos
• Transcripts
• Lecture Notes (1)

[Week 4] NPTEL Data Base Management System Assignment Answers 2023

Share your love.

NPTEL Data Base Management System Assignment Answers

Table of Contents

NPTEL Data Base Management System Week 4 Assignment Answers 2023

1. Consider the relational schema OfficeList (Sector, C o mpany, Building, Floor, Employees)with the following Functional Dependency set: {Sector, Company} -> Building, Floor} {Company, B u ilding} – {Employees, Sector} Building > Floor Which attribute is present in all the composite candi d ate kevs of OfficeList? a) Sector b) Com p any c) Building d) Floor

2. Consider the relational schema: DeviceLogs (Device, OperatingSystem, Logins, DateOfRecord, DeviceLocation) with the following Functional Dependency set: {Device, OperatingSystem} -› DeviceL o cation {Logins, Date0fRecord] – OperatingSystem DeviceLocation -› DateOfRecord If X is the number of candidate keys of DeviceLogs and Y is its highest N ormal 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

3. Consider the relational schema DataLabelling (DataSetName, DataFeatu r e1, DataFeature2, Label, Confidence, Annotators) with the following Functional Dependency set:

All Answers are locked.

All Answers are uploaded but locked by owner. Sign Up & Buy our Plans or Login to unlock these Answers.

NPTEL Data Base Management System Week 3 Assignment Answers 2023

1. Consider the relation Payments as follows:

a) UPI b) Cash c) NEFT d) Card

2. Consider the relation Payments as follows:

Which of the TransactionIDs will NOT be present in the output of R1-R2? a) 42 b) 15 c) 14 d) 4

3. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes). Choose the correct Tuple Relational Calculus that represents the following statement: “Display the titles of those videos that are published on You Tube Channels and have more than 50,000 likes.”

4. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes). Choose the correct Domain Relational Calculus that is equivalent to the following SQL Query: SELECT Channel, VideoTitle FROM Content WHERE Dislikes<100; a) {< c,v > |31, d(< c,v, 1,d >€ Content ^ d < 100)} b) {c,v|3c,v, 1, d(< c,v, 1, d >€ Content ^ Dislikes < 100)} c) {< c,v > 3c,v,1,d € Content ^ d < 100} d) {c,v|3 < 1, >€ Content ^ Dislikes < 100}

5. A C program, with embedded SQL query, allows the users to enter a date and an amount to check the transactions that were made on that day. The entered date is stored in the variable Idate and the amount in variable amt. The SQL query returns the TransactionID and Amount of those payments from Payments (Mode, TransactionID, PaymentDate, Amount) whose PaymentDate match with the user’s entered date and the Amount is more than the entered amount. Which of the following SQL queries is correct for the purpose?

a) EXEC SQL DECLARE c CURSOR FOR SELECT TransactionID, Amount FROM Payments WHERE PaymentDate= :Tdate AND Amount>: amt END EXEC b) EXEC SOL DECLARE c CURSOR FOR SELECT * FROM Payments WHERE PaymentDate= Tdate AND Amount>amt END EXEC c) EXEC SOL DECLARE c CURSOR FOR SELECT * FROM Payments WHERE Tdate=PaymentDate AND amt>Amount d) EXEC SQL DECLARE c CURSOR FOR SELECT TransactionID, Amount FROM Payments WHERE : PaymentDate= :Tdate AND : Amount>: amt END EXEC

6. A cloth factory maintains a schema of manufactured Clothes where each clothing item is identified by a tag. The clothes are also associated with corresponding sizes and materials. However, each cloth can be designed by multiple designers. Which of the following schema correctly represents the Clothes entity set? a) Clothes (Tag, Size, Material, Designer) b) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer) c) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer) d) Clothes (Tag, Size, Material), Clothes Designer (Tag, Designer)

7. Consider the three relational schemas: Stories (Title, Author, Pages, StoryCount) Books (Title, Author, Pages) Educational (Title, Author, Pages, Subject) Which of the Entity Relationship diagrams correspond to the given schemas?

8. Consider the Entity Relationship Diagram:

Which of the following is/are true? a) The participation of Organizer in Org.Conf is partial. b) The participation of Conference in Org-Conf is partial. c) Presenter is a composite attribute of Presentation. d) Presenter is a multivalued attribute of Presentation.

9. Consider the entity relationship diagram.

10. Consider the following instance of organizer.

NPTEL Data Base Management System Week 2 Assignment Answers 2023

1. Consider two relations StyleName and PrintStyle as follows: An operation θ between StyleName and PrintStyle will generate the following output: Identify the operation G. a) natural join b) natural left outer join c) natural right outer join d) natural full outer join

2. Consider the following CREATE statements:

3. Consider the following schema:

• loan (loan _number, branch_name, amount)

4. Consider the following instance of the relation BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)

5. Consider the following instance of the relation BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)

6. Consider the following instance of the relational schema PAYSCALE (POSITION, BASE_SALARY, EXPERIENCE)

7. A role Manager has the privilege to perform select, insert, update and delete operations on all tables of database. A new role Software_Engineer is created and the following statement is executed.

8. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation.

9. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)

10. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)

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?

Related Posts

NPTEL Advanced Computer Networks Week 1-2 Assignment Answer 2023

NPTEL AI:Constraint Satisfaction Assignment Answer (Week 1-2) 2023

NPTEL Design and Analysis of Algorithms Assignment Answer 2023 (week 1-4)

NPTEL Applied Accelerated Artificial Intelligence Assignment Answer (week 1-3) 2023

NPTEL Customer Relationship Management Assignment Answer (week 1-2) 2023

NPTEL Integrated Waste Management For A Smart City Assignment Answer (week 1-2) 2023

NPTEL Plastic Waste Management Assignment Answer (week 1-2) 2023

NPTEL Social Networks Assignment Answer (week 1-2) 2023

NPTEL Stress Management Assignment Answer (week 1-2) 2023

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

NPTEL Financial Management For Managers Assignment Answer (week 1-2) 2023

[Week 1] NPTEL Digital Circuits Assignment Answers 2023

[Week 1, 2] NPTEL Artificial Intelligence : Search Methods For Problem Solving Assignment Answer 2023

[Week 3] NPTEL Problem Solving Through Programming In C Assignment Answers 2023

[Week 4] NPTEL Computer Graphics Assignment Answers 2023

Leave a comment cancel reply.

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

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

DBC Itanagar

[Week 4] NPTEL Data Base Management System Assignment Answers 2023

NPTEL Data Base Management System Assignment Answers

Table of Contents

NPTEL Data Base Management System Week 4 Assignment Answers 2023

1. Consider the relational schema OfficeList (Sector, C o mpany, Building, Floor, Employees)with the following Functional Dependency set: {Sector, Company} -> Building, Floor} {Company, B u ilding} – {Employees, Sector} Building > Floor Which attribute is present in all the composite candi d ate kevs of OfficeList? a) Sector b) Com p any c) Building d) Floor

2. Consider the relational schema: DeviceLogs (Device, OperatingSystem, Logins, DateOfRecord, DeviceLocation) with the following Functional Dependency set: {Device, OperatingSystem} -› DeviceL o cation {Logins, Date0fRecord] – OperatingSystem DeviceLocation -› DateOfRecord If X is the number of candidate keys of DeviceLogs and Y is its highest N ormal 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

3. Consider the relational schema DataLabelling (DataSetName, DataFeatu r e1, DataFeature2, Label, Confidence, Annotators) with the following Functional Dependency set:

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

5. Consider the relational schema Tournament (Champion, Category, Participants, Judges, Day) with the following Functional Dependency set F.

6. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency set:

7. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency sets:

8. Consider the relational schema Gallery (GallerySection, A rtistID, ArtID, Sold, Theme) with the following Functional Dependency set:

9. 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 on Furnitu r eNo and Weight together. Which of the following are the non-prime attributes of FurnitureStore? a) FurnitureNo b) Height c) Weight d) DeliveryChar g e

10. In a relation FurnitureStore (FurnitureNo, FurnitureType, Price, Width, Height, Weig DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Wid t h, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent on 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 should identify the DeliveryCharge d) Only Weight should identify the Width and Hei g ht

NPTEL Data Base Management System Week 3 Assignment Answers 2023

1. Consider the relation Payments as follows:

a) UPI b) Cash c) NEFT d) Card

2. Consider the relation Payments as follows:

Which of the TransactionIDs will NOT be present in the output of R1-R2? a) 42 b) 15 c) 14 d) 4

3. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes). Choose the correct Tuple Relational Calculus that represents the following statement: “Display the titles of those videos that are published on You Tube Channels and have more than 50,000 likes.”

4. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes). Choose the correct Domain Relational Calculus that is equivalent to the following SQL Query: SELECT Channel, VideoTitle FROM Content WHERE Dislikes<100; a) {< c,v > |31, d(< c,v, 1,d >€ Content ^ d < 100)} b) {c,v|3c,v, 1, d(< c,v, 1, d >€ Content ^ Dislikes < 100)} c) {< c,v > 3c,v,1,d € Content ^ d < 100} d) {c,v|3 < 1, >€ Content ^ Dislikes < 100}

5. A C program, with embedded SQL query, allows the users to enter a date and an amount to check the transactions that were made on that day. The entered date is stored in the variable Idate and the amount in variable amt. The SQL query returns the TransactionID and Amount of those payments from Payments (Mode, TransactionID, PaymentDate, Amount) whose PaymentDate match with the user’s entered date and the Amount is more than the entered amount. Which of the following SQL queries is correct for the purpose?

a) EXEC SQL DECLARE c CURSOR FOR SELECT TransactionID, Amount FROM Payments WHERE PaymentDate= :Tdate AND Amount>: amt END EXEC b) EXEC SOL DECLARE c CURSOR FOR SELECT * FROM Payments WHERE PaymentDate= Tdate AND Amount>amt END EXEC c) EXEC SOL DECLARE c CURSOR FOR SELECT * FROM Payments WHERE Tdate=PaymentDate AND amt>Amount d) EXEC SQL DECLARE c CURSOR FOR SELECT TransactionID, Amount FROM Payments WHERE : PaymentDate= :Tdate AND : Amount>: amt END EXEC

6. A cloth factory maintains a schema of manufactured Clothes where each clothing item is identified by a tag. The clothes are also associated with corresponding sizes and materials. However, each cloth can be designed by multiple designers. Which of the following schema correctly represents the Clothes entity set? a) Clothes (Tag, Size, Material, Designer) b) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer) c) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer) d) Clothes (Tag, Size, Material), Clothes Designer (Tag, Designer)

7. Consider the three relational schemas: Stories (Title, Author, Pages, StoryCount) Books (Title, Author, Pages) Educational (Title, Author, Pages, Subject) Which of the Entity Relationship diagrams correspond to the given schemas?

8. Consider the Entity Relationship Diagram:

Which of the following is/are true? a) The participation of Organizer in Org.Conf is partial. b) The participation of Conference in Org-Conf is partial. c) Presenter is a composite attribute of Presentation. d) Presenter is a multivalued attribute of Presentation.

9. Consider the entity relationship diagram.

10. Consider the following instance of organizer.

NPTEL Data Base Management System Week 2 Assignment Answers 2023

1. Consider two relations StyleName and PrintStyle as follows: An operation θ between StyleName and PrintStyle will generate the following output: Identify the operation G. a) natural join b) natural left outer join c) natural right outer join d) natural full outer join

2. Consider the following CREATE statements:

3. Consider the following schema:

• loan (loan _number, branch_name, amount)

4. Consider the following instance of the relation BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)

5. Consider the following instance of the relation BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)

6. Consider the following instance of the relational schema PAYSCALE (POSITION, BASE_SALARY, EXPERIENCE)

7. A role Manager has the privilege to perform select, insert, update and delete operations on all tables of database. A new role Software_Engineer is created and the following statement is executed.

8. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation.

9. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)

10. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)

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?

Leave a Comment Cancel reply

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

• NPTEL Design and analysis of algorithms Assignment 3 Answer 2023
• NPTEL Design and analysis of algorithms Assignment 2 Answer 2023
• NPTEL Cyber Security and Privacy Assignment 3 Answer 2023
• NPTEL Cyber Security and Privacy Assignment 2 Answer 2023
• NPTEL Cyber Security and Privacy Assignment 1 Answer 2023

NPTEL Data Base Management System Assignment 1 Answer 2023

We Discuss About That NPTEL Data Base Management System Assignment 1 Answer 2023

NPTEL Data Base Management System Assignment 1 Answer 2023 – Here All The Questions and Answers Provided to Help All The Students and NPTEL Candidate as a Reference Purpose, It is Mandetory to Submit Your Weekly Assignment By Your Own Understand Level.

Are you looking for the Assignment Answers to NPTEL Data Base Management System Assignment 1 Answer 2023? If Yes You are in Our Great Place to Getting Your Solution, This Post Should be help you with the Assignment answer to the  Nation al Programme on Technology Enhanced Learning  ( NPTEL ) Course “NPTEL Data Base Management System Assignment 1 Answer 2023”

Table of Contents

NPTEL Data Base Management System Assignment

ABOUT THE COURSE : 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.

INTENDED AUDIENCE :  Students from all disciplines can enroll for this course. PRE-REQUISTES  :1. Procedural and / or Object-Oriented Programming (C / C++ / Java / Python)

2.Data Structures

3.Algorithms INDUSTRY SUPPORT  : DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems, data mining, machine learning) have a need for the same. These include – Microsoft, Samsung, Xerox, Yahoo, Google, IBM, TCS, Infosys, Amazon, Flipkart, etc.

Next Week Assignment Answers

This course can have Associate in Nursing unproctored programming communication conjointly excluding the Proctored communication, please check announcement section for date and time. The programming communication can have a weightage of twenty fifth towards the ultimate score.

• Assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course.
• ( All assignments in a particular week will be counted towards final scoring – quizzes and programming assignments). 
• Unproctored programming exam score = 25% of the average scores obtained as part of Unproctored programming exam – out of 100
• Proctored Exam score =50% of the proctored certification exam score out of 100

CHECK HERE OTHERS NPTEL ASSIGNMENTS ANSWERS 

Below you can get your nptel data base management system assignment 1 answer 2023  :.

• NPTEL Data Structure And Algorithms Using Java Assignment 1 Answer 2023
• NPTEL Cryptography And Network Security Assignment 1 Answer

You May Also Like

Nptel data base management system assignment 2 answer 2023.

404 Not found

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

NPTEL Data Base Management System Assignment 1 Answers 2023

• by QuizXp Team
• January 27, 2023 February 8, 2023

NPTEL Data Base Management System Assignment 1 Answers 2023? 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 “

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

NPTEL Data Base Management System Assignment 1 Answers 2023:-

Q1. Which level of abstraction describes types of data that are stored in the Database?

For week 2 Answers:- Click Here

Q2. Identify the valid primary key for the relation paper_info from the given instance.

Q3. Identify the correct statement/s.

a) Project(pCode, pName) is an instance of a relation schema. b) Project(pCode, pName) is an example of a physical schema. c) (2245, HardFort) is an instance of a relation schema.

d) (2245, HardFort) is an example of a logical schema.

Q4. Consider a relation Vehicle(VID, Model, Speed, Color) where the superkeys are as follows: {VID}, {VID, Model}, {Speed, Color}, {Speed, Color, Model}. Select the possible candidate key(s).

Next Week Answers: Assignment 02

Q5. Consider the following relations:

Book(ISBN,Title,Pages)

BookGenre (ISBN, Genre)

‘What does the following relational algebra expression represent? HISBII((”’Pages> 100Bo0k) M (0eanre—:Fiction’BOOKGeNTe))

Q6. Consider the following relational schema:

ImageCode (ImageID, Name)

ImageBook (BookID, ImageID, Page)

‘What will be the Relational Algebra equivalent to the following statement? “Find the names of all Images on Page 100.”

If there are any changes in answers will notify you on telegram so you can get 100% score, So Join

Q7. ‘Which of the following operations will return S1 itself?

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

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

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

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

if you have any suggestions then comment below or contact us at  [email protected]

If you found this article Interesting and helpful, don’t forget to share it with your friends to get this information.

Data Base Management System Assignment 2 Answers 2022

NPTEL Data Base Management System Assignment 2 Answers: 2022:- 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 2 Assignment Answers 2023

1. Consider two relations StyleName and PrintStyle as follows: An operation θ between StyleName and PrintStyle will generate the following output: Identify the operation G. a) natural join b) natural left outer join c) natural right outer join d) natural full outer join

2. Consider the following CREATE statements:

3. Consider the following schema:

• loan (loan _number, branch_name, amount)

4. Consider the following instance of the relation BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)

5. Consider the following instance of the relation BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)

6. Consider the following instance of the relational schema PAYSCALE (POSITION, BASE_SALARY, EXPERIENCE)

7. A role Manager has the privilege to perform select, insert, update and delete operations on all tables of database. A new role Software_Engineer is created and the following statement is executed.

8. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation.

9. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)

10. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)

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 2 Answers below.

NPTEL Data Base Management System Assignment 2 Answers 2022

1. Consider the following instance: Consider the query: SELECT title, author FROM books WHERE theme LIKE “y” AND genre NOT LIKE “r” ORDER BY theme DESC Which title will be present in the first (topmost) tuple of the output produced by the above query? a) The Cause b) Happiens c) Echoing Laughters d) The haunting

2. Consider the following instance: Consider the following queries: CREATE VIEW THEMEVIEW AS SELECT theme FROM books WHERE author LIKE “% %” SELECT COUNT (*) FROM THEMEVIEW; What is the final output after the two queries are executed? a) 3 b) 4 c) 5 d) 6

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

3. Consider the following instance: Which is the correct option to change the value of game ID from 3 to 2? a) UPDATE scoreboard SET game ID=2 WHERE game ID=3 b) ALTER TABLE scoreboard SET gameID=2 WHERE game ID =3 c) ALTER scoreboard SET game ID=2 WHERE gameID=3 d) UPDATE TABLE scoreboard SET gameID=2 WHERE game ID=3

4. Which attribute(s) is (are) represented by X in the above query? a) gameID b) gameID, Day c)Day d) Day, Score

5. Consider the following two tables: a) Supplier NATURAL LEFT OUTER JOIN Product b) Supplier INNER JOIN Product c) Supplier NATURAL RIGHT OUTER JOIN Product d) Supplier NATURAL FULL OUTER JOIN Product

6. Consider the following schema: player (p_id, tournament.code, month, match.count) In the player schema, p_id uniquely identifies every record. Given that a player cannot play more than 5 matches in a month for a tournament, identify the correct CHECK constraint for the create query of this table. a) CONSTRAINT CK_mat-count for CHECK (if match_count < 6) b) CONSTRAINT CKmat.count for CHECK (if match_count< 6 is true) c) CONSTRAINT CK_mat.count CHECK (if match.count < 6) d) CONSTRAINT CK_mat.count CHECK (match.count < 6)

👇 For Week 03 Assignment Answers 👇

7. Consider the following schema:

8. Consider the following instance of the relation BookDetails. BookDetails (BOOK_ID, YEAR_PUB, BOOK-TITLE, AUTHOR NAME, TOTAL.SOLD_COPIES)

9. Consider the following instance of the relation BookDetails. BookDetails (B0OKID, YEARPUB, BOOK.TITLE, AUTHOR_NAME, TOTAL SOLD_COPIES)

10. Consider the following relation schema: BookDetails (B00K_ID, YEAR_PUB, BOOK TITLE, AUTHOR NAME, TOTAL SOLD.cOPIES). Identify the correct statement to create an INDEX on B00K_ID and BOOK-TITLE of BookDetails relation named as ‘Books’. a) Create INDEX Books TO BookDetails (B0OK_ID, BOOK_TITLE); b) Create INDEX Books ON BookDetails (BOOK_ID, BOOK_TITLE); c) Create INDEX Books AS BookDetails (B00K_ID, BOOK_TITLE); d) Create INDEX Books OF BookDetails (BOOK_ID, BOOK_TITLE) ;

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

Leave a Comment Cancel reply

You must be logged in to post a comment.

Data Base Management System

ABOUT THE COURSE : 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.

• Database System Concepts by Abraham Silberschatz, Henry F.  Korth, and S. Sudarshan, 6th Edition, McGraw-Hill Education, 2010.
• Presentations used in the Course 

Instructor bio

Prof. Partha Pratim Das

Prof. Samiran Chattopadhyay

Course certificate.

DOWNLOAD APP

SWAYAM SUPPORT

Please choose the SWAYAM National Coordinator for support. * :