test 1 KEY - CGS 2545 Exam #1 Fall 2010 Monday September...

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

View Full Document Right Arrow Icon
1. Which of the following is not a constraint on generalization/specialization? (a) membership constraint (b) disjointness constraint (c) integrity constraint (d) completeness constraint 2. A given database will consist of exactly how many conceptual schema? (a) cannot say unless we know more about the database. (b) exactly one (c) exactly two (d) one for each relation in the database. 3. Which of the following is(are) disadvantage(s) of the file system approach to storing and managing data? (a) duplication of data (b) software/application development times (c) high degree of data sharing is possible (d) program-data independence (e) none of the above are a disadvantage of the file system approach 4. A superclass inherits relationship participation from its subclasses. TRUE FALSE 1 CGS 2545 – Exam #1 – Fall 2010 Monday September 27, 2010 100 points total Name: READ THIS!! Multiple Choice, True/False Multiple choice – circle the letter or letters which corresponds to the best answer from those listed. True/False – circle “TRUE” if the statement is True otherwise circle “FALSE”. Total points = 75, Each question = 3 points KEY
Background image of page 1

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

View Full DocumentRight Arrow Icon
5. This type of independence insulates the users of a database from changes made to the conceptual database. (a) physical (b) logical (c) conceptual (d) democratic 6. In an E-R diagram a derived attribute is represented by: (a)a set of curly braces. (b)a set of parentheses. (c) a set of square braces. (d) who cares? (this is not the correct answer!) 7. The “E-R” in the E-R data model stands for: (a) “Emergency Room” (b) “Entity Requirements” (c) “Entity Relationship” (d) “Entity Relational” 8. Which of the following is not one of the five basic steps in the SDLC process for database development? (a) planning (b) analysis (c) implementation (d) prototyping (e) all of the above are steps in the database design process. 9. In general, it is preferable to associate attributes with entity sets rather than relationship sets, whenever possible, because: (a) it requires less memory to store an entity set than a relationship set. (b) it makes the E-R diagram more manageable.
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.

Page1 / 9

test 1 KEY - CGS 2545 Exam #1 Fall 2010 Monday September...

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