Vince Roberts runs a vintage record shop in the University dis- trict. His shop sells 45's, LPs, and even old 76 RPM records.

Most of his stock is usedhe buys used vinyl from customers or finds them at yard sales and discount storesbut he does sell new albums that are released on vinyl. For a couple of years, he has kept most of his inventory either in his head or in a spiral notebook he keeps behind the sale counter. But his inventory and his business have grown to where that is far from sufficient. Vince is looking for someone to make him a database. He knows he needs to get a better handle on several aspects of his business: He needs to know the extent and condition of his

inventory. He needs to know the relative value of his inven- torysome records are worth a fortune; some are nearly worth- less. He also needs to track where, from whom, and for how

much he purchased his stock. He needs to track his sales. He often is not entirely sure how much money he has spent or how much money he has earned.

In addition he would like to allow customers to make spe- cific requests and notify them if a requested item comes in. More

generally he would like to make an email list of interested cus- tomers in order to let them know about new items of interest.

Someday, he would like to expand his business online. But he knows he needs to have everything under control before then.

1. List the major topics for this database.

2. Write a draft statement of work. Include a brief his- tory, a statement of scope, objectives, and a preliminary

timeline. 3. Documentation: Start a notebook, either electronically or physically, to record your progress with the scenario database. Add the statement of work and any notes to the notebook.