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.
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)
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 - TBD (points T.B.D.)
- Mid-Term Test (points T.B.D.)
- Comprehensive Final Exam (points T.B.D., no exemptions)
- Compute total points awarded, divided by the total points possible,
then use scale: 90%=A, 80%=B, 70%=C, 60%=D, 59% and below=F.
- 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.
Unexcused absences will progressively deduct: 1%, 3%, 7%, 15%, 31%, 63%, 100% from your final percentage.
Tests and exams missed without an accepted excuse yield zero.
Acceptance of excused absence is at instructor's sole disgression. Documentation may be requested. Pre-approval is recommended.
- Cheating is not tolerated, period.
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.