NPTEL Data Base Management System Week 3 Assignment Answers 2025
1. An organization, collecting car renters’ information, considers the following relations:
Renter (Renter _ID, Contact)
Renting (Renter_ID, Car Number)
Car (Car Number, Model).
What will the following relational algebra expression return to the organization?
IIContact (Renter) – IIContact (Renter X Renting)
a) The Contacts of those Renters who are Renting at most one Car at that instance.
b) The Contacts of those Renters who are Renting every Car at that instance.
c) The Contacts of those Renters who are Renting at least one Car at that instance.
d) The Contacts of those Renters who are not Renting any Car at that instance.
Answer :- For Answers Click Here
2.
Answer :-
3.
Answer :-
4.
Answer :-
5.
Answer :-
6.
Answer :- For Answers Click Here
7.
Answer :-
8. In a printing company, a Book is printed by multiple Employees and an Employee prints multiple Books. The Books are identified by their unique Title. A Book also has an Edition and multiple values of the attribute Author. An Employee has a unique ID. Assuming there is a Prints relation between Book and Employee, what will be the correct schema for Prints and Book?
a) Prints(Title, ID)
Book (Title, Edition, Author)
b) Prints(ID)
Book(Title Edition)
Book author (Title, Author)
c) Prints(Title, ID)
Book (Title, Edition)
Book author (Title, Author)
d) Prints(Title, ID, Author)
Book (Title, Edition)
Answer :-
9.
Answer :-
10.
Answer :- For Answers Click Here
