Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*I WOULD LOVE THIS TO BE DONE AT A MODERATE LEVEL LIKE FOR A FRESHMEN COLLEGE KID TO UNDERSTAND* Project Description: A new company, Plants

*I WOULD LOVE THIS TO BE DONE AT A MODERATE LEVEL LIKE FOR A FRESHMEN COLLEGE KID TO UNDERSTAND*

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.

CAN YOU PLEASE DRAW THIS AT A MODERATE LEVEL AND NOT PROFESSIONALLY. ALSO CAN YOU INCLUDE THE JAVA CODE PART.

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

Database Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

More Books

Students also viewed these Databases questions

Question

Define training and development.

Answered: 1 week ago

Question

=+3 In what ways can an MNE improve or change its approach to IHRM?

Answered: 1 week ago