How to integrate the Oracle database curriculum into the learning and teaching of the newly revised ASLCA/ALCS curricula - PowerPoint PPT Presentation

Loading...

PPT – How to integrate the Oracle database curriculum into the learning and teaching of the newly revised ASLCA/ALCS curricula PowerPoint presentation | free to download - id: 67d1b6-YmEyN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

How to integrate the Oracle database curriculum into the learning and teaching of the newly revised ASLCA/ALCS curricula

Description:

How to integrate the Oracle database curriculum into the learning and teaching of the newly revised ASLCA/ALCS curricula by Matthew Lai St. Paul s Secondary School – PowerPoint PPT presentation

Number of Views:20
Avg rating:3.0/5.0
Date added: 24 September 2019
Slides: 25
Provided by: StPaulsS
Learn more at: http://www.csa.edu.hk
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: How to integrate the Oracle database curriculum into the learning and teaching of the newly revised ASLCA/ALCS curricula


1
How to integrate the Oracle database curriculum
into the learning and teaching of the newly
revised ASLCA/ALCS curricula
  • by Matthew Lai
  • St. Pauls Secondary School

  • 9 June 2006

2
Contents
Topics
1 Integrate the Oracle database curriculum into the existing ASLCA Curriculum
2 How to login and create student accounts
3 Adv. Disadv. of using the Oracle platform
4 Overview of the Project Work
5 Other resources
3
Features of the Oracle Platform
4
ASLCA/ALCS curricula DATABASES
  • A. Introduction to Databases (3 hours / 4.5
    lessons)
  • Applications of databases in society
  • Daily life examples, e.g. library, inventory,
    credit card system
  • Discuss the importance of databases in business
  • Concepts and Terminology (Glossary)
  • Data and Information
  • Data, fields, records, tables, files and
    databases
  • Common data types
  • Indexes and keys
  • DDL, DML, data dictionary, transaction processing
    and access control
  • Program-data independence
  • Data redundancy and data integrity

5
ASLCA/ALCS curricula DATABASES
  • B. Relational Database (11 hours / 16.5 lessons)
  • Basic concepts of a relational database
  • Entity, relation, attribute, domain, primary key,
    foreign key, candidate key, entity integrity,
    referential integrity, domain integrity
  • Know how to organize data, establish
    relationships
  • C. Introduction to Database Design Methodology
  • Conceptual data model
  • Conceptual level, physical level and view level

1. Animation 2. Vocabulary Quiz
6
ASLCA/ALCS curricula DATABASES
  • Entity-Relationship modeling
  • 1-to-1, 1-to-many, many-to-many relationships
  • Create simple ER diagrams, resolution of
    many-to-many relationships into multiple
    one-to-many relationships
  • Transform the ER diagrams to tables, create a
    database schema
  • Introduction to Normalisation
  • Able to briefly explain the meaning and purpose
  • Aware of the methods or measures used to reduce
    data redundancy

7
ASLCA/ALCS curricula DATABASES
HTMLDB
  • B. Structured Query Language (18 hours / 27
    lessons)
  • Creating a relational database
  • Using SQL to create a simple relational database
  • at most 3 tables
  • Database maintenance and manipulation
  • Modify the structure of the tables
  • Add, delete and modify the data in the tables
  • View, sort and select the contents by filtering
  • In, between and like operators, arithmetic
    operators and expressions, comparison operators
    and logical operators

8
ASLCA/ALCS curricula DATABASES
  • Built-in functions, e.g. aggregate and string
    functions
  • Multiple field indexing and multi-level ordering
  • Equi-join, natural join and outer join
  • Sub-queries (1 sub-level only)
  • Export query results to text, html or spreadsheet
    format

9
April 2006 -
1. Introduction to Database 2. Database Design 3.
SQL
25 April 2006, release of Project Assignment List
  • DB

10
How to login and create student accounts
1 March 2006
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
No. of Workspace Schemas has been fixed!
15
FAQ
  • https//academy.oracle.com/pages/docs_pdfs_zip/200
    5_iLearning_Setup_FAQ.doc

16
Adv. Disadv. of using the Oracle platform
  • Pros
  • Printable Course Materials (Section 0)
  • Many examples, animations and quizzes
  • No need to install
  • Monitor the progress of students
  • Cons
  • Characters cannot be displayed properly
  • Some documents cannot be opened (DJ)
  • Username is not user-friendly

17
Compatibilities
  • Not support Boolean type
  • TO_DATE(2006-06-09, YYYY-MM-DD)
  • Alter table, keyword COLUMN is absent
  • Does not support multiple records be inserted
    once at a time
  • Memo Long

18
Overview of the Project Work
  1. Prototype
  2. Network Design
  3. Database Design

19
Reference
  • Point of Sale System
  • Websites
  • http//www.healthtech-solutions.com/point_of_sale.
    htm
  • http//www.amcomputers.com/page7.html
  • Passenger Clearance
  • Immigration Department
  • http//www.immd.gov.hk/ehtml/apcs_avcs_qa1.htm
  • Video
  • http//www.immd.gov.hk/images/video.wmv
  • http//www.immd.gov.hk/ppt/apcs_avcs.wmv
  • http//www.immd.gov.hk/ehtml/media/internet_apc.wm
    v

20
Rationale
  • demonstrate students ability to analyse a
    problem and so identify requirements, and to make
    appropriate use of knowledge in the module in
    providing solutions which they will design,
    implement, test and evaluate
  • (HKASL Regulations Syllabuses 2007)

21
Rationale
  • The teacher can discuss coursework with students
    in ways such as interpreting the requirement of
    coursework, making conjectures about the degree
    of difficulty of each coursework or advising
    possible use of certain software/hardware an
    achievable coursework is one that can meet the
    basic requirements in the public assessment
  • (Resource Package on Coursework Assessment of CIT
    Curriculum, CITE HKU EMB)

22
Rationale
Curriculum
23
Online Resources
  • E-Learning Training Package
  • http//sfcs.cite.hku.hk

24
  • Thank you
About PowerShow.com