Read the following scenario then solve the questions: The keepers in an animal park look after the feeding of the animals. Each animal is located in a different area of the park. Each area has its own keeper who reports to the head keeper. The head-keeper maintains a record of the sorts of food that each animal species or type in the park should be fed, and in what quantities. There is no distinction made between different animals of the same species. The keepers access the information so they know what to feed each animal type. Each animal type may be given more than one type of food, and each type of food may be fed to a number of animal types. Each day the keepers will take out the food needed for the animals in their care and record this on the information system. These food types can be perishable or non-perishable according to their shelf life. For example, fresh fruit and vegetables would be perishable where tinned produce or cereals would be considered to be non-perishable. The office staff keeps a track of the food supplies. They monitor which foods are running low every two or three days and draw up a list of that which needs to be ordered. In order to help them, the information systems contain details about re-order quantities and re-order levels. Sometimes they may need to readjust their re-order levels. A number of suppliers are used, and their names, addresses and telephone numbers are kept in the system. Because of the large quantities required and the difficulty of obtaining some foods at certain times of the year, there is more than one possible supplier for each type of food. Most of the ordering is done via the telephone. A standard order form is then created. The order form usually contains details of more than one food type to be ordered from a particular supplier. The order also contains details of the date of the order and what quantities are required for each food type. When deliveries are received, the keepers check the delivery note against the goods received, amend it if necessary and pass it on to the office. Here it is checked against the orders placed. It they agree, this is recorded in the system. The office staffs check the received orders against an invoice sent by the supplier. If they agree, payment is be made. Any discrepancies are taken up with the supplier, and the supplier's response is noted in the system. Most suppliers send an invoice each month.   a. Identify the external entities, processes, and data stores  b. Draw level 0 DFD (child level)

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Read the following scenario then solve the questions:

The keepers in an animal park look after the feeding of the animals. Each animal is located in a different
area of the park. Each area has its own keeper who reports to the head keeper.
The head-keeper maintains a record of the sorts of food that each animal species or type in the park should
be fed, and in what quantities. There is no distinction made between different animals of the same species.
The keepers access the information so they know what to feed each animal type. Each animal type may be
given more than one type of food, and each type of food may be fed to a number of animal types. Each
day the keepers will take out the food needed for the animals in their care and record this on the
information system. These food types can be perishable or non-perishable according to their shelf life. For
example, fresh fruit and vegetables would be perishable where tinned produce or cereals would be
considered to be non-perishable.
The office staff keeps a track of the food supplies. They monitor which foods are running low every two
or three days and draw up a list of that which needs to be ordered. In order to help them, the information
systems contain details about re-order quantities and re-order levels. Sometimes they may need to readjust
their re-order levels.
A number of suppliers are used, and their names, addresses and telephone numbers are kept in the system.
Because of the large quantities required and the difficulty of obtaining some foods at certain times of the
year, there is more than one possible supplier for each type of food. Most of the ordering is done via the
telephone. A standard order form is then created. The order form usually contains details of more than one
food type to be ordered from a particular supplier. The order also contains details of the date of the order
and what quantities are required for each food type.
When deliveries are received, the keepers check the delivery note against the goods received, amend it if
necessary and pass it on to the office. Here it is checked against the orders placed. It they agree, this is
recorded in the system. The office staffs check the received orders against an invoice sent by the supplier.
If they agree, payment is be made. Any discrepancies are taken up with the supplier, and the supplier's
response is noted in the system. Most suppliers send an invoice each month.

 

a. Identify the external entities, processes, and data stores 
b. Draw level 0 DFD (child level)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Data Modeling Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education