Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

D2L Bright space For this assignment, you are required to design a conceptual data model (ER Model) and a data dictionary for an information system

image text in transcribed
image text in transcribed
D2L Bright space For this assignment, you are required to design a conceptual data model (ER Model) and a data dictionary for an information system to help organize a springboard diving competition. The diving meet has the following characteristics: A dive meet takes place over one or more days at the same venue (pool) and is composed of several individual events. Events are categorized by three things: gender (male or female); age group (A, B, C, D or E); and board height (1M, 3M, 5M, 10M). For example, an event may be on the 3M board for all females in age group A (16 and over). Divers must register for the events in which they will compete. Divers can only register for one event per board height. Diver information such as national registration number, name, age group, and contact information (phone and email) must be stored by the system. For each event, a diver must submit a dive list consisting of a set of dive numbers along with their degree of difficulty. The same dive number (type of dive) may appear on multiple dive lists since a diver can perform the same dive in different events (different board height). After each individual dive, the driver is given a score by five judges. These individual dive scores are then tabulated for each diver, and for each event, and overall event results are determined

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Database Processing Fundamentals, Design, and Implementation

Authors: David M. Kroenke, David J. Auer

14th edition

133876705, 9781292107639, 1292107634, 978-0133876703

More Books

Students also viewed these Databases questions

Question

Define the term Working Capital Gap.

Answered: 1 week ago