1 / 9

Mr C Johnston ICT Teacher computechedu.co.uk

G057 - Lecture 01 Unit Overview. Mr C Johnston ICT Teacher www.computechedu.co.uk. Session Objectives. Know what the unit is about, Understand what you need to learn, Understand what you need to do, Details of how the unit will be structured. About The Unit. This unit will teach you to:

minerva-hinton
Download Presentation

Mr C Johnston ICT Teacher computechedu.co.uk

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. G057 - Lecture 01Unit Overview Mr C Johnston ICT Teacher www.computechedu.co.uk

  2. Session Objectives • Know what the unit is about, • Understand what you need to learn, • Understand what you need to do, • Details of how the unit will be structured.

  3. About The Unit • This unit will teach you to: • Explore how record-structured databases are used in organisations, • Explore how information is structured for database storage and processing, • Understand and use logical data modelling, • Apply the principles of relational database design, • Design, implement and test a relational database to meet a given specification, • Produce user documentation, • Develop good practice in their use of ICT.

  4. Topics Covered • Database Concepts, • Logical Data Modelling, • Normalisation, • Relational Database Structures, • Relational Database Construction, • Testing Relational Databases, • Documenting Relational Databases.

  5. Pukka Pizza Assessment • This unit is assessed by means of a portfolio, • It will involve you designing, implementing, testing and documenting a database system for:

  6. The Assignment Requires… • Analysis notes of the current scenario, • Design notes for a proposed database system which meets the needs of the user, • Evidence that the data model has been normalised to 3rd normal form (NF), • A working relational database which has a user interface, including data input forms and methods of obtaining output, • User and technical documentation; • Test plans and the results of the testing of the database; • An evaluation of the effectiveness of the solution and performance whilst completing the work.

  7. The Schedule • Firstly you will look at database theory and practise designing them on paper, • Once confident you will the commence the assignment and complete the design section of the portfolio. • You will then be taught how to use Microsoft Access and work on bringing your database design to life, • Finally you will compile your portfolio as required in the mark sheet.

  8. Support • Notes will be provided to all aspects of the topic, • Support materials for writing the project will be given, • Regular exercises will be set and answers given when complete, • Scans of text books are available – read them!!

  9. Topic Task • Print and read through the unit specification. Make yourself familiar with what you need to learn and how the criteria for each task is graded

More Related