After careful and repeated reading of the text of the problem, it is believed that the concepts around which will develop the database may be summarized as follows:
- Teams Athletes
- Gare
- Among the steps
- Institutes
- Calendars
- Locations
- Ratings
- How does a race? Allocation of time and evidence to support
- What is a race? a series of tests based on: test, quiz, report, plan, treatment of a topic
- In What are the stages? a series of races; such events can be repeated in each phase?
- What is the timetable? the scheduling of events at different stages in terms of: date, time, type of race, where will the race teams participating in the race
- How to manage and distinguish the races for teams and competitions for individuals? hypothesis would be to consider the individual as a team, for example by adding an attribute: number of components Team
- how to handle the records? One possibility would be to use an attribute that stores the record before a race.
Entities The entities could be identified as follows
- Athletes: contains all the information in the Registry for athletes with the added attribute age
- Teams: as anticipated, we will assume that the teams can be composed also by a single athlete and it will be assumed the presence of an attribute: Number of components. In this way, even the athletes who participate in the races will be treated as a team
- Steps: will feature: site description of the start date being
- Gare : will be described and identified, as mentioned above will add an attribute : Score Record
- Institutes : contains all the demographic information of the institutes participating in the competitions including geographic information: city district region state, whereas the countries international may not have all the same geographical organization will take the details of the Italian one providing for the assignment of NULL values.
- It could also be evidence of the magnitude associated with each race, but this is not explicitly referred
Possible associations could be:
- Calendar: type ternary alloy that entities: competitions, teams, phases, with the attributes: date, time that identifies the event
- Belonging: a binary that links entities Teams Athletes
- come: a binary that links entities Athletes Schools
Before I suggest you check whether the scheme meets the requirements of the identified query
0 comments:
Post a Comment