SQLserver database

An Introduction to Database with Web Applications, Martyn Prigmore, Prentice Hall, 2008, ISBN: 978-0-321-26359-9

The module aims to allow you to work in your own time and at your own pace, with lecturers being available during the two set tutorial/practical sessions each week to offer assistance where required. Extensive use is made of the technique of learning via problem solving. The course relies heavily on prescribed reading with lectures supporting you in complex areas. You will be able to identify the extent and type of help you require from these sessions by active learning self assessments which will be provided as an integral part of the module. There will be 12 lectures and 24 tutorial/practical sessions.
(1:n)1 (1:20)2

Coursework weighted at 100% made up of:

1) analyse and design (derived from a case study) a solution for a typical SME, weighted at 50% assessing learning outcome 1.
2) an implementation based on the work completed in 1), weighted at 50% assessing learning outcome 2.

This module focuses on data analysis rather than systems or business analysis.

The module comprises two (equal) sections:

a) Data modelling using
Entity Relationship Modelling
Normalisation
UML

These techniques will be developed with respect to typical software development lifecycles and methodologies such as SSADM 4+, Rapid Application Development (RAD) etc.

b) Utilising a database to design, build and query data that has been developed using skills shown in a)

The database will be suitable for small to medium size companies, and the students will use a GUI to manipulate and interact with database e.g. SQLserver

None.