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.
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 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)
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.
Fundamentals of database processing.
and relational databases. Comparison of database systems. Database implementation.
CSCI 220 or CSCI 250 is a prerequisite.
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:
Information Systems 410 does not address BSBA 2, 4.
- 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
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:
- Learn the role of databases and database applications in contemporary organizations (BSBA 1, 5, 6)
- Learn and practice data modeling using the entity-relationship
and semantic object models (BSBA 3, 6)
- Learn and practice developing database designs (BSBA 3, 6)
- Understand the use of SQL and learn SQL syntax (BSBA 3, 6)
- Learn emerging Internet technology that is relevant to database processing
including the use of XML,
ASP scripting, and OLE DB (BSBA 6)
- Understand the special needs of multi-user database processing and learn techniques
for controlling the consequences of concurrent data access (BSBA 6)
- Learn the need for both database administration and data administration (BSBA 1, 6)
- Understand the issues involved in enterprise data sharing and learn the nature of data warehouses (BSBA 1, 6)
Learn the features and functions of OLAP and understand its relationship to database processing (BSBA 6)
Understand the need for object database management and learn the basics of the SQL3 and ODMG standards (BSBA 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).
Course Requirements, Assessments, Evaluations, Major Assignments, and Exams:
- Assignment #1 - Chapter 2, Morgan Imports queries (50 points)
Assignment #2 - Access airline tables (200 points)
Assignment #3 - Linux / Oracle scripts (100 points)
Assignment #4 - Oracle airline tables and inserts (250 points)
Assignment #5 - PL/SQL query with cursor (50 points)
- Mid-Term Test (200 points)
- Comprehensive Final Exam (700 points, no exemptions)
- Testing is about 58% of the grade (900 points), assignments about 42% of the grade (650 points).
- 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.
Each unexcused absence will deduct 1% from your final percentage.
Additionally, 5 or more cumulative unexcused absences will reduce your grade by a full letter (A to B, etc).
Tests and exams missed without an accepted excuse yield zero.
Acceptance of excused absence is at instructor's sole disgression. Documentation may be requested.
- Cheating is not tolerated, period.
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):
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:
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:
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.