# NPTEL Data Base Management System Week 3 Assignment Answers 2024

## NPTEL Data Base Management System Week 3 Assignment Answers 2024

1.

`Answer :-  For Answer Click Here`

2.

`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.

`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)

`Answer :-  For Answer Click Here`

7.

`Answer :- `

8.

`Answer :- `

9.

`Answer :- `

10.

`Answer :- For Answer Click Here`