• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design of database.

Extracts from this document...

Introduction

TASK 4: Design of Database INFORMATION TECHNOLOGY COURSEWORK By: Sudhanshu Mohanty Advantages of Database The software used to produce a suitable database is Microsoft Access, this software is used because it consists of all the database functions thus giving clear access to storage of information. Tables Tables are used in Database to collect and store data in a orderly manner, tables need to be used because when a field is put in Microsoft analyzes the data and puts in the appropriate format, the format can be altered depending on the field this can be don manually. It is possible to use make-table queries to archive old records, to make backup copies of tables, to select a group of records to export to another database, or to use as a basis for reports that display data from a specific time. ...read more.

Middle

Queries Queries are used to view, change, and analyze data in different ways. It can also be used as a source of records for forms, reports. There are several types of queries in Microsoft Access. Data Dictionary Field Name Data Type Format Description First Name Text 30 Characters This is the First Name of the Member Last Name Text 30 Characters This is the Last Name of the Member Date of Birth Date/Time Short Date This is the Date of Birth of the Member Sex Boolean M/F This is the Gender of the Member Home Telephone Number Auto Number This is the Home Contact number of the Member Mobile Number Auto Number This is the personal Mobile Number of the Member Address Text 50 Characters This is the Home address of the Member District Boolean Hong Kong/Kowloon/ New Territories This is the District which the Member lives HK ID ...read more.

Conclusion

Auto Number This is the flexibility of the member a before/after the course Height Before/After Number Auto Number This is the Height of the member before/after the course in cm Weight Before/After Number Auto Number This is the result of the weight before/after the course in Kilograms Course Name Text 30 Characters This is the name of the Course Days Boolean Monday/Tuesday/Wednesday/Thursday/Friday/ Saturday/Sunday This is the days in which the course takes place Time Date/Time Short Time This is the Time which the course starts Instructor Name Text 30 Characters This is the Name of the Instructor who leads the Course Instructor Gender Boolean M/F This is the Gender of the Instructor who leads the Course Description Text 50 Characters This is the Description of the Course Course Data Date/Time Short Time This is the Date the course is on Data Flow Diagram By: Sudhanshu Mohanty 11 TANG 34 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Database Design Guideline

    ==> Reports - a report in Microsoft access will allow me to see information from the database in a presentable form. Whipps Cross will need reports in their database so they can see the out come of they results.

  2. Database design.

    will be like this when you click on it: Creating a relational database When all the tables have been created then we have to create a link between the tables; this is called a relational database. To do this I must click on a button on the toolbar at the

  1. Database Coursework

    Field Data Type Length Reason Loan ID AutoNumber Long Integer I have set this as AutoNumber so that computer automatically provides a unique number for each record. This can be any length as it linked to the number of loans.

  2. GCSE Database Project ICT

    The report is saved and printed and the Mail Merge is created and the query results linked with word (having the template already completed) the relevant information. Fields Required, searches, sorts and reports that will be needed Fields Table Fields Field Type Table Fields Field Type Patients Appointments Patient ID

  1. ICT Coursework (MarcoS)

    by name and date when the work is done, so you can access easily and fast to all the work done, without loosing time. The system will be accessible from anywhere in the world so every employee can check their work, and keep the account updated.

  2. ICT COURSE

    Evaluation: These computers as I mentioned above make the work a lot easier for Orchard Orthodontic as they can save templates and use the templates again and again without starting to write something from the start and then do all the work again which saves a lot of the time.

  1. Organising the database at Costsloadsless.

    DVD's just so it wont take long to find which DVD's/video's are in stock. The entire DVD collection will be in alphabetical order, just so the Employee will no straight were to look that way it will save time. ** advantages** **disadvantages** o It is quick and easy you don't need many skills!

  2. Evaluation of a membership card design

    * The Member ID field must be the key field. I have met this by making the Member ID field the fey field, and I have made this field as an auto number so that the number will be computer generated, so that nothing else can be entered in this

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