NPTEL Data Base Management System Assignment 1 Answers 2023

NPTEL Data Base Management System Assignment 1 Answers 2023

Hello learners In this article we are going to discuss 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 with your own knowledge and use this article as reference only.

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.

Assignment No.Answers
Data Base Management System Assignment 1 Click Here
Data Base Management System Assignment 2 Click Here
Data Base Management System Assignment 3 Click Here
Data Base Management System Assignment 4 Click Here
Data Base Management System Assignment 5 Click Here
Data Base Management System Assignment 6 Click Here
Data Base Management System Assignment 7 Click Here
Data Base Management System Assignment 8 Click Here
Data Base Management System Assignment 9 Click Here
Data Base Management System Assignment 10 Click Here
Data Base Management System Assignment 11 Click Here
Data Base Management System Assignment 12 Click Here

NPTEL Data Base Management System Assignment 1 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 describes data stored in a database and their relationships.
  • d) Logical level abstraction defines the physical schema.
Answer :- Will update answers soon and update on our telegram channel so Join Click Here

2. Consider the following relations:

Subject (sid, sname, credit)
Faculty (fid, sid)
Which of the following is correct?

  • a) RA1 C RAz
  • b) RAg C RAg
  • c) RAI C RAg
  • d) RA1 = RAg
Answer :-

Next Week Answers: Assignment 02

quizxp telegram

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.
Answer :-

4. Consider the relational schema PhoneBook (Name, PhoneNo, Location, LastCalled)

  • Ankit 3222265783 Kolkata 15 Jul
  • Shreya 3222265783 Delhi 16 Jul
  • Ankit 2222586110 Delhi 16 Jul
  • Shreya 2222586110 Kolkata 15 Jul
Answer :-

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 superkeys of Flight?

  • a) 8
  • b) 9
  • c) 10
  • d) 16
Answer :-

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?

  • a) {P,R}
  • b) {P,Q}
  • c) {Q,R}
  • d) {Q,S)
Answer :-

7. Consider the following instance of ChatBox (SenderID, ReceiverID).

If SenderID is the foreign key in the relational schema ChatMsg (ChatID, Text, SenderID),
which of the following is a valid instance of ChatMsg?

Answer :-

8. Consider the following table:

image 9
Answer :-

9. Consider the following table:

Answer :-

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

image 10
Answer :-