DV6E 34: Database Design Fundamentals
This Unit is designed to provide the candidate with the skills required to create, maintain and interrogate a relational database management system using commercially available database software. The resultant skills will help prepare the candidate to enter commercially operated database environments and to administer the system to the requirements of the industry. The Unit is primarily aimed as an introduction to relational database management systems and will incorporate the skills to design a suitable structure to maintain and update real world systems. The Unit is written in generic terms enabling it to be completed using a commercially available relational database management system software and may be delivered as part of an HN Group Award.
On completion of the Unit the candidate should be able to:1. Create a normalised relational database structure.
2. Write SQL select statements to maintain and update a database structure.
3. Interrogate the database and manipulate the data.
Credit value: 1 HN Credit at SCQF level 7: (8 SCQF credit points at SCQF level 7).
Recommended prior knowledge and skills: Access to this Unit will be at the discretion of the Centre as no prior knowledge is required although experience of using a computer system would be desirable.