NPTEL Data Base Management System Week 3 Assignment Answers 2024

Join Our WhatsApp Group Join Now
Join Us On Telegram Join Now

NPTEL Data Base Management System Week 3 Assignment Answers 2024

1.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :-  For Answer Click Here

2.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :-  For Answer Click Here

3. Consider the relational schema Sensor (SensorID, Battery, BaseStationID, Range).
Choose the correct Tuple Relational Calculus that represents the following statement
“Display all the SensorIDs associated with BaseStationID BS1.”

a) {s|t < t [BaseStationID]= ‘BS1 ‘>}
b) f 3s € Sensor (p[BaseStationID]=’BS1′)}
c) {t|3s € Sensor (t [SensorID]=s [BaseStationID] ^ t [BaseStationID]=’BS1′) }
d) {t|3s € Sensor (t [SensorID]=s [Sensor ID] ^s (BaseStationID]=’ BS1′) }

Answer :-  For Answer Click Here

4. Consider the relational schema Sensor (SensorID, Battery, BaseStationID, Range).
Choose the correct Domain Relational Calculus equivalent to the following SQL query
SELECT Range FROM Sensor WHERE Battery=’500′

a) {sl3c, d, i (c, d, i, s € Sensor A Battery=’500′ )}
b) {13c, d, i ( € Sensor ^ d=’500′)}
c) {|3c, d, i ( € s A Battery=’500′)}
d) {sl3 (c, d, i, s € Sensor A d= ‘500’)}

Answer :- 

5.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :- 

6. A company maintains a schema of Reports where each report is identified by a Heading.The reports are also associated with corresponding a Date and Length. Moreover, each 1 report can be written by multiple Authors. Which of the following schema correctly represents the Reports entity set?

a) Reports (Heading, Date, Length, Authors)
b) Reports(Heading, Date, Length), Reports1(Heading, Authors)
c) Reports(Heading, Date, Length), Reports1(Heading, Authors)
d) Reports (Heading, Date, Length), Reports1 (Heading, Authors)

Answer :-  For Answer Click Here

7.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :- 

8.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :- 

9.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :- 

10.

NPTEL Data Base Management System Week 3 Assignment Answers 2024
Answer :- For Answer Click Here