Simple Relational Database Management System (RDBMS)

Develop a fragment of a (hypothetical) Relational Database Management System (RDBMS) for the Formula 1 World Championship, the underlying logical data model of which should include the following entities:

• DRIVER – a competitor, with a name and team allegiance

• TEAM – to which each DRIVER belongs

• CIRCUIT – a part of a competition in which DRIVERs compete and achieve times

• COMPETITION – a sequence of CIRCUITS

Note that the RDBMS must be capable of storing the results of several World Championships. It should be able to store the result the finishing times of each race on a circuit, and it should make it possible to compute the current leader board for the competition.

Clearly state any assumptions made when you refine this description. You are welcome to use any online sources to clarify your understanding of Formula One, but make sure you reference them.


Deliverables are as follows.

Stage 1: Should contain

(1) Specification of the scope and functionality of your system, including any assumptions you have made (approximately 300 words).

(2) Identification of functional dependencies and normalisation of tables.

(3) Logical data model:

EAR scheme and its relational representation.

RI diagram with a concise but informative description.

Upon Successful Completion of this task, You will be First Choice In the second Part which involves SQL.

DEADLINE Is 25th Monday.

Taidot: MySQL, tietojärjestelmäarkkitehtuuri, SQL, Web hosting, Verkkosivun hallinta

Näytä lisää: use of sequence diagram, times leader, the sequence diagram, team management online, system architecture diagram, specification scope, software competition, simple sequence diagram, sequence diagram online, sequence diagram include, scope specification, online competition software, make sequence diagram, make a diagram online, functional sequence diagram, functionality diagram, description of sequence diagram, deliverable management, data sequence diagram, competition management, compete software, a sequence diagram, online relational database, online database management, online circuit

Tietoa työnantajasta:
( 5 arvostelua ) Oxford, United Kingdom

Projektin tunnus: #4270006