a) Together they constitute a composite key for the table b) ...
View QuestionA data type that creates unique numbers for key columns in Microsoft Access is:
a) Autonumber b) Boolean c) Sequential key d) ...
View QuestionThe term for information that describes what type of data is available in a database is:
a) Data dictionary b) data repository c) Index data d) Metadata Answer: d Explanation: Meta data ...
View QuestionIf an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
a) DKNF b) BCNF c) Fourth d) Third Answer: b
View QuestionIf every non-key attribute is functionally dependent primary key, then the relation will be in
a) First normal form b) Second normal form c) Third form d) Fourth normal ...
View QuestionWhich of the following is based on multi-valued dependency:
a) First b) Second c) Third d) Fourth Answer: d
View Question
Consider the relation given below and ind the maximum normal form applicable to them
i. R(A, B) WITH productions { A –> B }
ii. R(A, B) WITH productions { B –> A }
iii. R(A, B) WITH productions {A —> B, B –> A }
iv. R(A, B, C) WITH productions {A –>B, B –> A, AB –> C }
Consider the relation given below and ind the maximum normal form applicable to them i. R(A, B) WITH ...
View QuestionIdentify the composite attributes
a) Salary b) Credits c) Section_id d) None of the ...
View QuestionA domain is ______ if elements of the domain are considered to be indivisible units.
a) Atomic b) Subatomic c) Substructure d) Subset Answer: a Explanation: ...
View Question