Amarillo College Logo

Advanced Database Programming Syllabus for 2025-2026
Return to Syllabus List

Instructor Information

Instructor

Delane McUne (Curriculum Vitae)

E-Mail

delane.mcune@actx.edu

Phone

<p>(806) 371-5220 (Office)</p>

Office Location

BYRD 352

Office Hours

MW 1:00 PM - 3:30 PM  and TR 1:00 PM - 2:00 PM in BYRD 352

Students may contact me from 9:00 AM to 9:00 PM via text at (806) 340-0027.

Students may contact me by email through the course in Blackboard (Messages).  If you would like to schedule a specific day and time to meet, I have flexibility in my schedule.  Please do not hesitate to ask for a specific time if needed.

Course Information

AI Statement

Collusion is defined as “the unauthorized collaboration with another person or by any other means, including artificial intelligence (AI) and computer translators, in preparing work for fulfillment of course requirements.” Using AI like (ChatGPT or Google Gemini) to create a document is considered colluding. The use of Generative Artificial Intelligence on specific assignments is at the discretion of the instructor.

Title IX and Sexual Misconduct Reporting

Amarillo College prohibits discrimination and harassment based on sex, including sexual harassment, sexual assault, dating violence, domestic violence, and stalking, under Title IX and Texas Education Code §51.253–255. Faculty and staff are mandatory reporters and must share any related concerns with the Title IX Coordinator at titleix@actx.edu. Reports and additional information are available at https://www.actx.edu/hr/title-ixtitle-ix. Confidential counseling and advocacy services are available through the Counseling Center and Advocacy & Resource Center.

Recording Policy

Disability Statement

If you have a disability (learning, mental, physical) that affects your ability to participate effectively and have access to any program or service at Amarillo College please contact Disability Services at (806) 345-5639 . Our offices are located in the Enrollment Center, Suite 700. More information may be found at www.actx.edu/disability.
Disability Services facilitates access to all programs and services according to the ADA, Americans with Disabilities Act and Section 504 of the Rehabilitation Act, as well as other federal and state laws.

Amarillo College Web Accessibility Policy Statement

Amarillo College is committed to providing equal access to all programs and services, including all working, learning, and service environments that affect equal access for persons with disabilities. This commitment to provide equal access and opportunity for persons with disabilities is in compliance with federal and state law. Amarillo College also strives to provide Electronic and Information Resources (EIR) that are accessible to all authorized users.

If you find you are unable to access material in an accessible format please contact the Disability Services Office at (806) 345-5639 . This office will work in conjunction with other campus resources to address and accommodate your issue in a timely manner.

Statement for Mental Health and Advocacy & Resource Center:

As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student's ability to participate in daily activities. Amarillo College offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus by calling the AC Counseling Center at 806-371-5900. The AC Counseling Center website is https://www.actx.edu/counseling/ . Also, if you are in need of social services (affordable housing, utilities, transportation, food, clothing, childcare, medical/dental/vision, legal), please call the AC Advocacy & Resource Center at 806-371-5439. The AC Advocacy & Resource Center website is https://www.actx.edu/arc

Amarillo College Tutoring for Success Policy:

Tutoring for Success applies to any student whose overall performance in the course falls below 75%. The instructor will create the task in the Student Engagement Portal (Watermark) to direct the student to the appropriate tutoring service, which may be faculty- or SI-led, discipline-specific, and/or general. The tutoring service assigned, the due date for when the tutoring must be completed, and the amount of tutoring required are at the discretion of the instructor. Additionally, the task will alert the student’s success team. Students who do not fulfill the assigned tutoring task may be subject to program- and course-specific penalties that could result in a grade reduction and/or in not being allowed to progress in the course until the tutoring requirement has been satisfied.

Administrative Drop Policy

Students who do not attend class on or prior to the census date will be administratively dropped. Effective Fall, 2016

Student Withdrawal Procedures

Students who wish to withdraw from a course must complete all steps indicated on the Academic Withdrawal Request form by the course withdrawal deadline.

NOTE: Students who are attending Texas institutions of higher education, for the first time fall 2007 and later, may not withdraw from more than six courses during their academic career. This withdrawal limitation does not include dual credit or developmental classes (Senate Bill 1231 Rule 4.10.) For more information on Drop and Withdrawal Policies, please visit the Registrar's Office Web site.

Privacy Statement

The Amarillo College Privacy Policy is found at https://www.actx.edu/-amarillo-college-privacy-notice , and applies to all Amarillo College students.  If you have questions about this privacy statement or you believe that your personal information has been released without your consent, send email to humanresources@actx.edu .

Course

ITSE-2347-001 Advanced Database Programming

Prerequisites

Prerequisite: ITSE 2309

Course Description

Database development using complex database programming techniques emphasizing multiple interrelated files, menu design, security implementation and multiple access.

Student Resources Student Resources Website

Department Expectations

Occupational License Disclaimer

Notice to Students enrolled in an educational program for preparation of issuance of certain occupational licenses:

Students enrolled in an educational program in preparation for obtaining certain occupational licenses are potentially ineligible for such license if the student has been convicted of an offense. For further information, please contact:

Melodie Graves
Justice Involved Advocate
Student Service Center 117
mgraves24@actx.edu
806-371-5995
Make appointment at https://melodiegraves.youcanbook.me

You can also contact the Legal Clinic, or the faculty member in charge of the educational program that you seek to enroll in. The further information you will receive will include notification to you of your right to request a criminal history evaluation letter from the licensing authority in order to clarify your particular situation.

Hours

(3 sem hrs; 2 lec, 3 lab)

Class Type

On Campus Course

Syllabus Information

Textbooks

No Required Textbook

