BSc Information Technology Management for Business

All students should normally be able to complete their programme of study without incurring additional study costs over and above the tuition fee for that programme.

The  Manchester Bursary  is available to UK students registered on an undergraduate degree course at Alliance MBS who have had a full financial assessment carried out by Student Finance England.

In addition, Alliance MBS will award a range of  Social Responsibility Scholarships  to UK and international/EU students.

These awards are worth £2,000 per year across three years of study. You must achieve AAA at A-level (or equivalent qualification) and be able to demonstrate a significant contribution and commitment to social responsibility.

The School will also award a number of  International Stellar Scholarships  to international students achieving AAA at A-level (or equivalent qualification). Applicants who exceed AAA and/or have supplementary qualifications (such as EPQ) will receive additional consideration.

Additional eligibility criteria apply - please see our  scholarship pages  for full 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.

 

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 2024/25

Updated: March 2024

Approved by: March UG Committee