• 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. I have been given the task to design a database for a company called ...

    Delivery Date This form will not actually be used to directly enter in information on orders as the order information will be entered in by the user on to an order form which due to the relational links between the tables will transfer the necessary information on to order table.

  1. Network research assignment.

    that allows a computer to connect to a network. NIC's come in different formats depending on the type of network needed. They are developed in half size (8bit transmission) or Full size (16bit transmission) which means the can send a small or large amount of communication data.

  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

    The validation checking loop starts off at the top. So, if no value had been entered for Centre Number, a message box would pop up displaying the error. Once this has been rectified and the validation rule passes, validate gets reset to True and the loop continues.

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

    > Create a system with the lowest possible cost for the client to implement. > Make the system clear and simple to use > To decrease the amount of time it takes to operate the additional system by replacing processes with automated functions and minimising user input to just using a keyboard and mouse.

  1. Video Club Database Project

    I own this place. Self: What problems do you get with the manual system? Mr. Michael It is time consuming to fill records on paper and sometimes important documents are loss. Self: How much are you ready to invest in the computerization?

  2. 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?

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