Develop a logical relational data model whose entity types are all normalized to the third normal form using Visio Database Model Diagram or similar software. (2 points). Save your Visio file as If you use software other than Visio, turn in both original file and a screen shot of your diagram in a Word document so your instructor can still grade your diagram even he/she cannot open your original file. If you have a technical issue to use any software, hand-write your diagram, take a picture of it, and submit the picture file as png or jpg. The image near the end of this question shows the Customer Order form for a retail shop that sells consumer packaged products. All customers must already have an established account at the retail shop's website. A daily discount rate and price is set for each product differently for a particular week and those data must be retrieved from the database. The discount rate and price of each product can change at 12:00am on every Thursday. Therefore, the discount rate and price charged for an ordered product on a particular date must be stored in the database, too, in order to re-compute the grand total in the future. Gift Wrap Yes can be checked by a customer for each product every time the customer places an order when they want. This Gift Wrap Yes data needs to be stored in the database. Product No on the image is the internal unique sequential ID number assigned by the shop for each product. Given a user view (a figure) shown at the bottom of the question, construct a logical relational data model using Visio Database Model Diagram. Add you last name to all entity type (table) name and attribute (column) name. E. Student for an entity type (table). tudentID for an attribute (column) name. If you don't follow this, you will lose 1 point. Student Major PK Studenti PK Major ID Last Name MajorName FirstName Majorld You must create a Visio file (or any other file) from scratch. The use of any existing file will be considered as an academic dishonesty conduct. . Your diagram must show all necessary entity types (tables), attributes (columns), and relationships with appropriate cardinality. Show only attributes (columns) that are necessary to support the user view shown below. Do NOT include unnecessary attributes (columns). Indicate all the primary keys. Show all necessary foreign keys and they must be marked as foreign keys. All entity types (tables) must be in 3NF. Your diagram should NOT have any many-many relationship. Customer Order Order No 1 Order Date 8/25/2020 Customer Account No 1 Customer Email Address doe@eagle.com Customer Full Name Phone Number John Doe (239) 555-5555 Shipping Address 111 Augusta Street Fort Myers, FL 33102 Total Gift Wrap Yes Product No Product Name 1 Fancy Coffee Price Charged Ordered Quantity Discount Rate $20.00 2 0% $40.00 2 Milk $6.00 10 5% $57.00 3 Bread $4.00 1 0% $4.00 Grand Total $101.00 Record: 1 1 of 3 No Filter Search