1 / 20

Lecture 9 – Database Design

Lecture 9 – Database Design. Systems Development Life Cycle (SDLC) Database Life Cycle (DBLC). Lecture Objectives. Define Information System, System Analysis, System Development, and Database Development Discuss the components of the Systems Development Life Cycle

oksana
Download Presentation

Lecture 9 – Database Design

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lecture 9 – Database Design Systems Development Life Cycle (SDLC)Database Life Cycle (DBLC)

  2. Lecture Objectives • Define Information System, System Analysis, System Development, and Database Development • Discuss the components of the Systems Development Life Cycle • Discuss the components of the Database Life Cycle

  3. Definitions – Information Systems • Allows for data collection, storage, and retrieval • Facilitates the transformation of data into information and the management of data and information People + Hardware + Software + Databases + Application Programs + Procedures= INFORMATION SYSTEM

  4. Definitions – Systems Analysis • Process that establishes the need and the extent for information systems • Analyzing in detail the information needs of an organization, the characteristics and components of presently utilized information systems, and the functional requirements of proposed information systems.

  5. Definitions – Systems Development • Process of creating the information system • Use the results of the systems analysis to determine the requirements and hence use the requirements to develop the information system • Databases, application software, etc.

  6. Definitions – Database Development • Process of database design and development • Database Design • Complete, normalized, non-redundant and fully integrated conceptual, logical, and physical database models • Database Implementation • Database storage structure, loading data, and data management

  7. Systems Development Life Cycle(SDLC) • Traces the history of an information system • Split into 5 phases • Database design an essential component of the SDLC

  8. Systems Development Life Cycle(SDLC) • Initial Assessment • Feasibility Study • Should the existing system be: • Continued? • Modified? • Replaced? • System Cost • Technology

  9. Systems Development Life Cycle(SDLC) • User Requirements • Existing System Evaluation • Logical System Design

  10. Systems Development Life Cycle(SDLC) • Detailed Specifications • Screen, menu, report layouts • Conversion from old to new

  11. Systems Development Life Cycle(SDLC) • Coding • Testing • Debugging • Installation

  12. Systems Development Life Cycle(SDLC) • Evaluation • Maintenance • System Errors • Business Changes • Enhancements

  13. Database Life Cycle (DBLC) • Traces the history of the creation of a database • Split into 6 phases

  14. Database Life Cycle (DBLC) • Analyze company situation • Define Problem and Constraints • Define Objectives • Define Scope and Boundaries

  15. Database Life Cycle (DBLC) • Conceptual Design • ER-Diagram / Normalization • DBMS Software Selection • Create the Logical Design • Create the Physical Design

  16. Database Life Cycle (DBLC) • Install the selected DBMS • Create the databases • Load the data / Convert from Old System

  17. Database Life Cycle (DBLC) • Test the Database • Fine-Tune the Database • Evaluate the Database and its Application Programs

  18. Database Life Cycle (DBLC) • Produce the required information flow • Alternate form of testing

  19. Database Life Cycle (DBLC) • Changes to the System (from operation, bugs, business changes) • Enhancements

  20. Life Cycle Effectiveness DOCUMENTATION

More Related