Exam 2 Review

Match the following pre-implementation steps.

• Identifying necessary resources

• Design

• Identifying user requirements

• Analysis

• Translating requirements to specifics

• Planning

Match the following build & go-live and beyond steps

• Validating the system

• Maintenance

• Creating the system

• Development

• Keeping the system operational

• Implementation

• Providing the system to users

• Testing

Organize these options into the right categories from the pre-implementation stages

Groups:

(a) Planning

,

(b) Analysis

,

(c) Design

• Responsibilities

• Conceptual Design

• Project plan

• Requirements

• Technical specifications

• System model

• Roles

• Feasibility study

Reorder the steps from the pre-implementation stage

• Planning

• Analysis

• Design

Reorder the following from the build & go-live and beyond stage of the management framework.

• Maintenance

• Implementation

• Testing

• Development

Match the following types of JOIN Operations.

• Inner Join

• 
• Right Outer Join

• 
• Full Outer Join

• 
• Left Outer Join

• 

What is the first step of ERD?

• Concept: Identifies the entities, or tables, the database will need to capture.

• Logical: Adding field names for each table. All fields in a table must describe the appropriate records.

• Physical: the design blueprint of a relational database.

What does the SQL Language: Truncate command?

• Delete an existing table and all records it contains

• Deletes all the records contained in an existing table but does not delete the table

• Insert

• Removes one or more records from a table

What is data definition language (DDL)

• changes the structure of a database by adding or changing tables and relationships

• Modifies the data within a database

• interacts with DML commands when transactions are processed in the database

What is transaction control language? (TCL)

• changes the structure of a database by adding or changing tables and relationships

• modifies the data within a database

• grants access to or removes access from a database user

• interacts with DML commands when transactions are processed in the database