QUESTION 25 4-1 Question 4 Find the incorrect subtypes in the illustration. Explain why you think the subtype is incorrect. Adjust the model to improve it. AUTOMOBILE BUILDING HOUSE SEDAN SPORTS UTILITY VEHICLE 4-DOOR VEHICLE QUESTION 27 4-2 Question 1 Base on the diagram below and your set of business rule, draw the ERD ROOM building number room number PATIENT patient number patient name PHYSICIAN physician number name license number PRESCRIPTION prescription number date issued DRUG code drug name cost DRUG LABEL label number dosage treatment duration expiration date QUESTION 28 5-1 Question 1c Draw ERD for the question below. Indicate non-transferability when appropriate Each employee must work for one and only one department. Each department may have one or more employees Attach File Browse My Computer Browse Dropbox QUESTION 29 5-2 Question 1 Identify the relationship types of the statements below Identify the relationship types of the statements below Type Statement A snowboard instructor may instruct one or more snowboard- ers A bicycle may be owned by a child Classroom crayons may be used by students in a classroom A passport belongs to a person A female elephant gives birth to an elephant QUESTION 25 4-1 Question 4 Find the incorrect subtypes in the illustration. Explain why you think the subtype is incorrect. Adjust the model to improve it. AUTOMOBILE BUILDING HOUSE SEDAN SPORTS UTILITY VEHICLE 4-DOOR VEHICLE QUESTION 27 4-2 Question 1 Base on the diagram below and your set of business rule, draw the ERD ROOM building number room number PATIENT patient number patient name PHYSICIAN physician number name license number PRESCRIPTION prescription number date issued DRUG code drug name cost DRUG LABEL label number dosage treatment duration expiration date QUESTION 28 5-1 Question 1c Draw ERD for the question below. Indicate non-transferability when appropriate Each employee must work for one and only one department. Each department may have one or more employees Attach File Browse My Computer Browse Dropbox QUESTION 29 5-2 Question 1 Identify the relationship types of the statements below Identify the relationship types of the statements below Type Statement A snowboard instructor may instruct one or more snowboard- ers A bicycle may be owned by a child Classroom crayons may be used by students in a classroom A passport belongs to a person A female elephant gives birth to an elephant