MSIS Exam 2 Questions

MSIS Exam 2 Questions - MSIS Exam 2 Questions 1. What are...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MSIS Exam 2 Questions 11/14/10 5:03 PM 1. What are the steps to create a Database? 2. What are the two ways to describe a table? 3. What are the properties of a Primary Key? 4. What is the definition of a Bad Effect? 5. List and describe the types of normal forms? 6. What are the two requirements for two tables to join? 7. What does the phrase same entity mean? 8. What does it mean to have a valid database? 9. What is the definition of n-ary? And list the types. 10. What are the benefits of normalization? 11. List and describe the two anomalies. 12. What is a composite key? 13. What is a candidate key? 14. What is a surrogate key? 15. What is a foreign key? 16. What are the components of Data Integrity? 17. What is Data Independence? 18. What are the Principles of Database design? 19. What is data dictionary? 20. What is referential Integrity? 21. What is SQL and list and describe the SQL keywords mentioned in class? 22.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

MSIS Exam 2 Questions - MSIS Exam 2 Questions 1. What are...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online