Answered step by step
Verified Expert Solution
Link Copied!

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

 imageimage

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Robert F Blitzer

7th Edition

013449492X, 9780134453262

More Books

Students also viewed these Databases questions

Question

Tell me what you know about our organization and the position.

Answered: 1 week ago