Database Design and Management

Course Details

Course Number: 3123  Section Number: 101

Fall 2010

Location: Dillard College of Business Administration

Classroom Number: 335

Days & Times:

TR 12:30-1:50

Course Attachments

Syllabus  Syllabus_3123_F2010-20100827-090636.pdf


Database Concepts  ISBN: 9780136086536

MSU Faculty Member
Dr. Guoying (Grace) Zhang   
view Profile »

Course Objectives

General Learning Goals:   

  1. Teambuilding and collaboration to achieve group objectives. Students will work in teams throughout this course both on the team project and on an ad hoc basis as well. There will be one major team project and presentation. Peer and instructor evaluations, as well as project requirements, will be designed to insure that all team members actively participate in activities contributing to overall team grades.   
  2. Problem Solving and Decision Making. Various hands on exercises from the textbook will be the primary means by which the students learn the concepts of developing database applications in business. Hands on exercises require students to identify the requested business situation, make any necessary assumptions, assess given data/evidence, design the data model, and implement the database application. These graded hands on are a portion of the overall course grade.
  3. Competency in speaking and writing for common business scenarios. It is required that all team members speak during their team presentation and participate in the documentation of the team project. An assessment form will be used during presentations to address the professionalism of individual and group efforts. This form will be provided to students and discussed well in advance of their scheduled presentations. Documentation for the prototype of the database will be expected to contain no grammatical and punctuation errors. 
  4. Technology Utilization. Extensive use is made of business application technology throughout the course. Various DBMS software will be demonstrated to, evaluated by, and used by, the students. The DBMS software include Microsoft Access, SQL server express, MySQL and Oracle. Students will also demonstrate their ability to use common business computer applications by utilizing Microsoft Word, Excel, and Visio for written assignments and Microsoft PowerPoint for their team presentation. Additionally, a variety of in-class exercises will involve the use of various forms of information technology.   


These general learning goals are among those established by the Dillard College of Business Administration. General learning goals represent the skills that graduates will carry with them into their careers. While assessing student performance in obtaining these general learning goals, the Dillard College is assessing its programs. The assessments will assist us as we improve our curriculum and curriculum delivery. 

Course Expectations

Course Specific Learning Goals: After completing this course, students should be able to:

  1. Understand the conceptual foundation of a relational model and describe the basic relational terminology.
  2. Perform basic SQL operations to create, modify, and delete database.
  3. Describe the stages of database development and construct E-R data model to represent various kinds of relationships.
  4. Translate the E-R data model to database design with the appropriate level of normalization.
  5. Understand the need for and importance of database administration: concurrency control, security, and backup and recovery.
  6. Understand Web database processing and describe the concepts of XML, ODBC, OLE DB, ADO.NET, ASP, etc.

Grading Standards

Grading and Evaluation: Student's performance will be assessed using the following elements.

  1.  Exams (3): Each exam will consist of multiple-choice and true/false questions, some short answer, and/or essay questions.  Exams will cover assigned chapters, in-class lectures, and any other assigned readings. Students are responsible for all assigned textbook material, even if it is not directly discussed in class.
  2. Team Project:All students will participate in a group project. It is anticipated that the team project should facilitate the operations of a real business or an organization by designing and implementing a prototype of a database application. Details of the project requirements will be provided in additional document. Team formation is on a voluntary basis. The maximum of team size cannot exceed 4 students. The use of a commercial product or shareware will be done in an ethical manner.
  3. Workbenches (7): In-class workbenches are conducted for each chapter. Students are required to finish the workbench DURING the class session.
  4. Attendance and Participation: Absences will be excused only for approved school trips and serious health issues. I will deduct 1 point for each missing class/workbench session. Further, ad hoc quizzes will be administrated. Only your direct participation in class activities DURING class meeting times counts toward the points!


Points will be allocated using the following scheme. 





Grades will be assigned using the following scheme. 

Exam I





Exam II





Exam III





Team Project





Workbenches (7)




<= 59

Attendance & Participation





Total Points





Final Exam12/9/2010  10:30-12:30

Submission Format Policy

WebCT access to Course Content, My Grades, Assignment, Announcement, etc. I will use WebCT as the major communication channel for the class.

Note: You may not submit a paper for a grade in this class that already has been (or will be) submitted for a grade in another course, unless you obtain the explicit written permission of me and the other instructor involved in advance.

