Scribd Logo
Upload

Welcome to Scribd!

  • 9 views

    B04SDLC

    Uploaded by

    yemane
    1) The document discusses database fundamentals including E/R modeling, normalization, SQL, access programming, and DBMS operations. 2) Key concepts covered include decomposing descriptions into data models, normalizing databases into 3NF relations, writing SQL queries, and creating multi-table databases and programs in Access. 3) The purpose is to outline the knowledge expected for students entering an MIS course on information systems.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    B04SDLC

    Uploaded by

    yemane
    9 views15 pages
    1) The document discusses database fundamentals including E/R modeling, normalization, SQL, access programming, and DBMS operations. 2) Key concepts covered include decomposing descriptions into data models, normalizing databases into 3NF relations, writing SQL queries, and creating multi-table databases and programs in Access. 3) The purpose is to outline the knowledge expected for students entering an MIS course on information systems.

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) The document discusses database fundamentals including E/R modeling, normalization, SQL, access programming, and DBMS operations. 2) Key concepts covered include decomposing descriptions into data models, normalizing databases into 3NF relations, writing SQL queries, and creating multi-table databases and programs in Access. 3) The purpose is to outline the knowledge expected for students entering an MIS course on information systems.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    9 views15 pages

    B04SDLC

    Uploaded by

    yemane
    1) The document discusses database fundamentals including E/R modeling, normalization, SQL, access programming, and DBMS operations. 2) Key concepts covered include decomposing descriptions into data models, normalizing databases into 3NF relations, writing SQL queries, and creating multi-table databases and programs in Access. 3) The purpose is to outline the knowledge expected for students entering an MIS course on information systems.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 15

    Database Fundamentals

    Knowledge expected for


    students entering MIS 4663
    Information Systems
    Data Process

    Information
    System

    Infrastructure Organization
    The R
    e
    Problem Identification & Planning

    SDLC v
    i Understanding the Current Situation
    s
    i
    o Selection of the Best Alternative
    n

    &
    Business or Logical Requirements
    I
    t
    e Physical Design, Coding & Testing
    r
    a
    t Implementation
    i
    o
    n Maintenance
    System
    An inter-related set of components,
    with identifiable boundaries,
    working together for some
    purpose.
    Analysis
    The process of identifying problems,
    opportunities, requirements,
    constraints, and resources.
    Design
    The business of finding a way to
    meet the functional requirements
    within the specified constraints
    using the available technology.
    Zachman Framework Network
    or
    Data Processes Technology
    Lists of entities Overview of
    Lists of functions that
    Ballpark important to the
    the business performs. technology
    (Business Scope) business architecture.
    (BPM)
    Functional Enterprise
    Owner E-R Diagrams
    Hierarchy Diagram communication
    (Business Model) (Entity Level) diagram
    E-R Diagrams Dataflow Distribution
    Designer (Attribute Level)
    (IS Model) Diagrams Diagram
    Database Process Specifications Configuration
    Builder Design Design
    (Technology Model)
    Schema and
    Detailed Sub-schema
    Program Code Configuration
    (Technology Definition
    Specification)
    Definition
    Working Installed
    Functional Physical Tables Application Infrastructure
    System
    Systems Development Life Cycle
    (SDLC)
    Often called Waterfall Model
    Iterative Process
    Control cost and time
    Budgets
    Project timelines and deadlines
    Works best with well understood systems
    Employed on most large development projects.
    Systems Development Life Cycle
    (SDLC)
    Problem Identification &Planning

    Understanding Current Situation


    Selection of Best Approach

    Business or Logical Requirements

    Physical Design, Coding and Testing


    Implementation

    Maintenance

    Hoffer, George & Valacich


    SDLC Criticisms
    • Process Overhead
    • Significant time and resource costs.

    • Project Milestones
    • Discourages iterative changes to higher level models in
    light of lower level developments.

    • Not suited for poorly understood systems.


    • Difficult to apply if system requirements are not well
    defined.

    • Testing Methodology
    • Bottom up testing may result in components that work
    separately but not together.
    Database Fundamentals

     E/R Modeling
     Decompose a narrative description into a data
    model that includes entities, relationships and
    constraints
     Use the E/R paradigm to develop enterprise
    (high level) models, conceptual models, and
    relational models as needed
     Identify attributes and domain constraints for
    them
    Database Fundamentals

     Normalization
     Decompose a database into 3NF relations
    from an attribute set.
     Use normalization to recognize design errors
    in existing databases
    Database Fundamentals

     SQL
     Create data access retrievals (SELECT
    statements) from existing databases.
     Single table queries with conditions (SELECT …
    WHERE …)
     Joins (SELECT … WHERE … KEY1 = KEY2)
     Subset and group conditions (SELECT … WHERE
    … GROUP BY … HAVING …)
    Database Fundamentals

     Access programming
     Create a multi table database including 1:m
    and m:n relationships
     Create a program that includes forms,
    reports, macros and navigation using controls
    Database Fundamentals

    For general use


     DBMS operation
     Understand how database management
    systems provide concurrency control,
     Understand backup and recovery using
    commits and rollbacks and checkpoints
     Understand integrity and how it is managed
     Explain other DBMS functions

    You might also like