Links

 

0276 BTec Nationals Unit 35 Advanced Database Skills

Next Session Session 1

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.

1 Understand the purpose and features of relational databases
Relationships: creating and modifying relationships; cascading updates and deletes; benefits of the relational model, eg reduced data redundancy; normalisation (first, second and third normal forms); one-to-many; one-to-one; many-to-many (removal through normalisation)
Field properties: data types and properties of different field types
Creation and modification: tables; queries; reports, eg changes to a table, adding or deleting fields, changing field characteristics
Key fields: primary keys; foreign keys; referential integrity; auto incremented keys
Errors: identification of typical errors, eg different data types in related tables; rectification of errors; poor design; inconsistent normalisation

2 Be able to create, populate and test a multiple database
Data entry forms: verification and validation routines; input masking; checks for completeness; data consistency; data redundancy; visual prompts; dropdown or combo boxes
Importing data: import data from external sources, eg other databases, spreadsheets, text files
Query design: selection of data types to facilitate querying; use of logical operators, eg AND, NOR, NOT
Exporting data: query and report results to other applications, eg spreadsheet, database

3 Be able to use advanced features of a database and test functionality
Ensuring and maintaining integrity: use of software features such as update and delete
Creating styles: for fields, tables, forms, reports; style as appropriate to user need; consistency of styling and as tools and techniques, eg using tool box
Customising: menus and toolbars, eg use show/hide functionality, add buttons to toolbars
Automation: programmed routines, eg macros, scripts, program code
Evaluation criteria: appropriate for user need
Testing: functionality; against user requirements; customer acceptance

Scheme of Work

Session:Autumn 2009

 

 

School: Business Computing and Retail

Course title and year:

 

Btec Natonal Diploma 2008/10

Lecturer: Philip M Russell

E-commerce

 

 

Module/subject/unit:

Unit 35 Advanced Database Skills

Duration of Each Session: 1.5hrs

 

Week Number 1st Session 2nd Session
1    
2    
3    
4    
5    
6    
7    
8    
9    
10    
11    
12    
13    
14    
15    
16    
17    

 

 

Week

Topic + Learning outcomes

(what the student will be able to do)

Learning activities

Inc ILT activities

Assessments &

Assignments,

(Inc Key Skills Assessment)

1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      

Essential resources
Learners will need access to appropriate hardware and software that can handle relational databases such as Microsoft Access. Learners will also require manuals and helpsheets related to the actual software used.

Indicative reading for learners

Textbooks

Hernandez M — Database Design for Mere Mortals: A Hands-on Guide to Relational Database Design, 2nd Edition (Addison Wesley, 2003) ISBN 0201752840