
BSc Information Technology Management for Business / Course details
Year of entry: 2023
- View tabs
- View full page
Course unit details:
Database Design and Development
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
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