CISC215 Database Design and Application Development

Department of Science, Technology, Engineering & Mathematics: Computer/Information Science

  1. Course Number and Title

    CISC215 Database Design and Application Development

  2. Number of Credits

    3 credits

  3. Minimum Number of Instructional Minutes Per Semester

    2250

  4. Prerequisites

    CISC113 (C or better) or CISC115 (C or better)

    Corequisites

    None

  5. Other Pertinent Information

    This course is designed to present database concepts and prepare students to effectively develop applications using current database models. This solid base of knowledge enables the student to use the information as a foundation for learning new models as they evolve. Lab experiences with a currently available database programming package ensure that this course remains at a practical, hands-on level.

  6. Catalog Course Description

    This course provides students with a foundation of knowledge needed to work with database management systems and to create applications utilizing current development strategies. Students examine various types of database techniques with emphasis on relational designs. Students design and implement solutions to business-related problems.

  7. Required Course Content and Direction

    1. Learning Goals:

      1. Course
        2. Students will:
        1. analyze a business problem and develop data management requirements;
        2. develop a conceptual model to meet the problem requirements using an Entity- Relationship diagram or another conceptual modeling tool (UML);
        3. apply normalization to reduce/eliminate redundancy in database design; and
        4. implement the conceptual model in a commercial relational database such as MS Access, Oracle, MySQL.
      2. Core (if applicable)
        3. This course is not included in the Core.

    2. Planned Sequence of Topics and/or Learning Activities:

      1. database fundamentals
        1. advantages of database
        2. relational database design
          1. entity relationship diagrams
          2. normalization
        3. modify CRM database for normalization
        4. create MS Access CRM database with tables, form and reports
        5. Structured Query Language
          1. data definition
          2. queries
          3. SQL views
        6. create SQL database with tables, queries and views
      2. database design
        1. requirements analysis
        2. data modeling and entity-relationship model
        3. transforming data model into database design
      3. database management
        1. database administration
        2. control, security, and reliability
        3. create a database security plan
      4. database processing applications
        1. triggers and stored procedures
        2. set up Web database processing
      5. business intelligence systems
        1. examine basic concepts of data warehousing, data marts, dimensional databases, and data mining

    3. Assessment Methods for Core Learning Goals:

      1. Course
        2. The assessment of Course Learning Goals is based on written tests, labs, and other assignments, as well as performance-based tasks as appropriate.

      2. Core (if applicable)
        3. This course is not included in the Core.

    4. Reference, Resource, or Learning Materials to be used by Students:

      Departmentally selected textbook. Details provided by the instructor of each course section. See course format.

  8. Teaching Methods Employed

    Section VIII is not being used in new and revised syllabi as of 12/10/08.

Review/Approval Date - 9/98; Updated: 4/06 from Access to Oracle; Updated: 5/07 from Oracle to Access; Revised 6/09; Revised 10/2010; Revised 5/2012