SOLVED

1) A form of database specification that indicates all the parameters for data storage that are then input to database implementation is: A) logical. B) physical. C) schematic. D) conceptual. 2) Physical database design decisions must be made carefully because of impacts on: A) data accessibility. B) response times. C) security. D) all of the above. 3) The relational data model consists of which components? A) Data structure B) Data manipulation C) Data integrity D) All of the above 4) A two-dimensional table of data is called a: A) group. B) set. C) declaration. D) relation. 5) ________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. A) Business rule constraint B) Data integrity C) Business integrity D) Data structure 6) An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) column. B) foreign field. C) primary key. D) duplicate key. 7) An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) link attribute. B) link key. C) foreign key. D) foreign attribute. 8) A primary key that consists of more than one attribute is called a: A) foreign key. B) composite key. C) multivalued key. D) cardinal key. 9) Which of the following are properties of relations? A) Each attribute has a unique name. B) No two rows in a relation are identical. C) There are no multivalued attributes in a relation. D) All of the above. 10) In the figure below, the primary key for “Order Line” is which type of key? A) Composite B) Foreign C) Standard D