NSS-ICT‎ > ‎

Databases


First Term Exam (1.5 hours)
- Database A1: Chapter 1 - 7+ schema (48/60)
- Unit C: Internet and its application (Chapter 16 - 20) - mainly networking IP address (12/60)



CDC & HKEAA 
 Topic and Learning OutcomeRemarks 
 Introduction to Databases (8 hours)
  • Be aware of the uses and applications of databases in our daily 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.
  • Know database model such as relational model and hierarchical model and list examples of their modelling
  • Explain the use of database instance and schema in database modeling.
  • Describe the purposes and functions of DBMS.
  • Explain the concepts of data definition language, data manipulation language, and data dictionary, and construct a simple data dictionary.
  • 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.
 
 Relational databases (28 hours)
  • Explain the concept of program-data independence
  • Describe the basic concepts of relational databases
  • Create a simple relational database
  • Use SQL to maintain a simple relational database, and manipulate its data or retrieve the required information in at most three tables
 
Introduction to databases Design Methodology (22 hours)
  • Be aware of and appreciate the importance of a good database design in effective database management.
  • Describe the needs of the three levels of data abstraction, namely conceptual level, physical level and view level.
  • Be aware of the different types of relationships among entities in a relational database.
  • Analyse simple scenarios in business, education or other fields and create simple ER diagrams involving binary relationship only in designing databases.
  • Explain 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.


 
Databases Applications, Development and Society (17 hours)

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







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



Be aware of the uses and applications of data mining in daily life and explain how data mining can improve the quality of living.


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








 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.


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


Appreciate how effective use of database applications changes people's lives.


 

The main stages involved in the database application development lifecycle 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.

Students should recognise that the stages of the database application development lifecycle often involve review and repetition of previous stages through feedback loops.


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.






Students should be able to discuss the impact of technologies such as mobile and wireless technologies, and dynamic web pages on database development.

In considering the need for different database applications, factors such as volume of data, variety of data and variety of users should be discussed.

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


The responsibilities and ethics of different database personnel should be stressed.


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




SQL commands and Spreadsheet Functions

Reserved Word List



Textbook: New Senior Secondary Information and Communication Technology Elective A1, Pearson Longman.

Unit A
Chapter 1: Applications of databases in Our Daily Life
Chapter 2: Data Organization in Databases

Unit B
Chapter 3: Relational Database Concept (I)
Chapter 4: Relational Database Concept (II)
Chapter 5: Structure Query Language (I)
Chapter 6: Structure Query Language (II)
Chapter 7: Structure Query Language (III)




Paper 1
Section A (Book 1): Excel + Database  (Q1-10)
Section C (Book 2)                                (Q11-20)
Section D, E (except chp 28) - Book 3  (Q21-40)

Structure Q:
Q1. Excel + DB
Q2. Section C
Q3. Section D
Q4: Section E

Paper 2 (Database):
Q1-2. Section D 
Q3-4. Database

Paper 3 (SBA - Design)




ĉ
T. Chan,
May 28, 2015, 11:35 PM
ċ
ex3_ans_part3.sql
(5k)
T. Chan,
Jun 15, 2015, 10:41 PM
Comments