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

Load - unload utilities, These permit the user to unload a database or part...

These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in

Data warehouse, 1) Define a job scheduling strategy that will meet business...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Briefly describe concurrency execution, Briefly describe concurrency execut...

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

Correlated and uncorrelated queries, need to get answer for questions 3&4 o...

need to get answer for questions 3&4 on this page in part 1

Explain the concept of deadlock, Explain the concept of deadlock Yes. I...

Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s

Assignment, Birla Institute of Technology & Science, Pilani Work-Integrated...

Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG

Define views in relational algebra, Views in relational algebra:   1. B...

Views in relational algebra:   1. Basic expression contains either  a) A relation in the database. b) A constant relation. 2.  General expressions are madde out of sma

Describe substring comparison in sql, Describe substring comparison in SQL....

Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

How is the database organised in oracle, How is the database organised in O...

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

What are the different kinds of database end users, What are the different ...

What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que

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