ITSE 1303-002 (91182): ONL- Course instruction and testing are fully online without required class times.

Instructor’s Name:  Sajida Faiyaz

Office Hours:  Monday & Wednesday 1:00 pm to 3:00 pm (By appointment only)

Office:  TBA

Phone:  TBA

E-mail: sajida.faiyaz@austincc.edu

STUDENTS EXPECT TO RECEIVE A RETURN EMAIL WITHIN 24 HOURS.

NOTE: DO NOT SEND ME ANY EMAILS VIA BLACKBOARD

PREREQUISITES

To enroll in this course, students should:

COSC1315 Fundamentals of Programming, COSC1336 Programming Fundamentals or department approval.

Credit Hours: 3

An introduction to the fundamentals of SQL and relational databases using database programming techniques emphasizing database structures, modeling, and database access. This course instructs the student in the essential concepts and design methodology for the Relational Database Model as implemented in MySQL.

Instructional Methodology

This course is a competency based course introducing database concepts using MySQL.  During each module, the students will develop their skills and demonstrate their competency in the material.  The instructor’s ability to evaluate students’ progress is founded on observing the quality of their work.

Course Rationale

This course is aimed at the student who is interested in developing solutions using databases.  Students are provided an opportunity to obtain real life experiences. Practicing professionals may upgrade their job skills.

 REQUIRED TEXTBOOK:                        

Approved Course Text:  Set by taskforce.

The only required textbook is Murach's MySQL, 3rd Edition     

by Joel Murach,

ISBN 978-1943872367.

By the end of the course, students will be able:

• Recognize the basic concepts of the analysis and design of a database.
• Summarize the process of Database Development and Administration using SQL.
• Enhance Programming and Software Engineering skills and techniques using SQL.
• Develop a basic understanding of background materials needed for technical support using SQL.
• Solve Database problems using MySQL by applying SQL commands to Create, Insert, Update, and Retrieve a simple database.
• Recognize the services provided by a Database Management System. Recognize the use and application of the Relational Database Model.
• Recognize Transaction Processing and Multi-user Database support.
• Recognize the difference between a Production transaction database and a Data Warehouse.
• Recognize the Client/Server structures used in Database Management Systems.
• Develop and complete the design and Implementation of a basic database solution using the MySQL Database Management System.

The web site https://www.mysql.com/ is an excellent reference for all things MySQL. 

The only required textbook is Murach's MySQL, 3rd Edition by Joel Murach, ISBN 978-1943872367.

The Database Systems book is not required for this section.

Supplies

Student has access to a computer capable of running MySQL Community Server and MySQL Workbench. MySQL Workbench has options for user accessibility.

COMPUTER/LAPTOP RECOMMENDATION FOR STUDENTS:

1.  i5 Intel Processor (but i7 is better)

2.  16GB RAM (32GB RAM is better)

3.  500GB SSD Hard drive (500GB/1TB NVME M.2 Hard drive is better)

The course is graded using this breakdown of assignments.

LETTER GRADE ASSIGNMENT

             Austin Community College’s (ACC) grading system is as follows:

MAKE UP EXAMS

If an Exam is missed, you will have made arrangements with the instructor in advance and have 1 week to take the make-up Exam.

Taking the makeup Exam is subject to Instructor approval.

IF NO PRIOR NOTIFICATION IS MADE, THE EXAMINATION SCORE WILL BE A ZERO.

THE FORMAT OF THE MAKE-UP EXAM WILL DIFFER FROM THAT OF THE REGULAR EXAM.

For in-classroom courses:

Regular and punctual class and laboratory attendance is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class for non-compliance.

For online courses:

Regular and timely use of Blackboard participation in discussions and completion of work is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class for non-compliance.

In the event the college or campus closes due to unforeseen circumstances (for example, severe weather or other    

Emergency), the student is responsible for communicating with their professor during the closure and completing any.  

Assignments or other activities designated by their professor as a result of class sessions being missed.

• Each student is responsible for monitoring his/her email account frequently. 
• Students should check for e-mail and class announcements
• Students are expected to find out class assignments for missed classes and make up missed work. 
• Students are expected to find out if any changes have been made in the class or assignment schedule.
• Students are responsible for submitting a completed assignment. Make sure it is submitted otherwise you earn a zero.
• Written work must be presented in a professional manner. Work that is not submitted in a professional manner will not be evaluated and will be returned as unacceptable.
  • There is a craft to writing.  Spelling, grammar, punctuation and diction (word usage) are all tools of that craft.  Writing at the collegiate level will show careful attention to these elements of craft.  Work that does not exhibit care with regard to these elements will be considered as inadequate for college writing and graded accordingly. 
