INFO 340 Study Guide - Quiz Guide: Systems Development Life Cycle, Associative Entity, Deliverable
INFO 340
Quiz 1 Review
1. Cite the three major phases of database development and include high-level
objectives of each.
a. Follows similar process as the Systems Development Life Cycle (SDLC) used in
software development
b. Focuses primarily on the conceptual, logical, and physical phases
c. Conceptual
i. Discover business processes + purpose via stakeholder interviews and
observations; understand their point of view + goals
ii. Brainstorm
iii. Deliverable: conceptual database diagram
d. Logical
i. Refine the conceptual diagram by going through normalization
1. Validate transactions + ensure that questions can be answered
ii. Deliverable: entity-relationship diagram that is buildable on any platform
e. Physical
i. Implement the ERD
ii. It is product specific; understand the objects and product being used
(e.g., Oracle)
iii. Deliverable: schema of the database, which includes code for the ables,
entitites, logins, business rules, procedures
2. Explain the purpose of associative entities and provide an example.
a. Purpose
i. The result of a many : many relationship
1. One table that takes the identifying keys + lists them
ii. How can we uniquely identify when a unique student took a specific class
iii. Enables us to manage this overlap at high volume + quickly
b. Example
i. A student can register for multiple classes, and a class can have multiple
students
