Course Details

Course Code: IT7005
Course Title: Database Systems 2
Short Title: DB2
Course Level:: Level 7
Valid From:: 2024/2025 Sem 2
Credits:: 15
Owner: School of ICT
Assessment Method: Achievement
Course Aim

This course aims to further demonstrate advanced knowledge of database systems, core theories, principles and concepts where such systems fall within an Information Technology infrastructure in an organisation. The course will also expand on database concepts learnt in Database Systems 1 and introduce new database constructs relevant to the workplace.

 
CILO
On Completion of this course, the learner will be able to
# Learning Outcome Description
1 Undertake database administration tasks to deal with defined and undefined database operations and to solve encountered issues.
2 Demonstrate knowledge of advanced SQL and its usage to solve problems and achieve some specialist level skills.
3 Use advanced database programming techniques to plan, organize advanced level programming constructs and formulate solutions.
Requisites
  • Pre Requisite: IT6005
 
No Examinations
Other Controlled Assessments
Assessment Type
Online Quiz
Uncontrolled Assessments
Assessment Type
Project (Group)

The institute reserves the right to alter the nature and timings of assessment

Affiliated Entities
Entity Code Entity Title Entity Version Entity Type
ICT8011 Bachelor of Information and Communications Technology (Programming Major) 1 Programme
ICT8011 Bachelor of Information and Communications Technology (Programming Major) 2 Programme
BFA8800 Bachelor of Film and Animation 2 Programme
BFA8801 Bachelor of Filmmaking 1 Programme
BFA8802 Bachelor of Animation and Visual Effects 1 Programme
BFT8100 Bachelor of Science in Financial Technology 1 Programme
BWM8000 Bachelor of Web Media 3 Programme
BWM8000 Bachelor of Web Media 4 Programme
DES8000 Bachelor of Visual Design 3 Programme
ENT7080 Associate Degree in Engineering Technology (Civil) 1 Programme
ENT8020 Bachelor of Engineering Technology (Mechanical) 3 Programme
ENT8031 Bachelor of Engineering Technology (Electronics) 4 Programme
ENT8040 Bachelor of Engineering Technology (Electrical) 2 Programme
ENT8050 Bachelor of Engineering Technology (Electromechanical) 2 Programme
ENT8060 Bachelor of Engineering Technology (Communications and Networks) 2 Programme
ENT8060 Bachelor of Engineering Technology (Communications and Networks) 3 Programme
ENT8070 Bachelor of Engineering Technology (Chemical and Industrial Processes Engineering) 1 Programme
ENT8080 Bachelor of Engineering Technology (Civil) 1 Programme
ENT8090 Bachelor of Engineering Technology (Industrial Instrumentation and Automatic Control) 1 Programme
ENT8100 Bachelor of Engineering Technology (Biomedical) 1 Programme
ICT6010 Diploma in Information and Communications Technology 4 Programme
ICT6045 Diploma in Web Development 1 Programme
ICT7011 Associate Degree in Information and Communications Technology (Programming Major) 1 Programme
ICT7022 Associate Degree in Information and Communications Technology (Information Systems) 1 Programme
ICT7041 Associate Degree in Information and Communications Technology (Database Systems Major) 1 Programme
ICT7051 Associate Degree in Information and Communications Technology (Cyber Security) 1 Programme
ICT8010 Bachelor of Information and Communications Technology (Programming Major) 2 Programme
ICT8022 Bachelor of Information and Communications Technology (Information Systems Major) 1 Programme
ICT8023 Bachelor of Science in Cloud Computing and Information Systems 1 Programme
ICT8031 Bachelor of Information and Communications Technology (Networking Major) 1 Programme
ICT8031 Bachelor of Information and Communications Technology (Networking Major) 2 Programme
ICT8040 Bachelor of Information and Communications Technology (Database Systems Major) 3 Programme
ICT8041 Bachelor of Information and Communications Technology (Database Systems Major) 1 Programme
ICT8042 Bachelor of Science in Applied Data Analytics 1 Programme
ICT8051 Bachelor of Information and Communications Technology (Cyber Security Major) 2 Programme
MDM8040 Minor in Data Mining 1 Programme
No Code Yet Bachelor of Engineering Technology (Biomedical) 1 Programme
No Code Yet Bachelor of Engineering Technology (Renewable Energy) 1 Programme
No Code Yet Copy Of Bachelor of Information and Communications Technology (Cyber Security Major) 1 Programme
ICTDip-Optional ICT Diploma Optional 1 Group
NEDICTE Non-EDICT Electives 1 Group