BSc Information Technology Management for Business / Course details

Databases are vital for the functioning of modern organisations where their application enables data to be stored for efficient update, retrieval and analysis. They underlie technology, residing behind a huge fraction of websites, are a crucial component of telecommunication systems, banking systems, video games and just about any other software system or electronic device that maintains some amount of persistent information. This course introduces the fundamental concepts necessary for designing, using and implementing database systems and database applications.

 

Only available to students on BSc ITMB.

The course unit aims to:
1.    Introduce students to the principles and practices of database design and management; 
2.    Exhibit how database systems are developed; and
3.    Demonstrate the fundamentals of Structured Query Language (SQL).

 

1.    Understand the fundamentals of how data is stored in computer systems.
2.    Have knowledge on how to analyse the data needs of an organisation.
3.    Understand conceptual modelling diagrams and techniques.
4.    Understand database design and querying.
5.    Apply SQL for database creation, manipulation and control.
6.    Apply conceptual modelling and database theory to solve practical problems.

1.    Introduction to the role of database management in organisations.
2.    Database requirements, analysis and design.
3.    Relational database modelling.
4.    Methodology for database design.
5.    SQL: creating, updating and querying relational databases.
6.    Database implementation and use.
7.    Database issues concerning: security, ethical/legal and query processing and optimisation.
8.    Distributed database management systems.

 

Lectures, seminars and labs

 

Formative:
Lab and seminar exercises 

Summative: 
Individual report (assessing design) (40%)
Individual practical lab exam/demonstration (assessing implementation) (60%)

Feedback will be provided during seminar and lab classes when undertaking practical exercises.

Thomas Connolly and Carolyn Begg. Database Systems: A Practical Approach to Design, Implementation and Management, Global Edition, 2015.

Ramez Elmasri and Shamkant B. Navathe. Fundamentals of Database Systems, Global Edition, 2016.
 

 

Programme restrictions: This course is only available to first year ITMB student

For Academic Year 2023/24

Updated: March 2023

Approved by: March UG Committee