database system
$10-30 USD
Pago na entrega
task is to rely entirely on the existing ER model and implement a MySQL database manager. The prototype will also be filled with data so that it is
possible to demonstrate the solution for the national team. Because the database within one
future will also be linked to a website, you should also formulate
query operations that can be used against the database and indicate suggestions for parts of
The database can be forwarded using XML.
The relationship tables according to the ER model shall be implemented in the database manager
MySQL. It is important that key integrity (primary and foreign keys)
fulfilled correctly according to the model. Attribute and its appropriate data type
should be implemented in an appropriate manner. Please read "[login to view URL]"
available in Scio to ensure common design choices for the appropriate data types.
National Team ER model
Below are the ER model as the national team developed together with
systems consultants started work:
Skiers: identified by name and weighting. The national team believes that one is easy
riders are faster powder snow compared to a heavier riders. This is crucial
the riders taking out prior to each race.
Competition: Has a name and takes place on a predetermined date. In each competition can
many skaters from the national team compete. There are also skiers who do not participate in everyone
competitions due. damage and the like.
Weather: Because the weather plays a big role, you want to store the weather type (for example
sunny, cloudy, rainy, etc.) and the temperature prevailing at the respective type. The
may be that the weather changes during a race. Then want to store it in a
effective way. For example, if there is both sunny and minus 5 degrees and above
then it went on to become cloudy and minus 10 degrees.
Snow: Properties in the snow also play a major role in each competition. Here you want
store snow type (for example, fine-grained, coarse grains, sludge, fresh snow, etc.) and which
humidity prevailing in the snow. For a competition, the snow can change. At the start, it
be rough snow while on top of the hill is the slop because the sun taken more
where etc.
Ski: Every skier has a lot of different skis to choose from. Since
Many skis look alike, it is important to know which rider they belong to.
Since each rider is sponsored by a certain manufacturer, this must also be stored.
Each pods also have a range that describes about the ski works well in cold or
warm weather and its snow type. Each skier skiing identified by a number
together with the skier.
Valla: The Valla team puts a lot of time into finding the right choice
works before each competition. A lot of tests are carried out to find the right fixing floor
and slides. Therefore, you want to store the name of the whale and its type (if it is
hard wax, glue, wax, etc.).
Structure: If a ski is going to go really fast, it must also be right
structure (pattern) for the ski. Normally a coarse structure works (may look like
a Christmas tree pattern) in warm weather with sloppy snow while a finer structure
best suited in cold weather and harder snow. The structure is identified by it
name and must be on each ski.
Groove tool: Because there are different makes that manufacture structures, the national team also wants to store which brand is used. It may be that make
Swix worked better compared to Skigo even though the same structure was used
under the ski. Therefore you also want to store a comment for each groove tool. One
grooving tools are uniquely identified together with a particular structure.
The relationship tables according to the ER model shall be implemented in the database manager
MySQL. It is important that key integrity (primary and foreign keys)
fulfilled correctly according to the model. Attribute and its appropriate data type
should be implemented in an appropriate manner.
ID do Projeto: #19629138
Sobre o projeto
9 freelancers estão ofertando em média $191 nesse trabalho
Hi I'm an expert in F# programming. I'm sure that I can easily do this project. We can have a about it. Thanks..
hello i understand what you want. i develop your MySQL database and make queries for you so you can easily interact and demonstrate the database easily. i develop your database according to your ER diagram and make it Mais
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 5 Database Systems Course projects which cover: - Conceptual design (ER Diagram) - Creation of database Mais