Effective: Late Fall 8-Week, 2018/2019

CISS 430: Database Systems

Back to Top

  Course Description

Design and implementation of relational and object-oriented database systems.  Relational algebra, normal forms and normalization, query processing, efficiency and security considerations.

Prerequisite: CISS 285 or CISS 280

Proctored Exams: Final



  Textbooks

As part of TruitionSM, students will receive their course materials automatically as described below.

Required

  • Kroenke, David. Database Processing: Fundamentals, Design, and Implementation. 14th, Prentice Hall, 2016.  

Bookstore Information

Visit https://www.ccis.edu/bookstore.aspx for details.

eText Information

If a course uses an eText, (see Textbook information above) the book will be available directly in Desire2Learn (D2L) and through the VitalSource eText reader the Friday before the session begins, if registered for courses prior to that date.  Students will have a VitalSource account created for them using their CougarMail email address. Upon first login to VitalSource, students may need to verify their account and update their VitalSource password.  More information about how to use the VitalSource platform, including offline access to eTexts, can be found in D2L.  Students that would like to order an optional print-on-demand copy of eligible eTexts can do so through the VitalSource bookshelf at an additional cost.  Once orders are placed, it can take approximately five to seven business days for students to receive their print-on-demand books.

Physical Course Materials Information

Students enrolled in courses that require physical materials will receive these materials automatically at the address on file with Columbia College.  Delivery date of physical materials is dependent on registration date and shipping location.  Please refer to confirmation emails sent from Ed Map for more details on shipping status.

Note: Students who opt-out of having their books provided as part of TruitionSM are responsible for purchasing their own course materials.

  Course Overview

This course covers a wide range of vitally important topics. Students who successfully complete this course will understand what a database is, the capabilities of a database management system, how to design a simple database, how to build and query a database, and how to model data using the entity-relationship (ER) model.

  Technology Requirements

Participation in this course will require the basic technology for all online classes at Columbia College:
  • A computer with reliable Internet access
  • A web browser
  • Acrobat Reader
  • Microsoft Office or another word processor such as Open Office

You can find more details about standard technical requirements for our courses on our site.

You will also need to download and install the latest release of MySQL Community Server and MySQL Workbench.  You will find more information about these tools in Chapter 10 of the text.

  Course Learning Outcomes

  1. Demonstrate basic knowledge of databases, with a focus on relational databases.
  2. Develop conceptual and logical data models and perform normalization and denormalization for a moderately complex business scenario.
  3. Write and interpret moderately complex SQL queries.
  4. Develop moderately complex databases for a business problem on a major platform (e.g. Oracle).

  Grading

Grading Scale

Grade Points Percent
A 567-630 90-100%
B 504-566 80-89%
C 441-503 70-79%
D 378-440 60-69%
F 0-377 0-59%

Grade Weights

Assignment Category Points Percent
Discussions 40 6%
Dropbox Assignments 290 46%
Midterm Exam 100 16%
Final Exam 200 32%
Total 630 100%

  Schedule of Due Dates

Week 1

Assignment Points Due
Discussion 1 5 Sunday
Dropbox Assignment 20

Week 2

Assignment Points Due
Discussion 2 5 Sunday
Dropbox Assignment 28
Proctor Information N/A

Week 3

Assignment Points Due
Discussion 3 5 Sunday
Dropbox Assignment 56

Week 4

Assignment Points Due
Discussion 4 5 Sunday
Dropbox Assignment 30
Midterm Exam 100

Week 5

Assignment Points Due
Discussion 5 5 Sunday
Dropbox Assignment 40

Week 6

Assignment Points Due
Discussion 6 5 Sunday
Dropbox Assignment 40

Week 7

Assignment Points Due
Discussion 7 5 Sunday
Dropbox Assignment 40

Week 8

Assignment Points Due
Discussion 8 5 Saturday
Dropbox Assignment 36
Final Exam 200
Total Points: 630

  Assignment Overview

Discussion Assignments

Use the discussion board to pose questions you might have about topics from the readings and assignment each week.  There will also be a discussion question I will post each week. Participation in the class discussion will help you with understand the material and prepare for the exams.  

Dropbox Assignments

Each week you will answer a number of questions in the text.  You will post your answers (written in MS Word) in the dropbox.  Note that grammar, punctuation, spelling, and sentence structure matter. Number each response with the number of the question and list your answers in order by question number.

Midterm Exam

The midterm exam will be composed of questions from Chapters 1-4.  You will have two hours to complete it.  This is an open book exam. The exam will be available from Tuesday through Saturday of Week 4.

Final Exam

The final exam is comprehensive; it covers material from Chapters 1-8.  The exam will be proctored.  You will not be allowed to use your text or any notes while taking the exam.  You will have two hours to complete it.  The exam will be available from Tuesday through Saturday of Week 8.

  Course Outline

Click on each week to view details about the activities scheduled for that week.

Readings

Chapter 1

Class Activities

