•      About OUHK     

  •      Admissions     

  •      Academics     

  •     Administration    

  •      Library     

  •     Research    

  • Registration

     Credit exemptions  Finances
    Relational Databases: Theory and Practice
    COMP S359
      More information: Course Guide
    Relational Databases: Theory and Practice
    Course Start Date
    Aut 2020
    Course Level
    Length in Terms
    2 terms
    Fees ($) (including lab fees)
    Future Terms
    Aut 2021

    This course may be included in the list of reimbursable courses under the Continuing Education Fund. Click HERE for details of eligibility.

    Quota and Schedule
    Start Date
    Course Level Length in Terms Credits
    Fees ($)
    (including lab fees)
    Future Terms
    Aut 2020
    Higher 2 terms 10
    Aut 2021
    This course may be included in the list of reimbursable courses under the Continuing Education Fund. Click HERE for details of eligibility.

    Course Coordinator: Dr Kelvin Lee, BS, DipEd (CUHK); MPhil, PhD (HKUST)

    Course Developer: The Open University, UK, Course Team

    COMP S359 covers relational databases and is an important course within the BSc and BSc (Hons) in Computing, Product Design and Technology, Electronics and Communications Technology programmes.

    Advisory prerequisite(s)
    You are advised to have already studied COMP S205 / COMP S210 /MATH S261 / COMP S201 / COMP S263.

    This course aims to:

    • Explain the concepts underlying all relational databases;

    • Provide practical experience in applying the concepts in different situations.

    The first topic introduces the context of databases as part of an information system, which may be used by many people for different purposes and with different requirements. The topic then examines the types of software that are necessary for accessing a database, and how each database has to be specially designed to satisfy the requirements of its users.

    The second topic introduces the mathematical theory underpinning relational technologies and shows ways in which the theory is used in the database environment.

    The third topic is concerned with relational database management systems, and, in particular, the use of the database language SQL, the recognized standard for defining and accessing a relational database.

    The fourth topic is a detailed analysis of the steps involved in developing and implementing a database system. The topic examines, in depth, the tasks and techniques appropriate for each step in the development process, and makes detailed comparisons between implementation alternatives and data representations.

    Learning support
    There will be about ten two-hour tutorials.

    There will be four assignments and a final examination. Students are required to submit assignments via the Online Learning Environment (OLE).

    Online requirement
    This course is supported by the Online Learning Environment (OLE). You can find the latest course information from the OLE. Through the OLE, you can communicate electronically with your tutor, Course Coordinator as well as other students. To access the OLE, students will need to have access to the Internet. The use of the OLE is required for the study of this course.

    You will need access to a PC-compatible computer with:

    • 1.5 GHz x86 processor

    • 1 GB RAM

    • Hard disk drive with at least 2 GB free for course software

    • 8 MB graphics card with colour monitor

    • Internet access

    Students will need access to a computer with the Windows operating system.

    Set book(s)
    There are no set books for this course.

    Students with disabilities or special educational needs
    Students with serious impairment of sight or manual dexterity may find it difficult to follow this course. Course and supplementary materials are not available on tape. You are encouraged to seek advice from the Course Coordinator before enrolling on the course.

    Accessibility | Privacy policies | Terms and policies | Webmaster
    © 2020 by The Open University of Hong Kong. All Rights Reserved.
    Site Map Site map
    About OUHK
    President's Message
    Vision & Mission
    Strategic Plan
    Governance & Organization
    Principal Officers
    Honorary Graduates & University Fellows
    Facts & Figures
    School of Arts and Social Sciences
    Lee Shau Kee School of Business and Administration
    School of Education and Languages
    School of Nursing and Health Studies
    School of Science and Technology
    Li Ka Shing School of Professional and Continuing Education (LiPACE)
    Educational Technology and Development Unit
    Finance and Facilities Management Unit
    Human Resources Unit
    Information Technology Unit
    Mainland and International Affairs Office
    OUHK Shenzhen Office
    Public Affairs Unit
    Quality Assurance Office
    Research Office
    Student Affairs Office
    Research Postgraduate Programmes
    Postgraduate Programmes
    Postgraduate Programmes (Part-time)
    Undergraduate Programmes
    Undergraduate Programmes (Part-time)
    Sub-degree Programmes
    Sub-degree Programmes (Part-time)
    Continuing Professional Development (CPD) Programmes
    Programmes from LiPACE
    Annual Review 2017-2018
    Choose your study programme
    Events Calendar
    Giving to OUHK
    Information for
    Prospective Students
    Current Students
    Jockey Club Home Health Watch Programme
    Media coverage
    Motto: Disce, Progredere, Crea
    Open Learning Resources
    iTunes U
    Knowledge for All
    OUHK Great Speakers Series
    Privacy policies
    Terms and policies
    Research Office (RO)
    RGC Funded Projects
    Institutional Repository
    Other Funded Research Projects
    Staff Publications
    Research Degree Programmes
    External Research Funding
    Internal Research Funding
    External Funding for Development Project
    Site Search
    Social Media
    YouTube Channel
    Student Life & Support
    Students' Achievements
    Switch on to e-materials
    Useful Information
    Adverse weather arrangements
    Campus location
    Job Openings
    Contact us
    Telephone: (852-2711-2100)
    Facsimile: (852-2715-0760)
    Email: info@ouhk.edu.hk
    View the videos of Full-time Face-to-face Undergraduate Programme selected seminars
    Web for All
    Back To Top