Define each of the following key terms: a. Exclusivity - give an example (3 marks) In...

 

Transcribed Image Text:

Define each of the following key terms: a. Exclusivity - give an example (3 marks) In the space below, draw a data model that shows exclusivity b. Constraints (2 marks) c. Cardinality (2 marks) 2. Name four steps used when creating ER models from problem statements? (4 marks) 4. name three kinds of data anomalies and describe one of them. (4 marks) Page 1 of 3 4. Normalise the following form to 3NF (5 marks). Fremantle Music Festival Schedule of Events Group No. Type Gp01 Under 13 Piano 9.00 am Gp02 Under 12 Violin 10.00 am Gp03 Under 17 Piano 12.00 nn Examiner No. Name 34 Mr Carl 31 Ms Black 34 Mr Carl Performer No. Name 26 Fred Smith 76 Mary Jones 34 Jean Phelps 89 Sam Green 42 Eddie Allan 17 Sandy Cole 66 Bret Collins 34 Jean Phelps 31 Brian Luks 47 Don Chin 03 Joe Baker Teacher No. Name 12 Mary Poppins 32 Sally Brown 12 Mary Poppins 15 Debbie Palmer 06 Betty Grable 21 Nellie Gray 21 Nellie Gray 48 Sarah Black 32 Sally Brown 12 Mary Poppins 25 Betsy Mo Mark A+ C B+ A B- C+ B B C+ B- Define each of the following key terms: a. Exclusivity - give an example (3 marks) In the space below, draw a data model that shows exclusivity b. Constraints (2 marks) c. Cardinality (2 marks) 2. Name four steps used when creating ER models from problem statements? (4 marks) 4. name three kinds of data anomalies and describe one of them. (4 marks) Page 1 of 3 4. Normalise the following form to 3NF (5 marks). Fremantle Music Festival Schedule of Events Group No. Type Gp01 Under 13 Piano 9.00 am Gp02 Under 12 Violin 10.00 am Gp03 Under 17 Piano 12.00 nn Examiner No. Name 34 Mr Carl 31 Ms Black 34 Mr Carl Performer No. Name 26 Fred Smith 76 Mary Jones 34 Jean Phelps 89 Sam Green 42 Eddie Allan 17 Sandy Cole 66 Bret Collins 34 Jean Phelps 31 Brian Luks 47 Don Chin 03 Joe Baker Teacher No. Name 12 Mary Poppins 32 Sally Brown 12 Mary Poppins 15 Debbie Palmer 06 Betty Grable 21 Nellie Gray 21 Nellie Gray 48 Sarah Black 32 Sally Brown 12 Mary Poppins 25 Betsy Mo Mark A+ C B+ A B- C+ B B C+ B-

Answer rating: 100% (QA)

a Exclusivity Exclusivity refers to the property where an entity can be associated with only one instance of another entity at a given time In other words it means that the relationship between two en... View the full answer