Based on given scenario, I am required to design an entity relationship diagram (ERD) A school decides
Fantastic news! We've Found the answer you've been seeking!
Question:
Based on given scenario, I am required to design an entity relationship diagram (ERD)
Transcribed Image Text:
A school decides to develop a computer application to facilitate storage and retrieval of relevant information of its athletic meets including: Contestant name, class (e.g. 1D), grade (e.g. A, B, C), sex, house Event-grade, sex, game (e.g. 200m sprint, shot put, 4x100 relay), type (e.g. heat, semi-final, final) Athletic events are classified into track events and field events. Track events are those running races whereas field events include long jump, high jump, triple jump, shot put, and discus, etc. Track event contestants aim to finish their races as fast as possible whereas field event contestant aims to achieve the greatest distance. Each student, affiliated to a house, is allowed to join as many games as she likes. For each game, a score will be awarded to the individuals as well as to the house according to the following rules: Gold medalist - 10 points to individuals; 5 points to the house; Silver medalist - 8 points to individuals; 4 points to the house; Bronze medalist - 6 points to individuals; 3 points to the house; Other contestants - 2 points to the house for a contestant's appearance in each match (to encourage participation) Note that the results table does not store any explicit information about which results being associated with the champion, 1st runner up, and 2nd runner up of any events. As an example, if a student manages to get a bronze medal in an even after completing the heat, semi-final, and final, she earns 6 points for herself and 9 points (3+2+2+2) for her house. Note that there could be matches with only finals but no heats and semi-finals. A school decides to develop a computer application to facilitate storage and retrieval of relevant information of its athletic meets including: Contestant name, class (e.g. 1D), grade (e.g. A, B, C), sex, house Event-grade, sex, game (e.g. 200m sprint, shot put, 4x100 relay), type (e.g. heat, semi-final, final) Athletic events are classified into track events and field events. Track events are those running races whereas field events include long jump, high jump, triple jump, shot put, and discus, etc. Track event contestants aim to finish their races as fast as possible whereas field event contestant aims to achieve the greatest distance. Each student, affiliated to a house, is allowed to join as many games as she likes. For each game, a score will be awarded to the individuals as well as to the house according to the following rules: Gold medalist - 10 points to individuals; 5 points to the house; Silver medalist - 8 points to individuals; 4 points to the house; Bronze medalist - 6 points to individuals; 3 points to the house; Other contestants - 2 points to the house for a contestant's appearance in each match (to encourage participation) Note that the results table does not store any explicit information about which results being associated with the champion, 1st runner up, and 2nd runner up of any events. As an example, if a student manages to get a bronze medal in an even after completing the heat, semi-final, and final, she earns 6 points for herself and 9 points (3+2+2+2) for her house. Note that there could be matches with only finals but no heats and semi-finals.
Expert Answer:
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these databases questions
-
ENSURE WORK IS ORIGINAL OR I REJECT AND REPORT YOU TON THE SUPPORT INSTANTLYThe end result does now not should be taken care of. You may additionally expect n 6 length(xs). [Hint: Function least is a...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Determine the x-and y-intercepts on the graph of the equation. Graph the equation. y = x= 1
-
Cheryl, Cynthia, Carmen, and Chastity shot the targets below at Girl Scout camp. Match each target with the proper description. (a) Accurate and precise (b) Accurate but not precise (c) Precise but...
-
Calculate the higher and lower heating values of gaseous methane fuel (CH 4 ). Compare your results with the values in Table A27.
-
A large MNE in the cookware industry was having difficulties maintaining its market share due to a number of mergers among other competing firms in the industry. The MNE, with corporate headquarters...
-
Magness Delivery Service completed the following transactions during December 2016: Dec. 1 Magness Delivery Service began operations by receiving 510,000 cash and a truck with a fair value of $20,000...
-
Let p be the statement "Bob has a corgi", q be the statement "Bob is not busy", and r be the statement "Bob needs to clean his apartment." a) Translate the following statement into English: (p^q) r...
-
Two uniform bars of equal lengths I are hinged and supported as shown in Fig. 11.15. For a given vertical force P, determine the value of the horizontal force Q that would hold the system in...
-
The following diagram shows two reference variables pointing to the same Bunny object in memory. The reference variable myBunny is of type Bunny, while unknownBunny is a valid but unknown data type....
-
The author of this method forgot to include the data type. Which of the following reference types can best fill in the blank to complete this method? A. String B. StringBuilder C. Both D. Neither...
-
Given the file Magnet.java shown, which of the marked lines can you independently insert the line var color; into and still have the code compile? // line al public class Magnet { // line a2 public...
-
Which of the following properties of an enum can be marked abstract? A. The enum type definition B. An enum method C. An enum value D. An enum constructor E. None of the above
-
Given the following code, which lines when placed independently in the blank allow the code to compile and print bounce? (Choose two.) A. var new = TennisBall; B. TennisBall(); C. var var = new...
-
A state university stores all student data in a database. The collected data includes each student's first name, last name, age, gender, major, nationality, and so forth. The process component of the...
-
You have just begun your summer internship at Omni Instruments. The company supplies sterilized surgical instruments for physicians. To expand sales, Omni is considering paying a commission to its...
-
A construction contract differs from contracts that we generally deal with that focus on an easily defined physical object because the physical object can be examined. How is the object of a...
-
What does the owner contribute to the project and what does the contractor contribute to the project?
-
For what type of project is a line-of-balance schedule particularly suited? Identify specific examples.
Study smarter with the SolutionInn App