Computer Science Home | People | Degrees | Papers | Research | Events | Other FCMS Subjects
 
Level 1 Papers

Level 2 Papers

Level 3 Papers

Level 4 Papers

Level 5 Papers

Summer School Papers

Industry Papers

CGRD224
Visual Design for Interactive Media

CGRD241
Computer Graphic Design 1

CGRD252
Studies in Visual Communication

COMP200
Computer Systems

COMP203
Programming with Data Structures

COMP219
Database Practice and Experience

COMP221
Introduction to 3D Modelling and Animation

COMP223
Information Discovery

COMP224
Visual Design for Interactive Media

COMP241
Software Engineering Development

COMP258
Programming Usable Systems

COMP278
Interactive Computing

ENEL212
Electronics for Digital Systems

2015 Papers
Level 2 Papers >> A Semester
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

Moodle Link
http://elearn.waikato.ac.nz

Timetable

LECTURES:
The lecture schedule can be found on the Official Timetable Information

PRACTICALS:
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.

Workload

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

Grading Schedule

Assessment Deadlines

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.

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