True or False:
Q1: An inner join creates a result (view) from matching criteria ____
Q2: Foreign keys go into the strong entity ____
Q3: The process of data modeling may produce an ER diagram ____
Q4: SQL is the standard language used to access a relational database ____
Q5: ERD is the modeling process used to eliminate anomalies from a relational database _____
Fill in the Blank:
Q6: A main characteristic that distinguish relational databases from a data warehouse is: ______________________________________________.
Q7: A relational database is in _____________ normal form when the transitive dependency anomalies are removed.
Q8: A technique and notation used to diagram a relational database model using the Semantic Modeling approach is: ____________________.
Multiple Choice:
Q9: A mechanism that ensures the deletion of all related data among multiple tables when a record is removed is called:
____ A. Join
____ B. Referential Integrity
____ C. Modification Anomaly
____ D. Two Phase Commit
Q10: The process used to define entities (tables) and their relationships is:
____ A. Metadata definition
____ B. Modeling
____ C. UML