Infos 314 summaries
Chapter 8
Sequence
o Object for generating unique sequential values for a field
o Characteristics:
o Independent object in DB
o Not tied to table or column
o Have a name
3 differences between SQL and procedural language
o Runtime mismatch
o Processing mismatch
o Data type mismatch
Chapter 9
Database definition
o Repository of facts in an IS used for data collection, storage, transformation and retrieval
What does the performance of IS’s depend on?
o Database design & implementation
o Application design & implementation
o Administrative procedures
5 phases of SDLC (systems development life cycle)
1. Planning
2. Analysis
3. Detailed systems design
4. Implementation
5. Maintenance
Phases of DBLC (database life cycle)
, 1. DB initial study
2. DB design
3. Implementation & loading
4. Testing & evaluation
5. Operation
6. Maintenance & evolution
4 types of maintenance
o Corrective
o Adaptive
o Perfective
o Preventative
Purpose of the DB initial study (first phase)
o Analyse company situation
o Define problems & constraints
o Define objectives
o Define scope & boundaries
What must be tested for security?
o Physical security
o Password security
o Audit trails
o Access rights
o Diskless workstations
o Data encryption
What are designers’ efforts focused on?
o Information needs
o Information users
o Information sources
o Information constitution
Where can a designer obtain information from?
o End users
o Observing current system
o Interfacing with systems design group
Chapter 8
Sequence
o Object for generating unique sequential values for a field
o Characteristics:
o Independent object in DB
o Not tied to table or column
o Have a name
3 differences between SQL and procedural language
o Runtime mismatch
o Processing mismatch
o Data type mismatch
Chapter 9
Database definition
o Repository of facts in an IS used for data collection, storage, transformation and retrieval
What does the performance of IS’s depend on?
o Database design & implementation
o Application design & implementation
o Administrative procedures
5 phases of SDLC (systems development life cycle)
1. Planning
2. Analysis
3. Detailed systems design
4. Implementation
5. Maintenance
Phases of DBLC (database life cycle)
, 1. DB initial study
2. DB design
3. Implementation & loading
4. Testing & evaluation
5. Operation
6. Maintenance & evolution
4 types of maintenance
o Corrective
o Adaptive
o Perfective
o Preventative
Purpose of the DB initial study (first phase)
o Analyse company situation
o Define problems & constraints
o Define objectives
o Define scope & boundaries
What must be tested for security?
o Physical security
o Password security
o Audit trails
o Access rights
o Diskless workstations
o Data encryption
What are designers’ efforts focused on?
o Information needs
o Information users
o Information sources
o Information constitution
Where can a designer obtain information from?
o End users
o Observing current system
o Interfacing with systems design group
