• 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. The Data Management Structure: Components and the data structure

    always matching Advance DBMSs: Data Marts and Data Warehouses The database world is a fast changing one with innovation and new products coming our yearly. In recent years, data marts and data warehouse applications have been gaining popularity as tools to boost an organization's competitiveness.

  1. I have been given the task to design a database for a company called ...

    * Price lists which specification says must be included. This will be used for hard evidence on the prices and may be used when re-pricing the cost of sending parcels. * Manager's statistics which were also specified in the specification. METHODS OF DATA ENTRY The user only needs to enter data into the database about the customer, parcel, destination and order.

  2. Develop a system for use by a fitness centre to store and organise the ...

    Membership details from ID Instructor details from ID Invoices for customers and centre records Timetables for usage of facilities Print records Hardware Pentium 2 processor This is a chip that runs the computer and processes information and allows the user to use the interface at a reasonable speed.

  1. The Value of Data and the Use of Databases

    o Elimination of mailing costs. o Reduction of document management costs (on site and off site storage). o Reduction in data entry error rates. o Elimination of communication lag time between agency and customer. o Improved customer service. o Expendability of the system to other functions (using the same translation software for various applications such as procurement, collections, payments, etc.).

  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

    Validate = False Exit Function End If If txtCentreNo.Text > 79999 Then MsgBox ("Centre number must be between 10000 and 79999") Validate = False Exit Function End If If (txtExaminerNo.Text = "") Then MsgBox ("Examiner number has to be entered")

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

    There are records located both on paper and as saved files on the computer. It would benefit from centralisation which could be achieved computerising the system. Also, if somebody else were to take over the running it may be difficult for them to understand how it works properly.

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