Databases are increasingly being used in both small and large businesses as the cornerstone of modern information management systems. Through advances in client/server computing it is now possible to support corporate database activity on a variety of personal computer platforms. It is becoming increasingly important in the areas of Information Systems and Management Information Systems for database users to acquaint themselves with this type of software so that they can gain access to information directly rather than through a systems analyst.
The objective of this paper is to provide students with the knowledge and experience of a modern corporate relational database system. The paper will emphasise practical skills learned from a series of laboratory exercises.
Topics covered in both the laboratory and lecture programme will include:
- Data, Databases and DBMS
- Database Design
- Data Definition (SQL)
- Data Retrieval (SQL) Data Modification (SQL)
- Triggers and Integrity Constraints
COMP103 Introduction to Computer Science 1
Internal assessment/final examination ratio 1:0