Database Programming Syllabus for 2014-2015
Return to Syllabus List

Instructor Information

Course Information

Recording Policy

Disability Statement

Any student who, because of a disabling condition, may require some special arrangements in order to meet course requirements should contact disAbility Services (Student Service Center room 119, phone 371-5436) as soon as possible.

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:

Administrative Drop Policy

N/A

Student Withdrawal Procedures

N/A

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-2309-002 Database Programming

Prerequisites

Prerequisite: BCIS 1305

Course Description

Database development using database programming techniques emphasizing database structures, modeling and database access.

Student Resources Student Resources Website

Department Expectations

\N

Occupational License Disclaimer

Hours

(3 sem hrs; 2 lec, 3 lab)

Class Type

Online Course

Syllabus Information

Textbooks

For this class, students must have:

Database Concepts, 7e, Kroenke and Auer

*Please note you must have, or access to, MS Access 2013.   As a CIS student, you may download a free copy of Access 2013 through Dreamspark. Details are given in class.

A SAM account.  You can use your SAM account from BCIS 1305 or ITSC 2335.  If you do not have a SAM account, you will need to purchase a SAM code from sam.cengage.com.

Supplies

Storage media (optional):  Flash drive

Student Performance

• Learn the elements of a database
• Learn the purpose of a DBMS
• Understand the functions of a database application
• Learn the conceptual foundation of the relational model
• Learn basic relational terminology
• Learn the meaning and importance of different types of keys
• Be able to model data using the Entity-Relational Model
• Transform the Entity Relational data model into relational designs
• Apply the normalization process
• Know how to represent weak entities
• Represent 1:1, 1:N and N:M binary relationships
• Represent 1:1, 1:N and N:M recursive relationships
• Learn SQL for creating database structures, adding data to a database, modifying and deleting data from a database, modifying and deleting tables and constraints
• Learn SQL SELECT statements and options for processing single and multiple table queries and subqueries, and joins
• Know basic administrative and mangerial DBA functions
• Understand the need for database administration including concurrency control, security, backup, recovery (reprocessing, rollback/rollforward)
• Understand locking, deadlock, optimistic, pessimistic locking
• Know the meaning of ACID transaction
• Learn the four 1992 ANSI standard isolation levels
• Know how to improve database security

Students 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

Grading Criteria

Final grades will be assigned as indicated below:

A - Superior, Minimum of 90% average on exams and quizzes plus all homework turned in with a 90% average on that graded.

B - Good, Between 80% and 89.49% average on exams and quizzes plus all homework turned in with a minimum average of 80% on that graded.

C - Adequate, Between 70% and 79.49% average on all work.

D - Minimum, Between 60% and 69.49% average on all work.

F - Failing, Below 60% average on all work.

Student grade will be based on the following:

Attendance

• Check your email daily and have assignments in on time.
• Attendance for on campus classes  will be taken during each class period.  Attendance for online classes will be determined by participation through homework assignments, discussions, exams and logging on to AC Online.

Calendar

Additional Information

New Social Services Office at Amarillo College

Resources for social services or emergency services for students are available at - http://www.actx.edu/resources/.  So please let me know if there is some situation that you have that is interfering with your performance in the class, and be sure to take advantage of the resources available through the Social Services Office.

CIS Labs
2nd floor Byrd Building.  Labs open 7 days a week.  Students can get help with this course as well as other technical help.

Helpful Links:

CIS Web Site: http://cis.actx.edu

Direct link to AC Connect portal and courses as well as your AC Connect email- https://acconnect.actx.edu/. You will log in with the same ID and password you use for WebAdvisor.  Contact AskAC (806-371-5000) for help if you have trouble with your log in.

AskAC -  http://www.actx.edu/contact/-   Please contact AskAC for technical help. Contact your instructor for help with this class. 

Student Help Center -  http://www.actx.edu/ctl/index.php?module=article&id=178-   Offers technical help to AC students 

Writers' Corner

If you feel you need help organizing and writing course work, check this out:
Writers’ Corner: Tutoring with Pizzazz - http://www.actx.edu/english/index.php?module=article&id=36. Writers' Corner is a great resource for help with writing papers and assignments. They can't help you with the content of your work, but they can help you write your work in the proper format.

AC Distance Education Home Page -  http://www.actx.edu/de/-   Information on requirements and taking an online course. 

Learn about using AC Connect (Blackboard) and using features of our course by reviewing the following tutorials:

Blackboard On Demand Learning Center for Students– http://ondemand.blackboard.com/students.htm

AC Connect Student Resources- http://www.actx.edu/ctl/index.php?module=article&id=222