![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
A Sports Club is an organization formed in order to help its members develop interest in certain sports.
Usually, members interested in the same sport are divided into groups and an expert trainer is responsible for training each group.
In this TMA, it is required to help the head of a Sports Club for kids implement application to keep track of the kids (members of the club) and the sports they are interested in.
Requirements:
After a quick meeting with the head of the sports club, you got the following information:
It is required to store the whole data (all groups of all sports) in one collection.
Each group has a number, a trainer and they are interested in a certain sport (e.g. football). In addition, it contains many kids with flexibility of adding and removing kids within a given
limit for the maximum number of kids who could be in the same group (where this limit is fixed and unified for all groups). Furthermore, there are other attributes (add at least 2 attributes from your choice). Group number is unique for each sport.
Each trainer has a unique ID, a name and other attributes (add at least 3 attributes from your choice). He/she could train more than one sport.
Each kid has a unique ID, a name and other attributes (add at least 2 attributes from your choice).
Moreover, you have been informed that the following operations happen frequently:
Forming a new group
Adding a kid to a specified group
Removing a kid from a specified group
Retrieving the average number of kids per group of a certain sport
Displaying all groups in a format similar to the following:
sport1: groupNo1 groupNo2 groupNo3 ...
sport2: groupNo1 groupNo2 groupNo3 ...
...
where sports and groups are sorted in ascending order
Saving all the groups into a text file Analysis:
Q1: There are common attributes and methods between kids and trainers. W
![Check Mark](/static/check-mark.png)
Step by stepSolved in 3 steps with 1 images
![Blurred answer](/static/blurred-answer.jpg)
- Systems Analysis Assignment (Microsoft Word and Excel) You and your team have been hired to set up a computer classroom for Tech United, Inc. An up and coming tech startup who will like to become a tech training company. Tech United, Inc. wants to offer various different kinds of tech training at their new office location. They have only one classroom space available that can accommodate up to 30 students. The classroom is already equipped with tables and chairs. The classroom, however, does not have any computers, routers, projectors, smartboard etc. This is where you come in. The company has $40,000 as a starting budget and will like for you to determine for them what computers/keyboards/mouse/router/printer/smartboard etc. they should buy. You determine based on their budget, how many of each item should be purchased for the classroom. Deliverables Deliverable Part 1: A systems analysis report on what kind of computers and hardware the company should use in their classroom,…arrow_forwardSoftware developers use a number of models, depending on the application. Please help me sort these models by my life experiences.arrow_forwardCreate Functional and Non-Functional requirements for the following system: A parking deck system manages an entry/exit gate, which opens to let a vehicle (i.e., car) into or out of the deck and closes when the car has passed through. A driver must push a button to print a parking permit. When the driver takes the parking permit, the system raises the gate. The system lowers the gate after the vehicle has passed through. A permit id and time of entry is printed on the parking permit, and is also encoded on the permit’s bar code. When the vehicle leaves the parking deck, the driver inserts the parking permit into a bar code reader, which scans the bar code, and then transmits the bar code to the parking system. The parking system calculates a fee that is based on the number of hours that have elapsed since the vehicle entered the parking deck, and displays the fee to the operator and driver. The driver must pay the operator with cash or check. The operator accepts the payment, and if…arrow_forward
- Software developers use a number of models, depending on the application. Please help me sort these models by my life experiences.arrow_forwardpython:numpy def shoe_shopping(shoe_arr):'''QUESTION 4You're shopping on a budget and want to determine the cheapest shoe brandgiven an array of brands and prices. Return the brand with the lowestaverage price.Hint: You should create a new array of the prices with the correct dtype.Args:shoe_list(np.arry)Return: string>>> shoe_list1 = np.array([["Nike", "Adidas", "New Balance"],["110.99", "135.99", "94.99"],["85.99", "150.99", "105.99"],["225.99", "145.99", "130.99"]])>>> shoe_shopping(shoe_list1)'New Balance'''' # shoe_arr1 = np.array([["Nike", "Adidas", "New Balance"],# ["110.99", "135.99", "94.99"],# ["85.99", "150.99", "105.99"],# ["225.99", "145.99", "130.99"]])# print(shoe_shopping(shoe_arr1))# shoe_arr2 = np.array([["Converse", "Vans", "Dr. Martens", "Steve Madden"],# ["82.99", "250.99", "180.99", "109.99"],# ["99.99", "150.99", "115.99", "75.99"],# ["125.99", "115.99", "110.99", "99.99"]])# print(shoe_shopping(shoe_arr2))arrow_forwardJustify the number of fields that should be included on a single request for information form.arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)