Advanced Database Systems Development; C6001 Advanced Database Systems Development;
Coursework Assignment 2014-15
The coursework assignment is an individual assessment weighted 40% of the marks
for the module. It is designed mainly to assess students’ practical problem-solving skills
and critical thinking/evaluation on the design and development of database systems. It
requires the student to analyse, design and implement a web-based database
application based on a given business case study. You are asked to provide a software
solution as well as appropriate documentation detailing the design and implementation
of the system.
1. Case study – New Wave College
New Wave College is a reputable language institute specialised in providing foreign
language courses at various levels to the general public. It has several local centres in
and around London. At present, course enquiries and bookings are managed centrally
by the College on a semi-automated basis, namely, they are handled by a largely
paper-based file system, supported partially by a basic computer system.
Acutely aware of the limitations of the current regime and keen to improve the quality of
the services, the College has approached Big Wheel Ltd, an up-and-coming software
house based in Islington of North-East London, with a request to develop a fully
operational web-based database system to enhance course management at the
You have been sub-contracted by Big Wheel as a Junior Database Developer to
design and implement a prototype of the web-based database system for the College.
On completion of the system, you are required to provide a full set of documentation of
the system to Big Wheel.
Your prototype of the system will be developed using Oracle Designer, Oracle SQL
Plus, and ASP.NET with C# at London Met.
New Wave College offers courses for various foreign languages, including French,
German, Spanish, Italian, Japanese, Chinese and so on. Each course is identified by a
unique course code, and designated with a particular level (Introductory, Intermediate,
or Advanced). Any of the courses may be run at more than one centre of the College
and taught by more than one lecturer within the same period. Moreover, a lecturer may
teach at more than one centre if necessary.
A potential student will initially make an enquiry to one of the Course Officers at the
Central Enquiry Unit of the College. A brief conversation with the student will normally
enable the Course Officer to ascertain the course in which the student is interested,
and to identify an appropriate level for the student.
The Course Officer will then check the cost and dates of the course, together with its
availability. In most cases, the student will be requested to choose from a list of
available centres and lecturers that run the same course. Once a choice has been
made by the student and provided the chosen course is not yet fully booked, the
Course Officer will complete the Course Booking Form given in Figure 1, a copy of
which will be given to the student. Each Course Booking Form deals with one course
booking only. A student may book several courses, in which case a separate Course
Booking Form will be required for each course booked.
When the student confirms the booking, a copy of the Course Booking Form will be
passed to the Administrative Officer at the Registry of the College, who will prepare a
formal Enrolment Form. This Enrolment Form will be sent to the student, together with
an Invoice for payment and other relevant course information.
The Administrative Officer will then use the details contained in the Enrolment Form to
update the Course Summary Form as given in Figure 2. This form provides for each
course the most up to date information on all the centres and lecturers running the
course, together with a list of students who have registered for the course so far. A
copy of this Course Summary Form will be distributed to all the relevant centres and
the lecturers involved for record keeping. Consequently, each lecturer will be able to
extract information from this form to compile his or her own Class Registration List.
The Registry produces several other forms either on a regular basis or on request.
These forms include Lecturer Assignment Forms, Centre Assignment Forms, Course
Assignment Forms, Staff Details Forms, Student Details Forms, and so on.
In addition, the Registry generate various reports either on a regular basis or when
required, for example, Course Student Reports, and Lecturer Student Reports (as
given in Figure 3).
The introduction of a fully operational database system, the prototype of which Leading
Edge has sub-contracted you to develop, will facilitate a much needed improvement to
the Registry for its provision of timely course information and efficient course
NEW WAVE COLLEGE, LONDON
Course Booking Form
BOOKING REF NO
1 November 2012
13 Crazy Gardens
LONDON SW3 1PP
0207 8888 007
1 January 2013
1 April 2013
NAME OF LECTURER
Professor Yves Chirac
NAME OF CENTRE
COST OF COURSE
NEW WAVE COLLEGE, LONDON
Course Summary Form
COST OF COURSE
1 January 2013
1st April 2013
LECTURER / CENTRE ASSIGNMENT
NEW WAVE COLLEGE, LONDON
Lecturer Student Report
For month: January 2013
Lecturer Name: Yves Chirac
Lecturer Name: Ian Smith
2. Requirements of the Coursework
Marks are awarded for producing a working and properly documented system that meets
the requirements specified below as deliverables:
A list of sections/subsections of the document, including page numbers.
Produce a set of fully normalised tables for the system:
You may use Figure 1 and Figure 2 as a starting point for normalisation.
You may also add additional attributes where appropriate.
show clearly all the steps of normalisation, up to the 3rd normal form.
Use Oracle Designer to produce an Entity Relationship diagram, consistent with your
3rd normal form tables. Submit a copy of the ER diagram.
Use Oracle Designer to produce a list of attributes for each entity. Submit a print-out
copy of these lists.
Generation of Database
Use Oracle Designer to covert the E-R diagram into a set of database tables.
Provide a print-out of the DDL script for generating the tables.
Use Oracle SQL Plus to populate these tables with suitable data values.
Provide a print-out of contents for all the tables.
Implementation of Web-based Database Application
Implementation of a database web application which includes the following
webforms (web pages) using ASP.NET with C#:
All these forms should facilitate input, update and delete of information.
Lecturer Assignment (for any lecturer, show all the courses they have been
assigned to teach);
This form should facilitate the allocation of an existing lecturer to an existing
Course Assignment (for any course, show all the centres and the lecturers that
have been assigned to run it);
This form should facilitate the allocation of an existing course to an existing
lecturer at an existing centre.
Course Booking, as a slightly modified version of the form given in Figure 1 (for
a student, make a booking for a course taught by a particular lecturer at a
Implementation of a homepage which includes menus to access the webforms you
Implemented database application must be uploaded to focserver and accessible via
internet. Application submitted via CD or email will not be accepted.
Documentation of the system.
FOR EACH FORM
• Provide all ASP.NET and C# codes, as well as HTML and CSS code where
appropriate, used in Visual studio which have been written by you.
• Provide a set of screen dumps for all the web pages (webforms) you have
• Provide a copy of the initial data (table contents) contained in the system.
• For each form implemented, list the individual tests that have been carried out
together with their results.
FOR THE APPLICATION
User Manual (up to 5 pages)
The User Manual should have a contents page and separate sections for each
The User Manual should contain clear instructions on how to use the system and
how to run each of the forms available to it.
Your discussion should summarise your experience in undertaking this Coursework.
Your work must be submitted in a single document, with all output including
diagrams, tables, forms, SQL scripts clearly labelled and presented. URL of the
application should be clearly presented on the cover page of you document.
The coursework will be due on Friday week 18.The submission should include CW
documentation and a live web-based database application.
• The document should be contained in a single MS Word document with title and
• The title page should include module code, module title, URL of the web site,
student id and name, and date submitted
• The coursework document should be submitted via Weblearn.
• The web-based database application should be uploaded to the web server
(focserver.londonmet.ac.uk) at SoC .
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