Strategic Human Recourses Management
Unit code: H/601/1991
QCF Level 5: BTEC Higher National
Credit value: 15
Knowledge and Skills needed to understand:
* Query and
* Implement database systems.
An understanding of:
* Database tools and
* Database technologies
* Complex data structures and interface
Databases provide the infrastructure to many organisations and they offer support to key
business applications and information systems. The most common database model used
commercially is the relational one.
The aim of this unit is to:
* Provide a knowledge and understanding of ...view middle of the document...
Approaches: top down and bottom up; tools and techniques eg entity analysis, Entity Relation
Diagrams (ERDs), determinancy diagrams, data flow diagrams; entities; attributes and key
identifiers; relationship types and enterprise rules; degrees of relationships; functional
dependency; first, second and third normal forms
New developments: dynamic storage; data mining and data warehousing; web enabled
database applications; other developments eg multimedia databases, document
management systems, digital libraries
2. Be able to design and implement relational database systems
Designs: data types; entity and referential constraints; conversion of logical database design
to a physical implementation; tools and techniques; issues around the degree of
normalisation chosen; verification and validity checks; data definition; control mechanisms
Requirements: requirements specification; relational requirements; other requirements eg
need to integrate with legacy systems, future requirements, timescales, costs.
User interface: requirements eg functionality, reliability, consistency, performance, menu
driven, HCI interface