a) Instance b) Snapshot c) ...
View QuestionRepresentations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
a) Cross-tabs b) Snapshot c) Both Cross-tabs and Snapshot d) All of the mentioned Answer: ...
View QuestionDesigners use which of the following to tune the performance of systems to support time-critical operations
a) Denormalization b) Redundant optimization c) Optimization d) Realization
View QuestionWhat is the best way to represent the attributes in a large database?
a) Relational-and b) Concatenation c) Dot representation d) ...
View QuestionSuppose the user finds the usage of “room number” and “phone number” in a relational schema there is confusion.This is reduced by
a) Unique-role assumption b) Unique-key assignment c) ...
View QuestionIn which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
a) A many-to-many relationship set b) A multivalued attribute of an entity set c) ...
View QuestionWhich of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
a) A many-to-many relationship set b) A multivalued attribute of an entity set
View QuestionIf a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
a) A many-to-many relationship set b) A multivalued attribute of an ...
View Question_____________ can help us detect poor E-R design.
a) Database Design Process b) E-R Design Process c) Relational scheme d) ...
View Question