database system

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.

Квалификация: Программирование баз данных, Java, MySQL, PHP, XML

Показать больше change website start page phpbb portal, change default start page, change default start scripts, database system pdf, what is database management system, database systems techopedia, types of database management system, what is database system what is its need, database systems examples, database management system examples, different database systems, change week start day excel, database task, sharepoint database task application, database task management system project asp net, change blackberry start screen wallpaper, write a c++ programming fuly employe salery gender ageadd node at start, career change at 50, access database task tracker, change at bat icon android

О работодателе:
( 1 отзыв ) gothenburg, Sweden

ID проекта: #19629138

10 фрилансеров(-а) в среднем готовы выполнить эту работу за $175


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 за 1 день
(312 отзывов(-а))

Hi I want to do it for you sir. Thanks

$211 USD за 1 день
(153 отзывов(-а))
$111 USD за 3 дней(-я)
(47 отзывов(-а))

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 Больше

$120 USD за 5 дней(-я)
(49 отзывов(-а))

I am web and app program Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer to feel the greatest satisfaction with low price. If you want to dev Больше

$30 USD за 1 день
(37 отзывов(-а))

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 за 2 дней(-я)
(28 отзывов(-а))

Hi, I have read through your job descriptions, and I understand all of the requirements. I am applying because I believe that I have the required skill set to complete your project. I have been working as a PHP develo Больше

$950 USD за 20 дней(-я)
(28 отзывов(-а))

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 Больше

$135 USD за 3 дней(-я)
(8 отзывов(-а))
$35 USD за 2 дней(-я)
(0 отзывов(-а))

I have 7 years of industry experience in database development

$25 USD за 2 дней(-я)
(0 отзывов(-а))