please answer them. this is my second post.

1. Identify the supertype and subtype of the entity listed below.

• DISABILITY
• Visual Impairment
• Hearing Impairment
• Amputation
• Paralysis

______________ Disability

______________ Visual Impairment

______________ Hearing Impairment

______________ Amputation

______________ Paralysis

2. For each rule stated indicate if the rule is applicable to supertypes or subtypes.

______________ They have several attributes in common

______________ They inherit all attributes and relationships of the entity

______________ Never exists alone

______________ Create one when a group of instances of an entity have special properties

3. Find the incorrect subtypes in the illustration. Explain why you think the subtype is incorrect. Adjust the model to improve it.

4. Directions: Identify the vocabulary word for each definition below.

______________ A structural business rule indicates the types of information to be stored and how the information elements interrelate.

______________ A formalized statement of the usual, customary, or generalized course of action or behavior for a business.

______________ A business rule that is workflow or business process related. (e.g., A has to happen before B, and then C has to happen at the same time as D.) This is also called a process business rule.

5. Try and solve below exercise

Members of your design team have been working with the local hospital to develop a data model for their need to store information about patients, the patient's room number, the patient's doctor, drug prescriptions given, and specific drug information.

However, they all went on vacation and left you to figure out the model. They also failed to give you any of their documentation other than the entities and attributes illustrated here. Instead of going back to the hospital, which could reflect poorly on your company, youre going to have to think about everything you know about hospitals!

Your task is to generate a list of business rules you think were used to arrive at the information shown here. Use your imagination. List 10 structural rules, 5 procedural rules, and 2 programmatic rules (rules to be addressed by computer applications in the future). State each rule as a single sentence.

Please based on the above set of business rules, complete below task:

• Potential entities
• ERDish
• Procedural Rules
• Programming Rules
• Draw your ERD

AUTOMOBILE BUILDING SEDAN HOUSE SPORTS UTILITY VEHICLE 4-DOOR VEHICLE