Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Define each of the following key terms: a. Exclusivity - give an example (3 marks) In the space below, draw a data model that
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-
Step by Step Solution
★★★★★
3.39 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started