Harvey’s Book Store
Background
There is a local bookstore that is owned and operated by a man named Harvey Ames. He has operated the bookstore for more than25 years and hasn’t used any type of organized database. He has been using a file system stored on the computer in the form of Word documents and Excel spreadsheets. He was talking to some other local business owners about his storage and organization of the data and they recommended that he use a database for his file management. Harvey doesn’t know what a database is. All he knows is that he wants to make sure that his data is current and accurate. So now, Harvey is looking to hire a software professional to computerize his data. He doesn’t have a lot of money but he would like to upgrade his software.
The store
Harvey gathers and organizes information about publishers, authors, and books. The bookstore also stores the genre of the book, price, and whether the book is paperback or hardcover. Harvey also stores information about the authors of the books. He wants to keep a record of the number of units of the book that are in stock.
Harvey orders his products from several different publishers. He would like to store the information about these publishers in a more organized manner. He needs to have access to the publisher name, phone number, and address.
Harvey has 5 employees and he would like to store the employee’s information. He needs to keep better records of his employees for tax purposes. Since the store has a high employee turnover he has been having a hard time keeping track of everyone who works for him. He would like to have on file, the name, address, date of birth, social security number, etc. for each employee.
Harvey would like to start offering credit accounts to his customers. He doesn’t know how he will set this up. Harvey would like to be able to print a receipt for each customer. He wants to be able to print what the customer purchased, the name of the item, the price of the item, and the total dollar amount of the purchase. If this is a customer with a charge account the purchase total will need to be added to their account balance.
Harvey has been having a hard time keeping track of all of this information and that is why he wants to hire a consultant to design a database. He wants this system to be easy for him and his employees to use.
就是一个书店系统的建模。涉及书籍、出版社、作者、员工、顾客（打折）等实体。
数据库的设计
哈维书店
商店
哈维收集和组织关于出版商、作者和书籍的信息。书店还会存储书籍的类型、价格，以及这本书是平装本还是精装本。哈维还存储了关于这些书的作者的信息。他想记录下这本书的库存数量。
哈维从几家不同的出版商订购他的产品。他希望以更有条理的方式存储这些出版商的信息。他需要知道出版商的名字、电话号码和地址。
Harvey有5名员工，他想存储员工的信息。出于税务目的，他需要保存更好的员工记录。由于这家商店的员工流动率很高，他一直很难跟踪每一个为他工作的人。他希望有档案，姓名，地址，出生日期，社会安全号码等。对于每个员工。
哈维想开始向他的客户提供信用账户。他不知道该如何安排。哈维希望能够为每位顾客打印一张收据。他希望能够打印客户购买的商品、商品名称、商品价格以及购买的总金额。如果这是一个有收费账户的客户，购买总额将需要添加到他们的账户余额中。
哈维一直很难跟踪所有这些信息，这就是为什么他想聘请一名顾问来设计一个数据库。他希望这个系统对他和他的员工来说易于使用。