Create a database of a motor bike racing club, Database Management System

Assignment Help:

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt tracks on private farms (ie. none of the racing is done on public roads). Racers must provide their own bike and appropriate safety gear. Each racer must make their own way to each of the racing events venues. Each time a competition day is scheduled, a number of members register for it. When they register they specify the events they wish to compete in. Currently the club manually keeps records of

  • Each member and their details
  • The days that have been scheduled to hold races and the venue (location) of the race day.
  • The individual races that will be held on the particular race day (eg: start time, length etc)
  • The members that have registered for each race they wish to compete in.
  • The results of each race are recorded (ie each competitor's time for the race and also who won, came second etc). The club wish to computerise their records. What you have been asked to do is provide the database model for the system.

 

Pass/Credit Level - Design

To assist your friend, try and come up with a small database design for a new system. Provide the following:

  • Entity Relationship Diagram.
  • Relational Model (showing fields, primary keys, foreign keys and concatenated keys).
  • Justify the choices you have made. Are the entities and relationships you have chosen free of problems? What assumptions have you made?

 

Higher Level - Construct and Test

  • Create the database tables using SQL statements in your own database. Include
  • CREATE TABLE queries - that create each of the tables in your design
  • INSERT INTO queries - that insert values into your tables (at least 5 rows per table) Write some queries to test out the database.
  • One query should be a simple one involving one table and selection criteria.
  • The second query should involve a join (at least 2 tables)
  • The third should be a group by query.
  • Fourth query that involves a nested query.

Related Discussions:- Create a database of a motor bike racing club

When are two schedules said to be view equivalent, When are two schedules s...

When are two schedules said to be view equivalent?     Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met

Non-query optimisations, Part: Recommended (Non-query) Optimisations Thi...

Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

Explain what is ddl, Explain what is DDL? DDL - Data Definition Languag...

Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT

Attribute, a set of possible data value of an attribute is called??

a set of possible data value of an attribute is called??

What is equi join, What is equi join? Equi Join - It generates all th...

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

Explain the equijoin, Explain the θ-join and equijoin Refer tables Car ...

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

Define garbage collection, Define garbage collection. Garbage may be fo...

Define garbage collection. Garbage may be formed also as a side effect of crashes. Periodically, it is essential to find all the garbage pages and to add them to the list of fr

Write a short note on temporary tables, Write A short note on temporary tab...

Write A short note on temporary tables? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction

Project on designing and creating a database , This project will involve de...

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

What is an object id, What is an object ID? Each class-derived table ha...

What is an object ID? Each class-derived table has an ID for primary key, one or more object IDs form primary key for association derived tables. An object ID is equivalent dat

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd