Accessibility navigation

SE2XP0-Advanced Programming and Databases

Module Provider: School of Systems Engineering
Number of credits: 10 [5ECTS credits]
Level: 5
Terms in which taught:
Module Convenor: Professor D James
Pre-requisites: SE0XD0
Co-requisites:
Modules excluded:
Module version for: 2009/0

Email:

Aims:
To develop skills for designing and writing databases and to develop programs that can interact with databases.

  • To introduce the means of managing databases and program development and testing
  • To show the potential uses of databases and programming software and tools
    Note the programming language and query language to be studied is not dictated. Individual tutors will recommend languages suitable to the student.

    Assessable learning outcomes:
    On successful completion of the module, students will be able to:

  • Design and develop a database
  • Demonstrate the use of a data base query language
  • Design, write and test a program that accesses data from a database.
  • List the opportunities that program developers have to incorporate Internet technologies into their applications.

    Additional outcomes:
    Students may be able to take professional qualifications such as:

  • CISCO: Java Platform 2 Certification
  • Oracle9i: Java Programming Ed 2
  • Microsoft 1013: Mastering Microsoft Visual Basic 6 Development

    Outline content:

  • building complex databases
  • incorporating complex relationships into databases
  • Entity Relationship Modelling, Normalization and other relevant data modelling techniques.
  • the use of forms, program code and other techniques to enhance user interface and functionality.
  • the use of interfaces to external programs including the use of import and export.
  • complex query facilities.
  • developing a test plan and carrying out testing
  • the use of databases in Internet applications
  • understanding and applying database security features
  • understanding the principles of event-driven and object oriented programming in relation to databases and applying the basics to database programming.

    Brief description of teaching and learning methods:
    The student will learn from a combination of on line materials, group lab work, and formal tutor input.

    Contact hours:

      Over 1 year Spring Summer
    Lectures 15    
    Tutorials/seminars      
    Practicals      
    Independent Guided Study (including related work at the work place) 45    
           
    Total hours 60    
           
    Case Study Project 1    
    Other (eg major seminar paper)      

    Assessment:
    The term offered will depend on the partner college
    Assessment:
    Assessment will be through:
    * Continual assessment tests
    * Submission of a Project
    Coursework
    The case study project will where possible be related to the work place.
    Relative percentage of coursework : 100%
    Penalties for late submission
    Penalties for late submission of course work will be in accordance with University policy.
    Examinations
    There will not be an exam. Assessment is by coursework only.
    Requirements for a pass
    Pass in coursework
    Reassessment arrangements
    Resubmission of coursework.

    Last updated: 23 November 2009

    • Things to do now

    Page navigation

     

    Search Form