Databases & Interfaces
| Code | School | Level | Credits | Semesters |
| COMP1044 | Computer Science | 1 | 10 | Spring Malaysia |
- Code
- COMP1044
- School
- Computer Science
- Level
- 1
- Credits
- 10
- Semesters
- Spring Malaysia
Summary
Databases are everywhere and we interact with many different databases every day, using the web, using electronic calendars, diaries or timetables, making appointments, searching for contact details, shopping online, looking up directions, and many more things. These databases need to be both easy to use and fast. This module considers both the structure of databases, including how to make them fast, efficient and reliable, and the appropriate user interfaces which will make them easy to interact with for users. You will start by looking at how to design a database, gaining an understanding of the standard features that management systems provide and how you can best utilise them and then develop an interactive application to access your database. Throughout the lectures and computing sessions you will learn how to design and implement systems using a standard database management system, web technologies and GUI interfaces through practical programming/system examples. You will spend around three hours per week in lectures and two hours per week in organised computer labs studying for this module, and will be expected to spend additional time practising and completing your coursework.
Target Students
Available to Level 1 students in the School of Computer Science. Available to inter-campus mobility students and other exchange students in computer science. This module is not available to students not listed above, without explicit approval from the module convenor(s). This module is part of the Programming theme in the School of Computer Science.
Co-requisites
Modules you must take in the same academic year, or have taken in a previous year, to enrol in this module:
Classes
- One 2-hour lecture each week for 12 weeks
- One 2-hour computing each week for 12 weeks
- One 2-hour computing each week for 12 weeks
- One 2-hour computing each week for 12 weeks
Assessment
- 40% Coursework 1: Two quiz with 2 hours each.
- 60% Coursework 2: Submission of SQL code for building a relational database and executing various queries. This is followed by building a front-end using web technologies that will connect to the database and execute queries.
Assessed by end of spring semester
Educational Aims
To provide students with a general introduction to the theory and practice of database systems. To enable students to gain experience with a modern database system through the use of the SQL language. To give an understanding of the structure and workings of database systems and provide some insight into recent developments. To give an understanding of the principles of event-driven programming. To enable students to gain experience with design and implementation of GUI interfaces within a database environment.Learning Outcomes
Knowledge and Understanding: Ability to understand and use SQL. An understanding of the ANSI/SPARC and relational models of database systems. Understanding of the principles of event-driven programming.
Intellectual Skills: Basic knowledge of the mathematics underlying relational database systems. Ability to design and implement database systems. Ability to design and implement a GUI.
Professional Skills: The use of SQL for database specification and manipulation. The use of web technologies and GUI interfaces for database front-end development..
​Transferable Skills: Understanding of the use and administration of database systems. Understanding the use of web technologies and GUI interfaces.
Conveners
- Dr Chye Cheah Tan