6 Match the database model type with its characteristic. (2 pts ee = 20 pts) Table name: PAINTER Primary key: PAINTER_NUM Foreign key: none PAINTER_NUM PAINTER_LNAME PAINTER_FNAME PAINTER_INITIAL 123 Ross Georgette 126 tero Julio G a. Internal Model b. External Model C. Conceptual Model d. Physical Model Depicts the way that end users imagine their data: Neither hardware nor software independent: Depicts the highest level of abstraction: Depicts the actual way data are saved on storage devices: Table name: PAINTING Primary key: PAINTING NUM Foreign key: PAINTER_NUM PAINTING_NUM PANTING_TITLE 1338 Dawn Thunder 1339 Vanilla Roses To Nowhere 1340 Tired Flounders 1341 Hasty Exit 1342 Plastic Paradise PAINTER NUM 123 123 126 123 126 A representation of the DMBS as is 'seen" by the DBMS: Represents the logical design without regard to physical storage characteristics: Has specific software dependence but is hardware independent: Depicts the lowest level of abstraction: 2. List at least 3 sources of business rules: (9 pts) 3 ( Depicts and enterprise-side view of the data: A depiction that is relative to a specific DBMS 3. When reading an ERD, relationships are read from the side to the 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) side. (2 pts) 4. Today's relational model no longer needs to focus on the physical data models of the past, as today's DBMSs take care of that detail for us. Instead, our data models focus primarily on the view of the data. These data models are represented in 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 snipping tool to paste the completed ERD below. AND ALSO, for this problem, post the Visio (vsd) file in the drop box as well. diagrams. (4 pts) 5. Introduced by Codd in the 1970's, the model has become the foundation of both today's data modeling and Database Management Systems (3 pts)