Skip to content
  • Bucks for Students
    Enroll + Register
    • Academics
    • Admissions Information
    • Register for Courses
    • Placement Testing
    • Academic Advising
    • Majors + Certificates
    • College Catalog
    • Bucks Online
    • Honors at Bucks
    • Academic Departments

    Apply Now

    Planning + Payment
    • Financial Aid
    • Scholarships
    • Work Study Employment
    • Payment Options
    • Your Account
    • Tuition + Fees
    Transfer + Graduate
    • Transfer Information
    • Planning Your Transfer
    • Transfer by Institution
    • Transfer by Major
    • Graduate
    • Plan a Career
    • Labor Market

    Attend + Get Involved
    • Bucks+
    • Athletics
    • Bookstore
    • Student Life
    • Veterans
    • Fitness + Wellness
    • Student Government
    • Art + Entertainment
    • Alumni
    • Digital Badges
    • Internships
    • Job Resources

    Basic Needs

    • Accessibility Resources
    • Campus Services
    • Directory
    • Canvas
    • Bucks Email
    • Change Password
    • Pay Tuition
    • Student Planning
    • MyBucks
     
  • Bucks for Community

    Classes + Activities

    personal enrichment people
    Personal Enrichment
    • Art + Design
    • Culinary Classes
    • ESL
    • Business Development
    • Gaming
    • Health + Wellness
    • History + Special Interest
    • Foreign Language
    • Music
    • Test Prep
    • Browse All Courses
    kids on campus
    Kids on Campus Summer Camp
    • Camps for Ages 5-6
    • Camps for Ages 7-9
    • Camps for Ages 10-13
    • Teens On Campus
    • Camp Information
    • Camp Scholarships
    • Preschool Summer Program
    • Register for Camp

    Events

    Event Programs
    • Art + Entertainment
    • Book Discussions
    • Concerts
    • Foundation Events
    • Poetry + Prose
    • Movie Monday
    • Trips + Travel 
    • Event Tickets

    Buy Tickets

    Event Venues

    • Artmobile

    • Sculpture Walk

    • Zlock Performing Arts Center

    • The Gallery at Lower Bucks

    • Hicks Art Center Gallery

     
  • Bucks for Career
    briefcase
    Business + Career
    • Commercial Driver's License (CDL)
    • Customized ESL
    • Educators (ACT 48)
    • Browse by Industry
    • Online Learning
    • Professional Development
    • Registered Behavior Technician
    • Microsoft Office Technology & Customer Service
    • Bookkeeping with Quickbooks Certification
    • More
    Firefighter
    Fire + Public Safety
    • PSTC Course Schedule
    • Fire Training Weekends
    • Industrial Safety Training (OSHA)
    • Virtual Public Safety Training
    • Other Training + Resources
    • Training Facilities
    • More
    nurse
    Healthcare
    • CPR + First Aid Training
    • Dental Assistant
    • Nurse Aide
    • Nursing Review & Reentry
    • Pharmacy Technician
    • Physical Therapy Aide
    • Practical Nursing
    • More
    public safety figure
    Industrial + Manufacturing
    • Metalwork Pre-Apprentice Training Program
    • Industrial Maintenance Pre-Apprentice Program
    • Locomotive Engineer + Conductor
    • Workforce Development
    • More
    Man fixing server
    Information Technology
    • Certification Testing
    • Cyber Security
    • Database Development
    • Desktop Support (CompTIA)
    • Computer-Aided Design
    • Microsoft Office Software
    • Server Administration
    • Full Stack Web Developer
    • More
     
  • Library
  • Calendar + News
  • Diversity
  • Contact
Bucks County Community College

Courses + Programs

  Academics  —  Courses + Programs  —  Master Course Outlines

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
CISC127 (C or better) and CISC110 (C or better), or 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

  • Academic Advising
  • Academic Departments
  • Academic Majors
  • Catalog
  • Course Descriptions
  • Master Course Outlines
Bucks County Community College | Smart

(215) 968-8000

275 Swamp Road
Newtown, PA 18940

Maps & Directions

  • Newtown Campus
  • Bristol
  • Perkasie
  • Online
  • Follow Us on Instagram
  • Like Us on Facebook
  • Follow Us on Tiktok
  • Watch Us on YouTube

© Bucks County Community College.
All rights reserved.

Find Campus Services

  • Accessibility - TAO
  • Admissions
  • Advising
  • AESL Program
  • Basic Needs
  • Bookstore (External Website)
  • Career + Job Resources
  • Catalog
  • Counseling
  • Credit Union
  • Dining
  • Educational Enrichment
  • Financial Aid
  • Fitness and Wellness
  • IT Help Desk
  • KEYS Program
  • Library
  • Media Lab
  • Success Advocates
  • Perkins
  • Early Learning Center
  • Prior Learning Assessment
  • Security + Safety
  • Testing 
  • Transfer + Planning
  • Tutoring
  • Veteran Resources

Faculty + Staff Resources

  • MyBucks
  • Office 365
  • Canvas
  • Faculty Center
  • Faculty Online Resources
  • Professional Development

Get Involved

  • Arts + Entertainment
  • Athletics
  • Bucks+
  • Calendar + News
  • Event Tickets
  • Lectures + Conferences
  • Student Life

Read Notices + Policies

  • Academic Policies
  • Student Policies
  • Human Resources Policies
  • Information Technology
  • Administration
  • Advancement
  • Consumer Information
  • Disclaimers
  • Holiday Statement
  • Notice of Non-Discrimination
  • Clean Air Zone
  • Web Accessibility

Foundation + Alumni

  • Give
  • Alumni
  • Board of Directors
  • Foundation
  • Scholarships
  • Special Events

Explore Campus

  • Bucks Online
  • Newtown Campus
  • Lower Bucks Campus
  • Upper Bucks Campus
  • Parking
  • Facilities Rental
  • Weddings in Tyler Gardens
  • Purchasing
  • Sustainability
  • Emergency Closing Information

Find Jobs

  • Student + Work-Study Employment
  • Faculty + Staff Employment

Discover Bucks

  • Accreditations
  • Board of Trustees
  • Diversity, Equity + Inclusion
  • History
  • Mission + Vision
  • Office of the President
  • Provide Feedback

Contact Us

  • Ways to Contact Us
  • Faculty + Staff Directory
  • Social Media
  • Report an Issue
  • Emergency Text Alerts
  • System Status
  • Campus Health & Safety Plan