Course Introduction Overview

Week 1 - Chapter 1

 

Topic:  Fundamentals  of Database Systems

 

 

  • Read the weekly overview

  • Read the lecture notes posted in weekly modules

  • Participate in the weekly discussion forums

  • Review the supplement documents and example code posted in the weekly modules

  • Attempt the weekly practice exercise

  • Complete the weekly assignment

  • Complete the weekly quiz

 

 Since this is a face to face section of the CIS 205 course, it will be your responsibility to participate in many of the home work assignment activities outside of the scheduled hours for the course.  If you do not have your own personal computer, CCP provides computer resources in the Student Academic Computer Center (SACC ) Open Computer Labs.   As the semester progresses, it will be to your advantage to read ahead and be prepared for the topic. The reference material in the modules will be available for your review throughout the semester. We begin this week by first going over the class Syllabus.  The syllabus is the binding contract that instructors have with tier students.  There are two major reading activities this week.  The first is to read Chapter 1 in our courses textbook.  This chapter will prepare you for the weekly quiz for this week and the two discussion topics for the week.  To get full credit, when participating in a discussion forum, you must first post your own unique contribution, and then post on at least two other student's contribution to the discussion.  

The second major reading assignment is a PDF file that will start to prepare you for writing single table queries using the SELECT statement in the Structured Query Language (SQL).  During the first seven weeks of the course we will get weekly practice writing single table queries in SQL.  During the second half of the semester we will expand that and work primarily with multiple table queries.  Both of the reading documents for his week will begin to explore what a database is and how information is structured and stored in modern database management systems.   

 

This will be a light week since we only meet once in class because of the holiday.

 

Highlights This Week

Introduction to Course

 Review Syllabus

Overview of Relational Database Management Systems

Overview of Basic Select Statement Structure

Writing Single Table Queries  

 Homework

 Single Table Query Assignment

Readings

 Database Management Systems PDF File

 Chapter 1 in Textbook

Example Exercise

 Will discuss during class.  I will work out an example exercise of writing single table queries for you in class 

Online Discussions for the Week

Discussion 1

  •  What is the role of a DBMS, and what are its advantages? What are its disadvantages?

Discussion 2

  •  What is a DBMS, and what are its functions?

 

Weekly Quiz 

Complete Week 1 Quiz online