Question
Project Description: A new company, Plants R Us, has hired you to create a database system. They need a new system to help them properly
Project Description: A new company, Plants R Us, has hired you to create a database system. They need a new system to help them properly manage their inventory, human resources, and retail sales. Your job is to implement a Database that meets your clients needs. Your work will have two deliverables: E-R Diagram of the Database Design, and and Implementation according to your proposed design.
Inventory System Component: This system is responsible for the following: Keeping the inventory items up to date (both in terms of purchases of items by clients and shipments of new items to be stocked and restocked) Noting those items that need reordered Deleting Items from the Inventory
Human Resources: This system is responsible for the following: Keeping track of employee information (salaries, positions, etc...) Allow for Hiring and Firing of Employees Displaying a Monthly Payroll report for the client
Retail Sales: This system is responsible for the following: Keeping Track of each sale Finding the total price for a collection of inventory items
On top of this Database you will be creating a simple interactive application (command line, or GUI if desired) that will allow company management to manage the system.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started