Link to Class Announcements

BUS 116: Advanced Database Management
Fall 2008
SYLLABUS

Class meets on Thursdays, 6:00-8:45 pm, in BBC 103

COURSE DESCRIPTION AND OBJECTIVES

Catalog course description:
Advanced topics in database management, including data analysis and design, SQL and client/server database development tools and applications.

Additional description and learning objectives:
This course provides an introduction to the Oracle procedural language, PL/SQL, which supports logical processing and user interaction with Oracle databases and applications. PL/SQL is an implicit component of the Oracle database and application development products and is commonly used in the development of Oracle databases and applications as well as in supporting existing Oracle applications. The course also provides an introduction to business intelligence and data warehousing concepts. Specific learning objectives of the course are listed below.

Students will learn:

1. PL/SQL block structure and handling data in PL/SQL blocks.

2. Cursors and exception handling.

3. PL/SQL procedures, functions, and database triggers.

4. Data warehousing and business intelligence concepts.

Required Textbooks:

1. Joan Casteel, Oracle 10g Developer: PL/SQL Programming, Thompson/Course Technology (2008).
   ISBN 10: 1-4239-0136-3
   ISBN 13: 978-1-4239-0136-5
    

2. Turban, Sharda, Aronson, King: Business Intelligence, Prentice Hall (2008).
   ISBN-10: 013234761X
   ISBN-13: 9780132347617

Materials: A flash drive.

Other requirements: For the first part of the course that requires PL/SQL programming, students must either install Oracle Database software on their own computers (see the links above to download and install the software) or be able to go to the COB open lab (in BBC 302) to use this software.
 

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 homework 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.

Exams: One midterm and a final examination will be given. Exams will contain questions based on material in the textbooks as well as other material such as exercises, handouts, and class discussions. Examples and types of questions will be discussed in class. 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.

• Before coming to class, students are expected to have read the assigned textbook chapter/s and other materials as posted in the class schedule (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.

C = Chapters in the Casteel PL/SQL book; T = Chapters in the Turban et al., BI book