Is160
Pawnshop Design

Understanding of how the pawnshop would operate.

We store with the people who interact with our business, which can be customers or employees. People will have their own ID upon making a transaction or being employed in the pawnshop. (CID,EID) This will be contained the people table. People will include information used for employees and customers. Fields such as, name, phone number, hire date, wage, end date, drivers license number, date of birth. We would require and address on a separate table. This will ensure customers will not have the same address as another, preventing fraud/illegal transaction.
Employees will be able to check their work schedule with a paper copy of the schedule. The paper copy can be edited and adjusted, at the end of the week an accurate schedule will be entered into the database, updating the information first printed.
In our pawnshop, customers will come into our store, maybe browse our items, and then consult an employee. The customer will have the option to sell, purchase or pawn an item. One of these actions will result in a change in our inventory. The employee will enter the customer’s data into the database, then the data of the transaction.
If a customer sells an item, a value will be perceived in which we are willing to pay. When the customer agrees to the deal, the employee will collect personal information, and then he will collect data about the item. The data he will enter in the purchase table will include, item ID, CID, purchase price, purchase data, and the actual value. Also he will make an entry into the inventory table. The data he will collect will include, item ID, quality, color, the type of transaction, (pawn, we bought, we sold), our cost, and our selling price.
If a customer buys an item, they will agree on a price most likely different from what is listed. When the customer agrees to the deal, the employee will collect personal information and enter it into the database, if it is a new customer. The employee would then make an entry into our sold items table. The data collected will include, item ID, date of transaction, selling price, and CID.
If a customer wants to pawn an item, they bring it to an employee and it will be evaluated. Then a value of the item will be assessed. When the customer agrees on the value, the employee will collect personal data if they are a new customer. Then in the pawn item table, he will enter the customer ID, item ID, loan ID, and the value agreed. The employee will also enter data in the loan table. He will enter the LID,CID,IID, agreed value, date in, date out, full payment due date, and the remaining balance. The customer can come in at any time and find out what the remaining balance on an item is and make payments if necessary. The final entry will be the item entering the inventory, which will include all of the inventory data when we purchase an item. When it is picked up and all payments made, the items type will be changed under inventory.

The type of inventory plays a big part of our organization since all types of transactions are recorded in one inventory table. The types of inventory can be, pawn, we bought, sellable, repair, holding and police recovered. When we send an item out to be repaired, the type of inventory will be changed to repair in the database to keep track of which items are out on repair. Holding inventory must occur when we purchase or pawn an item. The item must go through police record to make sure it is not stolen. This grace period, where we cannot do anything with the item, last 30 days. When the item has reached its 30 days or has been cleared, it will return to sellable. If the item is stolen and the police recover the item, the item will go into the police recovered type.