Database Questions

  • What two conditions must be met before an entity can be classified as a weak entity? Give an example of a weak entity.
  • What is a strong (or identifying) relationship, and how is it depicted in a Crow's Foot ERD?
  • Given the business rule "an employee may have many degrees", discuss its effect on attributes, entities, and relationships (Hint: Remember what a multivalued attribute is and how it might be implemented.)
  • What is a composite entity, and when is it used?
  • Suppose you are working within the framework of the conceptual model in Figure Q4.5 Given the conceptual model in Figure Q4.5:
    • Write the business rule that are reflected in it.
    • Identify all of the cardinalities.
  • What is a recursive relationship? Give an example.
  • How would you (graphically) identify each of the following ERM components in a Crow's Foot notation?
    • an entity
    • the cardinality (0, N)
    • a weak relationship
    • a strong relationship
  • Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?
  • What two courses of action are available to a designer who encounters a multivalued attribute?
  • What is a derived attribute? Give an example.
  • How is a relationship between entities indicated in an ERD? Give an example using Crow's Foot notation.
  • Discuss two ways in which the 1:M relationship between COURSE and CLASS can be implemented. (Hint: Think about relationship strength.)
  • What three (often) conflicting database requirements must be addressed in database design?
  • Briefly, but precisely, explain the difference between single-valued attributes and simple attributes. Give an example of each.
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.