1. Home
  2. Flashcards
  3. Preview

IT2032.txt

  1. What is the traditional role of a client in a client/server architecture?
    a. Storage
    b. business logic
    c. presentaion and business logic
    d. requests and presentation
    d. requests and presentation
  2. Rules that goven an organization's business processes are know as ______.
    a. data stores
    b. presentation logic
    c. data constraints
    d. business logic
    d. business logic
  3. A transaction processing application focuses on groups of operations related to a specific business event.
    a. True
    b. False
    a. True
  4. The basic orgainzational unit for data in a database is the ______.
    a. table
    b. row
    c. primary key
    d. data item
    a. table
  5. Items modeled by a relational database are known as _____.
    a. entities
    b. keys
    c. attributes
    d. relationships
    a. entities
  6. You are designing a table to store payroll information.
    Given the following choices, which should you use as the table's primary key?
    a. Last name + First name
    b. Address
    c. Social Security Number
    d. Last name only
    c. Social Security Number
  7. What is used as a visual model of entities and their relationships?
    a. keys
    b. Tuples
    c. ERD
    d. constraints
    c. ERD
  8. What is the information called that usually describes an entity?
    a. key
    b. tables
    c. attributes
    d. relationships
    c. attributes
  9. It is necessary to define an associative entity when defining _____.
    a. any relationship
    b. a one-to-one relationship
    c. a one-to-many relationship
    d. a many-to-many relationship
    d. a many-to-many relationship
  10. You want to track class sections and student enrollments at a technical school. Each student attends at least four classes. You need to quickly retrieve student and class information. The most efficient way to store this information is a one-to-many relationship.
    a. True
    b. False
    b. False
  11. What is the minimum number of tables required to establish a many-to-many entity relationship when implemented within a database?
    a. 2
    b. 3
    c. 4
    d. 5
    • b. 3
    • Two tables are linked together with the third associative table.
  12. You are designing employee tables for a business. Each employee fills out a time card each week. You design includes both an Employee entity and a TimeCard entity. How should you design these entities?
    a. Two unrelated entities
    b. One-to-many relationship
    c. Two entities with a many-to-many relationship
    d. None of the above
    b. One-to-many relationship
  13. You are designing a database that will have a single table. Which of the following will not be needed in your table design?
    a. Data types
    b. Column names
    c. Primary key
    d. Foreign key
    • d. Foreign key
    • With a single table there is no foreign key to use!
  14. Not having a primary key on a table means _____.
    a. entity integrity is violated
    b. referential integrity is violated
    c. both entity and referential integrity is violated
    d. None of the above
    a. entity integrity is voilated
  15. Each foreign key entry on a table should reference a value in another table or ______.
    a. entity integrity is violated
    b. referential integrity is violated
    c. both entity and referential integrity is violated
    d. None of the above
    b. referential integrity is violated
  16. Entity Relationship Diagrams (ERDs) _____.
    a. are typically Relational Database Management System (RDBMS) specific
    b. are used to enforce integrity rules
    c. are used to design databases
    d. all of the above
    c. are used to design databases
  17. You need to create a relationship between the Employee entity and Order entity. The Employee entity includes EmployeeID(primary key), FirstName, LastName, and EMailAddress. The Order entity includes OrderID(primary key), EmployeeID, and Date. What should you do?
    a. Define EmployeeID in the Employee entity as a foreign key
    b. Define OrderID in the Order entity as a foreign key
    c. Define EmployeeID in the Order entity as a foreign key
    d. Add EmployeeID to the Order entity primary key
    c. Define EmployeeID in the Order entity as a foreign key
  18. 1NF
    All fields must contian single values only.
  19. 2NF
    Part of the primary key may not determine a non-key field.
  20. 3NF
    A non-key field may not determine another non-key field.
  21. 4NF
    In an all-key table part of the key can determine multiple values of, at most one other field.
Author
alienmark67
ID
27178
Card Set
IT2032.txt
Description
Database IT203
Updated

  1. Home
  2. Flashcards
  3. Preview