Click here to see Class Announcements

BUS 112: Database Management
Fall 2008
SYLLABUS

Section 1 meets TuTh, 12:00-1:15 pm, in BBC 320
Section 2 meets Tu 6:00-8:45 pm in BBC 103

COURSE DESCRIPTION AND OBJECTIVES

Catalog course description:
Intermediate database management systems and procedures, stressing the design and development of efficient business information systems. Emphasis on data modeling, data integrity, SQL, and implementation of a database application.

Detailed course description and objectives:
Students learn to design and create relational databases, manipulate data, and gain an understanding of the issues concerning database management. They learn data modeling using entity-relationship diagrams as well as important concepts from the relational data model including data integrity and data normalization. Structured Query Language (SQL) is introduced; students learn SQL data definition and manipulation commands in both MS Access and Oracle SQL*Plus environments. Using Microsoft Access 2003 software, students build databases and database objects such as tables, queries, forms, and reports. Specific learning objectives of the course are listed below:

1. Learn database design using entity-relationship diagrams and the relational data model.

2. Understand the concepts of data and referential integrity and data normalization.

3. Learn the syntax and use of Structured Query Language (SQL). 

4. Learn to create databases and database objects, manipulate and retrieve data, and build a simple database application using Microsoft Access.

Course Prerequisites: A grade of C or better in Bus92, Bus110A (previously Bus 110), and Bus 110B (previously Bus 93). (Please complete and submit the student information form to the instructor.)

Required Textbooks:

1. Peter Rob and Carlos Coronel, Database Systems: Design, Implementation, & Management, 7th Edition, Course Technology (2007).
   ISBN-10: 1418835935
   ISBN-13: 978-1418835934
    

2. Adamski & Finnegan, New Perspectives on Microsoft Office Access 2007, Introductory, Course Technology (2008).
   ISBN 10: 1-4239-0588-1
   ISBN 13: 978-1-4239-0588-2
    

Materials: A flash drive.

GRADING CRITERIA

The following course components (with their relative weights as shown) will be used to determine a student's grade in the course.

Homework assignments & project: A number of database assignments and a project will be given during the semester. Requirements and due dates will be announced in class and may also be posted on the announcements page. Please note the following policies:

• Homework assignments and the project are due at the beginning of class on due date. Late work will not be accepted except by previous arrangement or under extraordinary circumstances approved by the instructor.

• All work that is handed in for a grade must be typed and/or prepared electronically using an appropriate software. Work that is not typed will not be graded.

• Homework assignments/project are a student's individual responsibility (or a group's responsibility for a group project) and must not be copied from others. SJSU academic integrity policies apply to all of your work.

• It is recommended that you make copies of all assignments, projects, etc. before submitting them. It protects you from accidental loss on my part and allows you to continue working while the assignment is being graded.

• Be sure to verify your homework, project, and exam scores posted on Blackboard/WebCT and report any discrepancies to the instructor not later than one week after your graded work is returned in class. Scores may not be modified after that.

• Microsoft Access is an essential part of this course. The latest Access software is available for student use in the open lab (BBC 302). Also, you can obtain a free copy of the software through the MSDNAA program if you sign up with the instructor during the first week of class. Please use the link provided at the top of this page to download data files necessary to do the MS Access work.

Exams: One midterm and a final examination will be given. Exams will contain questions based on material in both books (Rob/Coronel and MS Access) as well as other material such as exercises, handouts, and class discussions. Examples and types of questions will be discussed in class. The final exam will cover material after the midterm as well as selected chapters/sections covered before the midterm. Please take the exams as scheduled - makeups are not given unless they are approved by the instructor prior to the exam date.

Extra credit options, if available: No extra credit is available.

Other Policies and Procedures:

• Students should attend all class meetings and arrive on time. They are responsible for the material discussed in class. If a student has to miss a class, she/he should make sure to obtain lecture notes and meet the deadlines/dates announced in class.

• Students are expected to have read the assigned textbook chapter and Access tutorial before coming to class (please see the schedule below).

• Notebook/laptop computers may be used in class only if they are used to support an activity related to this class.

• Students are advised to follow the add/drop policies of the University and the College of Business. They are responsible for completing necessary paperwork for adding or dropping this course. Students not attending classes may, however, be dropped by the instructor.

• Please communicate all individual or personal matters to me during scheduled office hours, through email, or by appointment as necessary. It is difficult to give these issues appropriate attention during class time.

UNIVERSITY & COLLEGE OF BUSINESS POLICIES

San Jose State University Policies:

Academic Integrity: Individual work (or group work, if it is a group assignment) on all assignments, projects, exams, and labs etc. is required. Students may discuss assignments together. However, after any such discussion, each student should work on an assignment independently, from scratch. It is against the rules of this class to include a student's name on a group project if they have not participated in doing the work. Faculty are required to report all infractions to the Office of Judicial Affairs. Please read San Jose State University Academic Integrity Policy for additional information and compliance.

Campus policy in compliance with the Americans with Disabilities Act: If you need course adaptations or accommodations because of a disability, or if you need special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible, or see me during office hours. Presidential Directive 97-03 requires that students with disabilities requesting accommodations must register with Disability Resource Center (DRC) to establish a record of their disability. Students with disabilities may contact the DRC at: (408) 924-6000; TDD: (408) 924-5990; Web site: www.drc.sjsu.edu; E-mail: drc@email.sjsu.edu for additional information and assistance.

College of Business Policies and Procedures:

(Please check this website for policy details: http://www.cob.sjsu.edu/cob/5_STUDENT%20SERVICES/cobpolicy.htm)

To ensure that every student, current and future, who takes courses in the Boccardo Business Center (BBC), has the opportunity to experience an environment that is safe, attractive, and otherwise conducive to learning, the College of Business at San José State has established the following policies:

Eating: Eating and drinking (except water) are prohibited in the Boccardo Business Center.  Students with food will be asked to leave the building.  Students who disrupt the course by eating and do not leave the building will be referred to the Judicial Affairs Officer of the University.
Cell Phones: Students must turn their cell phones off or put them on vibrate mode while in class.  They will not answer their phones in class.  Students whose phones disrupt the course and do not stop when requested by the instructor will be referred to the Judicial Affairs Officer of the University.
Computer Use: In the classroom, faculty allow students to use computers only for class-related activities.  These include activities such as taking notes on the lecture underway, following the lecture on Web-based PowerPoint slides that the instructor has posted, and finding Web sites to which the instructor directs students at the time of the lecture.  Students who use their computers for other activities or who abuse the equipment in any way, at a minimum, will be asked to leave the class and will lose participation points for the day, and, at a maximum, will be referred to the Judicial Affairs Officer of the University for disrupting the course.  (Such referral can lead to suspension from the University.)  Students are urged to report to their instructors computer use that they regard as inappropriate (i.e., used for activities that are not class related).
Academic Honesty: Faculty will make every reasonable effort to foster honest academic conduct in their courses. They will secure examinations and their answers so that students cannot have prior access to them and proctor examinations to prevent students from copying or exchanging information. They will be on the alert for plagiarism. Faculty will provide additional information, ideally on the green sheet, about other unacceptable procedures in class work and examinations. Students who are caught cheating will be reported to the Judicial Affairs Officer of the University, as prescribed by San Jose State University Academic Integrity Policy.
College of Business Mission Statement: The College of Business is the institution of opportunity, providing innovative business education and applied research for the Silicon Valley region.

CLASS SCHEDULE

The schedule is subject to change with fair notice. Any changes to the schedule will be announced in class during the semester.

R = Chapters in the Rob/Coronel textbook; A = tutorials in the Access book