• Students are expected to take the examinations on the designated dates.  If you are unable to take the exam on the scheduled date and know in advance, you are to make arrangements with your professor before the designated date.   

Withdrawal policy

The College defines withdrawals as occurring after the official reporting date of the semester, typically the 12th class day.  In addition, the Legislature has mandated the Rule of Six.

It is the responsibility of each student to ensure that his or her name is removed from the rolls should they decide to withdraw from the class.  The instructor does, however, reserve the right to drop a student should he or she feel it is necessary for non-compliance.  If a student decides to withdraw, he or she should also verify that the withdrawal is recorded before the Final Withdrawal Date.  The Final Withdrawal Date for this semester is Nov 21st, 2024.  The student is also strongly encouraged to keep any paperwork in case a problem arises.

Students are responsible for understanding the impact that withdrawal from a course may have on their financial aid, veterans’ benefits, and international student status.  Per state law, students enrolling for the first time in Fall 2007 or later at any public Texas college or university may not withdraw (receive a W) from more than six courses during their undergraduate college education. Some exemptions for good cause could allow a student to withdraw from a course without having it count toward this limit. Students are strongly encouraged to meet with an advisor when making decisions about course selection, course loads, and course withdrawals.

Incomplete:

     A student may receive a temporary grade of “I” (Incomplete) at the end of the semester only if.    

• ALL of the following conditions are satisfied:
• The student is unable to complete the course during the semester due to circumstances beyond their control.
• The student must have earned at least half of the grade points needed for a “C” by the end of the semester.
• The request for the grade must be made in person at the instructor’s office and necessary documents completed.
• To remove an “I”, the student must complete the course by two weeks before the end of the following semester. 
• Failure to do so will result in the grade automatically reverting to an “F”.

EMAIL

To help you, I need to know who you are, which class you belong to, and the nature of your question.  So, it is very important to follow this procedure regarding sending emails:

Give an appropriate subject line: the subject line of every email must have:

Your last name, class number, class section and the activity you are questioning.

            Example: smith, ITSE 1303, section number, project question

            Example: smith, ITSE 1303, section number, general question

If I answered your question, but you have a follow-up question, then click on “reply” and type your new question at the top of the email chain.

Failure to put the correct information in the subject line could mean that you miss the deadline for the activity because the email will be returned to you requesting the appropriate subject line.

Statement on Academic Integrity

Austin Community College values academic integrity in the educational process.  Acts of academic dishonesty/misconduct undermine the learning process, present a disadvantage to students who earn credit honestly, and subvert the academic mission of the institution. The potential consequences of fraudulent credentials raise additional concerns for individuals and communities beyond campus who rely on institutions of higher learning to certify students' academic achievements and expect to benefit from the claimed knowledge and skills of their graduates. Students must follow all instructions given by faculty or designated college representatives when taking examinations, placement assessments, tests, quizzes, and evaluations.  Actions constituting scholastic dishonesty include, but are not limited to, plagiarism, cheating, fabrication, collusion, falsifying documents, or the inappropriate use of the college’s information technology resources.  Further information is available at https://www.austincc.edu/about-acc/academic-integrity-and-disciplinary-process.

Any course specific policies, expectations, or procedures could be included here.

Student Rights & Responsibilities

Academic freedom is a foundation and hallmark of higher education.  In the context of college-level courses, it specifically refers to the rights of free expression and respect for others with differing opinions.  Students at the college have the rights accorded by the U.S. Constitution to freedom of speech, peaceful assembly, petition, and association. This concept is accompanied by an equally demanding concept of responsibility on the part of the student.  Just as you are expected to exercise these rights with respect for state and federal law in the larger world, you are expected to exercise these rights as a student with respect for the college’s standards of conduct.  These rights carry with them the responsibility to accord the same rights to others in the college community and not to interfere with or disrupt the educational process.  Students and faculty alike should create a climate of mutual respect and civility while fostering the freedom to debate and discuss the merits of competing ideas.

