Computers and Technology, 19.10.2021 09:40 123martinnnnn

You are hired to create a database for managing the information about a local girl soccer league. This league has more than 20 teams. Each team has a name, base-location, and an email address as the contact. Each team has a manager and a coach. Each team has multiple players. A player has a jersey number in her team. But if she plays for another team later, her jersey number may be different. The league needs to keep track all players, including name, phone, DOB, address, and parent’s phone. The information about the game is also important to the league, such as teams played, game time, location and the scores. The league not only wants to know which team plays games, but also which player played at each game and her stats (such as playing-minutes, goal made, number of faults, etc.). The coach of team is usually appointed for 2-year term. The league needs to know when a coach is appointed, coach’s contact number, his/her profession, education degree received, etc., A coach may coach different teams at different time period. The information of manager of each team should be also stored in the database, including his/her contact info. A manger may also work for different teams at different time period. Each team has some helpers/assistants who are usually parents or volunteers from local communities. The league also needs to keep track their contact information. a. create an ER model for this database.
b. transform this ER model into a set of tables.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 23:00

Fast sportcars the top speeds of sportscars, given in miles per hour, are: 155 mph bmw m5 217 mph lamborghini aventador spyder 205 mph ferrari 488 205 mph nissan gtr 197 mph chevrolet corvette stingray zr1 258 mph bugatti veyron supersport 195 mph dodge viper 270 mph hennessey venom 155 mph bmw m3 195 mph mercedes sl given: topspeeds=[155; 217; 205; 205; 197; 258; 195; 270; 155; 195]; carnames=string(["bmw m5" "lamborghini aventador spyder" "ferrari 488" "nissan gtr" "chevrolet corvette stingray zr1" "bugatti veyron supersport" "dodge viper" "hennessey venom" "bmw m3" "mercedes sl"]); the variable is a rectangular array. write a function called selectcars to identify cars with the top speed within a given range, and display the identified names. the selected cars speed will be in a range given by lowerbound < speed < upperbound. inputs to the function selectcars are: a column array os all car top speeds named topspeeds, the corresponding chara

Answers: 2

Answer

Computers and Technology, 23.06.2019 15:30

Write a program in plp assembly that counts up by one starting from zero (or one) inside a loop and writes this value to the leds every time the value is increased. the memory address of the leds is 0xf0200000. the table below shows the meaning and an example usage of the instructions covered in the video, plp instructions for project 1. instruction example usage meaning load immediate li $t0, 8 register $t0 is set to the value, 8. store word sw $t2, 0($t1) the value in register $t1 is used as the memory address. the value in register $t2 is copied into this memory address. add addiu $t4, $t3, 29 register $t4 is assigned the sum of 29 and the value in register $t3. jump j your_label_name the program jumps to the line following the label, "your_label_name: ". label your label name: defines a label called "your_label_name: " that can be jumped to

Answers: 2

Answer

Computers and Technology, 25.06.2019 05:10

What is the output of the following program? #include using namespace std; class bclass { public: void print() const; bclass(int a = 0, int b = 0); //postcondition: x = a; y = b; private: int x; int y; }; class dclass: public bclass { public: void print() const; dclass(int a = 0, int b = 0, int c = 0); //postcondition: x = a; y = b; z = c; private: int z; }; int main() { bclass bobject(2, 3); dclass dobject(3, 5, 8); bobject.print(); cout < < endl; dobject.print(); cout < < endl; return 0 ; } void bclass: : print() const { cout < < x < < " " < < y < < endl; } bclass: : bclass(int a, int b) { x = a; y = b; } void dclass: : print() const { bclass: print(); cout < < " " < < z < < endl; } dclass: : dclass(int a, int b, int c) : bclass(a, b) { z = c; }

Answers: 3

Answer

Computers and Technology, 25.06.2019 07:00

Asap 50 points ( paragraph pls) discuss the role of the concept behind the "internet of things (iot)" in today's digitally connected society.

Answers: 2

Answer

You know the right answer?

You are hired to create a database for managing the information about a local girl soccer league. Th...

Questions