CGS1545

Database Programming

Course Code: CGS 1545

Credit Hours: 3

Effective beginning: 2020-21

 

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:

Provided by Instructor

 

Assignment/course outline:

The following topics will be covered in this course at the discretion of the instructor:

  •  Applying Fundamental Database Software Skills & Tools
  •  Developing an Acumen for Database Software and Programming
  •  Organizing Information and for Effective Queries and Review 
  •  Enhancing Information Retrieval with a Clear Database Structure
  •  Troubleshooting Database Software Applications

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 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

 

 

  1. Attend and participate in class regularly.
  2. Read all assigned material before class.
  3. Study in-class notes and online (Canvas) materials.
  4. Complete assigned projects in a timely manner to enable reflections and revisions on the final product.
  5. Participate in discussions.
  6. Demonstrate your mastery of the required skills on quizzes, exams, etc.
  7. Complete all assignments with promptness and accuracy.
  8. All written documents as well as online assignments must be completed using correct grammar, spelling, and structure.

 

The grading breakdown is subject to change at the discretion of the instructor.

Quizzes

up to 40%

Test (which includes Midterm and Final) 

up to 60%

Assignments, Projects and/or Labs     

up to 40%

Participation

up to 20%

 

Please see your first day handout for individual instructor grading schemes.

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.