Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions