A table that has all key attributes defined, has no repeating groups, and all it

Question

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____. a) INF b) 2NF C) 3NF d) 4NF Successful database design is first and foremost based on ____. a) end-user requirements b) resource use c) cost savings d) programming ease Which of the following refers to the situation where different versions of the same data are stored at different places because they were not updated consistently? _____ a) Data query b) Data integrity c) Data redundancy d) Data dictionary A database system contains all of the following components: a) hardware, software, information, procedures b) hardware, software, data, procedures c) hardware, people, information, procedures d) software, people, information, procedures If a foreign key contains either matching values or nulls, the table(s) that makes use of such a foreign key is/are said to exhibit _____ integrity. a) entity b) restrictive c) secondary d) referential All of these are true about a database except: _____ a) it must contain multiple tables b) it is a shared, integrated structure c) it stores user data d) it stores metadata When two or more tables share the same number of columns, and when their corresponding cc share the same or compatible domains, they are said to be _____. a) intersect-compatible b) union-compatible c) difference-compatible d) select-compatible

Explanation / Answer

7.) 4 NF ( or somtimes also called as BCNF) is the normal form with minimum redundancy. Hence, option d is correct.

8.) Database is designed as per user requirements. Therefore, first and foremost purpose of database design should be end-user requirements. Hence, option a is correct.

9.) Data redundancy. option c

10.) hardware, software, data, procedures. option b

11.) referential integrity. option d

12.) a database can have only one table as well. Hence option a is correct.

13.) union-compatible. option b

Hope it helps, do give your valuable response.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.