Extended National Diploma in IT

Unit 18: Database Design

This session will focus on understanding the differences between using a spreadsheet to store data, and using a relational database.

Week	Lesson Activity	Learning Assessment	Skill Developed
1.1	10 min Outline the Aims and Outcomes of the Unit 18 10 min Explain the way in which Unit 18 will be assessed	Questions and Answers
1.2	45 min Introduction to Databases A comparison of Spreadsheet and Relational Database tables 10 Show this spreadsheet which can be used by students for the assessment to explain the advantages of relational databases Basic Spreadsheet of Students taking Courses 30 min Alternatively create a another example of a spreadsheet with a single table that contains data from more than one entity. 10 min Summarise the key concepts and answer any questions 30 min Database Normalisation a presentation on 1st, 2nd and 3rd Normal Form	Questions and Answers P1 M1 Spreadsheet Data Example	Spreadsheet Data Relational DB

Week

Lesson Activity

Learning Assessment

Skill Developed

explain the features of a relational database

explain referential integrity and the purpose of primary keys in building the relationships between tables

1.1

1.2

45 min Introduction to Databases A comparison of Spreadsheet and Relational Database tables
10 Show this spreadsheet which can be used by students for the assessment to explain the advantages of relational databases Basic Spreadsheet of Students taking Courses
30 min Alternatively create a another example of a spreadsheet with a single table that contains data from more than one entity.
10 min Summarise the key concepts and answer any questions
30 min Database Normalisation a presentation on 1st, 2nd and 3rd Normal Form

Video Introduction to Databases: a good introduction (37 mins) to the main concepts of why databases are better than spreadsheets (you do not need to understand SQL)