Unit Description:
The unit covers the underlying theory and basic concepts of relational data modelling, query languages and database design. Students will develop the knowledge and skills necessary for the effective design and implementation of database systems that satisfy the data management requirements of an enterprise. The unit will also address the various issues and techniques of data management, including retrieval, update, integrity, privacy and security aspects associated with data access, manipulation and administration.
Students will be prepared to adapt their knowledge and understanding over time to ensure sound theoretical understanding of the issues relevant to database fundamentals. Unification of multiple data sources is central to the ‘big data’ paradigm likely to dominate database design over the coming decades. Our students will be prepared to critically evaluate and understand database issues as they arise in practice over the coming years. This unit provides the foundation for such understanding.
Pre-requisites:
Nil
Content:
Topics may include:
- Core database concepts
- Database languages and architecture
- Overview of database models
- Relational database modelling concepts
- Security requirements for databases and the data stored in them
- Defining database objects, such as tables and views using Structured Query Language
- Graphical tools and query language scripts
- Database queries
- Stored procedures
- Data storage and normalisation
- Database administration
Reference Book(s):
Ramez Elmasri and Shamkant Navathe, 2010, Fundamentals of Database Systems, 6th edition, Addison Wesley
Microsoft Official Academic Course, 2011, 98-364: Database Administration Fundamental, Wiley.