Effective: Late Fall 8-Week, 2018/2019

CISS 202: Introduction To Databases

Back to Top

  Course Description

This course is an introduction to the basic techniques and theory in relational databases. Topics include: database concepts and architecture, data modeling, database design, normalization, denormalization, SQL, relational algebra, and database programming.

Prerequisite: CISS 170 or CISS 176

Proctored Exams: Midterm and Final



  Textbooks

Required

  • Coronel, C. & Morris, S. (2016). Database Systems: Design, Implementation, & Management (12th). Cengage Learning.
    • [ISBN-978-1305627482]
  • Forta, B. (2012). SQL in 10 Minutes, Sams Teach Yourself (4th). Pearson.
    • [ISBN-978-0672336072]

In addition to the above texts, a Windows operating system is required for the activities in this course.

MBS Information

Textbooks for the course may be ordered from MBS Direct. You can order

For additional information about the bookstore, visit http://www.mbsbooks.com.

  Course Overview

This course serves an an introduction to databases. Students will learn from study and hands-on application the principles of using databases. 

  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
  • A Windows operating system

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

  Course Learning Outcomes

  1. Demonstrate an understanding of the basics of relational databases.
  2. Demonstrate an understanding of the fundamentals of SQL
  3. Explain and apply the processes of database development
  4. Solve basic business database problems

  Grading

Grading Scale

Grade Points Percent
A 540-600 90-100%
B 480-539 80-89%
C 420-479 70-79%
D 360-419 60-69%
F 0-359 0-59%

Grade Weights

Assignment Category Points Percent
Discussions (7) 70 12%
Dropbox Assignments (7) 140 23%
Case Study 120 20%
Quizzes (7) 70 12%
Midterm Exam 100 17%
Final Exam 100 17%
Total 600 100%

  Schedule of Due Dates

Week 1

Assignment Points Due
Introductions -- Thursday
Discussion 1: Data, Fields, Records, and Files 10 Thursday/Sunday
Dropbox Assignment 1: Installing and Running Oracle 20 Sunday
Quiz 1 10

Week 2

Assignment Points Due
Discussion 2: Crow’s Foot ERD 10 Thursday/Sunday
Dropbox Assignment 2: SQL Statements 20 Sunday
Quiz 2 10
Proctor Information N/A

Week 3

Assignment Points Due
Discussion 3: Database Models 10 Thursday/Sunday
Dropbox Assignment 3: Relational Diagrams 20 Sunday
Quiz 3 10

Week 4

Assignment Points Due
Discussion 4: Examining ERDs 10 Thursday/Sunday
Dropbox Assignment 4: Listing 20 Sunday
Quiz 4 10
Midterm Exam 100

Week 5

Assignment Points Due
Discussion 5: Examining Data Modeling 10 Thursday/Sunday
Dropbox Assignment 5: Orders and Amounts 20 Sunday
Quiz 5 10

Week 6

Assignment Points Due
Discussion 6: Tables and Queries 10 Thursday/Sunday
Dropbox Assignment 6: Mailing Lists 20 Sunday
Quiz 6 10

Week 7

Assignment Points Due
Discussion 7: Database Design 10 Thursday/Sunday
Dropbox Assignment 7: Applying Discounts 20 Sunday
Quiz 7 10

Week 8

Assignment Points Due
Case Study 120 Thursday
Final Exam 100 Saturday
Total Points: 600

  Assignment Overview

Discussions

Each initial discussion post should be approximately 100 words in length. You must also respond to at least one peer. Other posts will not be visible until you post your own. Initial posts are due Thursdays at 11:59 pm CT; peer responses are due Sundays at 11:59 pm CT. Each discussion is worth ten points. 

Dropbox Assignments

In weeks 1-7, you will be assigned a detailed task to carry out. Specific information on each assignment is available in the content area of the course. Submit your completed file(s) to the appropriate dropbox by Sunday at 11:59 pm CT. Each dropbox assignment is worth 20 points. 

Case Study

The large project in this course is a Case Study. Specific details on this assignment are available in the content area of the course. Submit your completed file(s) for this assignment to the appropriate dropbox by Saturday at 11:59 pm CT of Week 8. The Case Study is worth 120 points. 

Quizzes

In weeks 1-7, you will be assigned a 10-question quiz over the week's reading material. You will have 120 minutes and one attempt to complete the quiz. Quizzes are due on Sunday at 11:59 pm CT of their assigned week. Each quiz is worth 10 points.

Midterm Exam

This exam is proctored. You will have 120 minutes to answer 50 questions over the readings from Weeks 1-4. The midterm is due by Sunday at 11:59 pm CT of Week 4. The exam is worth 100 points. 

Final Exam

This exam is proctored. You will have 120 minutes to answer 50 questions over the readings from Weeks 5-8. The final is due by Saturday at 11:59 pm CT of Week 8. The exam is worth 100 points. 

  Course Outline

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

Readings
Chapter 1 Database Systems (Coronel and Morris)
Introductions
Please introduce yourself to the class. 
Discussion 1: Data, Fields, Records, and Files
In your own words, explain and give an example of each of the following terms:
data
field 
record 
file
 
