Data Base Management System Assignment 3 Answers 2022

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

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 the average of the 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 YOUR AVERAGE ASSIGNMENT SCORE >=10/25 AND YOUR 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 3 Answers below.

NPTEL Data Base Management System Assignment 3 Answers 2022

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

a) X=Name, Y=Location, M=Location, N=KnownFor
b) X=Name, Y=Location, M=Name, N=KnownF or
c) X=Name, Y=KnownFor, M=Location, N=KnovnFor
d) X=Name, Y=KnownFor, M=Name, N=Location

Answer:- b

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?

a) Treeland
b) TreeLand, Bageecha
c) Bageecha, FloralParadise
d) FloralParadise

Answer:- d

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

Data Base Management System Assignment 3 Answers 2022

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

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

Answer:- d

5. Consider the following Entity Relationship Diagram:

Which of the following options is (are) true?

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

Answer:- a, b

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 04 Assignment Answers👇

Data Base Management System Assignment 3 Answers 2022

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?

a) Forest (Name, Location, Trees)
b) Forest (Name, Country, Area), Forest.trees (Name, Trees)
c) Forest (Name, Trees), Forest Location (Name, Location, Country, Area)
d) Forest (Name, Country, Area), Forest.trees (Name, Trees)

Answer:- c

8. Consider the following Entity Relationship Diagram:

Which of the following is (are) true?

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

Answer:- b

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

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

Answer:- For Answer Click Here

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?

a) IlpaintingID , Artist (Callery) x IIpaintingID, Theme (Callery)
b) TIpaintingID , Artist (Callery) x IlArtist, Theme (Callery))
c) IIpaintingID, Theme (Gallery) x IIpaintingID, Theme (Gallery)
d) TIpaintingID, Theme , Artist (Callery) « lITheme (Callery)

Answer:- a

For More NPTEL Answers:- CLICK HERE

Join Our Telegram:- CLICK HERE

Leave a Comment