Database Notes

Process

How know you need a database?
The amount of data
Current methods no longer work

Talk to people who need the database

Not too technichal

Really general requirements

Vince's Vinyl used record store

Interview with management

Why do you need a database? What information do you need to keep?

How do want to enter data? How are you doing it now?

Inventory, Sales (discounts), Customer--requests, purchases, Employees, who purchased from

Who will use the database? Limits, Permissions

Statement Of Scope

information discovery

Forms --receipts sales and purchase, notebook, requests

Reports--reports- tax statements, monthly and yearly earnings

manuals, procedures

Job shadowing--you watch how people do the job. finding exceptions.

Interview stakeholders

Review--look at all the nouns

Inventory --quality (good fair poor mint) title, genre(s), artist(s), playtime, edition, print year, who purchased, (songs) quantity, purchasedate, purchaseprice, Suggest sale price, location, requested, availablity,

Customer Name, contact info, phonenumber email, purchase history, requests, membership status, discounts, store credit, perferences

Sale customer, date of sale, employee, sale price, inventory item(s) sold tax, discounts, (profit--don't store calculated fields)

request Customer, condition, Album requested--artist requesting, price range, date requested, data fulfilled

Employees name, datehired, position, sales, address, phone, email

Purchase (store purchasing) item names, quality, purchase date, price paid, edition, vender,