Skip to main content

ERD of Park Inventory System with Visio file free download

Image
By

Basic Requirements


The company has 8 parks.

Each park has inventory that needs to record. These include workshop, storages, reception area, manager’s residence, cabin types, main structure. The main structure will include inventory for areas such as pool, the number of cabins, camp kitchen, laundry room and recreational room. Each park has different cabin types and each cabin has different rooms within the cabin that inventory needs to be an encounter for the e.g. kitchen, bedroom, lounge area, bathroom. The rooms would consist of furniture, white goods, towels, linens and curtains that need to record in detail include maker, serial number, colour, date of purchase and other suitable attributes. Managers residences would have a lounge area, main bedroom, second bedroom, spare room, kitchen and bathroom/laundry room take inventory needs to be accounted for. Inventory from one cabin can be moved into another cabin.
Inventory can also be moved from one park to another park at the owner’s discretion. This will need to be approved by the owners. Inventory can be written off by the managers, however, comments section need to fulfilled and the park owners need to be aware when inventory is written off presumably via email and approving the written off goods. The workshop would consist of goods such as a lawnmower, drill and other hardware products. Written off table need to include the attribute such as; where the goods were original, cost, date of purchase, reason, the total cost of goods written off and any other applicable attributes.

The requirement:


Inventory is up to date at all time
The inventory records should include the person credentials and time and date stamp
When a report is generated it should be providing a detail report for the whole park. Individual reports can also be generated room by room if required. Any product that needs to be written off must be approved. Ideally the owners would like an email sent to them with an explanation as why the goods are written off. They can accept it or decline it. When inventory is moved from one park to another park the system needs to send an email to the owners and also automatically update the inventory level for both parks. Once the ERD is completed, will create the database on SQL application and the forms will be via web pages are the parks are located countryside.

EDR Diagram


Download Visio and PDF files


Download Now!





CONTACT DETAILS

For any other questions or other tasks please feel free to contact me
via email: mhassnainjamil@gmail.com
via WhatsApp: +92-324-7042178
via skype: hassnainjamil1
Labels:

Comments

Post a Comment

Popular posts from this blog

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

By
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 Implem...
1 comment
Read more

Human Physiology by Stuart Ira Fox [PDF] (12th edition) free download

By
21 comments
Read more

Sudoku Game Project in Java with full source code including GUI task

By
Introduction The purpose of the project is to try in practice the use of recursion and object-oriented program design. Please make sure to read this entire note before starting your work. Pay close attention to the sections on deadlines, deliverables, and exam rules. The problem Your task in this part of the project is to write a solver for Sudoku puzzles. Sudoku puzzles are a kind of crossword puzzles with numbers where the following two conditions have to be met: In each row or column, the nine numbers have to be from the set [1,2,3,4,5,6,7,8,9] and they must all be different.  For each of the nine non-overlapping 3x3 blocks, the nine numbers have to be from the set [1,2,3,4,5,6,7,8,9] and they ust all be different. The following two figures show a Sudoku puzzle and its solution. The input The input of your program, the Sudoku puzzles, is given in text files. More specifically, they are represented as nine lines of nine characters separated by spaces. The characters can be of two...
Post a Comment
Read more