Resources

Working Sample Syllabus: Database Design/Development

Course Number:

 CIS 260

Course Title:

Database Management Systems    (Pierce College)       

 

Course Catalog Description: Credits:    5
Concepts, theory, analysis and design of relational database management systems (RDBMS). This project-based class explores Entity Relationship modeling and advanced Microsoft Access techniques in preparation for the Microsoft Office Specialist exam. Practical application includes case study analysis within the healthcare industry and comparison to other industries as applicable.
Course Content:
  1. Database Management Systems
  2. Database Development
  3. Business rules and user requirements
  4. Entity Relationship Diagrams
  5. Normalization
  6. Database Design Patterns
  7. Validate and manage data
  8. Data queries
  9. Database forms, views and reports
  10. Database Security and administration
  11. Software, data, and users testing

 

Student Outcomes:
1.  Discuss database management systems and database administration. (A1)2.  Analyze, design, and create relational databases to meet industry and customer needs using current relational database management system software. (B1)

3.  Identify the business rules and customer requirements to be included in the data model. (C1)

4.  Differentiate between and create conceptual data models, logical data models and  physical data models.(D1)

5.  Normalize relationships in tables. (E1)

6.  Use database design patterns in data modeling. (F1)

7.  Use modeling/diagramming software to model data. (F2)

8.  Validate, import, convert, and export data from one application to another (G1)

9.  Create data queries that sort, filter, manipulate and calculate data (H1)

10. Develop effective queries, forms, reports and custom user interfaces for databases. (I1)

11. Discuss ethics and security issues and regulations surrounding data and databases. (J1)

12. Test the integrity of the database design. (K1)

Degree Outcomes:   Enter the appropriate FAK (GER) or Program Outcome (Pro-Tech), and at least one Core Abilities

outcome which will be formally taught and assessed in this course.  FAK and Core Abilities outcomes are on the Pierce
College Degree Outcomes list, and Pro-Tech outcomes are on the Pierce College website: http://www.pierce.ctc.edu/proftech

Core Abilities

  • Information Competency:
    Graduates will synthesize new information with current understanding and experience in order to create something new, acquire insight, transform values, or expand knowledge base.

 

Program Outcomes

  • Leverage IT best practices to analyze and present database and information resources
  • Model and develop database and data warehouse applications to meet user needs.
  • Utilize data and business intelligence to consolidate, manipulate, integrate, and display data.

 

Potential Methods and Tools for Assessment:
  1. Case studies
  2. Demonstration
  3. Participation
  4. Projects
  5. Essays
Centers of Excellence

Developing partnerships among business, industry and education to meet the future needs of Washington State.