In your first small project, Michael introduces you to basic database terminology and the process of how JustLee Books is designed as a database. He interprets Figure $1\mathrm{.}5($will be a file attachment in D$2$L$),$ offering that a customer can place one or more orders. Each order might have multiple items within it$.$ He explains that a book might be ordered multiple times on an order. Also, a book might have multiple authors, and an author might write one or many books. In addition, a publisher might publish one or more books. For this small project, Michael has asked that you work through these tasks the days you are in the office this week:

Think of an existing business OR a business you would like to start. Write a paragraph about what the business does. Use the JustLee Books Entity Relationship Diagram $($Figure $1-5)$ and its interpretation above in planning out your paragraph.

Use the ERD for JustLee$$s bookstore: Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? $($Hint: List the table and then the fields; e$.$g$.$ answer $-$ RESTAURANT: Customer#$,$ Date, Order, etc...$)$

How would you determine $($which tables and fields would you use$)$ to find which orders have not yet been shipped to the customer? $($Answer in $1-3$ sentences$)$

If management needed to determine which book category generated the most sales in April $2009,$ which tables and fields would they consult to derive this information? $($Hint: List the table and then the fields$)$

Explain how you would determine how much profit was generated from orders placed in April $2009.($Answer in $1-3$ sentences; explain the actual calculation steps$)$

If a customer inquired about a book written in $2003$ by an author named Thompson, which access path $($tables and fields$)$ would you need to follow to find the list of books meeting the customer$$s request? $($Hint: List the table and then the fields$)$

Every employee in a company is assigned to one department. Every department can contain many employees. $($Hint: Draw boxes with connecting lines horizontally showing one$-$to$-$one, one$-$to$-$many$-$many$-$to$-$one, and$/$or many$-$to$-$many; use drawing tools$)$

A movie megaplex needs to collect movie attendance data. The company maintains sixteen theaters in a single location. Each movie offered can be shown in one or more of the available theaters and is typically scheduled for three to six showings in a day. The movies are rotated through the theaters to ensure that each is shown in one of the stadium$-$seating theaters at least once. $($Hint: Draw boxes with connecting lines horizontally showing one$-$to$-$one, one$-$to$-$many$-$many$-$to$-$one, and$/$or many$-$to$-$many; use drawing tools$)$

An online retailer of coffee beans maintains a long list of unique coffee flavors. The company purchases beans from a number of suppliers; however, each specific flavor of coffee is purchased from only a single supplier. Many of the customers are repeat purchasers and typically order at least five flavors of beans in each order. $($Hint: Draw boxes with connecting lines horizontally showing one$-$to$-$one, one$-$to$-$many$-$many$-$to$-$one, and$/$or many$-$to$-$many; use drawing tools$)$