Course Syllabus

CIS 205 - Database Management Systems

Course Description

Number of Credits: 4. Prerequisites: CIS 103.

This course introduces the design and implementation of relational data base management systems using Structured Query Language (SQL). The course covers fundamental data base design and implementation techniques and provides hands-on exercises for applying the techniques to real-world problems using database management software such as Oracle or MySQL.

Schedule

• Professor - Taoufik Ennoure - tennoure@ccp.edu
• CIS-205 - Section 001 - 40684
• Semester - Fall 2019
• Meeting Times – Saturdays 8:00 am-3:10 pm
• Meeting Location – C3-20 Center for Business and Industry
• Dates - Oct 01, 2019 - Dec 14, 2019
• Office Hours
• Location - Center for Business & Industry C3-1, E 
• 11:15 am to 2:45 pm Mon
• 4:45 pm to 6:00 pm Tues
• 4:45 pm to 6:00 pm Thurs

The tentative schedule of lectures and assignments can be viewed below or on the calendar. I reserve the right to adjust dates or the order to provide the best learning outcomes.

Texts & Materials

Textbook:

Title: Database Systems, Design, Implementation and Management Author: Carlos Coronel and Steven Morris Edition: 11th Publisher: Cengage ISBN: 13: 978-1-285-19614-5

 

Software:

We will use some utility and development software in this course.  All of the software applications that we will use in class are installed on the computers in the classroom and on the computers in the SACC Open Computer Labs.  If you plan on working on assignments from home, they may be downloaded from their websites listed below:

NOTEPAD ++

This is an Open Source Text Editor used to create SQL commands.  It recognizes reserve words and other special syntax in the SQL Database Language.  I will use this editor to illustrate examples of SQL Script.  All SQL Script must be written using a text editor not a word processing program.  You do not have to use NOTEPAD ++, however, you must use a text editor when writing SQL script for the course.  Notepad ++ will only function on a Windows Platform

All SQL Script must be submitted as file in a Text File Format. SQL Script in a Word Processor Format or copied and pasted into the Canvas will not be accepted as an assignment submission

Link to Download Note Pad ++: http://notepad-plus.sourceforge.net/uk/download.php

MySQL Community SERVER

Students wanting to work at home will need to download a version of MySQL Server. When we get to applied database activities, this will be the primary software that we will work with.  You may use the following link to acquire a free copy of MySQL.  Select the MYSQL Community Server link from the download portal. You may then select from the version that matches the Operating System (OS) that you have at home. This is a fully functional Enterprise Level Relational Database Management System (RDBMS).  If you are using an Apple Computer at home, you must use interface software to send queries to MySQL. We will use a Microsoft Windows OS in class. Microsoft Windows does not require the use of interface software.  Students using a Mac OS will have to install an additional software plug-in named Workbench from Oracle.  If you plan on using the Workbench plug-in, you will have to learn to use it outside of class. During class lectures and demonstrations, I will use a Windows Platform and execute SQL commands form a SQL Command Line Interface.

https://dev.mysql.com/downloads/mysql/

https://dev.mysql.com/downloads/workbench/

Visual Studio Code

This is an alternate text editor for Windows User s or Mac Users. If you are working on assignment away from campus on a Mac, Visual Studio Code is the recommended text editor.   Video Studio Code is recommended people using a Mac OS Platform.  Notepad ++ will not run on a Mac OS Platform.

https://code.visualstudio.com/

 

Student Learning Outcomes

1. Design and Create Conceptual Relational Database Using a professional modeling application
2. Implement Physical Database from a Conceptual Design
3. Work as part of a professional team to design, code, test and debug normalized databases
4. Correctly use the elements of Relational Algebra retrieving result sets from relational databases
5. Create source code and execute SQL statements that are syntactically correct
6. Demonstrate a knowledge of input and output routines, data types, and data operations
7. Demonstrate a knowledge of key concepts in Database Theory

