Database Management Systems
Testimonials
Aleksandra Shcherbakova
Master of Management
“I have met some truly impressive talents and kind personalities among our lecturers."
Angelica Balajadia
Master of Management
“I have found my people here, I have networked here. I am open to doors opening and so many doors are opening already."
Wiranpatchara (Sandy) Wongchanapai
Master of International Business
"Whilst studying at ICMS, I was able to have a strong work/study life balance".
Cameron Colvin
Bachelor of Business (Marketing)
"My work experience boosted my confidence and allowed me to apply theoretical knowledge in practical settings."
Taylor McLeod
Bachelor of Business (Sports Management)
“The small, intimate environment in my lectures makes me feel like I am being heard and that I am getting the most out of my studies."
Julie Williams
Bachelor of Business (Fashion and Global Brand Management)
"I chose ICMS because they have provided me with the opportunity to kickstart my career through their many industry partners".
Keegan Du Preez
Bachelor of Business Management (Accounting)
"ICMS is realistic. They understand the realistic expectations of various markets. It’s not just textbook knowledge, especially compared to every other competitor".
Michaela Mayes
Bachelor of Business (Marketing)
"ICMS' Work Integrated Learning gave me the ability to gain real life experience before I even graduated".
Alana Williams
Bachelor of Business (Accounting)
“I worked full time whilst studying, with ICMS allowing for such a great work to study ratio and balance, where I was flexibly allowed to do both.”
Juliette Wilson
Bachelor of Business (Marketing)
"I think the biggest thing is that you get a personalised experience, and you’ll be treated like a person, not a number".
Calum McKnight
Bachelor of Business (Marketing)
“Very quickly, ICMS gave me a circle of friends who are pretty driven – but who also like to have fun – and when I see where they are now it’s pretty exciting and it drives me further.”
Ewan Metcalfe
Bachelor of Business (Sports Management)
"Through being at this college and the geographical location, it always reminded me to stay grounded, keep working hard to further improve my life and stay happy".
Database Management Systems is available as a postgraduate-level subject offered by the International College of Management, Sydney (ICMS). Please click the button below to find a postgraduate course suitable for you.
Subject Code:
DAT601A
Subject Type:
Core
Subject Level:
600
Credit Points:
4 credit points
Subject Aim:
Advances in technology have enabled organisations to access massive volumes of structured and unstructured data from different sources such as social networking sites, sensors, or spreadsheet software. To leverage this data for decision-making, businesses need to invest in database solutions that support the effective management of data throughout the entire life cycle.
This subject equips students with the relevant skills and knowledge needed to effectively design, implement, and manage databases through the lens of the systems development life cycle (SDLC). Students will explore the different phases of the database design process including the conceptual, logical, and physical design. The subject will introduce the relevant relational database concepts and techniques for each phase including requirements analysis, entity relationship (ER) modelling, normalisation of database tables, integrity constraints, and database security management. Foundations and basic commands of Structured Query Language (SQL) will be covered. The subject also provides an introduction to advanced database concepts such as NoSQL as well distributed database systems and database performance optimisation.
Learning Outcomes:
a) Analyse conceptual, logical and physical requirements for effective relational database design and apply relevant systems’ development and database lifecycle frameworks.
b) Critically evaluate database performance by assessing the quality of business rules and data models using data modelling quality criteria.
c) Construct conceptual and logical data models by applying key data modelling principles to improve database and organisational performance.
d) Critically assess business requirements and apply the database management and systems’ analysis techniques to develop effective database design solutions.
e) Construct and execute Structured Query Language (SQL) commands to define, retrieve and manipulate data.
Assessment Information:
Learning outcomes for this subject are assessed using a range of assessment tasks as described in the table below.
| No | Assessment task | Weighting | Subject learning outcomes to be assessed |
| 1 | Online Quizzes (Invigilated) | 20% | a, b |
| 2 | Case study | 40% | a, b, c, d |
| 3 | Practical SQL lab Assessment | 40% | d,e |
Broad topics to be covered:
| Topic: |
W1: Introduction to database management and systems analysis
|
W2: Database design through the systems development and database lifecycle
|
W3: Foundations of data models
|
W4: Relational database model
|
W5: Entity relationship (ER) modelling
|
W6: Extended entity relationship model
|
W7: Database normalisation
|
W8: Structural Query Language (SQL) – Part A
|
W9: Structural Query Language (SQL) – Part B
|
W10: Database performance optimisation
|
W11: NOSQL and new SQL
|
Please note that these topics are often refined and subject to change so for up to date weekly topics and suggested reading resources, please refer to the Moodle subject page.