BTEC First IT Practitioners - Unit 7 Databases / IVA
Visited times
Remember the Policy adopted by your tutors is quite simple .... If a document relating to your course of study has been published on THIS WEBSITE, then we ASSUME YOU HAVE READ IT. This means that YOU CANNOT claim to NOT know about any topic that is covered on this website which relates to your course of study.. YOU have already SIGNED an agreement under the college LEARNER CODE OF CONDUCT that clearly states YOU are solely responsible for YOUR OWN LEARNING (with the support of your tutors). So make sure that you download , print and work through ALL the support notes and documents from this website that relate to you and your course. If you do this then your grades will improve dramatically .......kind regards .... Paul Bolger ...... 
Unit 7- Databases
   
Part 1 Features and facilities of a relational database
   
 

Components: Database Management System (DBMS) and the database itself. Examples of commercial packages
 

Relational database structure: tables, records, fields, key fields
 

Multiple tables: concept of related tables and common fields to link them
 

Facilities: forms, queries, reports, sorting, calculating
  Case studies: explore the use of databases in industry citing specific examples and facilities they provide for information provision
   
   
Part 2 Design a suitable database
   
 

Define tables: meaningful names and acceptable fields, using text and numeric fields appropriately
 

Forms for data entry: appropriate labels and sequencing for data entry
 

Sorting and searching: sorting on one or more fields and simple, meaningful queries on one or more tables
  Reports: on tables or queries; selection of appropriate layouts, labelling and titling
   
   
Part 3 Provide documentation for the database design
   
  Documentation user manual: design a user manual, giving guidance on purpose of database and forms for input and samples of reports
  Development log: recording stages, table definitions, consideration of alternative designs
   
Part 4 Evaluate the database
   
  Evaluation: is the database fit for its purpose? What problems were encountered? Was it easy to use? What improvements would be made to the overall design?