Databases 

By the end of the video, you will be able to ...

• Describe and exemplify entity-relationship diagrams with three or more entities. 

• Describe and exemplify an instances using an entity-occurrence diagram.

• Describe and exemplify a compound key.

• Describe and exemplify a data dictionary with three or more entities.

By the end of the video, you will be able to describe, exemplify and use SQL operations ...

• UPDATE, SELECT, DELETE, INSERT statements making use of 

  • wildcards

  • computed values, alias

By the end of the video, you will be able to describe, exemplify and use SQL operations ...

• UPDATE, SELECT, DELETE, INSERT statements making use of 

  • aggregate functions (MIN, MAX, AVG, SUM, COUNT)

  • GROUP BY

This video reviews the entire Higher Computing Science Website Design & Development Unit