Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
7 Cards in this Set
- Front
- Back
What is an information system?
|
Can be used for: data collection, data storage, and data retrieval. Also converts data into information.
|
|
What is Systems Development Life Cycle (SDLC)?
|
An iterative process not a sequential process.
|
|
Name phases of the SDLC and list at least two activities from each phase.
|
1.Database initial study -Analyze situation, Define objectives
2.Database design -Create the conceptual design, Create the logical design 3.Implementation and loading -Install the DBMS, Create the database(s) 4.Testing and evaluation -Test the database, Fine- tune the database 5.Operation -Produce the required information flow 6.Maintenance and evolution -Introduce changes, Make enhancements 7. Cycle repeats |
|
What is Database Life Cycle (DBLC)?
|
Trace the history of the database within an information system.
|
|
Name phases of the DBLC and list at least two activities from each phase.
|
1. Planning phase- initial assessment, and feasibility study
2. Analysis phase – user requirements, existing system evaluation, logical system design 3. Detailed systems design phase – detailed system specification 4. Implementation phase – coding, testing, and debugging , and installation, fine-tuning 5. Maintenance phase – evaluation, maintenance, enhancement |
|
What is the difference between conceptual design and logical design?
|
Conceptual – abstract overview of system (independent of hardware and software)
Logical – mapped to specific software |
|
Briefly Describe top-down, bottom-up, centralized, and decentralized database design strateigies.
|
•Top-down- Create Entities and then create Attributes
•Bottom-up – Create Attributes and then Create Entities •Centralized – All components in centralized location •Decentralized – design process is divided into modules, a team of designers work on a module, each module is verified and integrated to create aggregate module which is used to create conceptual design. |