CIS 211C - Special Topics in Database - Introduction to Oracle Database Design and SQL
Syllabus
Fall 2009 - Traditional & Online Classes
 

 

Instructor:  Marge Hohly
Email address:  m.hohly@verizon.net
res02i0t@gte.net
Hohly@cerritos.edu
Home page:  http://www.cerritos.edu/hohly
Location & Time:  Tuesday 7:00 - 10:00 pm BE-12
Online section orientation 8/18/09 in BE-12 7-10 pm
Ticket number:  CIS 211C - #22148 (Online)
CIS 211C - #22147 (Traditional)
Phone number: 

Skype address:

(562) 860-2451 Ext. 2736 voice mail available 

marge.hohly
Office hours:  6:00 - 7:00 p.m. Tuesday in SS-25 or BE-12
4:00 - 5:00 p.m. Wednesday in SS-25
4:00 - 5:00 p.m.Thursday in SS-25
Office: SS-25

 

Textbooks: 

Textbook material provided online in the Oracle iLearning Center  
Support materials will be provided on the websites to support this class  
Materials:  A USB drive for your copies of assignments and class work. 
 

 


 
BASIS FOR DETERMINING COURSE GRADE

Lab Assignments 14 @ 20 points each

280

4 Exams  @ 50 points each

200

2 part Final Exam @ 50 pt

100

Total Points

580

  A=522 , B= 464 , C= 377, D= 290 , Fail= 289  and below


 


Tentative Schedule  

Week
day

Topics to
be covered

Database Design Chapters
Lecture Lessons

Database Programming Chapters Lecture Lessons

Quizes
&
Exams

Lab
Assignments

1
Aug. 18

  • Overview of class
  • Introduction to iLearning
Section 1       

2
Aug. 25

  • Conceptual and Physical Models
  • Entities, Instances, Attributes
  • Relationships
  • ER diagrams
Section 2 & 3

  

  Lab 1

3
Sept. 1

  • Subtypes and Supertypes
  • Business Rules
  • Relationship types
  • Many-to-Many relationships
Sections 4 & 5     Lab 2

4
Sept. 8

  • Normalization & First Normal Form
  • Second Normal Form
  • Third Normal
  • Unique Identifiers
  • Arcs, Hierarchies, and Recursive Relationships
  • Historical data modeling
  • Labor Day 
    Monday Holiday 9/7
  Section 6 & 7     Lab 1 Due 9/8
Lab 3

5
Sept. 15

  • Modeling attributes which change with time
  • Drawing conventions
  • Generic Modeling
Section  10 (L1-4)
& 11 (L1 - 2)

 

  Lab 2 Due 9/15
Lab 4

6
Sept. 22

  • Relationship mapping
  • Subtype modeling
  • Introduction to SQL, database and Queries
 Section 12  (L1, 2, 3, 4, 5)  & 13 (L 1,2)    Database Design Exam 1 (midterm) Lab 3 Due 9/22
Lab 5

7
Sept. 29

  • Anatomy of SQL statements
  • Selection criteria, data types
  • Limiting columns and rows
  • Comparison operators & precedence rules
 Section 16 (lessons 1 - 4)  & 17 (L1-3)     Lab 4 Due 9/29
Lab 6

8
Oct. 6

  • Logical Comparisons and Precedence Rules
  • Sorting
  • Functions
  • Case and Character manipulation
  • Number & date functions
 Section 18 Section 1    Lab 5 Due 10/6

9
Oct. 13

  • Conversions
  • General and conditional expressions
  • Null Functions
  • Conditional Expressions
  • Cartesian Products and Join operations
  • Nonequijoins
  • Outer and self joins
     Section 2 & 3 Database Design Final Exam (Exam 2) Lab 6 Due 10/13    

10
Oct. 20

  • Cartesian Products and Join operations
  • Nonequijoins
  • Outer and self joins
  • Cross-joins and Natural joins
  • Inner Vs. Outer joins
  • Join Clauses
  Section 3 & 4    Lab 7 Due 10/20  

11
Oct. 27

  • Group functions
  • COUNT, DISTINCT, and NVL
  • GROUP BY and HAVING clauses
  • Subqueries
  • Single-row subqueries
  • Multiply-row subqueries
  Section 5 & 6
 
   Lab 8 Due 10/27
12
Nov. 3
  • INSERT and Updating values
  • Deleting rows
  • DEFAULT, MERGE statements
  • Creating Tables
  • Modifying tables
  Sections 7 & 8
 
 Lab 9 Due 11/3
13
Nov. 10
  • 11/11 Veteran's day Wednesday Only holiday campus closed
    Exam #1 Database Programming
