Quiz on database design

CIS39

Question #1: In you own words, explain third normal form. Explain each part separately and give an example of your own of each.

Question #2: In your own word, explain 1 to 1 relationships, 1 to many relationships and many to many relationships? Give an example of your own of each.

Question #3: If you were asked to develop a database design for a company or an organization, explain in detail how you would tackle the problem.

Question #4: Explain the problem with redundancy.

Question #5: Draw the entity relationship diagram for the following: A faculty member works for a department. A department is managed by a department chair. A department is part of a division. The division is managed by a dean. How would this translate into tables. Explain the tables.

Multiple Choice and True/False Questions: If you feel you need to clarify your answer please write an explanation.

#1: A foreign key is:

a) a field in a table that is a match for a field in another table

b) a field in a table that is a match for a key field in another table

c) a key field that is made up of multiple parts

d) a field that has been defined as a foreign key

#2: A field is said to be dependent if:

a) it is dependent on the foreign key

b) it is part of a primary key

c) it depends on the primary key

d) it depends on another field in the table

#3: In an entity relationship diagram, the symbol

a) is used to show a one to one relationship

b) is used to show a many to many relationship

c) is used to show a one to many relationship

#4: True or False: An entity relationship diagram is used to model entities and relationships.

#5: True or False: An ER model represents a logical view of the data.

#6: True or False: An instance is an occurrence of an entity. For example: you are an instance of the entity student

#7: True or False: When you look at a table, not all records contain the same fields.

#8: A valid primary key must be unique. Pick a valid primary key from this list:

a) the title of a play

b) last name + date of birth

c) car registration number

d) course code such as CIS17

#9: In a database management system an example of a flat file is:

a) a table that has fields for all of the data that you want to store

b) a table that does not have multiple occurrences of a field

c) any database design that consists of only one table

#10: A complex key field is a name for:

a) a key field containing data of multiple types

b) a key field made up of 2 or more fields

c) a key field that occurs in a secondary table

d) a key field that allows duplicates

#11: True or False: SQL is the industry standard for database queries.

#12: What diagram is used to show database objects and the relationships between them?

a) systems flowcharts

b) logic flowcharts

c) entity-relationship diagrams

d) hierarch charts