Enrollment in the college indicates acceptance of the rules set forth in the student standards of conduct policy, which is administered through the office of the campus dean of student services. Due process, through an investigation and appeal process, is assured to any student involved in disciplinary action.

Student Complaints

A defined process applies to complaints about an instructor or other college employee. You are encouraged to discuss concerns and complaints with college personnel and should expect a timely and appropriate response. When possible, students should first address their concerns through informal conferences with those immediately involved; formal due process is available when informal resolution cannot be achieved.

Student complaints may include (but are not limited to) issues regarding classroom instruction, college services and offices on the basis of actual or perceived race, color, national origin, religion, age, gender, gender identity, sexual orientation, political affiliation, or disability.

Further information about the complaints process, including the form used to submit complaints, is available at: http://www.austincc.edu/students/students-rights-and-responsibilities/student-complaint-procedures

Statement on Privacy

The Family Educational Rights and Privacy Act (FERPA) protects confidentiality of students’ educational records. Grades cannot be provided by faculty over the phone, by e-mail, or to a fellow student.

Grades are posted on Blackboard – also of note – a weighted average method is used.

Safety Statement

Health and safety are of paramount importance in classrooms, laboratories, and field activities. Students are expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies.  Emergency Procedures posters and Campus Safety Plans are posted in each classroom and should be reviewed at the beginning of each semester.  All incidents (injuries/illness/fire/property damage/near miss) should be immediately reported to the course instructor. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency

Everyone is expected to conduct themselves professionally with respect and courtesy to all. Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual may be immediately dismissed from the day’s activity and will be referred to the Dean of Student Services for disciplinary action.

In the event of disruption of normal classroom activities due to an emergency situation or an illness outbreak, the format for this course may be modified to enable completion of the course. In that event, students will be provided an addendum to the class syllabus that will supersede the original version.

Campus Carry

The Austin Community College District concealed handgun policy ensures compliance with Section 411.2031 of the Texas Government Code (also known as the Campus Carry Law), while maintaining ACC’s commitment to provide a safe environment for its students, faculty, staff, and visitors.  Beginning August 1, 2017, individuals who are licensed to carry (LTC) may do so on campus premises except in locations and at activities prohibited by state or federal law, or the college’s concealed handgun policy.  In addition, concealed weapons are not allowed on ACC-sponsored field trips where the school owns or has chartered or leased vehicles for transportation.   

It is the responsibility of license holders to conceal their handguns at all times.  Persons who see a handgun on campus are asked to contact the ACC Police Department by dialing 222 from a campus phone or 512-223-7999.   Please refer to the concealed handgun policy online at http://austincc.edu/campuscarry 

Discrimination Prohibited

The College seeks to maintain an educational environment free from any form of discrimination or harassment including but not limited to discrimination or harassment on the basis of race, color, national origin, religion, age, sex, gender, sexual orientation, gender identity, or disability.

Faculty at the College are required to report concerns regarding sexual misconduct (including all forms of sexual harassment and sex and gender-based discrimination) to the Manager of Title IX/Title VI/ADA Compliance.  Licensed clinical counselors are available across the district and serve as confidential resources for students.

Additional information about Title VI, Title IX, and ADA compliance can be found in the ACC Compliance Resource Guide available at: https://drive.google.com/file/d/1o55xinawnvtygi-fs-jbdyuamfdnvajz/view.

Use of ACC email

All College e-mail communication to students will be sent solely to the student’s accmail account, with the expectation that such communications will be read in a timely fashion. ACC will send important information and will notify students at any college- related emergencies using this account. Students should only expect to receive email communication from their instructor using this account.  Likewise, students should use their accmail account when communicating with instructors and staff.  Information about ACC email accounts, including instructions for accessing it, are available at:  http://www.austincc.edu/help/accmail/questions-and-answers

STUDENT SUPPORT SERVICES

The success of our students is paramount, and ACC offers a variety of support services to help, as well as providing numerous opportunities for community engagement and personal growth.

Student Support

ACC strives to provide exemplary support to its students and offers a broad variety of opportunities and services.  Information on these campus services and resources is available at  http://www.austincc.edu/students.

Student Accessibility Services