Supplies

  • Required Supplies

    • Access to PC
    • Reliable Access to Internet
    • USB Flash Drive (or other storage solution)
    • SQL Server Management Studio
    • Microsoft Visual Studio

Student Performance

STUDENT PERFORMANCE LEARNING OUTCOMES:  (minimum competencies)

Upon completion of this course, students will demonstrate mastery in the following domains, assessed by faculty within the department/program:

  • Implement database structure and query statements
  • Develop database applications using SQL
  • Implement database security and error trapping
  • Utilize SQL Indexes to improve query efficiency 

Students Rights and Responsibilities

Student Rights and Responsibilities

Log in using the AC Connect Portal

In order to receive your AC Connect Email, you must log in through AC Connect at https://acconnect.actx.edu .

If you are an active staff or faculty member according to Human Resources, use "Exchange". All other students, use "AC Connect (Google) Email".

Expected Student Behavior

Students are expected to maintain a high standard of individual honor in their scholastic work. Students who are guilty of cheating, plagiarism, copying, or dishonesty may be excluded from class with a grade of F; or, in flagrant cases, may be suspended from the College. The faculty of the CIS Department reserves the right to ask a student to verify any portion of a test by reproducing any specific section or all of the test in question.

Any action that compromises the computer systems at Amarillo College, including but not limited to hacking or cracking, can result in a grade of “F” in this course and possible further disciplinary action.

AI Policy
Students are permitted to use AI tools (such as chatbots or AI-assisted software) for learning and research purposes, but the use of AI for completing assignments, tests, or any other graded activities must be done in compliance with academic integrity. AI-generated content must be cited properly, and any attempt to pass off AI-generated work as your own without acknowledgment is considered plagiarism and will be subject to the same penalties. Misuse of AI in any form will result in disciplinary action, including but not limited to a grade of F for the assignment or course.

Grading Criteria

Grade categories:

Assignments                            60%

Exams                                      30%

Participation and Attendance  10%

Letter grade scale:

A: >=89.5

B: >=79.5

C: >=69.5

D: >=59.5

F: <59.5

The assignment with the lowest grade will be dropped.

Attendance

  • All Week 1 assignments must be completed by the end of Week 1 in order to be considered Present in the course. Failure to complete all assignments by this date may lead to an administrative drop from the course.
  • Check your email daily.  The email address used by your instructor is the @amarillocollege.com email issued to each AC student. Your instructor will communicate important course updates, guidance, and hints via email.
  • Complete assignments by the scheduled date/time.  There is a "no late work" policy, except in extreme circumstances.
  • Attendance for seated classes will be taken during each class period. Excessive absence or lack of participation may result in failure of the course.
  • Students should plan on spending a minimum of 10-12 hours per week OUTSIDE of class on this course. Actual amounts will vary depending on weekly assignments and topic complexity.
  • Due to the nature of this course and the volume of work required to master this material, students are rarely successful when attempts are made to complete work during one or two days each week. Please schedule your time, so that you can devote the appropriate energy and effort to achieve success in this course.
  • Your instructor, Delane McUne, may be contacted by email through the Messages feature in Blackboard. If Blackboard is not available, please email delane.mcune@actx.edu. In-person meetings or additional help are available if needed or desired. Please contact by email to set up a convenient day/time.
  • Emails are typically answered within 24 hours. If you do not receive a response within that time frame, please resend your message as a reminder.

Calendar

Tentative Course Schedule

Week 1 - Introduction to Database Systems

Week 2 - SQL Server Setup and Basic SQL

Week 3 - SQL Queries 

Week 4  - SQL Queries Cont.

Week 5 - Midterm Exam; Integrating Databases and Applications

Week 6 - SQLite / MySQL Databases

Week 7 - NoSQL / MongoDB Databases

Week 8 - Final Exam

Additional Information

IMPORTANT DATES TO REMEMBER:

March 23:                   Spring 2 Classes Begin
March 30:                   Census Day (Administrative Drop for Non-Attendance)
April 3 - April 5:           Easter Holiday (AC Closed)
April 6:                        Summer 2026 / Fall 2026 Registration Begins
May 5:                         Last Day to Withdraw from Course
May 14:                       Last Day of Course
May 15:                       Spring Commencement

TECHNOLOGY & COMPUTING ISSUES
  • Open Computer Labs: Open labs are available in the WARE building on the Washington Street campus. Technical assistance is available in the computer labs.
  • Computer Services Center: Located within the AC Bookstore, trained staff will diagnose computer-related issues and repair problems on a fee-for-service basis. Laptop rentals are also available. Visit the Computer Services Center website for additional details: https://www.actx.edu/bookstore/computer-service-center.
  • Student & Faculty Help Center: Located on the second floor of Ware Student Commons, the Help Center provides technical support to students and faculty. The Help Center offers assistance in logging into AC Connect, Blackboard, resetting passwords, and general computing and software questions. Visit the Student & Faculty Help Center website at https://www.actx.edu/ctl/helpcenter.
COURSE ASSISTANCE
PERSONAL ISSUES
  • Advocacy & Resource Center: The Advocacy & Resource Center is located on the first floor of Ware Student Commons. A variety of resources are available in the areas of social services, a food pantry, a clothing closet, and adult student programs. Visit the Advocacy & Resource Center website at http://www.actx.edu/arc/advocacy-and-resource-center.
  • Counseling Center: At the Counseling Center, student and counselor work together to develop more personal awareness and the skills needed to overcome barriers to success. All services are free and confidential. Visit the Counseling Center website at: https://www.actx.edu/counseling/index.php.

Syllabus Created on:

03/21/26 5:33 PM

Last Edited on:

03/22/26 5:09 PM