Dropbox Assignment 1: Installing and Running Oracle

See the content area of the course for details on this assignment. 

Quiz 1
Covers Chapter 1 of Coronel and Morris.
Readings

Chapter 2 Data Models (Coronel and Morris)

Lesson 1 Understanding SQL (Forta)

Lesson 2 Retrieving Data (Forta) 

Discussion 2: Crow’s Foot ERD

Typically, a hospital patient receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications, creating a 1:M relationship between ORDER and MEDICATION.

1. Identify the business rules for PATIENT, ORDER, and MEDICATION.
2. Create a Crow’s Foot ERD that depicts a relational database model to capture these business rules.

 
Dropbox Assignment 2: SQL Statements
See the content area of the course for details on this assignment. 
Quiz 2
Covers chapter 2 of Coronel and Morris.
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 Relational Database Models (Coronel and Morris)

Lesson 3 Sorting Retrieved Data (Forta)

Lesson 4 Filtering Data (Forta)

Lesson 5 Advanced Data Filtering (Forta)

Discussion 3: Database Models
Complete Questions 8-12 on Pages 107 and 108 of Coronel and Morris book.
Dropbox Assignment 3: Relational Diagrams
See the content area of the course for details on this assignment. 
Quiz 3

Covers chapter 3 of Coronel and Morris.

Readings

Chapter 4 Entity Relationship (ER) Modeling (Coronel and Morris)

Lesson 6 Using Wildcard Filtering (Forta)

Lesson 7 Creating Calculated Fields (Forta)

Lesson 8: Using Data Manipulation Functions (Forta)

Discussion 4: Examining ERDs
Complete Questions 17-20 on Pages 154 to 155 of Coronel and Morris book.
Dropbox Assignment 4: Listing
See the content area of the course for details on this assignment. 
Quiz 4

Covers chapter 4 of Coronel and Morris.

Midterm Exam

Proctored. Covers chapters 1-4 of Coronel and Morris.

Readings

Chapter 5 Advanced Data Modeling (Coronel and Morris)

Lesson 9: Summarizing Data (Forta)

Lesson 10: Grouping Data (Forta)

Lesson 11: Working with Subqueries (Forta)

Discussion 5: Examining Data Modeling
Complete Questions 7-9 on Pages 189 to 190 of Coronel and Morris book.
Dropbox Assignment 5: Orders and Amounts
See the content area of the course for details on this assignment. 
Quiz 5

Covers chapter 5 of Coronel and Morris.

Readings

Chapter 6 Normalization of Database Tables (Coronel and Morris)

Lesson 12: Joining Tables (Forta)

Lesson 13: Creating Advanced Joins (Forta)

Lesson 14: Combining Queries (Forta)

Discussion 6: Tables and Queries
Complete Questions 7 on Pages 235 to 236 of Coronel and Morris book.
Dropbox Assignment 6: Mailing Lists
See the content area of the course for details on this assignment. 
Quiz 6

Covers chapter 6 of Coronel and Morris.

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 9 Database Design (Coronel and Morris)

Lesson 15: Inserting Data (Forta)

Lesson 16: Updating and Deleting Data (Forta)

Discussion 7: Database Design
Complete Problem 1 on Pages 478 to 479 of Coronel and Morris book.
Dropbox Assignment 7: Applying Discounts
See the content area of the course for details on this assignment. 
Quiz 7

Covers chapter 9 of Coronel and Morris.

Readings

Lesson 17: Creating Tables (Forta)

Lesson 18: Using Views (Forta)

Case Study
See the content area of the course for details on this assignment. 
Final Exam

Proctored. Covers chapters 5, 6, and 9 of Coronel and Morris.

  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

Your grade will be based in large part on the originality of your ideas and your written presentation of these ideas. Presenting the words, ideas, or expression of another in any form as your own is plagiarism. Students who fail to properly give credit for information contained in their written work (papers, journals, exams, etc.) are violating the intellectual property rights of the original author. For proper citation of the original authors, you should reference the appropriate publication manual for your degree program or course (APA, MLA, etc.). Violations are taken seriously in higher education and may result in a failing grade on the assignment, a grade of "F" for the course, or dismissal from the College.

Collaboration conducted between students without prior permission from the instructor is considered plagiarism and will be treated as such. Spouses and roommates taking the same course should be particularly careful.

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

Students with documented disabilities who may need academic services for this course are required to register with the office of Student Accessibility Resources. Until the student has been cleared through this office, accommodations do not have to be granted. If you are a student who has a documented disability, it is important for you to read the entire syllabus as soon as possible. The structure or the content of the course may make an accommodation not feasible. Student Accessibility Resources is located in Student Affairs in AHSC 215 and can be reached by phone at (573) 875-7626 or email at sar@ccis.edu.

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. No other late assignments will be accepted unless there is a serious documented illness or documented deployment.

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 Helpdesk, or the D2L Helpdesk for assistance. 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.