Keeping Up

This class is structured to accelerate. It's going to start slow but each week builds on what you've learned in the weeks before. You can't afford to miss a lesson or fall behind.

Exams, Assignments and Grading

Final grades will be determined based on a weighted percentage of the total points each student has earned in several categories of assignments during the semester. The percentage for each group is calculated by dividing the total points earned by the total possible points that you could have earned during the semester.

Assignment Type	Percentage
Discussions/Reflections	5%
Quizzes	10%
Exams	30%
Assignments	20%
In Class LABS/Mini Projects	10%
Final Exam/Final Project	25%

Below is a chart of percentages as they relate to the letter grade.

• A - 90 to 100 %
• B - 80 to 89 %
• C - 70 to 79 %
• D - 60 to 69 %
• F - less than 60 %

 

Submitting work

You must submit all work in the Canvas LMS drop Box, Email submissions will not be accepted. Follow the instructions for the type of submission needed for any specific assignment or Project.

Submit all work on time before the due date. I do not give any extensions. Forgetting an assignment is due is not a valid excuse for late work.

Late Work

You are expected to turn in work on time. You have one week to turn in work on time, another week to turn it as late with 30% penalty and after that the assignment will be close and a grade of 0 will be assigned for that work.

Attendance

Attendance is important for all the classes and participation is highly recommended in the class. In case of situations where you have to miss a class, make sure you check on Canvas what was covered, you will be responsible for all the work that you missed.

Participation is Key!

A great deal of educational research has shown that the single biggest factor in determining final grades is class attendance. No other factor, not I.Q., SAT scores, family wealth, ethnic origins, nor any other factor correlates as closely with final grades as classroom attendance. If you show up for class and do the required work each week you will do well, if not, you won’t do well. This is true, in part, because colleges and universities have a complex system of placement and prerequisites to make sure you are in a course that you are able to handle. You must show up for class and do the required work each week to do well in the course. Your grade is directly related to how much you participate in the course.

Canvas and Computer Resources

Success in the class depends on your ability to use Canvas. If you have problems using Canvas, then please contact Vaishali Sharma, at vsharma@ccp.edu. For more information about Canvas, or Distance Education, please see the Distance Education Website at: http://www.ccp.edu/site/de/

The College has a number of open lab facilities for students who wish to do their work on-campus. For more information see the posted schedules of the SACC Computer Labs in MyCCP;

• Main Campus - (CBI Building SACC) 18th and Callowhill Street
• Northwest Regional Center - 12901 Townsend Rd
• Northwest Regional Center - 1300 W Godfrey Ave.
• West Regional Center - 4725 Chestnut St.

Students are expected to utilize College computer resources as part of this class, including websites, networks, and the possible use of physical facilities. You are expected to become familiar with the policies and accepted behavior for these resources. Any violations of their rules that results in a student being removed from or banned from using a College facility are grounds for dismissal from the course -- such as attempting to remove, copy, or install software on the College's systems.

Learning Lab Support

The Learning Lab will provide tutorial support for students requiring one on one tutorial support for this class. They may even be able to provide one on one tutorial support online using video conferencing. For more information on tutorial support for CIS courses contact:

• Mavis Pogue.
• B2-36d 215-751-8474
• mpogue@ccp.edu

Counseling

The College has excellent counseling services available. If you are having any personal problems that might interfere with your progress in class or toward a degree, including difficulties related to military service, please visit or contact our counseling center in room BG-07 on the Main campus or at any of our Regional Centers. More information, including contact information is online at: http://www.ccp.edu/site/current/support-services/counseling.php

College Policies

The Computer Technologies Department adheres to all College policies. These can be found in your Student Handbook or at the following url: https://www.ccp.edu/college-catalog/college-policies-and-procedures

Financial Aid:

Please see the College catalog regarding impact to Financial Aid if you drop this course.

Contacting the Instructor

