CGS1545

Database Programming

Course Code:
CGS 1545

Credit Hours:
3

Effective beginning:
2023-24

Sections:
000

 

Course Description:
This is an advanced course in database management. Topics include relational database design and normalization, the process of custom application development, techniques for customizing the user environment, and the use of microcomputer database software to develop custom business applications.

 

Course Details

Prerequisites:

COP 1700 or consent of department

 

Instructors:

As assigned

 

Required textbooks/ course materials:

No textbook or course materials are required to purchase for this course.

ZTC

 

Assignment/course outline:

See your Instructor First Day Handout for individual instructor assignment schedule.

 

Discipline-level learning outcomes:

CGS 1545 is not a General Education Core course.  However, it does address several discipline-specific competencies in the Technology Area.

T-1 Apply appropriate technologies to a range of tasks.

T-2 Communicate, collaborate, and create content effectively, using state-of-the-art information technologies.

T-3 Locate, access, evaluate, and use information from digital/electronic sources.

T-4 Identify ethical, social, and legal issues related to information technology.

T-5 Identify essential issues related to information security.

 

Associate in Science degree in Business Administration Learning Outcomes:

B-1 Demonstrate knowledge of the principles, practices and supervisory responsibilities of management, and ethical and legal issues in a business environment.

B-2 Apply general business work place competencies, including employability skills and office computer skills.

B-3 Perform accounting tasks and understands business accounting concepts. 

B-4 Communicate effectively in oral and written form, exhibit college level computation and problem-solving skills, and interact appropriately with people of other cultures or backgrounds. [Gen. Ed.]

 

Associate in Science degree in Computer Information Technology Learning Outcomes:

CIT-1 Understand, install, configure, monitor, use, and troubleshoot computer hardware and software. [1.0, 2.0, 3.0, 4.0, 6.0, IT Support 12.0, 13.0]

CIT-2 Understand, install, configure, monitor, use, and troubleshoot network hardware and software. [8.0, 9.0]

CIT-3 Demonstrate general computing workplace competencies, including employability skills, interpersonal & customer service skills, and user support skills. [11.0, IT Support 12.0, 13.0, 14.0, 15.0]

CIT-4 Demonstrate project management skills. [10.0]

CIT-5 Perform database management and design tasks. [7.0]

 

Associate in Science degree in Network Systems Technology Learning Outcomes:

NST-1 Understand, install, configure, monitor, use, and/or troubleshoot computer hardware and software. [1.0, 3.0]

NST-2 Understand, install, configure, monitor, use, and troubleshoot network hardware and software. [2.0, 4.0]

NST-3 Demonstrate general computing workplace competencies, including employability skills, interpersonal & customer service skills, and user support skills. [5.0, Server Admin 18.0]

NST-4 Demonstrate project management skills. [6.0]

NST-5 Depends on Specialization:

  • Server Administration (Program Code 2181): Demonstrate advanced understanding of networked environments and perform network administration activities. [Server Admin Specialization 7.0-8.0]
  • Network/Cybersecurity (Program Code 2182): Demonstrate proficiency in securing networks and data, including performing penetration testing and responding to cybersecurity incidents. [Network/Cybersecurity Specialization 7.0-9.0]
  • Digital Forensics (Program Code 2183): Demonstrate understanding of forensic casework procedures and perform computer and mobile device forensic investigations. [Digital Forensics Specialization 7.0-14.0]

 

Course-level learning outcomes:

Course-level student learning outcomesDiscipline-level learning outcomesAssessment methods
Propose and use basic and advanced features of database software

T-1, T-2, T-3, B-2, B-3  

Homework, tests, quizzes
Evaluate and use the proper procedures to design and create professional database resources pertinent to the work and academic environments

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Formulate practical examples of a computer system as a useful database development resource

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Support basic database software operations

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes

 

Means of accomplishing learning outcomes:

In-Person

The instructor will:

  • Lecture and lead class discussions.
  • Assign readings from textbooks and/or other sources to supplement lectures.
  • Provide supplemental materials that align with the material presented in the textbook as appropriate.
  • Design assignments, quizzes, discussions, etc., to help students engage with the course material.
  • Use other teaching strategies to assist students in examining and understanding course materials as needed.
  • Provide timely feedback on assignments.
  • Hold weekly office hours to address questions and student needs outside of class time.

The students will:

  • Attend class regularly and be attentive to lectures.
  • Engage with class discussion.
  • Participate in student discussion groups.
  • Read assigned readings.
  • Complete assignments, quizzes, discussion boards, etc., as assigned by the instructor.

Online

The instructor will:

  • Lead class discussions.
  • Assign textbook and/or other readings.
  • Provide supplemental materials that align with the material presented in the textbook as appropriate.
  • Design assignments, quizzes, discussions, etc., to help students engage with the course material.
  • Use other teaching strategies to assist students in examining and understanding course materials as needed.
  • Provide timely feedback on assignments.
  • Hold weekly virtual office hours to address questions and student needs.

The students will:

  • Engage with the course regularly.
  • Engage with class discussions.
  • Participate in student discussion groups.
  • Read assigned readings.
  • Complete assignments, quizzes, discussion boards, etc. as assigned by instructor.

 

Printer-friendly Version:

Download Syllabus

 

College-wide policies and resources

For more specific information on Chipola's college-wide academic policies and resources available to students, visit the link below.

Policies & Resources