CISC215 Database Design and Application Development

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

I. Course Number and Title
CISC215 Database Design and Application Development
II. Number of Credits
3 credits
III. Minimum Number of Instructional Minutes Per Semester
2250
IV. Prerequisites
CISC113 (C or better) or CISC115 (C or better)
Corequisites
None
V. 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.
VI. 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.
VII. 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.
    3. Core (if applicable)
    4. 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.

    3. Core (if applicable)
    4. 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.
VIII. 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