Department of Mathematics, Science & Technology

  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:

    3000 minutes

  4. Prerequisites:

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

    Corequisites:

    None

  5. Other Pertinent Information:

    This course is designed to present database concepts that will prepare students to effectively develop applications using current database models. This solid base of knowledge will permit 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 will make sure that this course remains at a practical, hands-on level.

  6. Catalog Course Description:

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

  7. Required Course Content and Direction:

    1. Learning Goals:

      1. Course Learning Goals

        2. Students will be able to

        1. demonstrate knowledge of database terminology;
        2. evaluate advantages and disadvantages of database processing;
        3. distinguish between features and uses of various database models;
        4. demonstrate knowledge of data definition and manipulation of the relational models;
        5. create related tables and follow the procedures for Normalization; and
        6. solve various business related problems using currently available DBMS.

      2. Core Learning Goals (if applicable)


        3. This course is not included in the Core.

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

      1. Planning and Creating a Database
        1. Relational Database Design
        2. Entity Relationship Diagrams
        3. Normalization
        4. Using Wizards
        5. Viewing Objects
        6. Navigating

      2. Creating and Using Tables
        1. Understanding Table Layout
        2. Creation in Design View and Use of Wizard
        3. Entry, Modification, and Deleting of Data
        4. Changes to Table Structure
        5. Changes to Field Properties and Records
        6. Sorting Records
        7. Finding and Filtering Records

      3. Building a Relational Database
        1. Understanding Relationships
        2. Creating Table Relationships
        3. Utilizing Relationships
        4. Editing and Deleting Relationships
        5. Data Integrity Rules

      4. Working with Forms
        1. Creating
        2. Working with Views
        3. Customizing
        4. Creation from Scratch
        5. Controls, Calculations, Combo, and List Boxes
        6. Subforms

      5. Designing and Modifying Queries
        1. Understanding
        2. Simple Queries
        3. Use of Multiple Tables
        4. Summary Queries and Expressions
        5. Append and Delete Queries

      6. Designing and Modifying Reports
        1. Understanding
        2. Use of AutoReport and Wizard
        3. Creating in Design View
        4. Modifying
        5. Creating Report Controls and Subreports
        6. Creation of Charts

      7. Integrating Data from Other Applications
        1. Understanding Object Linking and Embedding
        2. Adding and Viewing Images
        3. Importing and Exporting Data

      8. Use of the Internet, Macros, and Visual Basic
        1. Posting Forms and Reports
        2. Using Hyperlinks
        3. Creating and Modifying
        4. Customizing

      9. Use of Menus, Switchboards, and Toolbars
        1. Creation
        2. Modification

      10. Tools, Security, and Help
        1. Performance Analyzer
        2. Table Analyzer
        3. Security Issues

    3. Assessment Methods for Core Learning Goals:

      1. Assessment Methods for Course Learning Goals

        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. Assessment Methods for Core Learning Goals (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:

    At least two hours each week will be devoted to the presentation of course material and special projects in a classroom setting. The remaining time will be used for laboratory exercises and assignments.

    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