Opening the paper…
Database Management Systems, End Term
Consider the instance of a relation R. Which among the following functional dependencies set can be inferred from the given information?
| StudentID | Course | Grade | Instructor |
|---|---|---|---|
| S1 | C1 | A | I1 |
| S1 | C2 | B | I2 |
| S2 | C1 | A | I1 |
| S3 | C3 | C | I3 |
| S2 | C2 | B | I2 |
| S4 | C4 | A | I4 |
Consider the instance of a relation R. Which among the following functional dependencies set can be inferred from the given information? | StudentID | Course | Grade | Instructor | |---|---|---|---| | S1 | C1 | A | I1 | | S1 | C2 | B | I2 | | S2 | C1 | A | I1 | | S3 | C3 | C | I3 | | S2 | C2 | B | I2 | | S4 | C4 | A | I4 | Figure from the original question paper Consider the following monthly backup schedule used by a company: | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | |---|---|---|---|---|---|---| | 1/ Full | 2/ Incremental | 3/ Incremental | 4/ Incremental | 5/ Incremental | 6/ Incremental | 7/ Differential | | 8/ Incremental | 9/ Incremental | 10/ Incremental | 11/ Incremental | 12/ Differential | 13/ Incremental | 14/ Incremental | | 15/ Incremental | 16/ Incremental | 17/ Differential | 18/ Incremental | 19/ Incremental | 20/ Incremental | 21/ Incremental | | 22/ Differential | 23/ Incremental | 24/ Incremental | 25/ Incremental | 26/ Incremental | 27/ Incremental | 28/ Incremental | | 29/ Incremental | 30/ Incremental | | | | | | If a failure occurs on the 23rd day of the month after the backup for the day has been completed, how many backup sets have to be loaded for a full recovery?