It is best to reach me via the Canvas communication system as it goes to both my email and will be associated with your class in canvas. My email is tennoure@ccp.edu but for class related questions or concerns Canvas is best.

Classroom Conduct

You should be punctual, alert, and prepared for each class session. You must be considerate of other students, which includes being quiet during class lecture and discussion except when you have something to contribute to the class. Cell phones and beepers will be turned off or on vibrate mode for the entire class. If necessary, you will take calls outside the classroom. Food, beverages and their containers are not permitted in the classroom.

Academic Integrity Policy & Process:

Students must do their own work when the assignment specifies that it is an individual assignment. Assignments that are collaborative will be designated as being so. Plagiarism will not be tolerated. Any assignment presented by a student in fulfillment of course requirements must reflect his/her own work unless credit is properly given to others. If you find code or a technique to perform a part of your work on a website other than the Canvas course for this class, you must add a citation as a comment in your code. Anyone who assists another in such academic dishonesty is equally responsible. The grade on the assignment will be an "F" for all parties involved, if an academic integrity violation is discovered.

Academic Dishonesty

Violations of academic integrity can include, but are not limited to, cheating and plagiarism. Cheating is an intentional effort at deception or gaining of an unfair advantage in completing academic work. Plagiarism is the act of appropriating the work of another person and passing it off as one's own. Any student who assists another in an activity that constitutes a violation of academic integrity is also responsible and accountable for such a violation.

AS FOR THIS COURSE

• Strike 1 - you and the parties' involved will be given a ZERO (0) for the assignment NO MAKE UP.
• Strike 2 - you and the parties' involved will drop one final letter grade. This simply means that if you are carrying a B average in the course, your final grade will be a C. This will be the grade that you are "entitled" to as a result of your actions.
• Strike 3 - you and the parties' involved will fail the course.

Additionally, any party that is involved in an act of academic dishonesty will be reported via the college's reporting system which will likely result in a hearing with the dean.

Disability Accommodations Policy

Students who are registered with the Center on Disability must inform the instructor by the end of the first week of classes if special accommodations are requested. Proper documentation must be presented.

Important Dates

Be aware of important dates such as the final day to withdraw, the first day to enroll in classes for the next semester, and financial aid deadlines by referring to the academic calendar. http://ccp.edu/college-catalog/academic-calendar

 

Tentative course outlines

 

Week 1	Introduction to the course Introduction to Canvas LMS Introduction to Modern Relational Database Management Systems (RDMS) Single Table Queries Data Types and Data Models  Single Table Queries Introduction to Database
Week 2	Requirements and Database ER Model  Single Table Queries Entity Relationship (ER) Modeling Single Table Queries Creating Metadata and Data Dictionaries
Week 3	Single Table Queries Enhanced Entity Relationship (ER) Modeling Normalization of Database Tables First Normal Form Second Normal Form Third Normal Form
Week 4	Relational Algebra ·      Unions ·      Joins ·      Intersections ·      Differences
Week 5	Structured Query Language (SQL) ·      SQL Multi-Table Joins ·      Data Definition Language(DDL) ·      Data Manipulation Language             (DML) ·      Data Control Language (DCL)   Implementing a Database with MySQL MySQL Data Types MySQL Constraints
Week 6	Structure Query Language ·      SQL Multi-Table Joins ·      Advance Select Statements ·      SQL Multi-Table Joins ·      Updating Tables ·      Deleting Rows/Tuples
Week 7	Advanced SQL ·      Sorting and grouping data ·      Using Built in Functions Computed Fields Advanced SQL ·      Altering Tables ·      Nested Queues/ Inner Queries
Week 8	Procedures and Triggers ·      Introduction to MySQL Procedures ·      Introduction to MySQL Triggers
Week 9	·      Distributed Computing and Distributed Databases ·    Business Intelligence and Datawarehousing Final Review
Week 10 Finals Week	Final Exam Final Projects Are Due