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

    Integrated Consignment notes for the deliveryman and Customer Instead of having two separate consignment notes for the deliveryman and the customer I have designed a query which incorporates all the field from both consignment notes. This query is shown below.

  1. Video Club Database Project

    However he has now entered data for over 100 items and has no problems to report. 7. All reports are implemented as specified. 8. The menus work as planned. SECTION 7 APPENDIX Password Menu Private Sub Login_Click() On Error GoTo Err_Login_Click Dim stDocName As String Dim stLinkCriteria As String Text1.SetFocus

  2. Spare Parts Database Project

    When a client comes to fetch his order, he must spend time in searching for it. 1.4 Objectives of the new system. The objectives may be stated in both quantitative and qualitative terms. 1. The system should consist of a proper database to hold records, so as to minimize loss of records.

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

    ( Section 6.1 - Annotated Listing * Produce, where appropriate, a listing of each program or macro in the system with appropriate comments. Any complex routines should have comments indicating how they work. This table provides a description of all the units/modules involved in the program.

  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. Computing Module 3 Writeup

    This produces a message box, which displays the error. The validate value starts off True. If any of the validation criterion are breached, then this validate value is made False and this value is taken up into CmdAddCen Public Sub and this stops the database from being updated, as it will only be updated if Validate=True.

  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