COMP2013J Databases and Info Sys (S/E)

Academic Year 2023/2024

The Collection, organisation and storage of data are major tasks in many human activities and in every modern computing system. Computer-based information systems ensure that this data is permanently maintained, quickly updated and made accessible to users. Databases are essential components of computerised information systems. This is a module for all students interested in understanding how to design, develop and query databases. In this module students will learn the fundamentals of database models, database designing methodologies, database querying and database normalisation theory. They will learn details about the relational database model, relational query languages, the entity-relationship model for database design, and database normalisation. From a more practical point of view they will gain experience in building a relational database using a relational database management system (such as MySQL). Students will find these skills very useful in the development of any application requiring the storage and manipulation of data.

Show/hide contentOpenClose All

Curricular information is subject to change

Learning Outcomes:

On completion of this module students should be able to formulate, explain and compare the fundamental database concepts; design a relational database (conceptual and logical design using entity-relationship and relational models); analyse a relational database table to verify that it is in normal form; implement and query a relational database.

Student Effort Hours: 
Student Effort Type Hours
Lectures

30

Laboratories

26

Autonomous Student Learning

69

Total

125

Approaches to Teaching and Learning:
Lectures, Laboratory Worksheets, Take-home Assignments. 
Requirements, Exclusions and Recommendations

Not applicable to this module.


Module Requisites and Incompatibles
Not applicable to this module.
 
Assessment Strategy  
Description Timing Open Book Exam Component Scale Must Pass Component % of Final Grade
Examination: Final Exam. 2 hour End of Trimester Exam No Standard conversion grade scale 40% No

70

Continuous Assessment: Continuous Assessment Varies over the Trimester n/a Graded No

30


Carry forward of passed components
No
 
Resit In Terminal Exam
Summer Yes - 2 Hour
Please see Student Jargon Buster for more information about remediation types and timing. 
Feedback Strategy/Strategies

• Group/class feedback, post-assessment
• Self-assessment activities

How will my Feedback be Delivered?

Not yet recorded.

Name Role
Ms Jie Chen Tutor
Dairui Liu Tutor
Jiantao Wu Tutor
Timetabling information is displayed only for guidance purposes, relates to the current Academic Year only and is subject to change.
 

There are no rows to display