Afternoon Notes

Process--Organized-- out growing current system

Figure out the scope of the database:

The database will manage business transactions to make sure they are profitable. The Database will track inventory. The database will track point of sale. The database will track customers who are willing to enter data. (loyality awards). Manage requests. Manage purchases. Security. (Query or reports, profit and loss)

Gather information:

look at documents: spiral notebooks, receipts, Forms and Reports. Procedures and manuals.

Talk interview stakeholders

Job Shadowing: exceptions

Analysis: forming requirements:

Data requirements--what data has to be in the database

Reporting requirements--kinds of reports the database must produce

security requirements--Who has access to what

Inventory: Title, Year, genre, condition, rating, artist, purchase price, purchase date, Section (location), purchased from, Description, sellprice, Album version

Point of sale: employee, Date, time, album, customer (optional), discount, type of discount, taxpercent,

--don't store calculations

Customer: (frequency) name, email, phone, dateentered, birthday

Purchase: Date, Seller info, items purchased(title, condition) price paid for each

Requests: customer info, What album or artist, Condition, Year, album versions

Business Rules--

• Only vince can purchase albums
• If a customer purchase 5 albums they get a 15% discount on the next album
• Only vince can do overrides
• Customers are encouraged to register but not required
• Sellers are required to provide contact info
• Default sale price is 150% of purchase price.