Course Number and Title: CIS 238 - Database Design and Programming
This course introduces students to database programming using structured query language (SQL). Students acquire working knowledge of the databases necessary to apply and manage the key features such as creating, updating, and reporting.
- Explain database design theories and the normalization process. (CCC 1, 2, 6; PGC 3)
- Develop SQL statements. (CCC 1, 2, 6; PGC 3)
- Design, create, and update a database. (CCC 2, 6; PGC 3)
- Design and maintain database security. (CCC 1, 2, 4, 6; PGC 1, 3, 6)
See Core Curriculum Competencies and Program Graduate Competencies at the end of the syllabus. CCPOs are linked to every competency they develop.
Upon completion of this course, the student will:
- Explain database design theories and the normalization process.
- Describe database design theories and the normalization process.
- Develop relationships between database tables.
- Construct the table structures through the data normalization process.
- Develop SQL statements.
- Describe relational database systems and SQL.
- Explain SQL commands.
- Identify system objects and processes.
- Examine the basic structure of the SELECT statement and its options.
- Construct SQL SELECT statements.
- Design, create, and update a database.
- Formulate a plan to create a database.
- Create, modify, rename, and delete database tables.
- Write database queries using SQL statements.
- Construct multiple queries and views.
- Develop and modify reports.
- Design and maintain database security.
- Identify and describe database security issues.
- Explain database administration.
- Develop a plan for database security.
- Create and maintain user accounts and groups.
- Define the constraints to protect data integrity in database tables.
- Set up access and security for database tables.
Students must demonstrate proficiency on all CCPOs at a minimal 75 percent level to successfully complete the course. The grade will be determined using the Delaware Tech grading system:
Students should refer to the Student Handbook for information on the Academic Standing Policy, the Academic Integrity Policy, Student Rights and Responsibilities, and other policies relevant to their academic progress.
- Apply clear and effective communication skills.
- Use critical thinking to solve problems.
- Collaborate to achieve a common goal.
- Demonstrate professional and ethical conduct.
- Use information literacy for effective vocational and/or academic research.
- Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
- Install, configure and secure computer applications and operating systems.
- Design, write, and debug computer programs.
- Design and integrate databases in computer programs
- Analyze and design complex computer applications to solve business problems.
- Integrate the principles of the Internet into web development.
- Incorporate the principles of networking and information security in computer application development.
The College is committed to providing reasonable accommodations for students with disabilities. Students are encouraged to schedule an appointment with the campus Disabilities Support Counselor to request an accommodation needed due to a disability. A listing of campus Disabilities Support Counselors and contact information can be found at the disabilities services web page or visit the campus Advising Center.