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

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.
Posted Date: 3/2/2013 5:12:14 AM | Location : United States







Related Discussions:- Create a database of a motor bike racing club, Assignment Help, Ask Question on Create a database of a motor bike racing club, Get Answer, Expert's Help, Create a database of a motor bike racing club Discussions

Write discussion on Create a database of a motor bike racing club
Your posts are moderated
Related Questions
For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta

What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a

While sorting, if the main storage available is not enough, the system writes data to an external help file.  The SAP profile parameter, which determines DIR_SORTTMP

What is called a query evaluation plan? A sequence of primitive operations that can be used to assess a query is a query evaluation plan or a query implementation plan.

Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have

What are the three types of data sources used with ODBC? An ODBC file data source is a file that can be shared between database users. An ODBC system data source is one that is

Project Description: Critical Project for VMware Technical support. VMWare ESXi 5.1 support for upgradation and migration problem. Technical expert of Vmware needed. Sk

Project Description: Hi I'm seeking someone to make my dBase application work. I know it's not a 'modern' language but it's what I know. I have written an order program and I ne

Develop C# schoolproject ASAP Helping me with schoolproject. The project is prepared in C# and haves a database connection. We have some small issues asking up data from t