subject

A children’s sports league is currently keeping its records on paper and has asked you to design a data model so they can track their information in a database. For each child, the league has: first name, last name, age, address, whether a boy or a girl, and a note to indicate asthma or other medical conditions. They tell you that first and last name is good enough to identify a child. Each child has his or her own emergency contact, and for each emergency contact the league has: name, phone number, and relationship to the child. The league intends to use this database for many years, and over time each child will be on multiple teams. Of course, each team will have several children on it, and the league tracks the following about each team: sport, team name, coach’s name, number of wins, number of losses, and number of ties. For each child-team assignment, the league tracks the jersey number and position the child plays on that team. Create the entity-relationship diagram (ERD) for an appropriate data model. Be sure to indicate the identifier for each entity (if any) and the relationships between entities using the crow’s-feet method.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 00:30
These tools give presenters more freedom to move about the room and interact with their audience. laptop computer laser pointer lcd projector remote control
Answers: 2
question
Computers and Technology, 22.06.2019 22:40
Least square fit to polynomial write a function leastsquarefit3pol that solves a linear system of equations to find a least squares fit of a third order polynomial to an experimental data set given as two row arrays. the function leastsquarefit3pol must explicitly solve a set of linear equations and cannot use polyfit. there should be no restriction on the size of the problem that can be solved.
Answers: 1
question
Computers and Technology, 23.06.2019 00:40
Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why.a.) student.course.callnum = "csc230"; b.) cin > > student.name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student.name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist.course.credits = 3; j.) course = studenttype.course;
Answers: 1
question
Computers and Technology, 23.06.2019 02:00
Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”
Answers: 2
You know the right answer?
A children’s sports league is currently keeping its records on paper and has asked you to design a d...
Questions
question
Mathematics, 18.12.2021 01:20