COMPX223-18A (HAM)

Database Practice and Experience

15 Points

Edit Header Content
Faculty of Computing and Mathematical Sciences
Rorohiko me ngā Pūtaiao Pāngarau
Department of Computer Science

Staff

Edit Staff Content

Convenor(s)

Lecturer(s)

Administrator(s)

Placement Coordinator(s)

Tutor(s)

: nilesh.kanji@waikato.ac.nz

Student Representative(s)

Lab Technician(s)

Librarian(s)

: debby.dada@waikato.ac.nz
: clive.wilkinson@waikato.ac.nz

You can contact staff by:

  • Calling +64 7 838 4466 select option 1, then enter the extension.
  • Extensions starting with 4, 5 or 9 can also be direct dialled:
    • For extensions starting with 4: dial +64 7 838 extension.
    • For extensions starting with 5: dial +64 7 858 extension.
    • For extensions starting with 9: dial +64 7 837 extension.
Edit Staff Content

Paper Description

Edit Paper Description Content
This paper approaches the subject of databases from a practical perspective - how do I create a database and how do I retrieve/update data. Both aspects are heavily addressed in this paper. Database creation and querying, using SQL, will be introduced in lectures as you will master practical skills associated with a commercial Database product (Microsoft SQL Server). The paper also introduces Microsoft's extension to SQL, Transact-SQL, which provides a user interface to SQL Server. This 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.
Edit Paper Description Content

Paper Structure

Edit Paper Structure Content

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 Constratins
  • Security
Edit Paper Structure Content

Learning Outcomes

Edit Learning Outcomes Content

Students who successfully complete the course should be able to:

  • design relational databases using the entity-relationship modelling method
    Linked to the following assessments:
  • create relational databases using SQL
    Linked to the following assessments:
  • query relational databases using the query language SQL
    Linked to the following assessments:
  • demonstrate their understanding of database concepts through the creation of practical database solutions
    Linked to the following assessments:
  • utilise SQL tools such as stored procedures, triggers and views
    Linked to the following assessments:
Edit Learning Outcomes Content
Edit Learning Outcomes Content

Assessment

Edit Assessments Content

The student must get at least 50% in two of the three practical tests, as well as 50% in the project, and must also achieve an overall mark of 50% to receive a passing grade for this paper.

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 coordinator.

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

Edit Additional Assessment Information Content

Assessment Components

Edit Assessments Content

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0. There is no final exam. The final exam makes up 0% of the overall mark.

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0 or 0:0, whichever is more favourable for the student. The final exam makes up either 0% or 0% of the overall mark.

Component DescriptionDue Date TimePercentage of overall markSubmission MethodCompulsory
1. Curriculum Quiz
7 Mar 2018
11:30 PM
5
  • Online: Submit through Moodle
2. Practical Test 1
4 Apr 2018
No set time
15
  • Hand-in: In Lab
3. Practical Test 2
16 May 2018
No set time
20
  • Hand-in: In Lab
4. Practical Test 3
6 Jun 2018
No set time
20
  • Hand-in: In Lab
5. Project Deliverable 1
23 Mar 2018
4:00 PM
6
  • Hand-in: Assignment Box (G Block)
6. Project Deliverable 2
6 Apr 2018
4:00 PM
8
  • Hand-in: Assignment Box (G Block)
7. Project Deliverable 3
4 Jun 2018
No set time
16
  • Hand-in: In Lab
8. Practical Exercises / Moodle Quiz
10
  • Online: Submit through Moodle
Assessment Total:     100    
Failing to complete a compulsory assessment component of a paper will result in an IC grade
Edit Assessments Content

Required and Recommended Readings

Edit Required Readings Content

Required Readings

Edit Required Readings Content
There are no required textbooks for this paper. Reading material will be made available on Moodle.
Edit Required Readings Content

Recommended Readings

Edit Recommended Readings Content

There are no recommended textbooks for this paper. Reading material will be made available on Moodle.

A good textbook for students who are considering both database papers is

"Database Systems: The Complete Book" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom.
Edit Recommended Readings Content

Other Resources

Edit Other Resources Content

Computing Resources

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

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 administrators. 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.

Edit Other Resources Content

Online Support

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

Workload

Edit Workload Content

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

  • Lectures - 2 hrs/week
  • Practicals - 2 hrs/week
  • Reading - 2 hrs/week
  • Project - 2 hrs/week
  • Preparation and Revision - 5 hrs/week

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.

Edit Workload Content

Linkages to Other Papers

Edit Linkages Content

Prerequisite(s)

Prerequisite papers: COMP103 or COMPX101

Corequisite(s)

Equivalent(s)

Restriction(s)

Restricted papers: COMP219

Edit Linkages Content