The Zoo Management System - entity relationship diagram & MS Access Database

Zoo Management System - Project Details:

You are the employee of a big, worldwide working Zoo Management Company. Your company is responsible for the Zoo management. Your boss thinks it would be a great idea to store all data for each Zoo in a brand new self-developed ZOO Management System. Up to now, the ZOO management company has maps of each ZOO available. Your boss knows that you took a course in introduction on an ERP system, so he asks you if you could help designing such a system. Each ZOO must have the same organizational structure, which should look like this:

Each Zoo has a Zoo-Address. Each Zoo has many visitors (Visitor Ticket Process (VTP). Many Zoo-Attractions belong to a Zoo.

Module 1: Entity Relationship Diagram

Design a ER (entity-relationship) diagram for your ZOO Management System. Use the information provided below with the entities and its attributes. Put the entities in the correct relationship to each other (organizational structure).

Module 2: DB Implementation with MS ACCESS

Once the ER diagram is created and contains no mistakes, you have to create the MS ACCESS database. Start with the first two steps:

1. Create/define data dictionary/tables with table structures for all entities/attributes of each entity of the previous step into MS ACCESS tables.
2. Put the entities/attributes of each entity in the correct relationship to each other. Your employees must be able to create, edit and delete data with the Zoo Management System by using a user interface. This user interface in MS ACCESS has to be designed with forms.
3. Implement the Zoo Master Data Process: Create forms for your employees to create, edit and delete data in the MS ACCESS database for the following entities/attributes of each entity: Zoo-Address, Zoo-Attraction, Zoo-Attraction-Employee, Zoo- Attraction –Address and Zoo-Area-Animal.
4. Implement the Visitor Ticket Process (VTP): Each visitor buys a ticket for the Zoo. If visitors arrive at the cash point of the Zoo, the employee has to type in information about the visitor. All the employees of the Zoo’s must have the possibility to create the visitor master data records in the MS Access based database. Create forms for your employees to create, edit and delete datasets in the MS ACCESS database for the following entity/attributes of the entity: Zoo-VTP.
5. Implement the Animal Feed Process (AFP): As you know, there are many Animals in each Zoo. For each Zoo-Area-Animal all feed data has to be stored in the MS Access based database. Create forms for your employees to create, edit and delete datasets in the MS ACCESS database for the following entity/attributes of the entity: Zoo-ATP. Furthermore, your boss wants you to create some reports for the reporting. Implement the queries assigned for your team below:
6. Design the user interface/create forms and/or design the required reports with MS ACCESS. Create a form with your search criteria, create a query based on your search criteria, create a report based on your query.

Module 3: Reports and queries

• Find all Zoo-Addresses for one specific country (to be selected).
• Create a report with Firstname and Lastname of all visitors with a specific birthdate.
• Create a report with all Zoo-VTP Master Data for a specific Country (to be typed in).
• Find the quantity of all tickets bought in a specific country (to be typed in).
• Find all Zoo-Addresses for one specific ZIP code (to be typed in).
• Create a report with the turnover of each Zoo.
• Create a report with all available Zoo-Attractions with a specific Zoo- AttractionID (to be selected).
• Find all visitors with more than xx specific visits (for example more than xx=10 visits to be typed in).
• Find all Zoo-Area-Animal for one specific Name (to be typed in).
• Create a report with all available master data for one specific ZooID (to be typed in).
• Create a report with all available Zoo-Attractions of a specific Type of Animal (to be typed in).
• Find all animals for a quantity of food higher than xxx kg(for example higher than xxx=123 kg to be typed in).
• Find all Zoo-Attraction-Employee for a specific Type of Employee (to be selected).
• Create a report with all Zoo-Area-Animals feed more than 200kg.
• Create a report with all feed food for a specific Type of Food (to be typed in).
• Find all types of food feed on a specific date (to be typed in).
• Find all Zoo-Addresses for one specific ZIP code (to be typed in).
• Create a report with the sum of all feed food for the animals for one specific ZooID.
• Create a report with all available Zoo-Attractions with a specific Zoo- AttractionID (to be selected).
• Find all animals without feeding a specific month.
• Find all Zoo-Addresses for one specific country (to be typed in).
• Create a report with the total of feed food in kg for each Zoo-Area-Animal.
• Create a report with all available Zoo-Attractions with a specific Zoo- AttractionID (to be selected).
• Find all visitors with more than xx specific visits (for example more than xx=10 visits to be typed in).
• Find all Zoo-Attraction-Employee for a specific Type of Employee (to be selected).
• Create a report with all Zoo-Area-Animals feed more than 200kg.
• Find all Zoo-Area-Animal for one specific Name (to be typed in).
• Create a report with all available master data for one specific ZooID (to be typed in).

Get Project Solution by contacting us

- via WhatsApp: +92-324-7042178

- via email: codelogixstudio@gmail.com