INFS 410 Data Base Management Systems, Spring 2017
College of Business and Global Affairs
Department of Management, Marketing, and Information Systems
The University of Tennessee at Martin

This web page constitutes my official INFS 410 Course Syllabus, and was last modified (excluding calendar edits) on November 14, 2016. If you wish to have a printed copy of this syllabus, please print from your web browser. I reserve the right to modify my class policies at any time, and to make exceptions on a case-by-case basis. If there are any discrepancies between this syllabus and campus/college/departmental policy, the higher authority takes precedence, of course.
The imbedded calendar below uses a free online service that, unfortunately, results in advertisements. I do not endorse any of the ads. You can avoid seeing them, in Firefox, by using the free Adblock Plus add-in which I personally use and recommend.

Basic Information:

Course Section: INFS 410 section 001
Course Title: Data Base Management Systems
Credit Hours: 3
Meeting Time and Place: MWF, BA 33

Textbook and Materials:
"Database Processing - Fundamentals, Design, & Implementation"
by David M. Kroenke, 10th edition, Prentice Hall, ISBN 0-13-167267-3.
Important: do NOT purchase any other edition.

Faculty Contact Information:

Larry Holder (adjunct instructor)
Email: lholder@utm.edu
Website: www.utm.edu/staff/lholder
Phone: (731) 881-7890 (Office of Information Technology Services)
Address: 102 Crisp Hall (Computer Center)
Work Hours: Monday thru Friday, 8 a.m. to 5 p.m.
Office Hours (for student visits): Scheduling of appointments is highly recommended.

Course Information:

Course Description/Information:
Fundamentals of database processing. Network, hierarchical, and relational databases. Comparison of database systems. Database implementation.
CSCI 220 or CSCI 250 is a prerequisite.

Course Resources:
Canvas will be used only for assignment uploads. Microsoft Access, and Oracle on Linux, will be used.

Student Learning Outcomes/Objectives:
BSBA Learning Objectives related to the College Mission:

  1. BSBA 1 - Develop an understanding of the global aspects of business
  2. BSBA 2 - Have an understanding of the ethical aspects of business
  3. BSBA 3 - Demonstrate critical thinking skills
  4. BSBA 4 - Demonstrate effective verbal and written communication skills
  5. BSBA 5 - Demonstrate an understanding of the business core
  6. BSBA 6 - Demonstrate competence in information systems
Information Systems 410 does not address BSBA 2, 4.

Course Specific Objectives related to Course Description:
Students should gain an understanding and appreciation of the modeling, design, development, operation, maintenance, and management of databases.
Specific course objectives include:

  1. Learn the role of databases and database applications in contemporary organizations (BSBA 1, 5, 6)
  2. Learn and practice data modeling using the entity-relationship and semantic object models (BSBA 3, 6)
  3. Learn and practice developing database designs (BSBA 3, 6)
  4. Understand the use of SQL and learn SQL syntax (BSBA 3, 6)
  5. Learn emerging Internet technology that is relevant to database processing including the use of XML, ASP scripting, and OLE DB (BSBA 6)
  6. Understand the special needs of multi-user database processing and learn techniques for controlling the consequences of concurrent data access (BSBA 6)
  7. Learn the need for both database administration and data administration (BSBA 1, 6)
  8. Understand the issues involved in enterprise data sharing and learn the nature of data warehouses (BSBA 1, 6)
  9. Learn the features and functions of OLAP and understand its relationship to database processing (BSBA 6)
  10. Understand the need for object database management and learn the basics of the SQL3 and ODMG standards (BSBA 6)

Course communications:
Email is preferred. Most emails are responded to same day, except weekends.
For technical issues, contact the UTM Help Desk (www.utm.edu/helpdesk).

Course Requirements/Expectations:

Course Requirements, Assessments, Evaluations, Major Assignments, and Exams:

Course Outline:
I will cover material in the order that I determine as the class progresses. If you'd like to see how things were covered in prior terms, please go to the calendar, and view a past semester. Refer to Prior Syllabi for valid prior terms. The course will be taught with an emphasis on using Microsoft Access and Oracle (including writing SQL and PL/SQL). Assignment content is subject to change.

Calendar (you can also compare to past semesters):

University Policies:

Academic Integrity
The University of Tennessee at Martin has chosen as its primary objective quality undergraduate education. Commitment to this objective must include an obligation by all members of the University community to promote and protect the highest standards of in tegrity in study, research, instruction and evaluation. Dishonesty or unethical behavior does not belong at an institution dedicated to the promotion of knowledge and learning. Integrity of the academic process requires fair and impartial evaluation by faculty and honest academic conduct by students. Specific integrity attributes can be found at: www.utm.edu/departments/conduct/new_academic_integrity.php.

Standard of Conduct:
When persons enroll in The University of Tennessee at Martin, they retain the rights and duties of a citizen. Additionally, they must assume the duties and observe the regulations imposed by the University community. Specific conduct attributes can be found at: www.utm.edu/departments/conduct/conduct.php.

Disability Services:
The University of Tennessee provides reasonable accommodations (academic adjustments and auxiliary aids) to ensure equal access to educational content and university programs for students with disabilities. Students who are eligible for and who request accommodations through the Disability Services office must provide instructors with a letter of accommodation. The Disability Services office is located in the Student Success Center, 203 Clement Hall, (731) 881-7605.