QUESTIONS ||RECENTLY TESTING REAL EXAM QUESTIONS|
VERIFIED SOLUTIONS (100% CORRECT ANSWERS) GRADED
A+ /2025 BRAND NEW!!
How to eliminate repeating groups? - ANSWER-Make a seperate
table for each
set of related attributes , and give each table a
primary key
A table is in (2NF) if ? - ANSWER-It is in (1NF) and these is no
nonkey column
dependent on a partial primary key of
that table
A table is in (3NF) if ? - ANSWER-it is in 2nf and there are
no functional
dependencies between nonkey
columns
What is the entity- relationship (ER) model is used for? -
ANSWER-to design
, relational databases by removing all existing
redundancy in the data
What is the basic object of the ER model - ANSWER-An entity
What is an entity? - ANSWER-a real world ojbect
What is a foreign key? - ANSWER-a field in one table that
uniquely identifies a
row within another
table
What are the two steps of 3NF? - ANSWER-1. ensuring 2NF is
met ( ensure 1NF is met, remove subsets of data that apply to
multiple rows of a table and place them in separate tables ,
create relationships between these new tables and their
predecessor through the use of foreign keys)
3NF = - ANSWER-Eliminate columns not dependent on Key; if
attributes do not
contribute to a description of the key, remove them to
separate table