– show application value for implementing data security measures
– produce normalised data structures and dataflow diagrams representing a system solution to address business needs.
Tasks, Deliverables and Marking Scheme
You are required to produce part of an investigation, analysis and data design of a system for Silent Cyclesas described in the attached casestudy. The new system must enable Silent Cycles to manage members/clients, staff, products, sales, service schedules, competitions, training events…
Your investigation and design will be in the form of a report.
You should focus on the best methods to gather all the relevant requirements for such a data management system, the mapping of the relevant data and data flows needed to support the system.
Your Report should include the following sections:
1. An explanation of the variety of requirements gathering techniques you will use, to gain a more precise and detailed set of requirements for Silent Cycles. Also discuss the challenges, using these techniques will present to both the business and its staff. You should also explain your approach to this part of the report and how it will minimise disruption to day-to-day business at Silent Cycles.
2. A brief description of specific Database security issues a new database for Silent Cycles may encounter; followed by describing examples of countermeasures and how you would implement these measures to secure the data. Use examples based on the Silent Cycles’ data.
3. Produce a Context Level Diagram to show the scope/size for the Silent Cycle system. Choose any of the main processes to produce one level 1 diagram, showing the flow of the data eg. Order stock, Customer sale, schedule service, register club member…..
4a. Part of your analysis and design requires from you to use the technique of Normalisation to define data tables, from source documents provided by Silent Cycles. In the report, demonstrate step-by-step how you would Normalise the data from CLIENT INVOICE (one of thesource documents, included in Case study) into a set of 3rd NF Tables.
o First write down the Un-normalised Relation (UF) for CLIENT INVOICE
o Make assumptions regarding extra attributes, best key and derived attributes,
o Show all the steps to normalise the relation (1NF, 2NF and finally 3NF)
o NOTE: See dependency rules given with Client Invoice document.
4b. You have used the Bottom-Up technique (Normalisation) for designing the data tables based on a given source document (Client Invoice).
Discuss, by comparing advantages and disadvantages, why you are using this technique for database design as opposed to the traditional Top-Down (ERD) technique.
5. Acriticaldiscussion on the benefits that this database system solution will bring to Silent Cycles. This should consider all Database management system advantages, applicable to Silent Cycles. Support yourdiscussion with relevant examples.
Silent Cycles has 5 branches, located in the South and South West of England. Currently, they do make use of a limited database to support daily administrative procedures. Communication and data sharing between the branches is becoming an ever-growing challenge. Silent Cycles also recently started an exciting new SC Cycle club, affiliated to the different branches.
Theyhave expressed an urgent need for a group of expert analysts to develop an updated system for them to manage administration, stock, sales, club members, service scheduling, competitions, promotions etc….The ideal would be a centralised database to support both operational as well as club data, to be accessed via a website.
YOU ARE PART OF THE DATABASE DESIGN TEAM to help solve Silent Cycles’ problems.
Greg, the General Manager, described Silent Cycles as follows:
“We have a passion for Cycling and fitness”. Our branches offer a variety of bicycles and accessories to suit the need of any level of cyclist; from children to beginners to advanced or professional cyclist.
Currently, we handle in-branch or telephone orders and would ideally upgrade our market reach, via a website. Daily processes include; Customer sales, stock management, marketing, service scheduling, staff management….
We have launched the new SC Club. Silent Cycles needs to keep track of Club members, competitions, training schedules, cycle routes, races…..
We need a system to support the crucial daily operations as well as managing data to support the new SC Club operations.
The system should be able to handle pre-orders, re-funds, promotions, in-store sales and online sales. Customers need to register with the branch and would have the option to become a SC Club member, which will offer them extra benefits. Club members pay an annual fee, but would receive 20 % discount on race entries or training events.
The system should be able to keep track of stock levels, process stock return, stock orders etc.
One of the main priorities is customer service. Silent Cycles offers a variety of service options, ranging from pre-sale (getting the bicycle ready), after-sale (quarterly services), follow-up (should there be any technical or manufacturer faults) and second-hand servicing of used bicycles. These services need to be scheduled and monitored.
Greg believes in excellent customer satisfaction and makes sure that staff members embrace that. Each branch offers employment to 5-6 people, working on a rota. Some are part-time and some are full-time employees. Greg has a team of 3 people, supporting him with centralised management, including marketing and finance and legal issues. They rely on daily management reports (stock levels, invoice totals, supplier, deliveries…)
Silent Cycles rely on good and effective relationships with their suppliers. They need to track orders from suppliers, delivery schedules, manage supplier contracts, etc.
The new SC Club will allow Silent Cycles to register club members, organize competitions, and arrange for training events. They will offer information on local cycle routes, races and many more.
Example of a document that you will use during requirement gathering:
Silent Cycles: Southampton Branch
345 High Road
Client Number: 1001 Invoice Number: 405
Client Name: SamCooper Invoice Date: 02/01/2014
Client Address: 100 Points Staff Number: 210
Portsmouth PO155HK Staff Name: Martin Lawrence
Item Description Quantity Unit_price Discount Total
B100 Ladies 26inc Raleigh 1 850.00 85.00 765.00
ST-SP RX Helmet 1 32.00 3.20 28.80
CC-02 CC cycle glasses 2 18.00 36.00
Invoice Total 829.80
– Quantity sold depends on the item per invoice.
– Discount percentage will depend on the item bought as different discount promotions run at different periods.
– A Client gets a single invoice per sale.
– A staff member issues an invoice per sale.
– A branch keeps track of invoices issued
TO ORDER FOR THIS QUESTION OR A SIMILAR ONE, CLICK THE ORDER NOW BUTTON AND ON THE ORDER FORM, FILL ALL THE REQUIRED DETAILS THEN TRACE THE DISCOUNT CODE,
TYPE IT ON THE DISCOUNT BOX AND CLICK ON ‘USE CODE’ TO EFFECT YOUR DISCOUNT. THANK YOU