Process that establishes need for and extent of an information system

Transform data into information that forms the basis for decision making

Performance depends on triad of factors EXCEPT:

Provides “big picture” within which database design and application development can be mapped out and evaluated

Phases of SDLC

SDLC is iterative rather than sequential process

A thorough audit of user requirements is in which phase of SDLC?

Steps are laid out for conversion from old to new system

Database is created and system is customized by creation of tables and views, and user authorizations

Changes in the business environment is what type of maintenance?

Database Life Cycle (DBLC) consists of how many phases?

Helps define required data structures, type and number of entities, and physical size of the database

ER Modeling should be in which phase of DBLC?

Feature that allows simultaneous access to a database while preserving data integrity

•Identifies data sets

•Defines data elements for each of those sets

•Identifies data elements (items)

•Groups them together in data sets

Used when the data component of system has considerable number of entities and complex relations on which very complex operations are performed

Two departments use the different names for the same entity

Example Department A (Staff)

Department B (Employee)

Two different entities address by the same label

(Attribute from different entities having same name)

Example in table CUSTOMER AND STAF both have first_name as their attribute