BSc Information Technology Management for Business

Year of entry: 2024

Course unit details:
Database Design and Development

Course unit fact file
Unit code BMAN11092
Credit rating 10
Unit level Level 1
Teaching period(s) Semester 2
Available as a free choice unit? No

Overview

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.

 

Pre/co-requisites

Only available to students on BSc ITMB.

Aims

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).

 

Learning outcomes

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.

Syllabus

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.

 

Teaching and learning methods

Lectures, seminars and labs

 

Assessment methods

Formative:
Lab and seminar exercises 

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

Feedback methods

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

Recommended reading

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.
 

 

Study hours

Scheduled activity hours
Demonstration 7
Lectures 11
Seminars 4
Independent study hours
Independent study 78

Teaching staff

Staff member Role
Rotimi Ogunsakin Unit coordinator

Additional notes

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

Return to course details