INFS 410 Data Base Management Systems, Spring 2019
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 29, 2018. 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, noon, BA 33

Textbook and Materials:
Database Design, 2nd Edition (Adrienne Watt and Nelson Eng) - free digital textbook

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:
Current catalog information:
Fundamentals of database processing. Network, hierarchical, and relational databases. Comparison of database systems. Database implementation.
CSCI 220 or CSCI 250 is a prerequisite.

Proposed catalog information:
Fundamentals of relational databases, including design, development, maintenance, and operation.
No programming prerequisites.

Course Resources:
Canvas will be used only for assignment uploads. Microsoft Access 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
INFS 410 does not address BSBA 2
BSBA 4 is addressed via class presentation of a database design (objective 5 below)

Course Specific Objectives (new for Spring 2019) related to Course Description:
Students should gain an understanding and appreciation of the design, development, maintenance, and operation of relational databases.

Specific course objectives (new for Spring 2019) include:

  1. Learn the role of relational databases in contemporary organizations. (BSBA 1, 5, 6)
  2. Learn essential concepts including primary keys, foreign keys, and normalization. (BSBA 3, 6)
  3. Learn and practice data modeling using the entity-relationship model. (BSBA 3, 6)
  4. Learn the basic internal structure of common relational databases such as Microsoft Access and Oracle. (BSBA 3, 6)
  5. Learn and practice the design and development of relational databases. (BSBA 3, 4, 6)
  6. Learn and practice the use of SQL for both DML and DDL. (BSBA 3, 6)
  7. Learn allied topics such as XML, data warehousing, and data administration. (BSBA 1, 5, 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:

This is a senior-level course. Be prepared to put in the time and effort. Slacking is not tolerated.

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

Course Outline:
I will cover material in the order that I determine as the class progresses. The course will be taught with an emphasis on using Microsoft Access for database design and development, and an emphasis on writing SQL. Assignment content is subject to change. Starting Spring 2019, I will continue to mention Oracle, but I will remove design/development in Oracle (including PL/SQL programming), as well as the use of the Linux operating system. The latter were skills that were a carry-over from CSCI 410, from which INFS 410 later spun off.

Calendar (you can also compare to past semesters):

University, College, and Departmental Policies:

Academic Integrity (University):
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 (University):
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.

Mission Statement (College):
Mission statement of the College of Business and Global Affairs

Ethics Statement (College):
Ethics statement of the College of Business and Global Affairs

Disability Services (University):
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.