ISQS 3348-002 (54301), Database Management Systems

Spring 2016

Class Meeting: MWF, BA 025; 12:00p-12:50p

Instructor: Zhangxi Lin

Office hours: MW 17:30-19:00 at BA E311, or by appointment

Teaching Assistant: Tiju George

Homework submission:


Home | Schedule | Exercises | Projects | Attendance 



Course Description:

Database management systems (DBMSs) are sets of software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS can provide user data manipulation functions of definition, creation, querying, and update, and the administration of databases. This course is designed for students at the undergraduate level to learn fundamental skill of database management. The course will cover the following topics:


1.    Concepts of data management

2.    Data modeling

3.    SQL language applications

4.    Database application design

5.    Database management

6.    Web database processing

7.    An introduction to big data (using Azure, or VirtualBox)

Students will master the basic skills of Microsoft SQL Server.  Class discussions and team-based study are encouraged for better effectiveness and efficiency of the study.


Prerequisite: N/A


Learning Outcomes:

A student who successfully completes this course should be able to:

1.    Analyze and model general data management problems in an organization

2.    Skillfully use SQL language for data processing tasks

3.    Use Microsoft SQL Server to implement a database 

4.    Have a basic understanding of database security

5.    Understand the basic concepts of big data (using Azure, Citrix, or Virtualbox)


Assessment of Learning Outcomes:

     Learning will be assessed as follows:

1.    The ability to Analyze and model general data management problems by exercises, exams, and a term project.

2.    The skills in use SQL language for data processing tasks will be assessed by exercises, exams, and a term project.

3.    The understanding of concepts of big data will be assessed by exercises and exams.



1)    Students are expected to bring their own laptop computers for the class lab sessions.  Internet access is available.

2)    Shared network drive: \\techshare\coba\d\isqs3358\isqs3348 


University Policies:

Requirements:  Please contact me if you have any special requirements, or if I need to make special accommodations for you during the semester.  I encourage you to visit with me about your progress in the course at any time.

Integrity.  Academic dishonesty will not be tolerated.  All students are required to adhere to the Texas Tech University Policy on Academic Honesty

Civility in the Classroom.  “Students are expected to assist in maintaining a classroom environment which is conducive to learning.  In order to assure that all students have an opportunity to gain from time spent in class, unless otherwise approved by the instructor, students are prohibited from using cellular phones or beepers, eating or drinking in class, making offensive remarks, reading newspapers, sleeping or engaging in any other form of distraction.  Inappropriate behavior in the classroom shall result in, minimally, a request to leave class.” 

ADA Requirements.  Classroom accommodations will be made for students with disabilities, if requested.

Religious Holidays.  A student who intends to observe a religious holy day should make that intention known to the instructor prior to an absence. A student who is absent from classes for the observance of a religious holy day shall be allowed to take an examination or complete an assignment scheduled for that day within a reasonable time after the absence.


Required textbooks:

·         Database Concepts by David Kroenke and David Auer, 7th Edition, Published by Prentice Hall.

·         Supplemental Texts/Materials.

·         Downloadable course materials:

·         Unified Modeling Language Resource Website:

·         UML Specification:



Fundamentals of Database Management Systems, 2nd Edition; Mark L. Gillenson, Wiley

Hard copy: ISBN : 978-0-470-62470-8, 416 pages, December 2011, ©2012

E-Text: ISBN : 978-1-118-29789-6, 416 pages, January 2012, ©2012


Essentials of Database Management, Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman, ISBN-10: 0133405680 • ISBN-13: 9780133405682, ©2014 Prentice Hall

Paper, 408 pp, Published 06/17/2013

Grading Policy:

The total is 270 points.

Bonus credit is up to 10 points.


Previous studies showed that a student’s performance in a course is closely correlated to his/her class attendance. It is highly suggested that students attend all class meetings. Missing each class meeting will lose 5 points. If a student has to skip a class meeting for personal reasons, he/she needs to inform the instructor in advance. If the absence was caused by an unexpected situation, the written evidence must be presented to the instructor for the credit of the attendance points.


If a student needs to reschedule a test, he/she must contact the instructor before the scheduled test and show the instructor the evidence of the excuse, for example, a written note from a doctor for the medical problem.

Homework assignments:

Homework will be guided in the class. They can be taken home and turned in next class meeting. Assignments must be completed by the due date to be legible for grading. Late submission without good excuse will result in lower credit.


A major course requirement is the class project. You are required to work as a team (2-4 students per team).  You will build a prototype database application using SQL Server 2014 Express as a database server. Refer to the project handout for more details. Each project team member will evaluate the other project team member’s work on the project. The project grade of each team member will depend upon the peer-evaluation.

Each project team must schedule a meeting with the instructor before the due date to discuss the topic and working plan of the project.