solved Homework 1 Note: This homework will be an opportunity for

Homework 1 Note: This homework will be an opportunity for you to show off your capacity to model a system based on requirements provided with UML diagram. Instructions : Rename the file with your first name and last name as follow: Firstname_LastName_homework1Write a phrase or two stating that you will not cheat during the assignment and the assignment will be the product of your work. This is an individual work and cannot be made in group.Your Statement goes below in redI….Do not post the homework on any studying website like (Chegg, CourseHero, study.com, Test banks)Write your solution about the Your Answer section Grading Rubric Points Question 1 Up to 2 point Demonstrate the ability to analyze and understand the requirements. You analysis should include at least 2 requirements. Question 2 Up to 4 point Demonstrate the ability to draw a conceptual diagram with the proper notation. Make sure you have more than 4 entities and more than 4 attributes each. Question 3 Up to 4 point Demonstrate the ability to draw a normalized diagram with the proper notation. Make sure you have more than 4 entities and more than 4 attributes each. Producing a great wine is a really complex process, one that takes many years to master. Offering and selling wines to customers is another complicated process. For a few years, Chuck has been trying to sell wine and he was only using papers to manage his customers, his suppliers, their orders, the inventory and the three stores. Chuck has his stored growing on multiple location around the world and wants to recruit a database administrator to build their database. Chuck wants the following Manage the product that he is selling, the wine. The database should also hold the information regarding the producer of the wine, the origin of the producer. Manage the customer by getting their information to send gift to their home for their birthday. Manage the customer orders so that each customer can have the list of their orders. Manage his suppliers so by getting their information and call them when he needs to purchase new winesManage the inventory and making sure that he has a threshold when the inventory is lowManage the store and the location. Question 1 2pt Write a brief analysis of your understanding regarding the business problem 2pt Question 2 4pt Draw the conceptual model by using Lucidchart by specifying the relationship between the entities and having 4 attributes for each entities. Question 3 4pt Draw a normalized logical model by specifying the relationship between the entities and having 4 attributes for each entities.