the elective part of the nss ict curriculum - 教育局 · the elective part of the nss ict...

1

The Elective Part of theNSS ICT Curriculum

A. Databases

2

Database systems are widely used for various computer applications in modern society. (Banking systems, supermarket inventory

system, library system, )

Database systems give better organization of real-world information, better definition, control

and manipulation of data.

The Elective PartA. Databases

3

This option provides an understanding of the theoretical and practical issues underlying Database.

Encourage student to think critically and equip students with problem-solving and communication skill.

The Elective Part

Option feature:

A. Databases

4

Students will learn about:

concepts and applications related to databases and the Database Management Systems(DBMS);the basic concepts of a relational database, and the construction, manipulation andextraction of information from a relational database using Structured Query Language(SQL);how to identify and perform an analysis of the data requirements of simple scenarios indifferent applications;he construction of simple data models using the Entity-Relationship (ER) diagramsmethodology;the importance of good database design as a blueprint for the development of a database management system;the importance of data privacy and the measures for improvement;the database application development lifecycle and the main activities associated with the development stages; anddatabase development and its impact on society.

A. DatabasesLearning Objectives

The Elective Part

54

Time allocation:75 hrs


Introduction to Database

(8 hrs)

Relational Databases

(28 hrs)

Introduction to Database Design Methodology

(22 hrs)

Database Applications, Development and Society

(17 hrs)

6

A. Databaseshour

a. Introduction to Databases 8b. Relational Databases 28 c. Introduction to Database Design Methodology (18) 22 d. Database Security, Integrity and Data Privacy (13)ed. Database Applications, Development and Society (8) 17

Total: 75

The Elective PartChanges made since 2nd Consultation

7

d. Database Applications, Development and Society

Deletion of contents:Be aware of the motivation of data mining. Briefly describe technologies to support data mining including massive data collection, data warehouse, powerful multiprocessor computers and data mining method.

The Elective Part

A. Databases

Changes made since 2nd Consultation

8

d. Database Applications, Development and SocietyAdditional contents(1):

Understand the stages involved in the database application development lifecycle and the links between them.

The main stages involved in the database application developmentlifecycle include requirements collection and analysis, system definition, application and database design, DBMS selection, form and reportdesign, prototyping, implementation, data migration, conversion and loading, testing, and operational maintenance.Students should recognize that the stages of the database application development lifecycle often involve review and repetition of previous stages through feedback loops.

Practice the main activities associated with the stages of the database application development lifecycle in an educational or commercial scenario.

Students should be able to apply simple Computer Aided Software Engineering (CASE) tools to automate, manage and simplify the database design process. CASE supports may include tools for data dictionary construction, and those for facilitating data models development, etc.


9


Additional contents(2):Discuss the importance of data privacy and develop proper attitudes to be an ethical user of database to respect data privacy.

Ways to achieve data privacy in database applications using access rights should be discussed.

Discuss the needs and trends of future database development and the corresponding applications.

Trends in database models, including distributed, parallel, and multimedia, etc. and their impact, should be introduced.


10


Amendment:Be aware of the uses and applications of data mining in business field daily life and explain how data mining can improve the benefit of a business quality of living.


11

Variations of Curriculum Planning: - Database Design (beginning of 1st term of SS5)

SQL (later stage of 1st term of SS5 to 2nd term)mini project (2nd term of SS5 to 1st term of SS6)-


12

Experience sharing: Examples of learning and teaching activities- ref. Chapter 4

