ASSIGNMENT > The following question is based upon the GRAND SLAM relation below that lists details of ‘Grand Slam’ tennis tournaments and their winners over the last few years. You can assume that the data is representative. You have been asked to design a relational database based on this design. You know that there are problems with the current design and that it will need to be modified in order to work effectively. Answer the following questions. Each question is worth 10 marks a. Explain the problems with the existing design, in terms of the potential modification anomalies that it might exhibit.
California Polytechnic State University, Pomona CS MISC Question 1: Normalisation (40 marks) The following question is based upon the GRAND SLAM relation below that lists details of ‘Grand Slam’ tennis tournaments and their winners over the last few years. You can assume that the data is representative. You have been asked to design a relational database based on this design. ...[Show More]
Preview 2 out of 8 pages
Reviews( 0 )
| Category: | |
| Number of pages: | 8 |
| Language: | English |
| Last updated: | 8 months ago |
| Downloads: | 1 |
| Views: | 7 |
-preview.jpeg)
-preview.jpeg)
-preview.jpeg)
