C430 Midterm Exam Questions And Actual Answers.

False - Answer A relation describes the structure, content, and access controls of a physical data store or database. True - Answer A relational database management system stores data in tables. false - Answer Every table in a relational database must have a foreign key. true - Answer A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table. false - Answer Relationships in a relational database are usually represented by embedding a foreign key in each participating table. true - Answer Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables. false - Answer Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class. false - Answer A relational database table is in third normal form (3NF) if it is in second normal form (2NF) and if every non-key field is functionally dependent on the primary key. true - Answer A relational database table is in third normal form (3NF) if it is in second normal form (2NF) and if no non-key field is functionally dependent on any other non-key field. false - Answer Problem domain modeling and database normalization are incompatible techniques for relational database design.