• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19

Basic Database Building

Extracts from this document...

Introduction

Ricki Lambert Software Applications D1 and D2 Database Assignment In this assignment I had been given the task of creating a multi table database that would be implemented in to a sports complex called Sports World. The database had to do the following things; * It needed to have an input form for all of the users to be entered in to the database * From the above it needed to have a report that was generated this giving the operatives a printable set of criteria and details * It had to record the bookings for people * It needed to record the amount of times the facilities were used * From the above bullet point a report needed to be generated * The database would need to sue some form of validation to ensure accurate data entry * Summary charts need to be generated * A control needed to be added for the main access of the programme, a switchboard is ideal for this The data dictionary has been carried out on another piece of paper and will be attached to the back of this document Database Building The building of the database was in some parts quite challenging, it was imperative for a sports complex to have a efficient database to ensure data wasn't replicated, to do this we needed to normalise the database. The database normalisation was done to second form and this left me with the following tables. ...read more.

Middle

Size ID Long Integer 4 AllowZeroLength: False Attributes: Fixed Size, Auto-Increment CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False OrdinalPosition: 0 Required: False SourceField: ID SourceTable: FacilityUses Facility ID Text 50 AllowZeroLength: True Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: Text Box IMEMode: 0 IMESentenceMode: 3 OrdinalPosition: 1 Required: False SourceField: Facility ID SourceTable: FacilityUses UnicodeCompression: True Gym Uses Text 50 AllowZeroLength: True Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: Text Box IMEMode: 0 IMESentenceMode: 3 Ricki Lambert 16 May 2008 Table: FacilityUses Page: 5 OrdinalPosition: 2 Required: False SourceField: Gym Uses SourceTable: FacilityUses UnicodeCompression: True Sauna Uses Text 50 AllowZeroLength: True Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: Text Box IMEMode: 0 IMESentenceMode: 3 OrdinalPosition: 3 Required: False SourceField: Sauna Uses SourceTable: FacilityUses UnicodeCompression: True Football Uses Text 50 AllowZeroLength: True Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: Text Box IMEMode: 0 IMESentenceMode: 3 OrdinalPosition: 4 Required: False SourceField: Football Uses SourceTable: FacilityUses UnicodeCompression: True Tennis Court Uses Text 50 AllowZeroLength: True Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: Text Box IMEMode: 0 IMESentenceMode: 3 OrdinalPosition: 5 Required: False SourceField: Tennis Court Uses SourceTable: FacilityUses UnicodeCompression: True Ricki Lambert 16 May 2008 Table: FacilityUses Page: 6 Relationships FacilitiesFacilityUses Facilities FacilityUses Facility ID Facility ID Attributes: Not Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields Facility ID 1 Clustered: ...read more.

Conclusion

MemberDetails Football Uses Long Integer 4 AllowZeroLength: False Attributes: Fixed Size CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DecimalPlaces: Auto DisplayControl: Text Box GUID: {guid {B181FBAF-093C-4C2E-999C-A488F876BF73}} OrdinalPosition: 16 Required: False SourceField: Football Uses SourceTable: MemberDetails Tennis Court Uses Long Integer 4 AllowZeroLength: False Attributes: Fixed Size CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DecimalPlaces: Auto DisplayControl: Text Box GUID: {guid {AEDB07A9-8515-4231-8077-F07632748785}} OrdinalPosition: 17 Required: False SourceField: Tennis Court Uses Ricki Lambert 16 May 2008 Table: MemberDetails Page: 14 SourceTable: MemberDetails Membership active? Yes/No 1 AllowZeroLength: False Attributes: Fixed Size CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: 106 Format: Yes/No GUID: {guid {DBCAC31A-AEC1-47C5-A66B-431DE9FA8CB5}} OrdinalPosition: 18 Required: False SourceField: Membership active? SourceTable: MemberDetails Relationships MemberDetailsFacilities MemberDetails Facilities Member id Facility ID Attributes: Unique, Not Enforced RelationshipType: One-To-One Table Indexes Name Number of Fields Postcode 1 Clustered: False DistinctCount: 1 Foreign: False IgnoreNulls: False Name: Postcode Primary: False Required: False Unique: False Fields: Postcode Ascending PrimaryKey 1 Clustered: False DistinctCount: 6 Foreign: False IgnoreNulls: False Name: PrimaryKey Primary: True Required: True Unique: True Ricki Lambert 16 May 2008 Table: MemberDetails Page: 15 Fields: Member id Ascending User Permissions admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Visual basic

    * Because of this user control, event-driven programs are considered to be "user friendly." Object Oriented Programming * A Class defines under what circumstances an object can be created. * An Object is an instance or example of a class.

  2. Flow Control and Data Compression

    If multiple e-mails are to be sent at once then they will be stored within the buffer. When the buffer is full and another job is sent the modem will say to the computer not to send any more. It does this by using CTS "clear to send" Once all

  1. Computing Module 3 Writeup

    Then MsgBox ("Forename has to be entered") Validate = False Exit Function End If If (txtAddress.Text = "") Then MsgBox ("Address has to be entered") Validate = False Exit Function End If If (txtPostCode.Text = "") Then MsgBox ("Postcode has to be entered")

  2. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    When the batches are processed they are usually done at a time when the computer carrying out the processing is idle. This sort of method is very efficient when many transaction files have to be processed. If I were to use this method in my system the data that is

  1. Spare Parts Database Project

    Wong; The business deals in the selling of engines and spare parts. 4. Self: From where does the business import its goods? Mr. Wong; The business imports its goods from Japan and South Africa. 5. Self: What are the problems that the business is facing?

  2. Video Club Database Project

    Michael would invest about Rs30 000 in the new system. Summary of the interview A lots of problems with the new system has been revealed during the interviews, and the new objectives recommended was done but it was time consuming to take data from the old paper-based system and

  1. Pro5 is a Bristol based 5aside football league based at The Beeches in Brislington ...

    The current manual system used currently involves a lot of paperwork, and a lot of unnecessary staff time and costs. The proposed computerised system would make the result handling, fixture organising, registering of players and league calculations a lot simpler and more efficient, as well as reducing costs and providing a more up-to-date system.

  2. Network research assignment.

    Client-server models are also very restrictive, since the server can only hold so much space each client only has a certain amount of memory, the more clients there are, the less memory each will be allocated. Peer-To-Peer This is the other form of LAN network, usually used in the home environment.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work