1. One vendor may sell many products, each product can only have one vendor. 2. Every product will be associated with at least one category or more. Example: a CD titled "Madonna" can be categorized under "Foreign Album" and "Female Singer". 3. One category may have many categories as its children. For example, under "Album" category, we can have "Pop", "Rock", "R\&B" etc. However, it is optional to have a child category. 4. One category can also have many categories as its parents. For example, "Female Singer" can be categorized under "Pop" and "Rock" category. However, it is optional to have a parent category. 5. Each category may have products under it. 6. Each vendor may schedules many deliveries. 7. Each delivery must have at least one product shipped under it. 8. Each product also may be shipped under several deliveries. Note: You must indicate the connectivity in your ERD design. Deliverables 1. Draw equivalent ERD 2. Draw the relational schema 3. Write SQL code to create the required tables that you have designed in the ERD 4. Write SQL that inserts 2 records in each table in point 3 Introduction This assignment aims to enable students to study in-depth database design. The expected outcome will be a good knowledge gained about how to implement databases. Instructions 1. The due date for submitting your work to the e-learning system is on Saturday 15/1/2022 2. At a completion of the assignment, you should submit a cover page (first page) that has your name and ID followed by the assignment answers. 3. You are required to form yourself in groups, each group should include two students. The Business Rules 1. One vendor may sell many products, each product can only have one vendor. 2. Every product will be associated with at least one category or more. Example: a CD titled "Madonna" can be categorized under "Foreign Album" and "Female Singer". 3. One category may have many categories as its children. For example, under "Album" category, we can have "Pop", "Rock", "R\&B" etc. However, it is optional to have a child category. 4. One category can also have many categories as its parents. For example, "Female Singer" can be categorized under "Pop" and "Rock" category. However, it is optional to have a parent category. 5. Each category may have products under it. 6. Each vendor may schedules many deliveries. 7. Each delivery must have at least one product shipped under it. 8. Each product also may be shipped under several deliveries. Note: You must indicate the connectivity in your ERD design. Deliverables 1. Draw equivalent ERD 2. Draw the relational schema 3. Write SQL code to create the required tables that you have designed in the ERD 4. Write SQL that inserts 2 records in each table in point 3