Blog

As the project manager for developing a custom learning management system for a local community college, categorize the following activities into the most appropriate phase of the software development life cycle (SDLC). If an activity could belong to more than one phase, select the most predominant one.

Principle of Least Privilege (POLP) (choose best)

What is the best choice for an index for the following query: select name, age from employee where age > 21 and age < 65;

A strict schedule is often non-recoverable

Given R(A, B, C) with state: A B C a f m a g m b h m b i n c j n c k n The functional dependency B → A holds for the database state shown. (true or false)

A relation R(A, B), where A is a prime attribute and B is a non-prime attribute, meets 2NF criteria

With respect to JDBC (pick true statement):     

Desirable properties of relational normalization include

A relation schema R that meets Generalized 3NF criteria may have transitive dependencies

A relation with a single attribute as the Primary Key always meets Generalized 2NF criteria.