Download and install the latest generally available release of MySQL Community Server and its associated Workbench. You can find out more about this in Chapter 10 of your text and you can find a document in the Class Content area describing what you need and how to install it.  (Do not install any alpha or beta releases that might be available.)  Download the documentation for MySQL and MySQL Workbench. Spend some time beginning to learn about MySQL by browsing chapter 10B which you can find in the Course Content area and the documentation from the MySQL website.

Installing MySQL is not quite as simple as most applications. Make sure you look at the Chapter 10B in the content area of the course. There are also numerous videos in the content area of the course that will help with the installation.

Discussion 1

Introduce yourself in the "Introductions" thread of the class discussion. Please give us more than your name. Include your profession, hobbies, any experience you might have had using a database system, and any other information that can help us get to know you.

Dropbox Assignment

Answer the following questions in the text and post your responses in the dropbox for this week.  
1.4, 1.5, 1.10, 1.18, 1.25, 1.36, 1.45, 1.48, 1.55, and 1.62 (2 points each)

Readings

Chapter 2. Ignore portions of the text that apply to any database system other than MySQL. 

Class Activities

Create and populate the Cape Cod database using MySQL Query Browser. Since there are some inconsistencies in the scripts provided on the text website for creating and populating the Cape Cod database, the instructor will make corrected versions of the scripts available.

Discussion 2

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

Develop SQL expressions for each of the following questions from chapter 2. Copy and paste your queries into a word document and submit it to the dropbox by Saturday midnight. Each query should be numbered with the problem number from the text and the queries should be arranged in order.

2.20 2.29 2.31 2.33 (3 points each)
2.36 2.42 2.44 2.46 (4 points each) (28 points total)

Proctor Information
Submit your proctor form to the appropriate Dropbox folder by the end of the week. Remember to “Save” the form before placing it in Dropbox. See the Content area for more information.
Readings

Chapter 3

Discussion 3

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

Provide answers to each of the following questions from the end of the chapter.

  1. 3.54 (6 points)
  2. 3.58, Parts A, B, and C (20 points)
  3. Morgan Importing, page 175, Question A, Parts 1-6 (5 points each)(30 points total)
Readings

Chapter 4

Class Activities

Begin to experiment with MySQL Workbench. In particular the documentation for the Workbench contains some tutorials that you might find helpful.

Discussion 4

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

Answer Project question (Page 193) 4.41. (30 points)

Midterm Exam

This week you will take the midterm exam. It will cover chapters 1 through 4. The exam will be timed and you will have two hours.  All questions on the exam will be taken from questions at the end of chapters 1 through 4. The exam will be available from Tuesday at 8:00 A.M. through Sunday at midnight central time.

Readings

Chapter 5

Discussion 5

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

Place answers to the following questions from the end of the chapter in the dropbox for week 5 assignments. Your responses must be in order by question number. 
5.20 5.28 5.39 5.44 5.51 (2 points/question = 10 points total).

Problem 5.56, parts A, B, C, and D. (30 points)

Readings

Chapter 6

Discussion 6

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

Case Questions A, B, C, D and E on the San Juan Charter Case (Page 298). You may use any drawing program or even Word or PowerPoint  for the necessary drawings. (40 points)

Course Evaluation
Please evaluate the course. You will have an opportunity to evaluate the course near the end of the session. A link sent to your CougarMail will allow you to access the evaluation. Please note that these evaluations are provided so that I can improve the course, find out what students perceive to be its strengths and weaknesses, and in general assess the success of the course. Please do take the time to fill this out.
Readings

Chapter 7

Discussion 7

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

On page 359/360 of the text, answer items 7.7, 7.8, 7.9, 7.10 and 7.11.  Submit your completed answers as a WORD document rather than a .sql file. (40 points)

Readings

Chapter 8

Discussion 8

Use the discussion board to pose questions you might have about topics from the readings and assignment this week.

Dropbox Assignment

Answer the following questions in the text and post your responses in the dropbox for this week.  (9 points/question = 36 points total).

8.2, 8.11, 8.18, and 8.25.

Final Exam
This week you will take the final exam. It will cover chapters 1 through 8. The exam will be proctored and timed. It is a closed book exam. You will not be allowed to use your text or any notes while taking the exam. You will have two hours.  All questions on the exam will be taken from questions at the end of chapters 1 through 8. The exam will be available from Tuesday at 8:00 A.M. through Saturday at midnight central time.

  Course Policies

Student Conduct

All Columbia College students, whether enrolled in a land-based or online course, are responsible for behaving in a manner consistent with Columbia College's Student Conduct Code and Acceptable Use Policy. Students violating these policies will be referred to the office of Student Affairs and/or the office of Academic Affairs for possible disciplinary action. The Student Code of Conduct and the Computer Use Policy for students can be found in the Columbia College Student Handbook. The Handbook is available online; you can also obtain a copy by calling the Student Affairs office (Campus Life) at 573-875-7400. The teacher maintains the right to manage a positive learning environment, and all students must adhere to the conventions of online etiquette.

Plagiarism and Academic Integrity

