NPTEL Data Base Management System Assignment 3 Answers 2023? This article will help you with the answer to the National Programme on Technology Enhanced Learning (NPTEL) Course “ Data Base Management System Assignment 3 “
Below you can find the answers for Data Base Management System Assignment 3 Answers 2023
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))
Answer:- b,d
For week 1 Answers:- Click Here
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 “?
Answer: b) {t13p = Employee (t [EID] =p [EID] ^ p [Experience] >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?
Answer:- a, d
Next Week Answers: Assignment 04
Q.4. Consider the Entity Relationship diagram:
Which attribute will not be present in the schema of ManagedBy?
Answer:- c) experience
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”?
Answer:- d) {ln,t,c ( € Building ^ c=”Gray”)}a
Q.6. Consider the Entity Relationship diagram : Which of the following statement (s) is/are TRUE?
Answer:- c) CARNIVORES inherit the attributes of DOGS but not of OMNIVORES.
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?
Answer:- d) Creates (Tag, ID)
Handicraft (Tag, Material)
Handicraft_color (Tag, Color)
Q.8. Which PageNumber is not produced by the following Relational Algebra?
((IIpageNumber, Topic (Chapter) – Paragraph) x Paragraph) IIchapter.PageNumber
Answer:- b
Q.9. Consider the relation GROCERY (ITEM, PRICE, MONTH). Select the SQL query from within a host language, to find those ITEMS whose PRICE has exceeded the price stored in monthly budget in a specific MONTH defined in target_month. monthly budget and target-month are declared in host language.
Answer: a) 11
Q.10. 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)
Answer: d) EXEC SQL
DECLARE C CURSOR
FOR SELECT ITEM
FROM PRODUCT
WHERE PRICE >: monthly_budget AND MONTH= : target_month
END EXEC
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.
