CD Warehouse Management...

Problem Description

The purpose of this project is to develop an interactive information system for a CD warehouse. This system will enable the company to create an online ordering system interface , between the company and its customers for everyday transactions.

The database that we will create has two kinds of end-users: customers and company employees. Customers have access to the company's website and should be able to open accounts, do searches for the album that they want to purchase, place orders, and check the current status of their account balances. While searching for an album customers may know as little as the title of a hit song from the album to the name of the bassist of the group. Therefore customers should be able to make searches by using one of the following: group name, album name, and song title. After finding the album that the customers want to buy, they can put it in their shopping cart, and at the end of the session they can place and order. At any time, the customers can check their order's status and their account balance.

The company's employees periodically check the database to identify the customers with positive balance and send the bill. They are also interested to know about customers' preferences. Then customers are informed about new releases according to their preferences. When an order is received, an employee checks the availability of the albums. If the albums are available, they are mailed to the customer right away, and the inventory level is updated. Customers are informed about the shipment date, and their balance is updated. If the albums are not available, the suppliers are contacted. The supplier with the lowest cost and closest distance to the warehouse is chosen. At the beginning of each month suppliers get a payment from the company. Products are shipped through UPS.