- 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?
What DBMS runs on the Linux operating system?
The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?
How is data in a relational database system organized?
Select three or four companies from the Yahoo! Finance database. Estimate how much more these companies could borrow before they would exhaust taxable profits.
Discuss database management systems. Explore the multiple facets of database management systems.
What is the difference between a user and a schema?
Explain the relationship between entities, attributes, tables, and columns.
Discuss how databases are organized.