CTCITC 114: Database Design & Implementation

CTCITC 114: Database Design & Implementation


A.  Database Management Systems
B.  Database Development
C.  Business rules and user requirements
D.  Entity Relationship Diagrams
E.  Normalization
F.  Database Design Patterns
G.  Validate and manage data
H.  Data queries
I.  Database forms, views and reports
J.  Database Security and administration
K.  Software, data, and users testing


By the end of this course, students should be able to:

  • Summarize the purpose of database management systems and the role of database administrators. (A1)
  • Describe the process of analysis of client needs, design of data models, and implementation of databases in modern relational database management system software. (B1)
  • Analyze a scenario to identify the business rules and customer requirements to be included in a data model. (C1)
  • Distinguish between conceptual data models, logical data models and physical data models.(D1)
  • Describe the relational model and the principles of relational database design.
  • Employ Entity-Relationship diagramming tools to model data. (F2)
  • Demonstrate the process of normalizing relationships in tables. (E1)
  • Apply database design patterns in data modeling. (F1)
  • Use SQL statements to create a new database and modify an existing database
  • Use SQL statements to select, sort, and filter data within a database(H1)
  • Differentiate between an administrator/developer’s view of the database (tables, queries) versus a user’s view of the database (forms, reports, and custom user interfaces). (I1)
  • Identify ethical issues and regulations relating to data and databases. (J1)
  • Discuss database security issues (such as role-based access, data encryption, and SQL injection)
  • Give examples of the various types of testing relating to databases (for example, application software testing, data integrity testing, user testing).

By the end of this course, students may be able to:

  • Configure a database to allow for web-based application access
  • Validate, import, convert, and export data from one application to another (G1)
  • Construct multiple user interfaces to a database: forms, reports, web interfaces, etc.
  • Perform database integrity testing
  • Identify salient features of data warehouses
  • Identify salient features of dimensional databases