• 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 ...

    in the query screen print showing all the fields, to get a match to the name of recipient which is written in as shown in the above caption. In the dialog box I could have had one of two possible formulas I could have had: * Like "*" [Enter Business

  1. Video Club Database Project

    Report Menu All buttons placed using wizards. Maximise macro runs on opening form. Input Forms The Customer details form has a combo box displaying Customer codes so that the user can look up the record for any Customer. The record source for this box is the database.

  2. Spare Parts Database Project

    The database should hold information on item and customer. 3. It should be possible to update the stock automatically and inform the suppliers when the re - order level has been reached. 4. Customer should be informed on new products by selecting criteria and mail merging.

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

    ( A working system has been completed in a reasonably effective manner Following the time plan. ( There may be some defects in the solution ( The system is reasonably easy for user and/or operator. ( The use of software has been generally effective but not entirely appropriate.

  2. Network research assignment.

    and meet at Switching Elements/Router's (a central computer that will connect a group of the transmission lines) where it is decided which Transmission Line the Data must travel out on. The series of Switching Elements are what form the communication subnet.

  1. I have been given the task of creating a system for a hospital to ...

    I have decided to keep the hardware simple any only have a computer, keyboard, VDU and mouse. This is relatively cheep compared with the other options and will be easy for the user to understand. Software There are three main choices of software these are Excel a spreadsheet, Access a database or a high level language such as Pascal.

  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

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