TROY UNIVERSITY
MASTER SYLLABUS
SORRELL COLLEGE OF BUSINESS

IS 3346
Database Management Systems I

Instructor: / Dr. Dazhong Wu
Office Hours / MW: 11 a.m. – Noon; 1 p.m. – 3 p.m.
TTH: 10 a.m. – Noon;
Office Location: / 231C Bibb Graves Hall
Telephone Numbers: / 670-3941 Office
670-3413 or 670-3459 Secretary
670-3599 FAX
Email: /
Subject line: IS 3310, your Last Name, your First Name, Reason for Email
[Do this on every email]
Time of Class: / T/TH 1:00 -2:15p.m.
Class Location: / Bibb Graves 237

Prerequisites

IS 2241 or consent of instructor

Description

This course is designed for those who want to be information systems analysts, consultants, or "power" users of databases – hence, those who may want to design and build databases. Understanding the evolving nature of database management technology is a core competency of an information system professional or a serious user of IT. The course covers the concepts, techniques, and tools necessary to convert a logical system design into a working application using a relational DBMS. Conceptual data modeling, logical database design, and web based database applications are covered, among others. DBMS functions and the SQL language are also covered. Students use Microsoft Access and SQL Server DBMSs.

Please note that this course covers technical material. Typically, you will not truly understand the material without practicing again and again. The instructor expects that you will devote on average about 3 hours per week outside of class to this course, including reading and practicing.

Objectives

On completion of the course, the student should be able to:

  1. List and describe the advantages of a relational DBMS compared to other data stores.
  2. List and describe the components of a relational DBMS.
  3. Use design tools to create a relational DBMS prototype. This is the focus of this class.
  4. Use data definition language (DDL) and a graphical user interface (GUI) to create and delete relational DBMS objects.
  5. Use data manipulation language (DML) and a GUI to create queries and views for input, output, and data modification.

Purpose

To introduce data and DBMS in a business environment, including how data are organized and managed by relational DBMS, and how to design, create, and maintain a relational DBMS.

Approved Texts

Coronel, Morris, and Rob, Database Systems: Design, Implementation and Management (10thed), Course Technology.

Grading

You will be evaluated based on the following grading scheme:

  • Two Tests (@ 20% each)40%
  • Final Exam30%
  • Homework (there will be 5 homework assignments)20%
  • Group Project5%
  • Class Attendance5%

Grade

/

Percent

A / 90-100%
B / 80-89%
C / 70-79%
D / 60-69%
F / 0-69%

A student caught cheating or plagiarizing will be given a course grade of F.

Sorrell College of Business Vision / Sorrell College of Business will be the first choice for higher business education students in their quest to succeed in a dynamic and global economy. Sorrell College of Business will create the model for 21st century business education and community service.
Sorrell College of Business Mission / Through operations that span the State of Alabama, the United States, and the world, Sorrell College of Business equips our students with the knowledge, skills, abilities and competencies to become organizational and community leaders who make a difference in the global village and global economy. Through this endeavor, we serve students, employers, faculty, and Troy University at large as well as the local and global communities
Additional Services: / AMERICANS WITH DISABILITIES ACT: Troy University supports Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, which insure that postsecondary students with disabilities have equal access to all academic programs, physical access to all buildings, facilities and events, and are not discriminated against on the basis of disability. Eligible students, with appropriate documentation, will be provided equal opportunity to demonstrate their academic skills and potential through the provision of academic adaptations and reasonable accommodations. Further information, including appropriate contact information, can be found at the link for Troy University’s Office of Human Resources at
Absenteeism: / Each student is expected to attend all scheduled classes. It is the student's responsibility to obtain all information and materials presented in the classroom (including materials covered, handouts, and assignments) during his or her absence. Exams will include not only the material from the assigned chapters in the text and assigned readings, but also from any other materials covered during class lectures.
Attendance Policy: / 1.Class Roll: Class roll will be taken at the beginning of the class session
2.Attendance is mandatory. If a student misses a class it is his/her responsibility to obtain all information and materials presented (including materials covered, handouts, skills learned, and homework assignments) during his/her absence.
3.Excused absences: Excused absences have the following characteristics:
a. Professor was informed prior to the absence.
b. Professor determines that the absence is excused.
c. Absence is of the following type:
1. Participation in a documented official university function that does not permit the student’s class attendance (e.g., participation in athletic events, field trips, etc.)
2. Severe illness (this does not include scheduled medical appointments nor driving someone else to doctor), a hospital stay, or a doctor's excuse saying that it is impossible for student to attend class(es)
3. Death of immediate family member (grandparent, parent, sibling, or child)
4. Appearance in court
5. Family emergencies involving an immediate family member (grandparent, parent, sibling, or child)
6. Personal situations that are approved by the professor in advance of the time the student is to be absent
d. Written documentation (on letterhead) must be provided.
4.A deduction will be made to the student’s course grade for unexcused absences.
Incomplete Work Policy: / Any incomplete work at the end of the term will not be accepted unless the student can provide acceptable and clear documentation prior to grades being submitted to the Registrar.
Test Policy / TEST POLICY:
The use of electronic devices (e.g., cell phone, E-dictionary, calculator, PDA) is prohibited and will cause a student to receive a failing grade for the course. Make-up exams will be given only for documented (on letterhead), approved absences. See ATTENDANCE POLICY. Make up exams are administered only to students who have received approval from the professor prior to the test date. The make-up exam must be taken within one week of the student's return to class. Make-ups are different from exams given in class. A grade of zero will be assigned for an exam missed due to an unexcused absence.

ACADEMIC DISHONESTY

Cheating Policy: / If you are caught cheating, you will get a course grade of "F". Cheating is when you receive answers to homework items or exam questions. Cheating is also when you give answers for homework items or exam questions to another student.
See ORACLE: Student Handbook, 2009-2010, p. 41-49. “A student is subject to disciplinary action if: 2. In connection with the taking of, or in contemplation of the taking of any examination by any person: a. A student knowingly discovers or attempts to discover the contents of an examination before the contents are revealed by the instructor; 3. Where the work affects or might affect a student’s grade, credit, or status in the university, a student represents to be his or her own any work that is not the product of his or her own study and efforts (known as plagiarism).”
Plagiarism is the act of stealing and passing off (the ideas or words of another) as one’s own or to commit literary theft: present as new and original an idea or product derived from an existing source (Webster’s New Collegiate Dictionary). Plagiarism will cause a student to get a course grade of “F”.
According to the TSU ORACLE: Student Handbook, 2009-2010, pp. 48, The penalties for misconduct as described above may be subjected to one or more of the following penalties: “a. A student’s grade in the course or on the examination affected by the misconduct may be reduced to any extent, including a reduction to failure.” b. A student may be suspended from the university for a specific or an indefinite period.
Plagiarism / A plagiarism checker will be used on all papers turned in. Papers that do not give correct credit for intellectual property will receive a grade of zero. A course grade of F will be assigned.
Sorrell College of Business Vision / The Sorrell College of Business will be a recognized and respected leader for quality and flexibility in the delivery of business education that prepares graduates to succeed in the global business environment.
Sorrell College of Business Mission / The Sorrell College of Business supports the Troy University mission by preparing our diverse student body to become ethical professionals equipped to compete in the global business environment. To achieve this, our faculty, staff, and administration will:
  1. provide quality education in global business through our undergraduate and graduate programs, delivered around the world through facetoface and online environments, to traditional, non-traditional, military, and international students;
  2. contribute to the development and application of knowledge focused on applied business, learning, and pedagogical research;
  3. provide service to the University, business and professional organizations, and our communities through individual involvement, business outreach, and our centers for research.