- What is the relationship between columns that can be null and entity subtypes? Under what conditions would these columns lead to more than one entity subtype?
- Representing minimum cardinality in a physical database design can be tricky depending on whether the parent-child relationship is O-O, M-O, O-M, or M-M. Give an example of one of these minimum cardinalities and how it would affect the physical database design. What are referential integrity actions, and how could you use them in your example?
- Describe attribute conflict in view integration. How it is resolved?
- What are some potential problems of poor database design?
- Which database property type increases the efficiency of a search on the designated field in the physical database?
- True or false: The characteristics that allows a system to handle an increase in volume of data or users is called scalability.
- How to write business rules for a database.
- When was the database invented?