8729 BTec Nationals IT Practitioners
Unit 5 Advanced Database Skills
scheme of work session1 session2 session3 session4 session5 session6 session7 session8 session9 session10 session11 session12 session13 session14 session15 session16 session17
| Assignment 1 | Assignment 2 | Assignment 3 | Assignment 4 |
| pdf version | pdf version | pdf version | pdf version |
| Word version | Word Version | Word Version | Word Version |
| P1 | P5 | P2 P3 P4 P6 M2 M3 D2 D3 | M1 M4 D1 |
Current Homework
New Homework.
Resources How do you become number one on Google?
Description of unit
Many jobs involve the use of databases and for this reason employees with database
skills are valued. The advantages of using a database are extensive, including
significantly reduced data storage requirements, improved record manipulation and
faster access to records.
Most organisations use databases in some way to store records, for example customer
information, supplier information, employee details and basic financial information.
These records can be searched, sorted, ordered and indexed. Using a simplified chart
tool, graphs and charts can also be created and embedded in reports.
As with spreadsheets, data mining software can make use of database files to
interrogate records and look for trends or unusual events.
To ensure that databases have integrity, validity and efficiency, designing the
database prior to implementation is important. Failure to do this may result in a poor
product.
Learning outcomes
On completion of this unit a learner should:
1 Understand the purpose and features of relational databases
2 Be able to create, populate and test a multiple database
3 Be able to use advanced features of a database and test functionality.
Links to other sites with suitable resources
Last Revision Saturday, September 12, 2009 6:57 PM