Practice Exam - ITC114/423 Practice Exam Time given: 2...

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

View Full Document Right Arrow Icon
ITC114/423 Practice Exam Time given: 2 hours Student Name: _____________________________ ID: _____________ Short Answer Questions: 1. Explain multi-valued attributes, and provide an example. How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow’s Foot model? 2. What is a weak relationship? Provide an example. 3. What steps are involved in the conversion to third normal form? 4. Explain the BCNF. How is it related to other normal forms? 5. In what two cases are composite primary keys particularly useful? 6. Explain what a relationship is and list the different types of relationships 7. What is meant by a derived attribute? Illustrate by giving at leas t one example 8. What is meant by a A single-valued attribute? Illustrate by giving an example 9. Explain the meaning of a transaction in DBMS 10. What is the purpose of Concurrency Controls? 11. List the functions or responsibilities of the DBA
Background image of page 1

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

View Full DocumentRight Arrow Icon
Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 1. End-user data is ____. a. raw facts about the end-user b. raw facts of interest to the end-user c. data about data d. accurate, relevant and timely information ____ 2. A ____ is a collection of related records. a. database c. column b. field d. file ____ 3. The relational data model was developed in the ____. a. 1960s c. 1980s b. 1970s d. 1990s ____ 4. The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. a. hierarchical c. object-oriented b. network d. entity relationship ____ 5. Which data model has the highest level of abstraction? a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/15/2010 for the course MIT 424 taught by Professor Cevenini during the Three '10 term at Charles Sturt University.

Page1 / 6

Practice Exam - ITC114/423 Practice Exam Time given: 2...

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

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