Hku Space Hd Bis Year 1 Guide
THE UNIVERSITY OF HONG KONG HKU SPACE Community College Higher Diploma Programmes 2013-14 Course Document Course Title: Database Management Systems
Course Code: Course Objectives The course aims to provide students with an understanding of database concepts and design. It covers database design issues, such as security, integrity, recovery and concurrency. Distributed database, object-oriented database and data mining and data warehousing concepts will also be introduced. Intended Learning Outcomes of the Course On completion of the course, students should be able to: ILO1. explain the fundamental components and functions of a database management systems; ILO2. describe the characteristics of relational databases and the different types of database; ILO3. apply the database normalisation techniques and entity-relationship diagram in database design stage; ILO4. describe the main tasks performed by a database administrator; ILO5. apply basic SQL programming in creating, manipulating and removing items inside database table; ILO6. describe basic tools and techniques used for data warehouse and data-mining. Syllabus 1. 2. 3. 4. 5. 6. 7. 8. 9. Introduction to database Organisation, storage, and retrieval of large bodies of uniform or structured data Common database applications Introduction to relational databases, object-oriented databases, and distributed databases Entity-Relationship modelling Normalisation up to 3rd Normal Form Relation database design concepts Database creation, manipulation and maintenance Data mining and data warehousing C C 6 6 2 2 4 0 0
Assessment Type of Assessment (Weighting) Continuous Assessment (50%) Examination (50%) Group Assignment (20%) Test (20%) Written Examination (50%) Description Individual Assignment (10%)
Pre-requisite(s) Nil Required and Recommended Reading Textbook: 1. Kifer, M., Bernstein, A. and Lewis, P. M., 2005, Database Systems: An Application Oriented Approach, Complete Version, 2nd ed., Addison-Wesley.
Course Code: Course Objectives The course aims to provide students with an understanding of database concepts and design. It covers database design issues, such as security, integrity, recovery and concurrency. Distributed database, object-oriented database and data mining and data warehousing concepts will also be introduced. Intended Learning Outcomes of the Course On completion of the course, students should be able to: ILO1. explain the fundamental components and functions of a database management systems; ILO2. describe the characteristics of relational databases and the different types of database; ILO3. apply the database normalisation techniques and entity-relationship diagram in database design stage; ILO4. describe the main tasks performed by a database administrator; ILO5. apply basic SQL programming in creating, manipulating and removing items inside database table; ILO6. describe basic tools and techniques used for data warehouse and data-mining. Syllabus 1. 2. 3. 4. 5. 6. 7. 8. 9. Introduction to database Organisation, storage, and retrieval of large bodies of uniform or structured data Common database applications Introduction to relational databases, object-oriented databases, and distributed databases Entity-Relationship modelling Normalisation up to 3rd Normal Form Relation database design concepts Database creation, manipulation and maintenance Data mining and data warehousing C C 6 6 2 2 4 0 0
Assessment Type of Assessment (Weighting) Continuous Assessment (50%) Examination (50%) Group Assignment (20%) Test (20%) Written Examination (50%) Description Individual Assignment (10%)
Pre-requisite(s) Nil Required and Recommended Reading Textbook: 1. Kifer, M., Bernstein, A. and Lewis, P. M., 2005, Database Systems: An Application Oriented Approach, Complete Version, 2nd ed., Addison-Wesley.