Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*CAN I PLEASE HAVE THE JAVA CODE FOR THIS DATABASE TO BE CREATED* SQL AND JAVA Project Description: A new company, Plants R Us, has

*CAN I PLEASE HAVE THE JAVA CODE FOR THIS DATABASE TO BE CREATED* SQL AND JAVA

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.

SQL AND JAVA

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

The Manga Guide To Databases

Authors: Mana Takahashi, Shoko Azuma, Co Ltd Trend

1st Edition

1593271905, 978-1593271909

More Books

Students also viewed these Databases questions