database system

Mbyllur Postuar 4 vite mё parё Paguhet në dorëzim
Mbyllur Paguhet në dorëzim

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.

Programim Bazash të Dhënash Java MySQL PHP XML

ID Projekti: #19629138

Rreth projektit

9 propozimet Projekti në distancë Aktiv 4 vite mё parё

9 profesionistë freelancer dërguan një ofertë mesatare prej $191 për këtë punë

utkarshkatiyar19

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..

$80 USD për 1 ditë
(317 Përshtypje)
7.2
jonyahmed105

Hi I want to do it for you sir. Thanks

$211 USD për 1 ditë
(154 Përshtypje)
6.4
muzammaljanjua86

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 Më shumë

$120 USD për 5 ditë
(49 Përshtypje)
5.6
carlosperezit

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

$55 USD për 2 ditë
(28 Përshtypje)
4.9
huseyinaygun

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 Më shumë

$135 USD për 3 ditë
(8 Përshtypje)
4.0
roushankumar2k8

I have 7 years of industry experience in database development

$25 USD për 2 ditë
(0 Përshtypje)
0.0