Database Development

You will develop a critical and in-depth awareness of the theory, concepts, technology, practices, and professional issues related to database systems in a global context. You’ll have lots of practical exercises, giving you the opportunity to explore a variety of database products.

Topics covered may include:

• Data management
• The history of database systems
• Database system architecture
• The relational model (types, values, relations and relation-valued variables, relational algebra and calculus, integrity, constraints and views)
• Relational database design (functional dependencies, normalisation, and semantic modelling)
• Transaction management (recovery and concurrency.)
• Security.
• Optimisation and performance tuning.
• Distributed databases.
• Decision support systems (data mining and data warehousing)
• Temporal and spatial databases
• Deductive databases
• Object oriented databases
• Object/relational databases
• Database languages
• Data representation and XML