PLAGIARISM
You are reminded that there exist regulations concerning plagiarism. Extracts from these
regulations are printed below. Please sign below to say that you have read and understand
these extracts:
(signature:)______________________ Date: _______________
This header sheet should be aached to the work you submit. No work will be accepted without it.
Extracts from UniversityRegulations on
Cheating, Plagiarism and Collusion
Section 2.3: “The following broad types of offence can be identified and are provided as indicative examples.
(i)
| (ii) (iii) |
Personation, where a substitute takes an examination or test on behalf of the candidate. Both candidate and substitute may be guilty of an offence under these Regulations. Collusion to present joint work as the work solely of one individual. Plagiarisms, where the work or ideas of another are presented as the candidate’s own. Other conduct calculated to secure an advantage on assessment. Assisting in any of the above. |
| (iv) (v) (vi) (vii) (viii) |
|
| Some notes on what this means for students: | |
| 1. | Copying another student’s work is an offence, whether from a copy on paper or from a computer file, and |
AssignmentTutorOnline
in whatever form the intellectual property being copied takes, including text, mathematical notation and
computer programs.
2. Taking extracts from published sourceswithout attribution is an offence. To quote ideas, sometimes
using extracts, is generally to be encouraged. Quoting ideas is achieved by stating an author’s argument and
attributing it, perhaps by quoting, immediately in the text, his or her name and year of publication, e.g. ” e =
mc2 (Einstein 1905)”. A references section at the end of your work should then list all such references in
alphabetical order of authors’ surnames. (There are variations on this referencing system, which your tutors may
prefer you to use.) If you wish to quote a paragraph or so from published work, then indent the quotation on both
left and right margins, using an italic font where practicable, and introduce the quotation with an attribution.
Introducࢢon 2
1 Case Study – Online Library Management System 2
1.1 System Requirements 2
2 Requirements of the Coursework 3
2.1 Contents Page 3
2.2 Normalisaࢢon 3
2.3 E-R Model 3
2.4 Data Dicࢢonary 3
2.5 Generaࢢon of the Database 3
2.6 Implementaࢢon of the Web-based Database Applicaࢢon 4
2.7 Documentaࢢon of the developed system 4
2.8 Further Discussion 5
3 Marking Scheme 5
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 S
ydenham Library is a medium sized limited company, which provides educational
resources e.g. books, CDs etc. to students in different subjects (computing, business etc).
They have decided to develop an online library management system.
The Business Analyst has suggested the following minimum requirements for the online
library management system:
1.1
1. Home page (company information and sign in links for the admin and members)
1. Admin can sign in
2. Admin can add new members
3. Admin can edit/update members details
4. Admin can add new books/CDs details
5. Admin can edit/update books/CDs details
6. Admin can issue a book
7. Admin can receive a book
8. Admin can view all book
9. Admin can view all members
1. Member can sign in
2. Member can search a book(s)
3. Member can reserve a book
You have been sub-contracted by Sydenham Library as a Junior Database Developer to
design and implement a prototype of the web-based database system for the Sydenham
Library. On completion of the system, you are required to provide a full set of
documentation of the system to Sydenham Library
Your prototype of the system will be developed using OracleSQL Developer and ASP.NET
using C#.
2M
arks are awarded for producing a working and properly documented system that meets the
requirements as specified below:
2.1
A list of sections/subsections of the document, including page numbers.
2.2
Produce a set of fully normalised tables for the system:
⦁ Show clearly all the steps of normalisation, up to the 3rd normal form.
2.3
UseSQL Modeler to produce an Entity Relationship Diagram. The final Entity Relationship
Diagram should be consistent with the outcome of your normalisation.
2.4
UseSQL Developer to produce a list of attributes for each entity. Submit a printout copy of
these lists.
2.5
⦁ Use SQL Developer to convert the Entity Relationship Diagram into a set of
database tables. Provide a printout of the DDL script for generating the tables
(relevant ‘CREATE statements only).
⦁ Use SQL Developer to populate these tables with suitable data values (using
‘INSERT’ statements).
⦁ Provide a printout of contents for all the tables (using ‘SELECT’ statements).
2.6
Implementation of a web-based database application, which includes the following using
ASP.NET using C#:
⦁ Home page (company information and sign in links for admin and members)
⦁ Admin can sign in
⦁ Admin can add new members
⦁ Admin can edit/update members details
⦁ Admin can add new books/CDs details
⦁ Admin can edit/update books/CDs details
⦁ Admin can issue a book
⦁ Admin can receive a book
⦁ Admin can view all book
⦁ Admin can view all members
⦁ Member can sign in
⦁ Member can search a book(s)
⦁ Member can reserve a book
2.7
⦁ Provide a set of screen dumps for all the functionalities [2.1-2.6] you have produced.
⦁ Provide a copy of the initial data (table contents) in your system.
⦁ For each requirement, list the individual tests that have been carried out together
with their results.
URL address for the uploaded website (connected with the Oracle database)
⦁ 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.
2.8
Your discussion should summarise your experience in undertaking this coursework.
3
⦁ Normalisation
⦁ INF Rule [
⦁ 2NF Rule
⦁ 3NF Rule
⦁ ER diagram, consistent with normalisation outcome [
⦁ Data dictionary (print-out of attribute list for each table) [
⦁ UseSQL Developer Data Modeler to convert Entity Relationship Diagram into DB
tables [
⦁ Input data into DB tables (INSERT) [
⦁ Display data in the tables (SELECT) [
⦁ Home page (company information and sign in links for admin and members) [
⦁ Admin can sign in
⦁ Admin can add/ edit/update members [
⦁ Admin can add/ edit/update books/CDs details
⦁ Admin can issue/ receive a book
⦁ Admin can view all books/members [
⦁ Member can sign in [
⦁ Member can search a book(s) [
⦁ Member can reserve a book
⦁ Testing [
⦁ Discussion of own experience [