Please Read the text (Quindalup Border Collies) and answer the Questions 1a from the text (Quindalup Border Collies) by using the example of the level 0 data flow diagram which is given below. So, try set it out in a symmetrical way where: External entities are on the left, Processes in the middle And data stores on the right.
Based on the scenario: the question you need to answer for the text (Quindalup Border Collies) is:
1(a) Create a Level 0 Data Flow Diagram for Sally's business, Quindalup Border Collies.
Example of the level 0 data flow diagram:
Text: Quindalup Border Collies is given below
people or organisation outside of the system (known as external entities). Context diagrams show the external entities (in rectangles), the system (in a circle) and the flows of data (lines with arrow indicated direction of data flow). The context diagram allows us to understand the part of the system we have control over. We look further into the system when we look at the level O DFD (explained below). We can control aspects within the system but have no control over the external entities that interact with our system. Example: Fred's Seafood has decided to implement a new digital online ordering system. It will allow their customers easy access to their products as well as provide automation for their deliveries and seafood ordering processes 1. Customers go to Fred's Seafood website and provide their login details to access the website. These details are checked against existing customers from the Customer database. If their login is successful, they can proceed on to order their seafood. 2. Customers then browse through the selection of seafood and place an order using the website. The system generates an invoice which is then displayed to the customer on the screen. A copy of the order is saved into the Order database. 3. The customer provides payment for the order using their credit card and the system sends a receipt of payment to the customer via email. order database is updated with the customer payment details 4. Fred's Seafood kitchen staff read a screen showing the current order. They prepare the order as requested. Once completed they verbally inform the waitstaff the food is ready to be delivered. 5. Fred's Seafood use an external delivery driver to get the food to the customer. When the driver arrives, staff hand them a delivery list with the order details including the address of the customer retrieved from the customer database. The delivery driver emails Fred's Seafood once the delivery has been completed. Fred's Seafood staff then send an email through to the customer confirming that the order has been delivered. The order database is updated with the delivery confirmation details and the stock levels are updated in the stock level database. 6. At the end of each day, the manager of Fred's Seafood checks the stock levels from the stock level database and places an order for any seafood required. The manager sends the seafood order through to their supplier and saves a copy of the seafood stock order in the Stock Order database. 7. Each month the seafood supplier sends an invoice to Fred's Seafood detailing the orders for the month. Fred's Seafood checks the invoice against the orders it has on record in the Stock Order database and, if correct, sends through payment to the supplier. Version 1.3 January 2021) 3 2021 This document may be distributed freely to staff and students, but the content should not be used or reproduced in any other form without permission. This copyright statement must remain intact. Please email any errors or suggestions for improvement to education@ontask.net.au Conditions Due Wednesday 10th March 2021 Total Marks: 64 marks Scenario: Quindalup Border Collies Sally Mathieson is a respected breeder of Border Collie dogs at her rural property in Quindalup, WA. She house-raises puppies as non-working family dogs and sells them to keen dog owners all across Australia. Sally also exhibits her dogs at various town shows, including the Perth Royal Show, where they have won many awards. Sally currently uses three simple, unconnected database systems to keep track of her business. The Personnel database contains details of all owners and potential owners. The Dogs database contains details of all dogs bought and sold by the business. For each dog, Sally must record its name, sex (M or F), microchip number, registration, whether it is (or going to be) a breeding dog (Y or N), mates, progeny (offspring), purchase price, veterinary care history, parent names, vaccination history, personality and colour. Quindalup Border Collies come in one of three colour combinations: black & white (BW), merle (ME) or chocolate & white (CW). Currently, it is puppy season and there are two main breeding pairs on the property - Sam (M; BW) & Queenie (F, ME); and Mason (M; CW) & Sapphire (F; CW). Sam and Queenie have produced two litters of five puppies (1M; 4F) (3M; 2F) each this season. Mason and Sapphire have produced one litter of seven (3F; 4M) puppies this season. All puppies, except for one female from Mason and Sapphire's litter, are for sale. Sally records key information for each puppy as above in the Dogs database. When a potential owner wishes to purchase a Border Collie puppy, their basic details are recorded by an online form into the Personnel database - this includes their name, address and contact details. The date is also recorded. Only one record can be made per person in this database. Sally contacts all potential owners and decides whether they would make a good Border Collie owner. She also inspects their yards where possible. When a puppy has been confirmed as going to a new home, the purchaser is now the owner. A record is made in the Financial database with the new owner's details as specified in the Personnel database. This has to be added manually. The base cost is $500, and Sally adds the cost of any veterinary visits. She also records if the puppy has received medical attention, a microchip and vaccinations for Canine Parvovirus, Hepatitis, Kennel Cough and Distemper. Puppies cannot go to a new home before they are 12 weeks old. 12ATCSC_Assessment Task 2 P SDLC T Goodwin 2021 Quindalup Border Collies has a home office on their property, with a server on which the database systems are stored. The office is unlocked most of the day. There is a workstation in the 'puppy room' which is eight years old and connected to the server via a bus network and coaxial cables. The system is critical at the moment for keeping records of the new puppies. The operating system used is Windows XP Sally would like to replace the current three database systems (Personnel, Dogs and Financial) with one integrated system. It is planned that the new system will perform all the same tasks as the current systems, with some improvements (for example, being able to track each dog's Show awards and breeding lines would help with pedigree registration). Image: http://www.bordercollies.com.au/) Questions 1. Based on the scenario: (a) Create a Level 0 Data Flow Diagram for Sally's business, Quindalup Border Collies. (22 marks) Questions 1. Based on the scenario: (a) Create a Level 0 Data Flow Diagram for Sally's business, Quindalup Border Collies. (22 marks)
