This web page constitutes my official INFS 410 Course Syllabus, and was last
modified (excluding calendar edits) on April 29, 2019.
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.
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: None
Faculty Contact Information:
Larry Holder (adjunct instructor)
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.
Current catalog information:
Fundamentals of database processing.
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.
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:
INFS 410 does not address BSBA 2
- BSBA 1 - Develop an understanding of the global aspects of business
- BSBA 2 - Have an understanding of the ethical aspects of business
- BSBA 3 - Demonstrate critical thinking skills
- BSBA 4 - Demonstrate effective verbal and written communication skills
- BSBA 5 - Demonstrate an understanding of the business core
- BSBA 6 - Demonstrate competence in information systems
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:
- Learn the role of relational databases in contemporary organizations. (BSBA 1, 5, 6)
- Learn essential concepts including primary keys, foreign keys, and normalization. (BSBA 3, 6)
- Learn and practice data modeling using the entity-relationship model. (BSBA 3, 6)
- Learn the basic internal structure of common relational databases such as Microsoft Access and Oracle. (BSBA 3, 6)
- Learn and practice the design and development of relational databases. (BSBA 3, 4, 6)
- Learn and practice the use of SQL for both DML
and DDL. (BSBA 3, 6)
- Learn allied topics such as
XML, data warehousing, and data administration. (BSBA 1, 5, 6)
Email is preferred. Most emails are responded to same day, except weekends.
For technical issues, contact the UTM Help Desk (www.utm.edu/helpdesk).
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:
- Assignments - Progressive work on individual database projects
- (No Mid-Term Test)
- Comprehensive Final Exam (no exemptions)
- All students who have sufficiently completed their database projects
(including a presentation) will walk into the final exam with an "A".
(in future terms, this will be amended to walk into the final exam with an "A" or "B" or "C").
The final exam will determine whether the final grade is an "A" or a "B"
(in future terms, this will be amended to the grade walked in with or one lower letter grade),
at the disgression of the instructor, reflecting the overall competency of the student.
Failure to sufficiently complete and present a database project is a final grade of "F" (and barred from final exam).
Failure to take the final exam is a final grade of "D".
- Assignments are due by 11:59 p.m. on the due date, uploaded to Canvas (unless otherwise specified).
Late assignments will not be accepted.
It is your responsiblity to consider all factors necessary to complete and submit the work on time,
including, but not limited to:
having a backup of your work in case you lose the original,
having access to another computer in case you are not able to use your primary computer,
finding Internet access at times when such access might not be available at the times and places you'd prefer.
- Attendance is mandatory. Excessive absence, at the digression of the instructor, may lower the final grade.
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:
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:
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.