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. Number of Instructional Minutes
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. Course Learning Goals

    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. Planned Sequence of Topics and/or Learning Activities

    Course Outline:

    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 Course Learning Goals

    The assessment of Course Learning Goals is based on written tests, labs, and other assignments, as well as performance-based tasks as appropriate.
  4. Reference, Resource, or Learning Materials to be used by Student:

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

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; New Core 8/2015