Courses Offered

COMP3278 Introduction to database management systems

2017-18

Instructor(s):

Chui C K

(Class A)

No. of credit(s):

Chui C K

(Class B)

Recommended Learning Hours:

Lecture:	31.0
Tutorial:	8.0

Pre-requisite(s):

COMP2119 or CSIS1119 or ELEC1502 or ELEC1503 or ELEC2543

Co-requisite(s):

Mutually exclusive with:

BUSI0052 or IIMT3601

Remarks:

Course Learning Outcomes

1.	[Information Modeling] Able to understand the modeling of real-life information in a database system.
2.	[Query Languages] Able to understand and use the languages designed for data access.
3.	[System Design] Able to understand the design issues of an efficient and reliable database system.
4.	[Application Development] Able to implement a practical application on a real database.

Mapping from Course Learning Outcomes to Programme Learning Outcomes
	PLO a	PLO b	PLO c	PLO d	PLO j
CLO 1	T,P	T,P			T,P
CLO 2			T,P		T,P
CLO 3				T,P
CLO 4				T,P	T,P

T - Teach, P - Practice
For BEng(CompSc) Programme Learning Outcomes, please refer to here.

Syllabus

Calendar Entry:
This course studies the principles, design, administration, and implementation of database management systems. Topics include: entity-relationship model, relational model, relational algebra, database design and normalization, database query languages, indexing schemes, integrity and concurrency control.

Detailed Description:

Database design	Mapped to CLOs
Entiry-relationship model	1
Relational model	1
Database normalization	1
Query languages	Mapped to CLOs
Query languages: relational algebra and SQL	2
System Design	Mapped to CLOs
Data storage	3
Indexing	3
Query evaluation	3
Transaction management	3
Application Development	Mapped to CLOs
Application Development	4

Assessment:
Written Examination: 50%
Continuous Assessment: 50%

Teaching Plan

Please refer to the corresponding Moodle course.

Moodle Course(s)

COMP3278A
COMP3278B

Courses Offered

COMP3278 Introduction to database management systems

Sign in to your account

Sign in to your account