University of Hawaii at Hilo, College of Business and Economics
QBA 364
Database Design and Application

Course Details

Class Times: Spring Semester 2006,
Monday/Wednesday/Friday 9:00-9:50 am,
K 112
Instructor: Dr. Kimberly Furumo,
furumo@hawaii.edu,
K-243, 974-7672
Website: http://www.uhh.hawaii.edu/uhh/faculty/furumo/
Office Hours: Mondays and Wednesdays: 2:00 - 3:00 pm,
Tuesdays: 11:00 am - 2:00 pm, or by appointment
Textbook:

Post, Gerald, Database Management Systems: Designing & Building Business Applications, 3rd Edition, McGraw-Hill/Irwin, 2005

Post, Gerald, Designing & Buiilding Business Applications with Microsoft Access, 3rd Edition, McGraw-Hill/Irwin, 2005

Final Exam:  

Course Description

The collection, storage and retrieval of information is a major part of almost every business and technical project undertaken. This course will look at all stages of database design and implementation; as well as discuss the on-going requirements of an operational database system. Special emphasis will be placed on the relational model, and the design considerations of systems. Project management and systems analysis and design tools will be included.

Course Policies and Expectations:

Class Attendance and Preparation Expectation
Students are expected to attend classes and be prepared. Students are expected to show up on time and stay for the entire class. Students are responsible for makeup work in the event of an absence. Please report planned absences in advance.
Academic Dishonesty Policy
Academic dishonesty includes representing the work of another as one's own or cheating by any means. Academic dishonesty also includes aiding, abetting, concealing, or attempting such activity. The usual penalty is an F in the course and disciplinary activity by the University.
Open Door Policy
I have an open office door policy. I encourage students to come to my office with any questions or concerns or just to say "aloha". I am in my office from 9:00am - 4:00pm on most days unless I am teaching, in a meeting, or at the library. I do not mind if students stop by without an appointment during these hours. If my door is open, come on in.
Email
I check my email everyday (including weekends). If you need to contact me this is often times the best way to do so. I try to respond to email very quickly.

Course Grading

Milestone Points
Homework Exercises 100
Project 100
Exam 1 100
Exam 2 100
Exam 3 100
Total 500

Final Grades

Final grades will be computed in the following manner. This grading scale is firm!!

Grade Percentage Points
A 92% - 100% 460 - 500 pts.
A- 90% - 91% 450 - 459 pts.
B+ 88% - 89% 440 - 449 pts.
B 82% - 87% 410 - 439 pts.
B- 80% - 81% 400 - 409 pts.
C+ 78% - 79% 390 - 399 pts.
C 72% - 77% 360 - 389 pts.
C- 70% - 71% 350 - 359 pts.
D+ 68% - 69% 340 - 349 pts.
D 62% - 67% 310 - 339 pts.
D- 60% - 61% 300 - 309 pts.
F < 60% < 300 pts.

Homework Exercises

Students will be assigned several hands-on homework assignements. Some will be introduced in the lab sessions while others will be assigned during class. Point values for exercises will vary depending on the assignment.

Exams

Three exams will be administered in this course. Exams will consist of multiple choice and short answer questions.

Project

Students are required to complete a hands-on database development project. Projects may be completed individually or in groups or 3 or less. Students will demo their database systems for the class.

 

Planned Schedule (subject to change)

Week Monday Wednesday Friday
Jan 9 - 13
  • Chapter 1
  • Chapter 1
  • Lab
Jan 16 - 18
  • Holiday
  • Chapter 2
  • Lab
Jan 23 - 27
  • Chapter 2
  • Chapter 3
  • Lab
Jan 30 - Feb 3
  • Chapter 3
  • Chapter 3
  • Lab
Feb 6 - 10
  • Chapter 3
  • Exam 1
  • Lab
Feb 13 - 17
  • Chapter 4
  • Chapter 4
  • Lab
Feb 20 - 24
  • Holiday
  • Chapter 4
  • Lab
Feb 27 - Mar 3
  • Chapter 5
  • Chapter 5
  • Lab
Mar 6 - 10
  • Chapter 5
  • Chapter 5
  • Lab
Mar 13 - 17
  • Chapter 6
  • Chapter 6
  • Lab
Mar 20 - 24
  • Chapter 6
  • Exam 2
  • Lab
Mar 27 - 31
  • Spring Break
  • Spring Break
  • Spring Break
April 3 - 7
  • Chapter 7
  • Chapter 7
  • Lab
April 10 - 14
  • Chapter 8
  • Chapter 8
  • Holiday
April 17 - 21
  • Chapter 9
  • Chapter 9
  • Student Project Demos
April 24 - 28
  • Student Project Demos
  • Student Project Demos
  • Student Project Demos
May 1 - 5
  • Student Project Demos
  • Exam 3
  • No Class