Database Management Systems, Quiz 2
Consider the following table:
| PlayerID | PlayerName | Team | Runs |
|---|---|---|---|
| 001 | Virat | India | 100 |
| 002 | Rohit | India | 100 |
| 003 | Smith | Australia | 70 |
| 004 | Jason | England | 60 |
| 005 | Rohit | Bangladesh | 65 |
| 006 | Asif | Pakistan | 50 |
| 007 | Smith | Newzealand | 70 |
Table 1: Players
Which of the following functional dependencies hold in the Players table? [MSQ]
Consider the following table: | PlayerID | PlayerName | Team | Runs | |---|---|---|---| | 001 | Virat | India | 100 | | 002 | Rohit | India | 100 | | 003 | Smith | Australia | 70 | | 004 | Jason | England | 60 | | 005 | Rohit | Bangladesh | 65 | | 006 | Asif | Pakistan | 50 | | 007 | Smith | Newzealand | 70 | Table 1: **Players** Which of the following functional dependencies hold in the **Players** table? [MSQ] Figure from the original question paper Consider a magnetic disk with 4 platters, 2 surfaces per platter, 1024 tracks per surface, and 2048 sectors per track, with a disk capacity of 8 GB. Find the capacity of one sector.