Database Management Systems

University of the South Pacific

Course Description

  • Course Name

    Database Management Systems

  • Host University

    University of the South Pacific

  • Location

    Suva, Fiji

  • Area of Study

    Information Sciences

  • Language Level

    Taught In English

  • Prerequisites

    IS122: Information Systems 2 or CS112: Data Structures and Algorithms

  • Course Level Recommendations

    Upper

    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.

    Hours & Credits

  • Credits

    3 - 4
  • Recommended U.S. Semester Credits
    3 - 4
  • Recommended U.S. Quarter Units
    4 - 6
  • Overview

    Database management systems (DBMS) are the foundation of the business operations of the organization. Database management systems must effectively store, access and manipulate data as well as provide data security, data sharing and data integrity.
    As the database technology advances rapidly, information professionals must not only understand the concepts and principles of database systems but also the associated management issues. This course will introduce students to database management systems, their design, construction and management. This course emphasizes both theories and hands-on experiences.
    Course Content
    - File systems and databases;
    - Relational database model;
    - Entity- Relationship (E- R) modelling;
    - Normalization of database tables;
    - Structured query language;
    - Database design; and
    - Transaction management
    Learning Outcomes
    - Explain the fundamental database and relational database management system (RDBMS) concepts.
    - Write the business rules for the business processes.
    - Design a relational database.
    - Implement, manage and utilize a RDBMS for business decision making (using SQL).
    Textbooks
    Morris & Coronel, Database Systems Design, Implementation and Management, 9th Edition
    Assessment
    Tests: 18%
    Quizzes: 8%
    Workbooks: 8%
    Assignments: 16%
    Lab: 10%
    Final Exam: 40%

Course Disclaimer

Courses and course hours of instruction are subject to change.

Eligibility for courses may be subject to a placement exam and/or pre-requisites.

Some courses may require additional fees.

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.

Please reference fall and spring course lists as not all courses are taught during both semesters.

Availability of courses is based on enrollment numbers. All students should seek pre-approval for alternate courses in the event of last minute class cancellations

Please note that some courses with locals have recommended prerequisite courses. It is the student's responsibility to consult any recommended prerequisites prior to enrolling in their course.