test 1 review part 3

Question 1

(very high level: entities and relationships) —>

(lower level: normalization, PK, FK) –>

(Table/Column names, Keys, Constraints as supported by a specific RDBMS – e.g. datatypes, may be some denormalization)—->

Answer 1

conceptual, logical, physical design

Question 1

What are the four components of Database System with SQL

Answer 1

Users, Database Applications, SQL, DBMS

Question 2

Which of the following is the correct order of steps for designing a database?

Determine attributes, determine entities, Convert entities to relations through a process called “normalization”, Define relationships to other entities (ERD)

(A) 1, 2, 3, 4
(B) 2, 1, 3, 4
(C) 3, 1, 2, 4
(D) 4, 1, 2, 3

Answer 2

(B) 2, 1, 3, 4

Question 3

What is the correct order of the following:

primary key, candidate, determinant

(A) 1, 2, 3
(B) 3,1,2
(C) 2,1,3
(D) 1,3,2
E) 3,2,1

Answer 3

E) 3,2,1

Question 4

For a key to be a unique identifier, it must often become a composite key. (T/F)

Answer 4

True

Question 5

The ideal surrogate key is short and numeric and sometimes changes. (T/F)

Answer 5

False ; The ideal surrogate key is short and numeric and never changes.