About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Applied Sciences,Calculus See all

Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all

Teaching Since:	Apr 2017
Last Sign in:	103 Weeks Ago, 3 Days Ago
Questions Answered:	4870
Tutorials Posted:	4863

Education

MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000

Experience

Professor
Devry University
Mar-2010 - Oct-2016

Category > Programming Posted 11 May 2017 My Price 9.00

Module 1 - SLPDATA, DATABASE

Need help from those who know Oracle and SQL.

MUST BE ORIGINAL WORK, NOT COPIED FROM OTHER WORK.

Module 1 - SLPDATA, DATABASE, DATABASE MANAGEMENT SYSTEM, ANDRELATIONAL DATABASE MODELINGThe SLP Project in CSC316 spans from Module 1 to Module 4. You are requiredto apply what you have learned in previous modules to the assignment in thecurrent module. That is, the Module 2 SLP is built on the Module 1 SLPassignment, and the Module 3 SLP is built on the Module 2 assignment, etc.Please follow the instructions below closely:Problem DefinitionA used-book store has been in business for over a month. The owners have beenso busy that they have not had time to design and implement a computer-basedsystem to track their operation. Their first priority is to develop a databasemanagement system to track inventory and sales information.You are hired to design, program, and implement the system. You will be workingon elements of this system in the rest of the SLP assignments in this course.The owners provide you with the following facts:The bookstore sells used and hard-to-find books and CDs. Sales are for cash/checkor credit card.The bookstore mainly caters to the needs of people living in the area.The bookstore maintains an inventory of books and CDs.Store sales are recorded at a Point-of-Sale (POS) terminal.When books are purchased by the store from individuals or organizations, the dataare entered into the system.The owners ask you to:Design a database to track inventory and sales information. The database shouldprovide the following information:1.Current inventory status of books and CDs2.Sales Transactions List3.Monthly Profit Report4.Inventory Status Query by Product5.Sales Transactions that each employee has processed6.Any other output you think appropriateThis is the relevant data for the first month of operation. The owners have savedthe information in an Excel file. You might want to take them into considerationwhen you design your database.

Attachments: