7. Create a Crow's Foot ERD in Visio, based on the following business rules: (30 pts) (I would draw a rough idea on paper, first, before working through Visio) Table name: PAINTER Primary key: PAINTER_NUM Foreign key: none PANTER NUM PAINTER LNAME PAINTER FNAME PAINTER INTIAL 123 Ross Georgette P 126 tero Julio G a. Each department is allocated many computers b. Each computer is allocated to one department c. Each computer houses many software instances d. Each software instance is housed on one computer e. Each software vendor supports many software instances f. Each software instance is supported by one software vendor Name each entity, give each relationship line a verb and include the appropriate connectivity symbols. No PKIFK/Attributes will be graded just entities, relationships and verbs. When complete, use the shipping tool to paste the completed ERD below. AND ALSO, for this problem, post the Visio (vsd) file in the drop box as well. Table name: PAINTING Primary key: PAINTING_NUM Foreign key: PAINTER_NUM PAINTING NUM PAINTING_TITLE 1338 Dawn Thunder 1339 Vanilla Roses To Nowhere 1340 Tired Flounders 1341 Hasty Ext 1342 Plastic Paradise PANTER NUM 123 123 126 123 128