(Midterm Part 1 & Midterm Part 2) after Section 7 complete online by Friday
Lab 10
Due 11/15
14
Nov. 17
  • NOT NULL, UNIQUE  contraints
  • PRIMARY KEY, FOREIGN KEY, & CHECK constraints
  • Managing constraints
  • In-Class Views
  • DML Operations and Views
  • Managing Views
  Sections 9 & 10
 
Lab 11
 Due 11/17
15
Nov. 24
  • Sequences
  • Indexes and Synonyms
  • Security, Privileges
  • User Access control
  • Grant & Revoke Privileges
  • Thanksgiving Holiday Thursday-Sunday Nov. 26-29
  Sections  11 &  12    Lab 12
 Due 11/24
 
16
Dec. 1
  • Application builder
  • Database Transactions
  • Final Exam prep
  Sections  14
 

 
 Lab 13
 Due 12/1
 
17
Dec. 8
  • Review and Prep for Exams

 
Complete Lab assignments  and your application

 

   Lab 14
 Due 12/8

 Lab 15  (Bonus)
 Due 12/8
18
Dec.15
  • Final Tuesday, Dec. 15 - 8:00 - 10:00 p.m.
    Comprehensive
   Final Exam Section 16 Final Exam (Part 1 and Part 2) (after section 14)  

Please Note: CIS labs are closed during final exams, 12/12 - 12/18.
Last day to drop with a "W" is 11/20

The above schedule is subject to change.

NOTE:

NOTE:  The student who wants to work at home, will need access to Internet.  You will be provided with access to the text and testing materials through iLearning on the Oracle Academy website.  Your user access code to this site will be provided by your instructor.  You will also need access to the Application Express (APEX) SQL server.  This again is accessible via a web browser.  The user ID and password will be also provided by your instructor when they become available.  

The lab assignments and links to lecture and supporting materials are found on the class web pages.  There are three sites for this section.  One at Cerritos College (http://www.cerritos.edu/hohly/),   the iLearning site and APEX.   Please refer to these pages for more information.  Make sure that you print out the separate sheets that contains the lab assignments.

Revisions to schedule will be made to the syllabus and posted on the web sites for this class. Lab, lectures, and supporting materials for this class are posted on the two main sites (Cerritos College website, and iLearning).  Some things are only available on the iLearning site.  The iLearning site has exams, lecture notes, and quizes  not found on the Cerritos site.  Instructions to log on to the site will be provided during orientations. The Cerritos website contains the information like the class syllabus, lab assignments, powerPoint presentation, support material, links to iLearning and APEX and other procedural materials.   It is the students responsibility to retrieve their assignments from the Web pages. All assignment must be submitted to your instructor via email (m.hohly@verizon.net), or submitted in class by the due date/time.  They will ONLY be accepted via email to the m.hohly@verizon.net address, or on paper in class.   The difference between submissions for the traditional and online class will be discussed at the class orientation.  The traditional student will need to submit the printouts and  files when requested.  The online student MUST submit their files via email to the m.hohly@verizon.net address and they will have more detailed submissions online.  This will be explained at the orientation and in the online lab instructions.

Remember it is critical to keep in contact with your instructor.  If you have not been heard from  for 3 weeks or are not making academic progress you will be dropped from the class.

Academic Honesty/Dishonesty Policy:   The work submitted by each student in this class is expected to their own work, not the work of others. Please be sure to read the college’s Academic Honesty/Dishonesty Policy found in the catalogue and schedule of classes.  A copy of the catalogue is located at www.cerritos.edu and the Academic Honest/Dishonesty Policy is found on pages 135-136 of the Fall 2009 schedule of classes.   Don't put your credit in this course at risk by violating this policy. 

For tests be sure to study and answer questions on your own without help from other students.  For the homework assignments make sure you create your own files from scratch and do your own typing.  I know some of you work together, share books and computers.  That’s OK.  What is not OK is having one person type up the assignment and then submitting it (file or printed document) for multiple students.  Trust me I have ways of figuring it out if you are cheating in this manner.  If I determine that you are cheating, then I will do one of the following actions as stated from the college’s policy:

One or more of the following actions are available to the faculty member who suspects a student has been cheating or plagiarizing:

1. Review-no action.

2. An oral reprimand with emphasis on counseling toward prevention of further occurrences.

3. A requirement that work be repeated.

4. A reduction of the grade earned on the specific work in question, including the possibility of no credit for the work.

5. A reduction of the course grade as a result of item 4 above, including the possibility of a failing grade for the course.

6. Referral to the Office of Judicial Affairs for further administrative action, such as suspension or expulsion.


 


 

(C211cFa2009syl_T.htm)
 last update:  08/25/2009