Students with documented disabilities who need classroom, academic, or other accommodations must request them through the office Student Accessibility Services (SAS).   SAS offices are located at each major campus.  Students are encouraged to request accommodation when they register for courses or at least three weeks before the start of the semester; otherwise, the provision of accommodation may be delayed.  Students who have received approval for accommodations from SAS for this course must provide the instructor with the document titled “Notice of Approved Accommodations” from SAS before accommodations will be provided. Accommodation will not be provided retroactively.  Arrangements by the instructor for academic accommodations can only be made after he or she receives the “Notice of Approved Accommodations” from the student.

Additional information about Student Accessibility Services is available at https://www.austincc.edu/offices/student-accessibility-services-and-assistive-technology

Academic Support

ACC offers academic support services on all of its campuses. These services, which include face-to-face and online tutoring, academic coaching, and supplemental instruction, are free to enrolled ACC students. Tutors are available in a variety of subjects ranging from accounting to pharmacology. Students may receive these services on both a drop-in and referral basis. Tutoring schedules can be found at:  https://www.austincc.edu/students/tutoring/tutoring-schedules

Library Services

ACC has a full-service library at each of its campuses to support ACC courses and programs and to provide students with research and assignment assistance from expert faculty librarians, computers, course reserves, laptop and tablet check out, study spaces, and copying, printing, and scanning services.  In addition, ACC students have full rights and privileges to access Library Services online 24/7 via the ACC Library website and students can use their acceid logins to access all online materials, including ebooks, articles from library databases, and streaming videos.   ACC Libraries also provide an “Ask a Librarian” service, which allows students to reach a librarian 24/7 through online chat.  Faculty librarians are also available via email, phone, and in person seven days a week during hours of operation. Visit:

• Library Website: http://library.austincc.edu
• Ask a Librarian: https://library.austincc.edu/help/ask.php
• Library Hours of Operation by Location: https://library.austincc.edu/loc/
• Email: library@austincc.edu

In partnership with ACC’s Student Support Center, ACC Libraries also maintain a limited collection of textbooks for students to borrow. Priority access to the textbook collection is given to students receiving assistance. More information is available on the ACC website by searching “Student Support Center Textbook Collection.”

Student Organizations

ACC has over seventy student organizations, offering a variety of cultural, academic, vocational, and social opportunities.  They provide a chance to meet with other students who have the same interests, engage in service-learning, participate in intramural sports, gain valuable field experience related to career goals, and much else.  Student Life coordinates many of these activities, and additional information is available at http://sites.austincc.edu/sl/.

Personal Support

Resources to support students are available at every campus. To learn more, ask your professor or visit the campus Support Center. All resources and services are free and confidential. Some examples include, among others:

• Food pantries are located in all campus Student Life offices: https://sites.austincc.edu/sl/programs/foodpantry/.   
• Assistance with childcare or utility bills is available at any campus Support Center:         http://www.austincc.edu/students/support-center.
• The Student Emergency Fund can help with unexpected expenses that may cause you to withdraw from one or more classes: http://www.austincc.edu/SEF.
• Help with budgeting for college and family life is available through the Student Money Management Office: http://sites.austincc.edu/money/.  
• Drop-in child care is available at Highland Campus: http://www.austincc.edu/students/child-care/child-watch-drop-in-center

Clinical Counseling services are available throughout the ACC Student Services District to address personal and or mental health concerns: http://www.austincc.edu/students/counseling .

If an emergency occurs during operational hours, please come to the Student Services Office and let the front intake staff know that you are experiencing a crisis. They will alert appropriate personnel. You may also contact the ACC District Police at 222 (on campus) or 223-7999 (off campus or cell phone).

After Hours:

If you are struggling with a mental health or personal crisis, call one of the following numbers to connect with resources for help. However, if you are afraid that you might hurt yourself or someone else, call 911 immediately.

Free Crisis Hotline Numbers:

• Austin / Travis County 24-hour Crisis & Suicide hotline: 512-472-HELP (4357)
• The Williamson County 24-hour Crisis hotline: 1-800-841-1255
• Bastrop County Family Crisis Center hotline: 1-888-311-7755
• Hays County 24 Hour Crisis Hotline: 1-877-466-0660
• National Suicide Prevention Lifeline: 1-800-273-TALK (8255)
• Crisis Text Line: Text “home” to 741741
• Substance Abuse and Mental Health Services Administration (SAMHSA) National Helpline:   1-800-662-HELP (4357)
• National Alliance on Mental Illness (NAMI) Helpline:1-800-950-NAMI (6264)

TENTATIVE COURSE SCHEDULE

Readings are to be completed prior to class where listed.