(Example3 Topic: b. Relational DatabasesTheme: A database for a library book reservation system

Example7 Topic: c. Introduction to Database Design Methodology Theme: Analyzing simple scenarios in business, education or

other fields and creating simple entity-relationship (ER) diagrams involving binary relationships only in designing a database.


13

(1) (2) (3)

14

// (ER)

15

Experience sharing: Examples of learning and teaching activities- ref. Chapter 4

(Example8 Topic: c. Introduction to Database Design Methodology Theme: Creating simple entity-relationship (ER) diagrams.

Example9 Topic: c Introduction to Database Design Methodology Theme: Understanding the concepts of data redundancy

Example10 )Theme: Guidance on a project on databases

-


16

A. c. (ER)(ER)(); ()(; ) ()

17

A. c. ()/

18

A. ()() - - ()

19

Logical Flow of Learning

RDB seems to be a good choice, but what are the basic constructs of a Relational DB?

Why do we use Database?

What types of DB Models are there?Which one we are going to use?

Background information about the File System and Database System.What are the advantages of DB over file system?

Data Models:Relational, Hierarchical and Network.Comparison of the above three.

Basic knowledge of RDB.Fundamental notions, operators, data dictionary, indexes.

A

20

Why do we use Database?

Be aware of the uses and applications of databases in our everyday life, such as database usage in education, public services, and business and commerce.Discuss the importance of databases in an organization and how it improves the Operations of an organization.

21

What types of DB Models are there? Which one we are going to use?

Describe and explain the relationship of fields, records, tables, files and databases.Describe common data types such as integer, real, character, string, Boolean, and date. Know database models, such as relational model and hierarchical model, and list examples of their usage.Explain the use of database instance and schema in database modeling.

22

RDB seems to be a good choice, but what are the basic constructs of a Relational DB?

Describe the purposes and functions of database management systems.Explain the concepts of data definition language, data manipulation language, and data dictionary, and construct a simple data dictionary.Explain the concept of program-data independence.Describe the basic concepts of relational databases.

It includes entity, relationship, attribute, domain, index, key and integrity

Create a simple relational database.should know how to organize data differently but sensibly in a relational database and be able to establish the required relationships among the tables.

23

B

A

Now you know what a RDB is and know how to use it, but can you design a RDB on you own?

You must know some basic concepts:-Data Modeling,-Levels of Data Abstraction

You must learn a tools:- Entity-Relation Diagram (E-R).

And you must know the technique:- Normalization

Basic operations of the RDB:Structured Query Language(SQL),Data Definition Language(DDL),Data Manipulation Language(DML),Embedded SQL.

Now you know the basics of the Relational DB but do not know how to use it.

24

Now you know the basics of the Relational DB but do not know how to use it?

Basic operations of the RDBUse SQL to maintain a simple relational database, and manipulate its data or retrieve the required information in at most three tables.

modify the structure of the tablesadd, delete and modify the data in the tablesview, sort, and select contents by filtering, and create different viewsuse appropriate operators and expressions such as arithmetic operators and expressions, comparison operators, logical operators and the in, between and like operators to perform specific operationsuse simple built-in functions such as aggregate and string functionsperform queries on multiple tables, including the use of equi-join, natural join and outer joinperform sub-queries (for one sub-level only)export query results to, for example, text, html or spreadsheet format

25


some basic conceptsBe aware of and appreciate the importance of a good database design effective database management.Describe the needs of the three levels data abstraction, namely conceptual level, physical level and view level.

26


Learn a tool: Entity-Relation Diagram (E-R).Be aware of the different types of relationshipsamong entities in a relational database.Analyze simple scenarios in business, education or other fields and create simple Entity-Relationship (ER) diagrams involving binary relationship only in designing databases.

The resolution of many-to-many relationship into multiple one-to-many relationships should also be introduced.

28


Know the technique: NormalizationExplain the concepts of data redundancy and discuss the methods or measures used to reduce data redundancy.Transform the ER diagrams to tables in relational databases.Reduce data redundancy through normalization up to 3NF.

Students should be able to reduce data redundancy through normalization up to 3NF.

29

data privacydata miningdatabase personnel

Now you possess the basic techniques, what are the steps to construct a RDB.

- Database Life Cycle- Conceptual Design- Logical Design- Physical Design

Apply simple (CASE) tools to automate, manage andsimplify the database design process.

B

Bingo!!

The RDB has been built, is there any other issues that should also be considered to improve or to fine-tune it further?

OK, you are ready to go to design your own RDB now, is there any tool that can help to forfacilitating data models development, etc.?

Database and society

30

Now you possess the basic techniques, what are the steps to construct a RDB.

Database Life CycleUnderstand the stages involved in the database application development lifecycle and the links between them.

Include requirements collection and analysis, system definition, application and database design, DBMS selection, form and report design, prototyping, implementation, data migration, conversion and loading, testing, and operational maintenance.often involve review and repetition of previous stages through feedback loops.

31

(CASE) tools

Practice the main activities associated with the stages of the database application development lifecycle in an educational or commercial scenario.

(CASE) tools to automate, manage and simplify the database design process. CASE supports may include tools for data dictionary construction, and those for facilitating data models development, etc.

32

Database Applications, Developmentand Society

Discuss the importance of data privacy and develop proper attitudes to be an ethical user of database to respect data privacy.

Ways to achieve data privacy in database applications using access rights

Be aware of the uses and applications of data mining in daily life and explain how data mining can improve the quality of living. Identify different database personnel such as database administrators, designers, developers and data entry operators, and describe their roles and responsibilities in database development and maintenance.

The responsibilities and ethics of different database personnel should be stressed

33

Database and Society

Discuss the needs and trends of future database development and the corresponding applications.

mobile and wireless technologies, and dynamic webpagefactors such as volume of data, variety of data and variety of usersTrends in database models, including distributed, parallel, and multimedia, etc. and their impact

Appreciate how effective use of database applications changes peoples lives

34

Useful Resources

Oracle Sql platformSqlEdgeCase Studiohttp://www.cs.cityu.edu.hk/~dbdesign/main.html

35

Thank you!

the elective part of the nss ict curriculum - 教育局 · the elective part of the nss ict...

Documents