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

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

Required

  •  Scott, L. (2017). Relational Database and Transact-SQL (1st). Scotts Valley, CA: CreateSpace.  Physical Book

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

Recommended

  •  Elmasri, R, Navathe, S. (2015). Fundamentals of Database Systems (7th). London, United Kingdom: Pearson.  Physical Book

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.

Returns: Students who drop a course with physical course materials will be responsible for returning those items to Ed Map within 30 days of receipt of the order.  More specific information on how to do so will be included in the package received from Ed Map.  See here for Ed Map's return policy. Failure to return physical items from a dropped course will result in a charge to the student account for all unreturned items.

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

In addition to the standard technical requirements, you will also need to download Visual Studio Community 2017 with DBMS, a free integrated development environment (you will find a link in the course Content area).

  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%
Exams (2) 200 33%
Total 600 100%

  Schedule of Due Dates

Week 1

Assignment Points Due
Introductions -- Thursday
Discussion 1 10 Thursday/Sunday
Dropbox Assignment 1 20 Sunday
Quiz 1 10

Week 2

Assignment Points Due
Discussion 2 10 Thursday/Sunday
Dropbox Assignment 2 20 Sunday
Quiz 2 10
Proctor Information N/A

Week 3

Assignment Points Due
Discussion 3 10 Thursday/Sunday
Dropbox Assignment 3 20 Sunday
Quiz 3 10

Week 4

Assignment Points Due
Discussion 4 10 Thursday/Sunday
Dropbox Assignment 4 20 Sunday
Quiz 4 10
Midterm Exam 100

Week 5

Assignment Points Due
Discussion 5 10 Thursday/Sunday
Dropbox Assignment 5 20 Sunday
Quiz 5 10

Week 6

Assignment Points Due
Discussion 6 10 Thursday/Sunday
Dropbox Assignment 6 20 Sunday
Quiz 6 10

Week 7

Assignment Points Due
Discussion 7 10 Thursday/Sunday
Dropbox Assignment 7 20 Sunday
Quiz 7 10

Week 8

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

  Assignment Overview

Discussions

In Weeks 1-7, you will participate in an online discussion with your peers. 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 by 11:59 pm CT; peer responses are due Sunday by 11:59 pm CT of the assigned week. Each discussion is worth 10 points. A grading rubric is available in the course. 

Dropbox Assignments

In Weeks 1-7, you will complete 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 folder Sunday by 11:59 pm CT of the assigned week. Each assignment is worth 20 points. A grading rubric is available in the course. 

Case Study

In Week 8, you will complete a detailed Case Study. You will develop a database for a fictitious small school for its management of student records. You will also be required to write SQL statements to answer a few questions. 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 folder Thursday by 11:59 pm CT of Week 8. The Case Study is worth 120 points. A grading rubric is available in the course. 

Quizzes

In Weeks 1-7, you will complete 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 Sunday by 11:59 pm CT of the assigned week. Each quiz is worth 10 points.

Exams

In Weeks 4 and 8, you will complete a 50-question exam. The exams are proctored, closed-book exams. The Midterm Exam covers chapters 1-4 of the textbook. The Final Exam covers chapters 5-7 of the textbook. You will have 120 minutes and one attempt to complete each exam. The Midterm Exam is due Sunday by 11:59 pm CT of Week 4. The Final Exam is due Saturday by 11:59 pm CT of Week 8. Each exam is worth 120 points.

  Course Outline

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

Readings

Chapter 1

Introductions

Please introduce yourself to the class. 

Discussion 1

In this first week, we learned many database terms. To demonstrate your understanding, please explain the following terms. Your discussion should focus on how the terms are related to each other:

  1. Users/Programmers
  2. Database system
  3. Applications
  4. DBMS
  5. Metadata
  6. User data
Dropbox Assignment 1
  1. Install Visual Studio Community 2017 by following Section 1.11 on Pages 18-19. Install the DBMS by checking “Data storage and processing” during installation as shown in Figure 1.11 on Page 19. 
  2. After installing the Visual Studio, you need a database to work on. Open Visual Studio, click Tools on the menu, then SQL Server, then New Query as shown in Figure 1.12 on Page 20.
  3. Write your first SQL statement by following Section 1.12 on Pages 19-23.  
  4. Using a snipping tool app, make a screenshot that is similar to Figure 1.15 on Page 23.
  5. Save the screenshot as Dropbox01. Acceptable formats include .jpg, .png, .docx, or .pdf.
  6. Upload your screenshot to the appropriate Dropbox folder.
Quiz 1

This quiz covers chapter 1 of the Scott text. You will have 120 minutes to answer 10 questions. 

Readings

Chapter 2

Discussion 2

This week, we learned that there are four levels of abstraction of a data model. They are contextual, conceptual, logical, and physical. Briefly explain each level with a focus on the differences between them. When working on the final project for this course, many students go directly to the physical model. What would you say to these students? Why would you say so?

Dropbox Assignment 2
  1. Complete “Database Design Exercise One” on Page 61. We recommend that you use Microsoft Visio for drawing all Entity Relationship Diagram in this course.
  2. Write the following in one SQL file.
    1. Complete “SQL Exercises” 2.5 on Page 63.
    2. Complete “SQL Exercises” 2.7 on Page 63.
    3. Complete “SQL Exercises” 2.9 on Page 64.
    4. Complete “SQL Exercises” 2.10 on Page 64.
  3. Put both Entity Relationship Diagram file and the SQL file in one zipped folder titled Dropbox02 and upload to the appropriate Dropbox folder.
Quiz 2

This quiz covers chapter 2 of the Scott text. You will have 120 minutes to answer 10 questions. 

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

