Computer and Data Systems

Introduction to Databases and Data Warehouses

Summer 2016 | May 23 –  July 1 | 01:30 – 03:45 pm | Mondays, Wednesdays & Fridays | E203

This course is devoted to the most fundamental issues and topics related to the design, development, and use of operational and analytical databases. Database systems are vital to businesses and organizations because they provide highly efficient methods to handle complex datasets. There are five major components in a database environment that we are going to cover in this course: data, hardware, software, people, and procedures. This course provides an introduction to:  Operational Databases, Database Requirements and ER Modeling, Relational Database Modeling, Update and Normalization, SQL, Database Implementation, Analytical Databases, Data Warehouse and Data Mart Modeling, Data Warehouse Implementation and Database Administration.Ethical issues related to database management will be also addressed throughout all concepts of the courses whenever applicable.

Course Plan

Class Plan

See the schedule here.

  • Database Requirements & ER Modeling
  • Relational Database Modeling
  • Update Operations, Update Anomalies, and Normalization
  • Database Implementation & Use

  • SQL Commands Overview
  • Data Definition by SQL
  • Data Manipulation by SQL
  • Data Control by SQL
  • Transaction Control by SQL
  • Data Analytics by SQL
  • SQL Standard(s) and SQL Syntax Differences

  • Data Warehousing Concepts
  • Data Warehouse Design and Data Mart Modeling
  • Data Warehouse Implementation and Use
  • Data Warehouse Administration

  • Database Administration Overview
  • Monitoring and Maintaining Database Systems
  • The Ethics of Databases and Database Administration
  • Security Issues in Database Administration
  • Legal, and Professional Issues in Database Administration


☀ Learn the Basics of SQL (4 Units)

☀ Table Transformation in SQL (4 Units)

☀ Analyzing Business Metrics with SQL (2 Units)

Powered by:



Your Grade = Mini Cases (40%) + Lab Works (50%) + Participation (10%)

Mini Cases = ER Modeling (10%) + relational schema (10%) + Oracle SQL (10%) + Analytical database (10%)

Lab Works =  SQL intro (20%) + Transformation in SQL (15%) + Analyzing Business Metrics with SQL (15%)

☀ Details will be posted on the course Google Classroom Page.

Class Community

Google Classroom is a blended learning platform to enhance your learning experience. You can ask questions, submit assignments, download materials, check your grades, share interesting things and help each other. Students can join the class with this code: hmgkoc

Database Systems: Introduction to Databases and Data Warehouses

by Nenad Jukic, Susan Vrbsky, & Svetlozar Nestorov.

©2014 | Pearson | Online Resources | Buy/Rent

Textbook + Apps

Codeacademy          -WPK07Fc          erdplus


Class Rules

Please respect your classmates by refraining from any disruptive behavior during class. Disruptive behavior includes but is not limited to: text messaging, talking on a cell phone, the use of computers unrelated to the class, side conversations, arriving after class starts or leaving before class ends, disruptive comments during lectures, and any non-class related activity. You are allowed to use laptops and other personal electronic devices during the class but all cellphones must be turned off before class. If you must leave class early, please notify me before class begins and sit next to the door. Please respect your fellow classmates by following these rules.

Class Attendance

Regular attendance is expected. If you have a serious situation that requires your absence, be sure to provide documentation or inform me in advance. If you are on an athletic team and may miss some sessions, please provide me with a letter no later than the end of the first full week of class so we can communicate about assignments and other course content. It is your responsibility to look ahead on the syllabus and deal with any conflicts prior to the conflicting event. If you will be absent from class for a religious observance, please notify me of any scheduling conflicts by the end of the first full week of class. In all cases, students who must miss class will be responsible for completing all assigned work but I am available to help. Students who missed more than three classes (or three lab assignments) without valid excuse not only should submit the missing assignments but also need to successfully pass the final exam to be able to pass the course.


Class Participation

The majority of the lecture class will be devoted to lab assignments with as little lecturing as possible. You are expected to participate in class activities and discussions. You are free to ask questions and debate the topics at hand. There are no wrong questions, and you are strongly encouraged to participate even if you found the subject difficult or problematic. The participation grade evaluation will be based on the quantity and quality of comments and questions and demonstration of knowledge of the course material. Attendance per se will not be evaluated, but if you are not in class you cannot complete the lab assignments. We will also break into active learning sessions several times throughout the semester to apply the skills you are acquiring to the study of BI/BA applications in business. Your enthusiasm and attention in these sessions directly impacts your participation score. In addition, you will each have an opportunity to lead a discussion in class. Keep in mind that leading a discussion does not mean that you are required to understand everything in the textbook. Creativity is welcomed, but the ultimate goal is effectively enhancing the learning environment.



Please feel free to contact me as soon as possible if you are having any difficulty with the course assignments, class projects, feel overwhelmed, or if instructions are unclear. You are welcome to ask your question via email. To do so, please use a clear subject line, provide context, and use full name. Please do not ask questions via email that will require a long response. Do use office hours for any questions that require extensive feedback or a back-and-forth conversation. If you are worried about your grade at any time during the semester, I strongly encourage you to meet with me.  Do not wait until the last week of class to discuss your grade, as it will be too late to work on improving your grade.


Academic Integrity

The integrity of a university depends upon academic honesty, which consists of independent learning and research. Academic dishonesty includes cheating and plagiarism may result in suspension or expulsion from UH Manoa. All students are expected to abide by the rules of conduct outlined in the UH Student Conduct Code. Violation of the academic honesty portion of this Code will automatically result in a course grade of ‘F’. The complete Code can be viewed at the following site:


Students with Special Needs

The University of Hawaii at Manoa provides upon request appropriate academic accommodations for qualified students with special needs. If you have specific physical, psychiatric, or learning difficulties and require accommodations, please notify me by the end of the first full week of class. I will provide reasonable and appropriate accommodations for students with special needs with the equitable opportunity to excel academically.


Please feel free to contact me if you are having any questions, or difficulty with the course assignments, class projects, feel overwhelmed, or if instructions are unclear. I also welcome your feedback, comments, and suggestions on the course content and instruction. Remember, “The art and science of asking questions is the source of all knowledge” (Thomas Berger).

Office: 2404 Maile Way, C 502K     OR

1410 Lower Campus Rd. #132

Office Hours: Anytime by appointment