COMP1821 Coursework Specification
This is a group coursework.
A Group consists of 4 to 6 students. You can only form groups from students within your
tutorial group. You are expected to submit 1 output via the Moodle submission link.
Each member of the group should upload one single PDF file with the group report .
Please include in the appendix a short personal discussion regarding your role and
contribution within the group.
Case study: “All About Toys” LTD
AllaboutToys LTD (AAT) is a company located in London. It has a reputation for selling high quality products, including “Dolls”, “Mechanical”, “Soft” toys, etc. The toys are made from
clay, plastic, fabric or metal and they are purchased from different suppliers around the world.
The company sells products through its own stores (10 of them around the country). The
company is controlled by the Board of Directors.
Currently AAT has the following processing systems:
• Purchasing System – this system tracks buying of various toys. Every toy has a name,
belongs to a category and a manufacturer. A toy has a unique identifier, weight, and a
shipping charge. The supplier details are stored as well.
• Point of Sale system – manages the cash registers at each of the company retail stores.
This system tracts the inventory at each store.
With most parents spoiling their children lately, AAT has experienced rapid growth in the past
5 years, with orders increasing over 300%. Having said this though, the economic climate has
changed and now AAT is facing tough competition in a number of its product areas. In order
to keep up with big competitors (such as Amazon and Ebay) the Board of Directors are,
therefore, now thinking to expand their services by allowing customers to buy toys online as
well as offer support to those who browse their online catalogue but prefer the traditional
way of placing orders in person, or to those who would just like to submit queries on different
toys from home and at any time.
The Board of Directors believe that by expanding their services and providing other options
for customers to buy online will enable them to attract new customers and increase market
share. They also feel that by allowing customers to share/write their honest views about a toy
and their experience at the AAT online, will have a positive impact on their reputation.
Therefore, the new system shall support Customers to search/browse for products, read
descriptions and reviews, write reviews and also order products online using conventional
electronic “shopping basket” and “check out” functionality.
All online payments will be by credit card. The checking of credit card details will be done by
the company’s bank, through a link to a system known as VISACheck. The VISACheck system
acts as an interface between the company and their bank’s credit check services.
Customers will have the option to choose from several different shipping methods and rates
based on a formula related to the urgency of an order or collect their products from one of
the company’s stores, using their credit card. When processing a payment, the system will
produce a receipt showing a breakdown of the total payment.
The system should also be able to capture the sales, to determine stock levels and statistical
information about customer preferences. An extra functionality to be implemented,
therefore, is that of customers getting suggestions for new products they may be interested
in and special offers on selected items. This list is generated based on matching categories of
products searched, or placed in the customer’s shopping basket, in a session with an updated
list of new products. Two to three new products from the category matching the customer’s
behaviour should be presented to the customer in a separate window. If customers would
like to use their special offer, they should enter the special offer code when they place an
order in their next visit.
Sales staff on their end will have to read and respond to customer’s queries and deal with
enquiries about previous orders, log returns, etc. They will also handle any online orders that
are flagged with problems during the otherwise automatic online ordering and shipping
request process. Some of their actions include creating customer accounts, confirming
product’s details, and placing an order on behalf of a customer.
The president of the company, Mr Jacob and the vice president of the Selling Department, Mr
Cooper, fully support the decision of the Board of Directors. They indeed believe that having
such an automated online system will save them time and money as the Sales staff at the
counters will be able to serve more customers.
However, the Sales staff, who are under the supervision of Mr Brown (vice president of the
Purchasing Department) are not particularly keen on the development of the online
computerised system. Most of them have been working in the stores for years and therefore
they prefer sticking to their old way of working, having to deal with people, rather than having
to deal with computers. They are reluctant to go through training and they do not see the
value of an online system selling toys. They are also quite disappointed with the Board of
Directors for proposing this and are afraid that someday they might close down the shops.
Mr Jacob and Mr Cooper still believe this will speed up work. Their vision is to attract more
customers and they believe that this new system can help them with that. They are thinking
to provide customers with cheaper options of purchasing toys such as weekend special offers
(10% discount) or BOGOF (Buy one get one free) for limited edition toys, an idea presented
to the Board of Directors and approved.
They want the system to be able to produce monthly sales reports as well as to collect
information regarding customers’ pattern of web searching and orders, number of toys
ordered in the last year, etc. to support active marketing. They also feel that this information
will help them expand their services by selling other children products such as books and
clothing, something they believe is one of the keys to increase sales. The Board of Directors
are very excited about the new opportunities the system will provide. Mr Brown, however, is
not happy with their approach. He feels they need to concentrate on retaining their existing
customers and just do what they do best, sell toys. The Sales staff also believe that expanding
to other products might risk their reputation of providing high quality toys.
Mr Jacob approached your company to help develop their proposed system. They are open
to suggestions regarding their advertising strategy and extra functionalities their new online
system should support. For an initial phase, as consultants you will need to produce the
analysis and design of their new online system.
- Within your group you need to discuss the 5 Ps relevant to the given case study.
- Produce a preliminary design using traditional, structured methodologies, covering
the full functionality of the proposed new system. The design should include:
• Entity Relationship Diagram which represents the Conceptual Data Model of the
scenario described in the coursework spec as modified by elicitation discussions
with the client. You are required to distinctly show all entity types, attributes
(including primary key attributes) and relationships, as well as determine the
structural constrains (cardinality and participation constrains) of each relationship
• Data Flow Diagram which represents the Process Model of the same specific
functional area that you modelled for the Entity Relationship Diagram. You are
required to include the DFD level 0 (context diagram)
- Implement a database based on the design produced as per above requirement. The
prototype database is to be built using any competent technology/tools you are
familiar with. MS Access is fine for a prototype
Once you built the database, it should provide enough functionality to be able to run
the following SQL queries.
• Add a toy to the system (you should indicate its category– mechanical, etc).
• Delete a Toy
• List all toys for a particular category
• Create a sale for one or many toys (with a time and date stamp)
• Check how many toys of one type are in stock.
• Check all the sales for a particular Customer
- Create the propose system design using object-oriented methodologies, to allow for
more flexible design/build iterations and re-use of design and code. The design should
• Use Case Analysis – A UML Use Case diagram identifying all actors and their
• Interaction Diagrams. Using UML sequence (interaction) diagrams perform
an analysis of three main Use Case scenarios.
• Design UML Class Diagram – Show all attributes, methods, and associations
for all main classes.
Deliverables (due by the submission date)
1) A final report which should include:
a) A discussion regarding the 5 Ps relevant to the given case study (1500 words).
Within your discussion include:
i) Problem: a short description and rich picture
ii) Process: Describe and compare 2 software process models and explain the merits
and constraints of the various approaches for the given case study. Further
elaborate on your software lifecycle and the activities associated with each phase
iii) Project: state the goal of the system, a list of resources, and a breakdown of the
budget (providing the framework within which management can be exercised).
iv) Product: State the artefacts that are created during the life of the project, such as
models , source code, executables, and documentation.
v) People: describe the prime movers in the software project.
b) A list of functional and non-functional requirements;
c) Structured design, including:
i) Entity Relationship Diagram which represents the Conceptual Data Model of the
scenario described in the coursework specification
ii) Data Flow Diagram. You are required to include the DFD level 0 (context diagram)
iii) screenshots of the prototype database, including screenshots of the results for
the SQL queries created for the Part 1 of the requirements
d) The UML design, including:
i) Use Case Analysis – A UML Use Case diagram identifying all actors and their Use
ii) Interaction Diagrams. Using UML sequence (interaction) diagrams perform an
analysis of the main Use Case scenarios.
iii) Design UML Class Diagram – Show all attributes, methods and associations for all
e) Identify where you used GRASP patterns in your design, with examples.
f) Completed copies of the Self-Assessment form found included in the coursework
g) A completed copy of the work breakdown form on the last page of this document. As
a group you will fill in and attach to the report a pro-forma (from the end of this
document) that will enumerate all the tasks that your group tackled and completed as
part of this coursework, and the involvement of each member of the group in each
task. This will be used in part to establish the individual contribution of each member
of the group. The pro-forma must be agreed and signed by all members of the group.
h) An appendix with
i) Any additional functionalities extracted from the discussion with the client or you
proposed (subject to the client’s agreement)
ii) a short personal discussion regarding your role and contribution within the
2) System prototype demontration.
As part of the software development cycle an acceptance testing will need to be
carried out. For the acceptance testing your group needs to demonstrate to the client
(in this case your tutor) the design and the prototype database you have built.