Question: Define entity, attribute and relationship

Answer: An entity is an object of interest to the end user. Attributes are characteristics of entities. A relationship is an association between entities.

Question: What are the three types of relationship?

Answer: Relationships may be classified as one-to-one, one-to-many, or many-to-many.

Question: Explain attributes domain

Answer: Attributes have a domain, a domain is the set of possible values for a given attribute. For example, the domain for the grade point average (GPA) attribute is written (0,4) because the lowest possible GPA value is 0 and the highest possible value is 4.

Question: Multivalued

Answer: Multivalued attributes are attributes that can have many values. For instance, a person may have several college degrees, and a household may have several different phones, each with its own number.

Question: Single-valued

Answer: A single-valued attribute is an attribute that can have only a single value. For example, a person can have only one Social Security number, and a manufactured part can have only one serial number.