1. An online store Best Book Deals sells books to customers. Customers can buy many books and a book can be bought by several customers. The books sold on the online store are written by a single author, but an author can write many books. Every time a customer buys books online from Best Book Deals, an invoice is generated that includes the date and time the invoice was generated.

1. Identify the entities (10 pts)
2. Identify 3 attributes for each entity (10 pts)
3. What type of relationships (example, 1:1, 1:M, M:N) exists between the entities (10 pts)

2. Draw an ER Model using Visio for the following. Make sure the ER model is in 3^rd Normal Form and includes appropriate attributes for entities/tables, including the Primary Key (PK) and Foreign Key (FK) (35 pts):

A consulting firm, Boston Datacorp based in Boston, Massachusetts, USA hires managers to manage several client projects, but each project requires the involvement of only one manager. Each manager supervises several data scientists and each data scientist can be managed by more than one manager. Data scientists use high-end statistical applications (such as SAS) to run statistical models to do their work; a data scientist may use several statistical applications, and each application could be utilized by several data scientists. At Boston Corp managers need to make additional contributions by writing papers or articles (sometimes referred to as white papers) to get promoted. A manager can write several articles/papers (white papers), while a white paper can only be written by one manager.

3. Draw an ER Model using Visio for the following. Make sure the ER model is in 3^rd Normal Form and includes appropriate attributes for entities/tables, including the Primary Key (PK) and Foreign Key (FK) (35 pts):

A professional soccer sports team KNight Riders wants to track ticket sales and games/matches its soccer team plays with other soccer teams. Each customer can purchase multiple tickets, but a ticket can be bought by only one customer. Each customer attends multiple soccer games/matches and games can be attended by many customers. KNight Riders wants to record information about the game venue, date, and game outcome. Customers attending KNight Riders games can buy many sports merchandise (example, apparel), and a merchandise can be bought by several customers. Customers are requested to leave their comments after buying the merchandise; the customer comment depends on both the merchandise bought and the customer. KNight Riders management has also noticed that the sale of merchandise is linked to the games the KNight Riders soccer team plays. Many merchandise can be sold at Knight Riders games, and each game can be associated with sales of many merchandise. Further, the game popularity depends on the merchandise sales and the game itself