NPTEL Data Base Management System Assignment 3 Answers 2022

NPTEL Data Base Management System Assignment 3 Answer: In this article, you will find NPTEL Data Base Management System Assignment 3 Answer , Use “Ctrl+F” To Find Any Questions Answer. & For Mobile User, You Just Need To Click On Three dots In Your Browser & You Will Get A “Find” Option There. Use These Option to Get Any Random Questions Answer. 

NPTEL Data Base Management System Week 4 Assignment 4 Answers 👇
CLICK HERE

Note: We are trying to give our best please share this answer link with other students also.

NPTEL Data Base Management System Week 3 Answers 2022

NPTEL Data Base Management System Assignment 3 Answer 2022 :-

 

Q1. Consider the following instance of the relation Gardens (Name, Location, OpensAt, ClosesAt, KnownFor)Only statement 1 is true

  • X=Name, Y=Location, M=Location, N=KnownFor 
  • X=Name, Y=Location, M=Name, N=KnownF or 
  • X=Name, Y=KnownFor, M=Location, N=KnovnFor
  • X=Name, Y=KnownFor, M=Name, N=Location

Q.2. Consider the following instance of the relation Gardens (Name, Location, OpensAt, ClosesAt, KnownFor)

Which of the following Names will be produced by R1 R2?

  • Treeland 
  • TreeLand, Bageecha
  • Bageecha, FloralParadise
  • FloralParadise

NPTEL Data Base Management System Week 4 Assignment 4 Answers 👇

telegram

 

Q.3. A C program, with embedded SQL allows the users to enter their ticket number which is stored in the variables tno. With the help of an embedded SQL query, the program then displays the corresponding travel date and destination from a database with the following schema: TravelReg (TicketNo, Destination, TravelDate, ReservationName). Select the correct Embedded SQL query that should be present in this C program.

  • Answer: D

Q.4. Consider the following instance of the relation Gardens (Name, Location, OpensAt, ClosesAt, KnownFor)

  • Answer: D

Q.5. Consider the following Entity Relationship Diagram:

Which of the following options is (are) true?

  • Participation of Product is total is Prod_del. 
  • The primary key in the relational schema for Receipt is {Name, ItemName, ProductNo}. 
  • The primary key in the relational schema for Receipt will be {Name, ItemName, AgentPin}. 
  • Participation of Product is total in Prod rec.

Q.6. Consider the relation Planets (pname, rank, satellites, diameter) What is the Domain Relational Calculus expression equivalent to the statement Select the names of those Planets uhich have a diameter of more than 50,000 kms”?

  • Answer: B

For Week 4 Assignment Answers Join this Group👇

telegram

Q.7. Consider the following scenario:

A Natural resource management company keeps a record of different forests, identified by their names. A forest is associated with its location that contains the Country and area in which the forest is present. In each forest, there are different types of trees that are also recorded by the company.

Which of the following schema correctly represents the Forest entity set?

  • Forest (Name, Location, Trees) 
  • Forest (Name, Country, Area), Forest.trees (Name, Trees)
  • Forest (Name, Trees), Forest Location (Name, Location, Country, Area) 
  • Forest (Name, Country, Area), Forest.trees (Name, Trees)

Q.8. Consider the following Entity Relationship Diagram:

Which of the following is (are) true?

  • Participation of Author in Auth.pub is total. 
  • Participation of Publisher in Auth_pub is total. 
  • A Book can be written by multiple Authors.
  • An Author can be associated with at most one Book.

NPTEL All Weeks Assignment Solution: Click Here

Q.9. Consider the instance of the relational schema Gallery (PaintingID, Artist, Theme) and Price (PaintingID, Cost):

  • 3
  • 4
  • 8
  • 10

Q.10. Consider the instance of the relational schema Gallery (PaintingID, Artist, Theme):

Which of the following Relational Algebra expressions produce(s) exactly the same tuples as present in this instance of Gallery?

  • IlpaintingID , Artist (Callery) x IIpaintingID, Theme (Callery) 
  • TIpaintingID , Artist (Callery) x IlArtist, Theme (Callery))
  • IIpaintingID, Theme (Gallery) x IIpaintingID, Theme (Gallery) 
  • TIpaintingID, Theme , Artist (Callery) « lITheme (Callery)

 

For Any Changes in Answers Join this Group👇

telegram

 

This answer is provided by us only for discussion purpose if any answer will be getting wrong don’t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided by Chase2learn. This tutorial is only for Discussion and Learning purpose.

 

About NPTEL Data Base Management System 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.

 

For Week 4 Assignment Answers Join this Group👇

telegram

 

COURSE LAYOUT

The course structure and content covers, over a period of 8 weeks:

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

Leave a Comment