We are moving from Flat File databases to Relational Databases in this lesson. You will watch several videos which describe the advantages of Relational Databases as well as the components that make up a Relational Database.

By the end of the lesson you should be able to:

• represent an existing relational database in a schematic diagram

• create a schematic diagram for a scenario where the data is to be organised into a relational database

• modify an existing schema to meet a change in user requirements

• choose and justify the most appropriate type of database, flat-file or relational, to organise a given set of data

• create a simple relational database from a schematic diagram and data dictionary

• populate a relational database with data

• describe the similarities and differences between flat-file and relational databases

• create a data dictionary for a given set of data 

• create documentation, including data modelling, to indicate how a relational database has been used to organise data 

Outcomes:

• H4.1  proposes and justifies ways in which information systems will meet emerging needs
• H6.1  analyses situations, identifies needs, proposes and then develops solutions