PLEASE ONLY ANSWER THE QUESTION IF YOU PLAN ON ANSWERING BOTH PARTS OF THE QUESTION. IF YOU ONLY KNOW HOW TO DRAW THE ER DIAGRAM, THEN DO NOT ANSWER THE QUESTION.

Thank you.

.

Part 1:

Consider the design of an online auto part shopping website, such as http://shop.advanceautoparts.com/home , in which auto parts are listed in various categories, such as Engines, Batteries, Brakes, etc. A category might contain multiple sub-categories, and a sub-category might contain multiple sub-sub-categories, and so on. Each auto part might be listed in one or more categories (the term of category is used to refer to categories at all levels from now on). Each category is managed by at most one employee, although one employee might manage multiple categories. The management of a category includes: insert/delete/update a subcategory, and insert/delete/update a part to the category. Each category is identified by a categoryid, category name, and a list of search keywords (could be arbitrary number of keywords). Each auto part is identified by a unique partid, part name, a short description, a price, and a list of search keywords (again, could be arbitrary #). Each auto part is associated with a list of reviews, either positive or negative, from buyers who purchased the parts before. Each employee is identified by a unique employee ID, first name, last name, email, phone number. Draw an E-R diagram for the above system. Use underlines, thick lines, and arrows to represent constraints. State your assumptions if necessary.

Part 2:

Translate your E-R diagram for problem 1 into a relational model, i.e., a set of CREAT TABLE/ASSERTION statements enforcing all stated constraints. In addition, write a CREATE ASSERTION statement to ensure that each category can contain at most 5 sub-categories.