• 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.

• 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

• 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.

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.