Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.1. A list of the business rules; 1.2. ER Diagram(s) prepared using software such as MS Office Visio or any other ER diagram tool. These

image text in transcribed

image text in transcribed

image text in transcribed

1.1. A list of the business rules;

1.2. ER Diagram(s) prepared using software such as MS Office Visio or any other ER diagram tool. These should include all necessary information about the entities, attributes and relationships. Please provide clear and easy-to-read screenshot of your ER Diagram(s). If you draw your diagram(s) in MS Visio, please submit the Visio file too;

These are very important for me.

plz help me. I will give you good things.

Scenarla Footscray University (FU) organizes table tennis match at university wide for both staff and students. This is an annual activity that has a history of 11 years. You are asked to design a small database for the organizer to record data for better management service in the future. Every year, there are 20 teams participating in this table tennis match. The team can be formed by staff and students together. For each team, there is at least one staff to be the leader of the team, who will communicate with organizer and leaders from the other teams. A team needs 4 to 8 members, including the leader. A form was used to collect the member information of each team. The leader needs to submit this form to organizer two weeks before the first game. In the form, all members' name, contact email address, role (leader, primary player, or substitute), staffistudent ID are provided. One staff or student can only play for one team. Each team has a name for itself, which is also provided in the form. Final (Round 4) Team STeam T Semi-Fina (Round 3) Team W Team X Team Y Team 2 Round 2 Team A Team B Team C Team D Team l Team 3 Round 1 Team 1 | | Team 2 | | Team 3 | Team 4 | Team 5 Team 6 Team 7 Team 8 Team 17 Team 18 Team 19 Team 20 Scenarla Footscray University (FU) organizes table tennis match at university wide for both staff and students. This is an annual activity that has a history of 11 years. You are asked to design a small database for the organizer to record data for better management service in the future. Every year, there are 20 teams participating in this table tennis match. The team can be formed by staff and students together. For each team, there is at least one staff to be the leader of the team, who will communicate with organizer and leaders from the other teams. A team needs 4 to 8 members, including the leader. A form was used to collect the member information of each team. The leader needs to submit this form to organizer two weeks before the first game. In the form, all members' name, contact email address, role (leader, primary player, or substitute), staffistudent ID are provided. One staff or student can only play for one team. Each team has a name for itself, which is also provided in the form. Final (Round 4) Team STeam T Semi-Fina (Round 3) Team W Team X Team Y Team 2 Round 2 Team A Team B Team C Team D Team l Team 3 Round 1 Team 1 | | Team 2 | | Team 3 | Team 4 | Team 5 Team 6 Team 7 Team 8 Team 17 Team 18 Team 19 Team 20

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 And Expert Systems Applications 33rd International Conference Dexa 2022 Vienna Austria August 22 24 2022 Proceedings Part 2 Lncs 13427

Authors: Christine Strauss ,Alfredo Cuzzocrea ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

3031124251, 978-3031124259

More Books

Students also viewed these Databases questions

Question

17. What is an example of an unconscious visually guided behavior?

Answered: 1 week ago

Question

using signal flow graph

Answered: 1 week ago