What does cardinality represent in an entity-relationship diagram? 1:The uniquely identifiable element about which data is stored 2:The maximum number of entity instances in a relationship 3:The total number of primary keys in an entity 4:The total number of attributes in an entity

Which of the following criteria would make an entity a weak entity? a.) If the primary key is not derived from the parent entity in the relationship b.) If the entity can exist without the entity with which it has a relationship c.) If the primary key of a related entity contains the primary key of the parent entity d.) If the entity has a primary key that is partially derived from the parent entity

Draw an entity relationship diagram with the following: 1. Patient Entity: RUT (Primary Key): IntegerName: ChainLast name: RopeDate of Birth: DateEmail: StringAddress: ChainTelephone numbers: ChainPension System: Chain     2. Health Insurance Entity: Code (primary key): IntegerType: Rope     3. Medical entity: RUT (Primary Key): IntegerName: ChainLast name: RopeDate of Birth: DateSpecialties: RopeYears of practice: Whole       4. Medical Specialty Entity: Code (primary key): IntegerSpecialty name: String     5. Pharmaceutical company entity: Code (primary key): IntegerName: ChainTelephone number: Chain     6. Medication Entity: Business name (primary key): StringFormula: RopePharmaceutical company code (foreign key): Integer     7. Pharmacy Entity: Code (primary key): IntegerName: ChainAddress: ChainTelephone number: Chain     8. Patient-Doctor Assignment Entity: Assignment ID (primary key): IntegerPatient RUT (foreign key): IntegerDoctor RUT (Foreign Key): Integer numberStart date:…

Discuss the differences between entity, instance of an entity, and relationship.