$2$ QUESTION ONE $[50]$

In the ever$-$evolving landscape of higher education, the University of South Africa $($UNISA$)$ is expanding their horizons by embarking on a journey that enriches its academic stature and fosters collaboration with institutions worldwide. Different academic staff members explore creating and nurturing international partnerships while travelling the world, contributing to global reach and impact.

UNISA is currently sending their academics to different countries and universities to create relationships that will benefit UNISA and their partnering with the institutions. The key milestones for travelling include the following:

$$ Participation in Global Conferences: The academics will present their research at international conferences where they meet other academics from other international universities who share similar research interests and create collaboration initiatives.

$$ Collaboration in Research Initiatives: The academics create joint research projects with other academics from other academic institutions. These projects bridge geographic and cultural gaps, enriching their research work with diverse perspectives.

$$ Student Exchange Programs: The academics establish student programs, enabling their students to go abroad and host international students.

$$ Guest Lectures and Workshops: The academics will be invited to deliver guest lectures and workshops at partner universities, facilitating knowledge exchange and strengthening academic ties.

$$ Join Funding Applications: The academics will be able to secure research grants where they secure funding for joint research endeavours, conferences and student support.

International collaborations have an impact on the following basis:

$$ Enhanced Reputation: This significantly increases the university's ranking and global profile due to international research projects and partnerships.

$$ Research Excellence: The collaboration research projects resulted in good groundbreaking knowledge generation and publications, solidifying UNISA's reputation as a research$-$leading institution.

$$ Cultural Enrichment: Students were exposed to diverse perspectives and cultures, fostering global citizenship.

$$ Increased Research Funding: The university increased its applications and brought substantial funding to the university to support various academic initiatives.

The academic staff had been visiting different universities, and these academics were from different colleges, schools, and departments within UNISA. The sample information is presented

$4$

ICT$3621/0/2024$

Academic Colleg School Department Destination University Reason for Impact Discipline e Country Travel

Themba Shabangu CSET Computing Computer

Science China$/$Beijing Perking

University

Funding Increased

Funding Data Science and

Machine Leaming

Peter Mkhize CSET Computing Information Systems Australia$/$Melbourne University of Melbourne Global Conference Enhanced Reputation lnfonnaiton Systems Management

Tshepi Makua CEDU Teacher Education Mathemiatics Education Greece$/$Rethimno University of Crete Collaboration Research and Funding Reseacrh Excellence$/$Inc reased Funding Teaching Mathematics in disadvantage areas

Themba Dube CSET Science Applied Mathematics Greece$/$Chania Technical University of Crete Guest Lecture Enhanced Reputation Financial Mathematics

Sinenhlanhla Mthimkhulu CEMS Management Sciences Human Resource Management United Kingdom$/$Nottingham University of Nottingham Student Exchange Research Excellence Soft Issues in Workplace

Karabo Masanabo CAS Accountancy Taxation United Kingdom$/$Leeds University of Leeds Student Exchange Cultural Enrichment Tax Invasion

Jan Schoeman CAS Applied Accountancy Financial Governance United Arab

Emirates$/$Abu Dhabi Abu Dhabi University Research Collaboration Research Excellence Financial Mangement

Come Le Roux CEMS Public and Operations Applied Management Ethiopia$/$ Mekele Mukelle University Guest Lecture Enhanced Reputation Public Management

Vincent Nkosi CSET Engineering Industrial Engineering Russia$/$Kazan Kazan Federal University Research Collaboration Research Excellence Nano Materials

Tshepo Lekala CSET Science Chemistry Russua$/$Saint Petersburg ITMO

University Research Collaboration Increased Funding$/$Rese arch Excellent Analytical Chemistry

$5$

$1\mathrm{.}1$ Draw a dependency diagram that is in first Normal Form

$1\mathrm{.}2$ Draw a dependency diagram that is in Second Normal Form

$1\mathrm{.}3$ Draw a dependency diagram that is in Third Normal Form

$1\mathrm{.}4$ Develop five business rules using the results of $1\mathrm{.}3$

$(10)$

$(5)$

$(5)$

$(5)$

$1\mathrm{.}5$ Develop an ERO diagram using the results of $1\mathrm{.}3$ and incorporate the business rules that were developed in $1\mathrm{.}4.(25)$

$3$ QUESTION TWO $[25]$

Maintaining a database is an important task in ensuring the good performance of the database system. This includes ensuring the transactions are performed as quickly as possible, and the transactions are completed with the correct information and