Classroom Notes Morning

Process: Identifying the need

--lot of transaction, secure, better track of transactions--track inventory, point of sale autonomize

Setup statement of scope

The database will track inventory, and manage point of sale, track purchasing, expenses, manage profitability. The database will track customers and sellers. track requests.

Talking to primary stakeholders

2. Gathering information

Documents Notebooks used to track sales. receipts, pricing guides, purchasing Forms and Reports Manuals, procedures,

Talk stakeholders: Vince, employees, possibly customers.

Job shadowing: exceptions

3. useful and not : Requirements

inventory : accurate, updatable, album name, price purchased, purchase date every album will as unique, conditions, press date, labels, album year, artist where purchased, genres, store location, trends--queries, reports

Point of sale: customer, method(type of payment), saleprice, discount, kind of discount, saledate, vinyl, time, gross profit/ net (generally don't store calculated fields), employee, number of items

Customer : name, contact (email), zip, phone, date entered (discount for x number of purchases)

Sellers: name, contact (email), zip, phone, date entered, id

Requests: customer, album requested, date, artist, condition, date pressed, Notes<.p>

Business Rules--

• Default sale price is 150% of the purchase price
• Vince can always give discounts
• Only Vince can purchase
• Employees can only discount with Vince's permission
• Customers are encouraged to register but not required
• A registered customer who makes 5 purchases gets a disount on the 6th
• Customers must be registered to get discounts
• A customer must register to make a request
• Sellers must register