CIS 260

Database Management Systems    (Pierce College)       

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

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.

1. Case studies
2. Demonstration
3. Participation
4. Projects
5. Essays