Area of Study
Computer Info Systems, Computer Programming, Computer Science, Information Sciences, Information Technologies
Taught In English
31271 Database Fundamentals OR 31061 Database Principles OR 31474 Database Fundamentals OR 31487 Database Management Systems
Recommended studies: it is assumed that students are familiar with basic database concepts; familiarity with the SQL language is mandatory and previous experience with at least one higher-level programming language is required
Course Level Recommendations
ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.
Recommended U.S. Semester Credits4
Recommended U.S. Quarter Units6
Hours & Credits
OverviewDescriptionThis subject teaches students how to design, develop and evaluate database programming and administration solutions to meet pre-defined quality characteristics of functionality (suitability, security), usability (operability), efficiency (time behaviour, resource utilisation), and maintainability (changeability, testability). Database programming and administration solutions are implemented using Oracle 11G, SQL*Plus and PL/SQL. Concepts, theories and technologies underlying the methods and techniques are introduced and explained as required. Students apply all that they have learnt to develop a small application to solve a database problem.Subject objectivesUpon successful completion of this subject students should be able to:1. Be able to describe the benefits of Database Programming2. Understand programming constructs available in PL/SQL.3. Understand how triggers, stored procedures and stored functions and database packages operate.4. Understand the current development methodology in modern database systems5. Describe the use of supplied packages in the Oracle database6. Have a basic understanding of the roles and responsibilities of a database administratorTeaching and learning strategiesEach week there will be a 2 hour lecture and a 1 hour tutorial/lab. Lab sessions will be used to support the lectures with illustrative examples and exercise.ContentIntroduction to Database Programming, revision of SQL and an introduction to SQL*Plus, iSQL*Plus and the development tool SQL DeveloperPL/SQL language fundamentals, variables and built in functionsDatabase procedures, functions, triggers and packagesError and exception handlingFile input/output from the databaseDynamic SQL.Introduction and awareness of performance tuningDatabase administrationAssessmentAssessment task 1: Assignment 1Objective(s):This assessment task addresses the following subject learning objectives:1 and 2Weight: 20%Criteria linkages:Criteria Weight (%) SLOs CILOs12SLOs: subject learning objectivesCILOs: course intended learning outcomesAssessment task 2: Assignment 2Objective(s):This assessment task addresses the following subject learning objectives:4 and 5Weight: 30%Criteria linkages:Criteria Weight (%) SLOs CILOs45SLOs: subject learning objectivesCILOs: course intended learning outcomesAssessment task 3: Final ExaminationObjective(s):This assessment task addresses the following subject learning objectives:1, 2, 3, 4, 5 and 6Weight: 50%Criteria linkages:Criteria Weight (%) SLOs CILOs123456SLOs: subject learning objectivesCILOs: course intended learning outcomesMinimum requirementsStudents must attain 50% of the total exam score to qualify for a pass in this subject. Accordingly, exam scores below 50% will result in a fail with a final grade of X.Student Attendance:The Faculty of Engineering and Information Technology expects that students will attend all scheduled sessions for a Subject in which they are enrolled.
Courses and course hours of instruction are subject to change.
Credits earned vary according to the policies of the students' home institutions. According to ISA policy and possible visa requirements, students must maintain full-time enrollment status, as determined by their home institutions, for the duration of the program.