COMP8761 Databases and Conceptual Modelling GE

2012

4.5

1 x 100-minute lecture weekly
1 x 100-minute tutorial weekly
1 x 50-minute workshop weekly
1 x 1-hour project work weekly

1 of COMP2231, COMP2761, COMP8231 has been successfully completed

Basic mathematical and numeric concepts.

The aim of this topic is to familiarise students with the basic concepts, fundamental structures and general techniques that are needed to define, construct and manipulate a database using a Database Management System (DBMS) with the main emphasis on relational DBMSs. The topic will cover the concept of data models, basic skills in data modelling using the Entity-Relationship (ER), Extend Entity-Relationship (EER) and relational data models, and the Unified Modelling Language (UML); functional dependencies; normalisation; relational algebra and calculus, and the Structured Query Language (SQL).

The aim of this topic is to familiarise students with the basic concepts, fundamental structures and general techniques that are needed to define, construct and manipulate a database using a database management system (DBMS) with the main emphasis on relational DBMSs.

Furthermore students should understand the concept of data models, have skills in data modelling using the Entity-Relationship (ER), Extend Entity-Relationship (EER) and relational data models, and the Unified Modelling Language (UML); understand functional dependencies; normalisation; relational algebra and calculus, and the Structured Query Language (SQL).

At the completion of the topic, students are expected to be able to:

1. Explain the concept of data model and have basic skills in data modelling using the information (or semantic) and the relational data models
2. Specify the activities that a database management system supports and describe common approaches to supplying this support
3. Discuss and practise the various techniques for database system design, implementation and maintenance including normalisation
4. Specify data declarations and manipulation operations for the relational model formally using relational algebra and calculus
5. Define and manipulate a relational database using SQL
6. Understand the role of ethics in a data modelling environment and maintaining a database management system and its environment
7. Conduct research in an area of data modelling and present it in an appropriate manner