Henry owns a chain of four bookstores, all of them located in the state of Mississippi. When Henry took control of the bookstores several years ago, he inherited a paper-based system that organized the information he needed to run the businesses on preformatted forms and printed listings. Henry keeps a book card (see Figure 1) for every set of books he owns, recording the book code, title and publisher of the book. The form also displays the book type and sales price. The book card indicates whether the book is in paperback format or hardcover. For each book, Henry lists the different authors and their sequence (first author, second author, etc). Finally, Henry keeps track of how many copies of each book his bookstores have on hand. A particular book has one publisher, possibly multiple authors, and stored at multiple branches.

My answer so far:

Requirements:

1. Create all the tables necessary to maintain records about books in all branches, the list of publishers, information about the different branches, the types of books, the information about authors, list of employees (two types: sales and cashiers), list of customers, data about the following events: sales and cash receipts, and a list of cash accounts. Use the following data model as a starting point in addition of the solution for the data model exercise (see above system description doc):

Make sure to handle properly the many-to-many relationships: between authors and books, between branches and books, between sales and books, between sales and cash receipts. Customer can write a check for multiple sales invoices and/or pays an invoice in multiple installments.

2. Create and specify the properties for the fields in each table. Specify the primary key or composite keys. Identify input mask, default values, and validation rule when it is appropriate or necessary. Enter sample data in each table (use the data displayed in the system description and create your own: multiple books, multiple employees, multiple customers).

3. Create the book card form based on figure 1 in the system description. Hint: use two subforms, one to record the list of authors and one to record the quantity on hand in the branches. Create combo box and calculated field(s) when necessary.

Henry's Bookstores Henry owns a chain of four bookstores, all of them located in the state of Mississippi. When Henry took control of the bookstores several years ago, he inherited a paper-based system that organized the information he needed to run the businesses on preformatted forms and printed listings. Henry keeps a book card (see Figure 1) for every set of books he owns, recording the book code, title and publisher of the book. The form also displays the book type and sales price. The book card indicates whether the book is in paperback format or hardcover. For each book, Henry lists the different authors and their sequence (first author, second author, etc...). Finally, Henry keeps track of how many copies of each book his bookstores have on hand. A particular book has one publisher, possibly multiple authors, and stored at multiple branches. Henry keeps a list of his bookstores, their location, and how many employees each branch employs (see Figure 2). Figure 2-List of Henrv's bookstores Every time Henry receives a book from a new publisher, he adds the new publisher information to the list (see Figure 3). For each type of book (science fiction, biography, etc...), Henry created a special code (see Figure 4 ). Fiure 4 - I ist of hook tvnes Every time Henry makes a book sale, he fills out a sale form (see Figure 5). He records the customer information on the form and lists the book(s) sold. He computes manually with a calculator the total of the purchase