Advanced Database Systems Development; CC6001 Advanced Database Systems Development
Advanced Database Systems Development;
CC6001 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
College.
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.
1
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
management.
2
NEW WAVE COLLEGE, LONDON
Course Booking Form
BOOKING REF NO
B0888
BOOKING DATE
1 November 2012
STUDENT NO
S1007
STUDENT NAME
James Bond
STUDENT ADDRESS
13 Crazy Gardens
Chaotic Junctions
LONDON SW3 1PP
STUDENT TELEPHONE
0207 8888 007
COURSE CODE
CF300
COURSE NAME
French
COURSE LEVEL
Advanced
START DATE
st
1 January 2013
FINISH DATE
1 April 2013
NAME OF LECTURER
Professor Yves Chirac
NAME OF CENTRE
Victoria
COST OF COURSE
£2000
st
st
Figure 1
3
NEW WAVE COLLEGE, LONDON
Course Summary Form
COURSE CODE
COURSE NAME
COURSE LEVEL
START DATE
FINISH DATE
COST OF COURSE
CF300
French
Advanced
st
1 January 2013
1st April 2013
£2000
LECTURER / CENTRE ASSIGNMENT
LECTURER#
NAME
CENTRE
L120
L245
L120
Lucy Paris
Yves Chirac
Lucy Paris
CENTRE PHONE
Victoria
Victoria
Moorgate
0207-2341000
0207-2341000
0207-2342000
CLASS SIZE
8
10
5
STUDENT LIST
STUDENT#
S1007
S1010
S1212
S1518
S1650
S1890
S2000
S2678
S2999
NAME
James Bond
John Scott
Bush Blair
Simon Lee
Johnny Major
Bridget Jane
Hue Grant
George Rumsfelt
Mary Adams
PHONE
0207 8888007
0208 3456780
0207 1234567
0208 1222789
0123 5678900
0201 1167456
0207 1169878
0208 5762345
0207 7852879
CENTRE
Victoria
Moorgate
Victoria
Moorgate
Victoria
Victoria
Victoria
Moorgate
Victoria
LECTURER#
L245
L120
L245
L120
L120
L245
L120
L120
L245
Figure 2
4
NEW WAVE COLLEGE, LONDON
Victoria Centre
Lecturer Student Report
For month: January 2013
Lecturer#:
L245
Lecturer Name: Yves Chirac
Student No
Student Name
Student Phone
S1007
S1212
S1890
S2999
James Bond
Bush Blair
Bridget Jane
Mary Adams
0207 8888007
0207 1234567
0201 1167456
0207 7852879
Lecturer#:
L120
Lecturer Name:
Lucy Paris
Student No
Student Name
Student Phone
S1650
S2000
S3001
Johnny Major
Hue Grant
Adam Clarke
0123 5678900
0207 1169878
0118 0001234
Lecturer#:
L201
Lecturer Name: Ian Smith
Student No
Student Name
Student Phone
S1000
S1213
S1899
S2567
S3050
Mike Howard
Eddie Windsor
Victoria Pond
Pamela Lee
Catherine Dole
0207 1256807
0207 8765432
0201 3201700
0207 7458745
0789 1567384
Figure 3
5
2. Requirements of the Coursework
Marks are awarded for producing a working and properly documented system that meets
the requirements specified below as deliverables:
2.1
Contents Page
A list of sections/subsections of the document, including page numbers.
2.2
Normalisation
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.
2.3
E-R Model
Use Oracle Designer to produce an Entity Relationship diagram, consistent with your
3rd normal form tables. Submit a copy of the ER diagram.
2.4
Data Dictionary
Use Oracle Designer to produce a list of attributes for each entity. Submit a print-out
copy of these lists.
2.5
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.
2.6
Implementation of Web-based Database Application
Implementation of a database web application which includes the following
webforms (web pages) using ASP.NET with C#:
•
Basic Webforms:
Student Details
Lecturer Details
Course Details
Centre Details
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.
6
•
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
specific centre).
Implementation of a homepage which includes menus to access the webforms you
have implemented.
Implemented database application must be uploaded to focserver and accessible via
internet. Application submitted via CD or email will not be accepted.
2.7
Documentation of the system.
FOR EACH FORM
Implementation document
• 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
produced.
Testing Document
• 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)
•
•
2.8
The User Manual should have a contents page and separate sections for each
form provided.
The User Manual should contain clear instructions on how to use the system and
how to run each of the forms available to it.
Further Discussion
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.
7
3.
Coursework Submission
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
contents pages
• 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 .
END
8
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)