INFO MAG LESSON 2: DATABASE: SYSTEMS DEVELOPMENT LIFE CYCLE

• Planning- To develop a preliminary understanding

  of a business situation. help solve a problem or make an opportunity

  possible. Create Business Opportunity Report or Written Request to study or create system in business
• Analysis-To analyze the business situation thoroughly to determine requirements of the business and the clients. Deliverables are functional specifications for a system that meets user requirements and is feasible to develop and implement
• Design- To elicit and structure all information

  requirements; Deliverables: Detailed functional specifications

  of all data, forms, reports, displays, and processing

  rules; program and database structures,
• Implementation- To write programs, build data files,

  test and install the new system, train users,

  and finalize documentation. Deliverables: Programs that work accurately

  and to specifications, documentation, and

  training materials
• Maintenance- maintain, repair, and enhance the operation of the system. Deliverables: Periodic audits of the system to demonstrate whether the system is accurate and still meets
• Enterprise Data Model- is an integrated view of the data

  produced and consumed across an entire organization. Analyze the general business functions and their database need. Justify need for new data and databases in support of business.
• Conceptual Data Modeling- Identify the scope of database requirements for the proposed information system. Analyze overall data requirements for business function(s) supported by database
• Logical Database Design- Analyze in detail the transactions, forms, displays,

  and inquiries (database views) required by the business

  functions supported by the database. Includes entities (tables), attributes (columns/fields) and relationships (keys)
• Physical Database Design- Define database to DBMS (often generated from repository). Decide on physical organization of data. Design database processing programs. Includes tables, columns, keys, data types, validation rules, database triggers, and access constraints
• Database Implementation- Code and test database processing programs. Complete database documentation and training materials
• Database Maintenance- Tune database for improved performance. Fix errors in database and database applications and recover database when it is contaminated
• Waterfall- A System Development Life Cycle. Up to down detailed development process. Which is time consuming
• Rapid Application Development (RAD)- Iterative process of rapidly repeating analysis, design, and implementation steps until they converge on the system the user wants
• Prototyping- Rapidly building an initial version of the application that can be used as a basis for further refinement.
• Agile Methodology- Involves iteratively developing software through continuous feedback with end users or stakeholders. It emphasizes flexibility over following a plan.