2014 Papers
Level 2 Papers >> All Papers
COMP219A Database Practice and Experience

20 Points

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)
  • Views
  • Triggers and Integrity Constraints
  • Security

Learning Outcomes

Students should be able to:

  • Design relational databases using the entity-relationship modelling method.
  • Demonstrate their understanding of database concepts through the creation of practical database solutions.
  • Utilise SQL tools such as stored procedures, triggers and views.
  • Perform a range of SQL queries.

Pre Requisite Papers
COMP103 Introduction to Computer Science 1

Lecturers and Tutors

A Semester

Moodle Link


The lecture schedule can be found on the Official Timetable Information

Practicals will be posted on Moodle each week. Each practical session will focus on a particular topic and the student can get help from demonstrators.

Starting from the third week of the semester, a series of 1 hour lab sessions is scheduled. Students will be expected to complete the practical in their own time if they do not finish the practical during their supervised lab session. Students will be required to attempt a practical completion exercise for each practical on Moodle which is then marked by the tutor. The practical material will be made available in Moodle as the course progresses. Any files which the course requires will be available on Moodle.

You may use the laboratory at any free time to prepare for the practical. A timetable of free time for the lab is shown on the door of the lab. In the first week of the course you will sign up for a supervised lab session where you can get help from demonstrators. You will not be permitted to attend any supervised lab hours that you have not signed up for.

Compulsory Components

This paper approaches the subject of databases from a practical perspective; how do I create a database, and how do I retrieve/update data are heavily addressed in this course. Database programming, using SQL, will be introduced in lectures as you will master practical skills associated with a commercial Database product (Microsoft SQL Server). The strategy to use Transact-SQL as a user interface to SQL Server is to promote both understanding and practice of the different tools used to build, access and maintain a database within a Client/Server database computing environment.


You should plan to spend approximately thirteen hours per week on this course. The time (per week) will be divided as follows:

Lectures 2 hrs/wk
Practicals 2 hrs/wk
Reading 2 hrs/wk
Preparation and Revision 7 hrs/wk

This is a very rough guideline; the number of hours you spend and the way you allocate those hours will depend very much on your individual background and aptitudes.

Other Reading Material

The course notes and handouts will be made available to students in electronic form through Moodle.

Computing Resources

Lab 2 in R Block is available for use by COMP219A students to complete the practicals for this course.

Lab 2 is open for class use during normal working hours. Outside of these hours you will need authorisation for after hours access. A Cardax authorisation form can be obtained from the Computer Science secretaries. You may use the facilities during the lab session you signed up for. Sessional assistants will be available to assist you. You should not log on during the times that another class is scheduled to use the laboratory even if there are machines not being used. You are advised to check the laboratory schedule posted on the laboratory door for the available times.

Assessment Ratio
Internal assessment/final examination ratio 1:0

Assessment Components
The student must get at least 50% in two of the three practical tests, the student must submit Project Deliverable 4 and must also achieve an overall mark of 50% to receive a passing grade for this course.

Marks for completed work will be posted on Moodle for you to check and ensure that they have been recorded correctly. If there is any discrepancy in your marks, inform the tutor co-ordinator.

Ensure you keep all completed coursework until you have received your final grade. The completed coursework will be required if you need to have your grade reviewed.

Grading Schedule

Coursework assessment is based upon Four major components: 3 practical tests and a final project. The marks are allotted as follows:

Practical Test 1 20%
Practical Test 2 25%
Practical Test 3 25%
Project: 20%
Lab Exercises: 10%

Assessment Deadlines

Hamilton Students
Practical Test 1 is on Wednesday 2nd April 2014
Practical Test 2 is on Wednesday 14th May 2014
Practical Test 3 is on Wednesday 4th June 2014

Tauranga Students
Practical Test 1 is on Thursday 3rd April 2014
Practical Test 2 is on Thursday 15th May 2014
Practical Test 3 is on Thursday 5th June 2014

All Students
Project Deliverable 1 is due Friday 28th March by 4pm
Project Deliverable 2 is due Friday 9th May 2014 by 4pm
Project Deliverable 3 is due Friday 23rd May 2014 by 4pm
Project Deliverable 4 is due at the time of your demonstration
Project Demonstrations will be held on Tuesday and Wednesday in Study Week. Exact dates and times will be posted on Moodle closer to the time.

Attendance Policy

Class attendance is expected. The course notes provided are not comprehensive; additional material will be covered in class. You are responsible for all material covered in class.

Tutor Coordinator
The first person to contact in relation to any course matter (queries, problems, help, etc) is the Tutor Co-ordinator.

Nilesh Kanji (RG.13, (07) 858-5047) is the Tutor Co-ordinator for this course. Enquiries or questions can be posted on Moodle or an email should be sent to contact-comp219@cs.waikato.ac.nz, these will be responded to within one working day.

Academic Integrity
Follow this link for Academic Integrity information and this link for detailed explanation of How to prevent plagiarism in Computer Science assessment items.

Performance Impairment
Follow this link for information on Performance Impairment.

Student Concerns and Complaints
Follow this link for Student Concerns and Complaints information.

Application for Extension
Follow this link for information on applying for an Extension.

Review of Grade
Follow this link for information on applying for a Review of Grade.

University Regulations
Your attention is drawn to the following regulations and policies, which are published in the University Calendar:

  2007 FCMS. The University of Waikato - Te Whare Wananga o Waikato