Late Paper Policy

Assignments:Assignments are due in class at the beginning of class on the specified due date. There is NO PROVISION for late work on any assignment. Plan and schedule to complete work early.  Having your work completed on schedule is a key to early success in your business career. 

Missed Examination, Quiz, and In-class Exercises Policy: Only students with authorized absences (see University Class Attendance Policy) may make up missed examinations, quizzes (announced and unannounced), and in-class exercises. Arrangements must be made in advance if at all possible. In all cases, the instructor must be contacted no later than the day of the scheduled exam or no make up will be allowed. At the instructor’s discretion, a deduction may be assessed for a late exam.

Plagiarism Policy Plagiarism is the use of someone else's thoughts, words, ideas, or lines of argument in your own work without appropriate documentation (a parenthetical citation at the end and a listing in "Works Cited")-whether you use that material in a quote, paraphrase, or summary. It is a theft of intellectual property and will not be tolerated, whether intentional or not.

Student Honor Creed

As an MSU Student, I pledge not to lie, cheat, steal, or help anyone else do so."

As students at MSU, we recognize that any great society must be composed of empowered, responsible citizens. We also recognize universities play an important role in helping mold these responsible citizens. We believe students themselves play an important part in developing responsible citizenship by maintaining a community where integrity and honorable character are the norm, not the exception. Thus, We, the Students of Midwestern State University, resolve to uphold the honor of the University by affirming our commitment to complete academic honesty. We resolve not only to be honest but also to hold our peers accountable for complete honesty in all university matters. We consider it dishonest to ask for, give, or receive help in examinations or quizzes, to use any unauthorized material in examinations, or to present, as one's own, work or ideas which are not entirely one's own. We recognize that any instructor has the right to expect that all student work is honest, original work. We accept and acknowledge that responsibility for lying, cheating, stealing, plagiarism, and other forms of academic dishonesty fundamentally rests within each individual student. We expect of ourselves academic integrity, personal professionalism, and ethical character. We appreciate steps taken by University officials to protect the honor of the University against any who would disgrace the MSU student body by violating the spirit of this creed. Written and adopted by the 2002-2003 MSU Student Senate.

Students with Disabilities The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights protection for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Disability Support Services in Room 168 of the Clark Student Center, 397-4140.

Safe Zones Statement The professor considers this classroom to be a place where you will be treated with respect as a human being - regardless of gender, race, ethnicity, national origin, religious affiliation, sexual orientation, political beliefs, age, or ability. Additionally, diversity of thought is appreciated and encouraged, provided you can agree to disagree. It is the professor's expectation that ALL students consider the classroom a safe environment.

Contacting your Instructor All instructors in the Department have voicemail in their offices and MWSU e-mail addresses. Make sure you add your instructor's phone number and e-mail address to both email and cell phone lists of contacts.

Attendance Requirements

Attendance Policy: Regular attendance is expected and roll will be taken. Upon a student’s fifth unauthorized absence, that student will be dropped for nonattendance and receive a grade of WF for the course. Participation in class discussion is mandatory and a significant part of the overall class grade. Students must read the assigned material and complete assignments and be prepared to discuss and ask questions relating to assigned material. See the MSU Student Handbook for University Class Attendance Policy.

Other Policies

Syllabus Change Policy

 This syllabus is a guide for the course and is subject to change. Syllabus changes will be communicated in class or via WebCT.

 Classroom behavior:

  • Please come to class on time. Take care of personal business prior to class. I do not expect you to leave and return to class. If you leave the classroom before class ends, take your things with you and I’ll see you next class. 
  • Computers will remain off during class except as directed by the instructor. Class time is not for surfing the Web or catching up on email. You will be asked to leave the class if you continually violate this policy.
  • Turn off your cell phones and any other electronic devices and put them away. If you have an emergency situation that requires your cell phone to be on, let me know and we’ll work something out. 

Writing Proficiency Requirement All students seeking a Bachelor's degree from Midwestern State University must satisfy a writing proficiency requirement once they've 1) passed English 1113 and English 1123 and 2) earned 60 hours. You may meet this requirement by passing either the Writing Proficiency Exam or English 2113. Please keep in mind that, once you've earned over 90 hours, you lose the opportunity to take the $25 exam and have no option but to enroll in the three-credit hour course. If you have any questions about the exam, visit the Writing Proficiency Office website at, or call 397-4131.