Database Concepts

RMIT University Vietnam

Course Description

  • Course Name

    Database Concepts

  • Host University

    RMIT University Vietnam

  • Location

    Ho Chi Minh City, Vietnam

  • Area of Study

    Computer Engineering, Computer Science, Information Technologies

  • Language Level

    Taught In English

  • Prerequisites

    It is assumed that you have basic computer literacy. 

    Hours & Credits

  • Host University Units

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

    Course Description

    Databases and the database technology are having a major impact on the growing use of computers. They play a critical role in almost all areas where computers are used.

    This course is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. This course focuses on developing skills in designing databases for efficient data management and SQL programming for querying and using databases for various database applications. 

     

    Objectives/Learning Outcomes/Capability Development

    Program Learning Outcomes

    This course contributes to the following Program Learning Outcomes (PLOs) for

    • BP094 Bachelor of Computer Science,
    • BP096 Bachelor of Software Engineering,
    • BP162 Bachelor of Information Technology,
    • BP232 Bachelor of Technology (Computing Studies),
    • BH091 Bachelor of Engineering (Computer and Network Engineering) (Honours)/Bachelor of Computer Science,
    • BH094 Bachelor of Engineering (Telecommunications Engineering)(Honours)/Bachelor of Computer Science and
    • BH119 Bachelor of Analytics
       

    1. Enabling Knowledge

    You will gain skills as you apply knowledge effectively in diverse contexts.

    2. Critical Analysis

    You will learn to accurately and objectively examine and consider computer science and information technology (IT) topics, evidence, or situations, in particular to:

    Analyse and model requirements and constraints for the purpose of designing and implementing software artefacts and IT systems

    Evaluate and compare designs of software artefacts and IT systems on the basis of organisational and user requirements.

    3. Problem Solving

    Your capability to analyse problems and synthesise suitable solutions will be extended as you learn to:

    Design and implement software solutions that accommodate specified requirements and constraints, based on analysis or modelling or requirements specification.

     

    Course Learning Outcomes

    Upon successful completion of this course you should be able to:

    • CLO 1: Describe various data modelling and database system technologies.
    • CLO 2: Explain the main concepts for data modelling and characteristics of database systems.
    • CLO 3: Identify issues with and compare, justify relational database design using the functional dependency concepts.
    • CLO 4: Apply SQL as a programming language to define database schemas and update database contents.
    • CLO 5: Apply SQL as programming language to extract data from databases for specific users’ information needs
    • CLO 6: Design a database schema using conceptual modeling mechanisms such as entity-relationship diagrams.

     

    Overview of Learning Activities

    The learning activities included in this course are:

    • Lectures: Key concepts are explained, course material is presented, and the subject matter is illustrated with demonstrations and examples.
    • Tute-lab sessions focus on analyse and problem solving of given scenarios, such as data modeling problems, and provide practice in the application of theory along with tutors and peers.
    • Moderated online discussion forums provide a question-answer forum for subject and assessment matters
    • Private study is important to work through the course learning material and gain practice at solving conceptual and technical problems.
    • Peer-assisted or mentor-led learning programs may be available.
       

    A total of 120 hours of study is expected during this course, comprising:

    Teacher-directed hours (48 hours): lectures and tute-lab sessions. Each week there will be 2 hours of lecture and 2 hours of tute-lab. You are encouraged to participate during lectures through asking questions, commenting on the lecture material based on your own experiences and through presenting solutions to written exercises. The tute-lab sessions will introduce you to the tools necessary to undertake the assignment work.

    Student-directed hours (72 hours): You are expected to be self-directed, studying independently outside class.

     

    Overview of Learning Resources

    The course is supported by the Blackboard learning management system which provides specific learning resources. See the RMIT Library Guide at http://rmit.libguides.com/compsci 

     

    Overview of Assessment

    Note: This course has no hurdle requirements.

    The assessment for this course comprises

    Assessment tasks 

    Assessment Task 1:  Assignment 1

    Weighting  20%

    This assessment task supports CLOs 1, 3, 4.

    Assessment Task 2: Assignment 2

    Weighting 30%

    This assessment task supports CLOs 2, 3, 4, 5, 6.

    Assessment Task 3: Exam

    Weighting 50%

    This assessment task supports CLOs 1, 3, 4, 5, 6.