cs4 no answer

MIDTERM EXAMINATION ( CS4 ) – APPLICATION SOFTWARE (write the correct answer before the corresponding number)

1. Uses interviews and questionnaires to collect facts about systems, requirements, andpreferences.a. Fact-finding b. requirement specification c. database design d. none of the above

2. One of the major goal in requirements gathering is to collect the data used by the organizationa. Fact-finding b. requirement specification c. database design d. none of the above

3. Requires understanding both the operational and business requirements of anorganization a. Fact-finding b. requirement specification c. database design d. none of the above

4. Most popular conceptual model for database designa. Fact-finding b. requirement specification c. database design d. none of the above

5. Describes data as entities, attributes and relationshipsa. Fact-finding b. requirement specification c. database design d. none of the above

6. A relation is a named, two-dimensional table of dataa. true b. false

7. All tables qualify as relationsa. true b. false

8. Every relation has a unique namea. true b. false

9. Relational model is one logical data modela. true b. false

10. Columns correspond with entity instancesa. true b. false

11. Rows correspond with entity instances (and with many-to-many relationship instances)a. False b. true

12. The word relation (in relational database) is NOT the same as the word relationship (in ERmodel)a. False b. true

13. Are unique identifiers of the relation in questiona. Foreign key b. composite keys c. primary key d. all of the above

14. Are identifiers that enable a dependent relation (on the many side of a relationship) to refer to its parent relation (on the one side of the relationship)a. Foreign key b. composite keys c. primary key d. all of the above

15. More than one fielda. Foreign key b. composite keys c. primary key d. all of the above

(Below diagram for questions 16-20)

16. CUSTOMER relation primary keya. Customer_ID b. Order_ID c. both A and B d. none of the above

17. CUSTOMER relation primary keya. Customer_ID b. Order_ID c. both A and B d. none of the above

18. ORDER relation foreign keya. Customer_ID b. Order_ID c. both A and B d. none of the above

19. ORDER_LINE relation composite keya. Product_ID b. Order_ID c. both A and B d. none of the above

20. PRODUCT relation primary keya. Product_ID b. Order_ID c. both A and B d. none of the above

(Below diagram for questions 21 - 25)

21. Referential integrity constraints are drawn via arrows from dependent to parent tablea. false b. true

22. ORDER relation is a dependent tablea. false b. true

23. Restrict – don’t allow delete of “parent” side if related rows exist in “dependent” side (do not delete customer if there are orders)a. false b. true

24. Cascade – automatically delete “dependent” side rows that correspond with the “parent” side row to be deleted (if a customer is delete, delete all orders)a. True b. False

25. Set-to-Null – set the foreign key in the dependent side to null if deleting from the parent sidea. True b. False

26. In mapping binary relationships, a One-to-One - Primary key on the mandatory side becomes a foreign key on the optional sidea. True b. False

27. One-to-Many - Primary key on the one side becomes a foreign key on the many sidea. True b. False


28. Example of mapping a M : M relationshipa. True b. False

29 - 31. Name the CUSTOMER atttributesa. Customer_ID b. Customer_Name c. Customer_Address


32. ER diagram (1:1)a. True b. False

33 – 40 Draw the resulting relations of diagram in number 32.

cs4 no answer

Documents