ment3_Description.docx - C... Search (Alt Prabin Giri ces Mailings Review View Help - AEEE 211 . A 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Paragraph is Styles B. Scenario The 2022 Commonwealth Games officially known as the XXII Commonwealth Games and commonly known as Birmingham 2022 is an international multi-sport event for members of the Commonwealth that will be held on the Birmingham between 28 July and 8 August 2022. This will be the 22nd Commonwealth Games which is held every four years. Over 5000 athletes and team officials from 72 nations and territories will converge on the Birmingham for the 12-day sporting and cultural event. A new aquatics centre, scheduled to host the swimming and diving events, being built in Smethwick, is set to be completed in spring 2022. The facility will also include a 50m Olympic-sized swimming pool, as well as a 25m diving pool, community swimming pool and permanent seating for 1,000 people. All events will be held in the 50 metre pool and athletes will compete in events for the four strokes - freestyle, breaststroke, backstroke and butterfly. The lengths for the races vary with 50m, 100m, 200m, 400m, 800m and 1500m races being held for freestyle, and at least 50, 100 and 200 metre races for other strokes. Most races have both Mens and Womens Division and there are also the relay team events and the medley which brings out the most versatile swimmers. The Commonwealth Games Federation (CGF) provides a report outlining the requirements for swimmers to qualify to compete in the games. This includes the qualifying times which the swimmers must have equalled or bettered in an official competition event within the 12 months leading up to the games. Qualifying Swim Teams Foc O 5C Clou W t3_Description.docx C... - Search (Alt+Q) Prabin Giri Mailings Review View Help Title Title Title Title TITLE The Title Title TITLE HEADING Medit Beading A Colors Fonts Paragr. Effects Set as Document Formatting competition event within the 12 months leading up to the games. Qualifying Swim Teams For a country to qualify and be included in the swimming events, there is no minimum number of team members, however each swimmer must qualify for their selected event(s). Each country's team must have a team manager, team leader (typically the strongest swimmer) and at least one coach and one medical officer. To apply for inclusion in the games, prospective countries must provide the Federation with the country's swimming team details for consideration. All team members, including swimmers, coaches and medical officers, need to provide personal contact information. Swimmer Details The swimmers must provide their contact information, gender, date of birth and the name of their coach. For each race event they wish to compete in, they must provide the details of their qualifying time, the date and approved swimming competition where the time was recorded. The qualifying time must have been recorded in 2021. Other team members: All other team members must provide their contact information. Each coach also needs to provide details about whether they have qualifications and training as a coach. Coaches are required to have a police check for working with children ("WWC Check"). In addition, coaches are certified by the Federation, and must have the date of certification and level of certification (1 to 5) recorded by the Federation. Medical officers also need to provide details of their qualifications, including the year of their degree or latest qualification and any specialisations. D. Focus 5C Cloudy > Bi ent3_Description.docx - C... O Search (Alt+0) Prabin Giri -5 Mailings Review View Help Title Title Title Title TITLE Tmt Title HEAD Title TITLE READING Para Effec A Colors Fonts Healing . Set a Document Formatting Preliminary Heats and Final Race ment 3 DATA2001 - Database Systems Page 2 Several preliminary heats/ra will be held ermine who will compete the final race for each event. The result times for each swimmer completing in each of these races must be recorded. For each event, the final winner of the Gold, Silver and Bronze medals will be recorded. Your task Birmingham 2022 requires a database to store the data associated with all swimming teams, team members as well as the preliminary heats and final races held at the games. The system of spreadsheets and paper forms that Birmingham 2022 is currently using has many data inconsistencies that detract from their belief in the accuracy of the data and information provided. While keeping requirements for a new system closely aligned to the current manual system used by Birmingham 2022, your task is to develop a prototype database, and test it with queries which are likely to be used by Birmingham 2022. You are not required to write an application to use with this database. The file DATA2001_Assignment3 SampleFormsWithData.docx, provided with this D. Focus gate 5C Cloudy O BI DATA2001Assessment3_Description.docx - C... Search (Alt+O) Prabin Giri ayout References Mailings Review View Help TTTLE Title Title The TITLE Tm Title Title TITLE HANSI A Paragrap Effects Colors Fonts Set as. D Document Formatting The file DATA2001_Assignments SampleFormsWithData.docx, provided with this assignment, provides you with some sample forms and information. The file DATA2001 Assignment3_exampleData.xlsx will provide you with further details and some specific examples of the current manual system data to get you started. Note that this data is provided "as is" and is not transferable directly to tables in the new database. The entities and attributes mentioned in the scenario and on the sample forms must be included. You will be required to normalise some of the above into smaller relations/tables prior to implementing your design into a database. You may add more attributes to help improve the design and efficiency of the database. Assessment Requirements Part A-EERD - due Week 11 a. a. EERD Drawing 7 marks Using the scenario and the data requirements provided, you must analyse the data storage needs of the client. Identify all entities and attributes and the relationships between them. Using a drawing software tool (Visio, Lucidchart or similar - NOT Word), draw an Enhanced Entity Relationship Diagram (EERD) of your design using crows foot notation. Your EERD must show all entities, attributes, relationships and cardinality as well as any business rules identified. Supertypes and subtypes are also expected in the design b. Database Design 3 marks Your final design choices should allow you to create your relational database in fully normaliced form. Following the normalieation norace MOI will determine the tables Accessibility investigate Droos CE 5C Cloudy O FS F6 FB Eg FO FIL P12 Scrl Prsc SAR Del nis IN Pause DATA 2001_Assessment3_Description.docx - C... Search (Alt+0) Layout References Mailings Review View Help Prabin Girl title TITLE Tide Title Title Title HEADING TITLE Tmi Title Title TITLE TI Paraard Effects Colors Fonts Set as A Document Formatting included. You will be required to normalise some of the above into smaller relations/tables prior to implementing your design into a database. You may add more attributes to help improve the design and efficiency of the database. Assessment Requirements Part A-EERD - due Week 11 - a a. EERD Drawing 7 marks Using the scenario and the data requirements provided, you must analyse the data storage needs of the client. Identify all entities and attributes and the relationships between them. Using a drawing software tool (Visio, Lucidchart or similar - NOT Word), draw an Enhanced Entity Relationship Diagram (EERD) of your design using crows foot notation. Your EERD must show all entities, attributes, relationships and cardinality as well as any business rules identified. Supertypes and subtypes are also expected in the design. b. Database Design 3 marks Your final design choices should allow you to create your relational database in fully normalised form. Following the normalisation process, you will determine the tables, primary keys, foreign keys and columns needed to provide all functionality required by the client as outlined in the scenario above. Identify your database schema using standard formatting for table names, keys, and foreign keys. Deliverables: Your EERD diagram should be presented in a Word document using a basic report layout with a title page. The database schema should be included on a separate page. See "Submission Format" for document naming requirements. Accessibility Investigate D Focus w 25C Cloudy F8 - F9 EM Be F2 Saruh prise SUSRO s