This week, we learned about logical data modeling. We add a primary key to each entity. For example, if we have an entity called STUDENT, we properly will use student ID as the entity’s primary key. Describe an entity that you probably will use two or even three fields as a composite primary key.

Dropbox Assignment 3
  1. Complete “Database Design Exercise One” on Pages 99.
  2. Write the following in one SQL file.
    1. Complete “SQL Exercises” 3.3 on Page 101.
    2. Complete “SQL Exercises” 3.4 on Page 101.
    3. Complete “SQL Exercises” 3.6 on Page 101-102.
    4. Complete “SQL Exercises” 3.10 on Page 102-103.
  3. Put both Entity Relationship Diagram file and the SQL file in one zipped folder titled Dropbox03 and upload to the appropriate Dropbox folder.
Quiz 3

This quiz covers chapter 3 of the Scott text. You will have 120 minutes to answer 10 questions.

Readings

Chapter 4

Discussion 4

This week, we learned enhanced entity relationship diagram (EERD). There are two types of constraints between the super and sub types. They are disjointness and completeness constraints. Answer these questions, given this EERD (available in the course):

  1. Is it required that every entity instance in the STUDENT table be associated with an entity instance in the UNDERGRADUATE table or GRADUATE table?  Why or why not?
  2. Is it possible for an undergraduate student to appear in the UNDERGRADUATE table without appearing in the STUDENT table? Why or why not?
Dropbox Assignment 4
  1. Complete “Database Design Exercise One” on Pages 136.
  2. Write the following in one SQL file.
    1. Complete “SQL Exercises” 4.4 on Page 138.
    2. Complete “SQL Exercises” 4.6 on Page 139.
    3. Complete “SQL Exercises” 4.11 on Page 140-141.
    4. Complete “SQL Exercises” 4.12 on Page 141.
  3. Put both ERD file and the SQL file in one zipped folder titled Dropbox04 and upload to the appropriate Dropbox folder.
Quiz 4

This quiz covers chapter 4 of the Scott text. You will have 120 minutes to answer 10 questions.

Midterm Exam

This proctored exam covers chapters 1-4 of the Scott text. You will have 120 minutes to answer 50 questions.

Readings

Chapter 5

Discussion 5

This week, we learned the ERD to relation mapping. Summarize the eight mapping rules in your own words. Which one do you think is the most challenging? Explain that one in more detail.

Dropbox Assignment 5
  1. Complete “Database Design Exercise” on Pages 185-186.
  2. Write the following in one SQL file.
    1. Complete “SQL Exercises” 5.4 on Page 187.
    2. Complete “SQL Exercises” 5.7 on Page 188.
    3. Complete “SQL Exercises” 5.13 on Page 189.
    4. Complete “SQL Exercises” 5.16 on Page 190.
  3. Put both image file and the SQL file in one zipped folder titled Dropbox05 and upload to the appropriate Dropbox folder.
Quiz 5

This quiz covers chapter 5 of the Scott text. You will have 120 minutes to answer 10 questions.

Readings

Chapter 6

Discussion 6

This week, we first learned normalization; then we learned denormalization. Do we waste time by doing something and then undoing it? Why or why not? 

Dropbox Assignment 6
  1. Complete “Database Design Exercise” on Pages 232-233.
  2. Write the following in one SQL file.
    1. Complete “SQL Exercises” 6.6 on Page 235.
    2. Complete “SQL Exercises” 6.9 on Page 236.
    3. Complete “SQL Exercises” 6.10 on Page 236.
    4. Complete “SQL Exercises” 6.12 on Page 237.
  3. Put both image file and the SQL file in one zipped folder titled Dropbox06 and upload to the appropriate Dropbox folder.
Quiz 6

This quiz covers chapter 6 of the Scott text. You will have 120 minutes to answer 10 questions.

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

The week, we learned relational algebra. In fact, you don’t have to know relational algebra in order to retrieve data from the database. Throughout the book, you learned that SQL SELECT statements accomplish exactly the same thing. Do you agree with the author that you should learn relational algebra? Why or why not?

Dropbox Assignment 7
  1. Complete “Relational Algebra Exercises” on Page 272.
  2. Write the following in one SQL file.
    1. Complete “SQL Exercises” 7.2 on Page 273.
    2. Complete “SQL Exercises” 7.3 on Page 273.
    3. Complete “SQL Exercises” 7.9 on Page 274.
    4. Complete “SQL Exercises” 7.11 on Page 274.
  3. Put both image file and the SQL file in one zipped folder titled Dropbox07 and upload to the appropriate Dropbox folder.
Quiz 7

This quiz covers chapter 7 of the Scott text. You will have 120 minutes to answer 10 questions.

Case Study

This week, you will develop a database for a fictitious small school for its management of student records. You will also be required to write SQL statements to answer a few questions. Your instructor is the product owner. Post questions for approval before making any assumptions.

The business description is outlined in Section 8.1 of your textbook. Your tasks include the following:

  1. Write business rules based on the given business description.
  2. Draw a logical ERD that follows the business rules.
  3. Map the logical ERD to relations by using the relational schema format. An example of a relation in relational schema format is:

    Student (StudentId, FirstName, LastName, MiddleInitial, AdvisorId)

    The above relation name is Student. It has five fields. The primary key is StudentId. A foreign key is AdvisorId.

  4. Complete physical design by writing T-SQL code to generate the database and tables.
  5. Answer all six questions outlined in Section 8.8 of your textbook. Provide a screenshot for the output of each question. Acceptable formats include .jpg, .png, .docx, or .pdf.
  6. Put all above five items in a zipped folder titled CaseStudy and upload to the appropriate Dropbox folder.
Final Exam

This proctored exam covers chapters 5-7 of the Scott text. You will have 120 minutes to answer 50 questions. 

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