Academic integrity is a cumulative process that begins with the first college learning opportunity. Students are responsible for knowing the Academic Integrity policy and procedures and may not use ignorance of either as an excuse for academic misconduct. Columbia College recognizes that the vast majority of students at Columbia College maintain high ethical academic standards; however, failure to abide by the prohibitions listed herein is considered academic misconduct and may result in disciplinary action, a failing grade on the assignment, and/or a grade of "F" for the course.

Additionally, all required papers may be submitted for textual similarity review to Turnitin.com for the detection of plagiarism. All submitted papers may be included in the Turnitin.com reference database for the purpose of detecting plagiarism. This service is subject to the Terms and Conditions of Use posted on the Turnitin.com site.

Non-Discrimination

There will be no discrimination on the basis of sex, race, color, national origin, sexual orientation, religion, ideology, political affiliation, veteran status, age, physical handicap, or marital status.

Student Accessibility Resources

Columbia College is committed to creating a learning environment that meets the needs of its diverse student body. If you anticipate or experience any barriers to learning, communicate your concerns with the instructor. In addition to speaking with the instructor, the following resources are available to ensure an opportunity to learn in an inclusive environment that values mutual respect.

  • For students with disabilities/conditions who are experiencing barriers to learning or assessment, contact the Student Accessibility Resources office at (573) 875-7626 or sar@ccis.edu to discuss a range of options to removing barriers in the course, including accommodations.
  • For students who are experiencing conflict which is impacting their educational environment, contact the Office of Student Conduct at studentconduct@ccis.edu or (573) 875-7877.
  • For students who have concerns related to discrimination or harassment based on sex, gender identity, sexual orientation, pregnancy or parental status, please contact the Title IX Office at titleixcoordinator@ccis.edu. More information can be found at http://www.ccis.edu/policies/notice-of-non-discrimination-and-equal-opportunity.aspx

Online Participation

You are expected to read the assigned texts and participate in the discussions and other course activities each week. Assignments should be posted by the due dates stated on the grading schedule in your syllabus. If an emergency arises that prevents you from participating in class, please let your instructor know as soon as possible.

Attendance Policy

Attendance for a week will be counted as having submitted any assigned activity for which points are earned. Attendance for the week is based upon the date work is submitted. A class week is defined as the period of time between Monday and Sunday (except for week 8, when the work and the course will end on Saturday at midnight.) The course and system deadlines are based on the Central Time Zone.

Cougar Email

All students are provided a CougarMail account when they enroll in classes at Columbia College. You are responsible for monitoring email from that account for important messages from the College and from your instructor. You may forward your Cougar email account to another account; however, the College cannot be held responsible for breaches in security or service interruptions with other email providers.

Students should use email for private messages to the instructor and other students. The class discussions are for public messages so the class members can each see what others have to say about any given topic and respond.

Late Assignment Policy

An online class requires regular participation and a commitment to your instructor and your classmates to regularly engage in the reading, discussion and writing assignments. Although most of the online communication for this course is asynchronous, you must be able to commit to the schedule of work for the class for the next eight weeks. You must keep up with the schedule of reading and writing to successfully complete the class.

No late discussion posts will be accepted.

Twenty percent is deducted for each day a weekly assignment is late. After five days no credit is given for late work. 

Course Evaluation

You will have an opportunity to evaluate the course near the end of the session. A link will be sent to your CougarMail that will allow you to access the evaluation. Be assured that the evaluations are anonymous and that your instructor will not be able to see them until after final grades are submitted.

Proctor Policy

Students taking courses that require proctored exams must submit their completed proctor request forms to their instructors by the end of the second week of the session. Proctors located at Columbia College campuses are automatically approved. The use of ProctorU services is also automatically approved. The instructor of each course will consider any other choice of proctor for approval or denial. Additional proctor choices the instructor will consider include: public librarians, high school or college instructors, high school or college counseling services, commanding officers, education service officers, and other proctoring services. Personal friends, family members, athletic coaches and direct supervisors are not acceptable.

  Additional Resources

Orientation for New Students

This course is offered online, using course management software provided by Desire2Learn and Columbia College. The course user guide provides details about taking an online course at Columbia College. You may also want to visit the course demonstration to view a sample course before this one opens.

Technical Support

If you have problems accessing the course or posting your assignments, contact your instructor, the Columbia College Technology Solutions Center, or the D2L Helpdesk for assistance. If you have technical problems with the VitalSource eText reader, please contact VitalSource. Contact information is also available within the online course environment.

Online Tutoring

Smarthinking is a free online tutoring service available to all Columbia College students. Smarthinking provides real-time online tutoring and homework help for Math, English, and Writing. Smarthinking also provides access to live tutorials in writing and math, as well as a full range of study resources, including writing manuals, sample problems, and study skills manuals. You can access the service from wherever you have a connection to the Internet. I encourage you to take advantage of this free service provided by the college.

Access Smarthinking through CougarTrack under Students -> Academics -> Academic Resources.