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.

• 1495078239-CSC316_SLP_Module 1.docx

SuperTutor

(15)

Status NEW Posted 18 May 2017 03:05 AM My Price 9.00

-----------

Attachments

file 1495078242-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer