Objectives
The objective of this course is to understand and apply the fundamental concepts involved in setting up and using relational databases.
Syllabus
-understanding the architecture of a database management system
-create a conceptual Entity / Association data model
-transforming a conceptual data model into a relational logical data model in 4NF
-formalise database querying using relational calculus and relational algebra
-build, query and modify a MySQL database
-use the SQL language to create and manipulate a database
-design a database according to functional requirements
-optimising access to databases
