# NPTEL Data Base Management System Assignment 3 Answers 2023

Hello NPTEL Learners, In this article, you will find NPTEL Data Base Management System Assignment 3 Week 3 Answers 2023. All the Answers are provided below to help the students as a reference don’t straight away look for the solutions, first try to solve the questions by yourself. If you find any difficulty, then look for the solutions.

###### NPTEL Data Base Management System Assignment 4 Answers 2023 Join Group👇

Note: We are trying to give our best so please share with your friends also.

## NPTEL Data Base Management System Assignment 3 Answers 2023:

#### Q.1. Consider the following instance of the relation MovieBooking (MovieName, TheatrID, HallNo, Glasses 3D, MLanguage, Showtime ID, ShowDay)

Which of the following MovieNames are produced by the Relational Algebra expression given below?

IlMovieName (HallNo>2^MLanguage English’ (MovieBooking)) IlMovie Name (Glasses3D-‘Yes’ (MovieBooking))

• a) The Martian
• b) Interstellar
• c) Gravity
• d) Inception

#### Q.2. Consider the relation Employee (EID, Dept, Experience, Salary). What is the Tuple Relational Calculus expression equivalent to the statement “Select those Employee IDs (EID) whose Experiences are more than 10 years “?

• a) {13 p,t Employee (t [Salary] =p [Dept] v p [Experience] =10)}
• b) {t13p = Employee (t [EID] =p [EID] ^ p [Experience] >10)}
• c) {t13 p,t Employee (t [Salary] =p [EID] ^ p [EID]>10)}
• d) {13p = Employee (t [EID] =p [EID] ^ p [Employee] >10)}

#### Q.3. Consider the following Entity Relationship Diagram :

If n [Payment] is the number of attributes present in the relational schema of Payment, n[In_Cash] is the number of attributes present in the relational schema of In-Cash and n[In Cheque] is the number of attributes present in the relational schema of In_Cheque, which of the following options can NOT be true?

• a) n[Payment] = 6
• b) n[In Cheque] = 6
• c) n[In_Cash] = 4
• d) n[In_Cheque] = 3

#### Q.4. Consider the Entity Relationship diagram:

Which attribute will not be present in the schema of ManagedBy?

• a) cnumber
• b) id
• c) experience
• d) Enrolment

#### Q.5. In a company, the Building relation maintains information about the BuildingLocation, BuildingFloors, BuildingType and BuildingColor. What will be the Domain Relational Calculus expression to obtain the Building Locations of those Buildings whose BuildingColor is “Gray”?

• a) {plan,t,c ( € Building ^c=”Gray”)}
• b) {plan,t,c (n,t,c € Building ^c=”Gray”) }
• c) {n,t,c (p,n,t,c € Building V c=”Gray”)}
• d) {ln,t,c ( € Building ^ c=”Gray”)}

#### Q.6. Consider the Entity Relationship diagram : Which of the following statement (s) is/are TRUE?

• a) DOGS inherit the attributes of CARNIVORES but not of ANIMALS.
• b) DOGS inherit the attributes of CARNIVORES and ANIMALS.
• c) CARNIVORES inherit the attributes of DOGS but not of OMNIVORES.
• d) ANIMALS inherit the attributes of CARNIVORES, OMNIVORES, HERBIVORES and DOGS.

#### Q.7. In a company, a Handicraft is made by multiple Artisans and an Artisan makes multiple Handicrafts. The Handicrafts are identified by their unique Tags. A Handicraft is made of a particular Material and is multi- Colored. An Artisan has a unique ID. Assuming there is a Creates relation between Handicraft and Artisan, what will be the correct schema for Creates and Handicraft?

• a) Creates (Tag, ID) Handicraft (Tag, Material, Color)
• b) Creates (ID) Handicraft (Tag Material) Handicraft_color (Tag, Color)
• c) Creates (Tag, ID, Color) Handicraft (Tag, Material)
• d) Creates (Tag, ID) Handicraft (Tag, Material) Handicraft_color (Tag, Color)

#### Q.8. Consider 2 instances:

Which PageNumber is not produced by the following Relational Algebra? ((IIpageNumber, Topic (Chapter) – Paragraph) x Paragraph) IIchapter.PageNumber

• a) 11
• b) 40
• c) 20
• d) 33

#### Q.10. Consider the following instance of a relation Uniform :

How many tuples will be returned by the following Relational Algebra Query? Uniform) ÷ Ilcolor (Color=’Blue Uniform)) U ((School=’KidSys’vColor=’Blue IISchool (Color White/Uniform)

• a) 1
• b) 2
• c) 3
• d) 4
##### NPTEL Data Base Management System Assignment 3 Answers Join Group👇

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

##### Course Outcome:
• 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.
###### CRITERIA TO GET A CERTIFICATE:

Average assignment score = 25% of average of best 8 assignments out of the total 12 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.

If you have not registered for exam kindly register Through https://examform.nptel.ac.in/