Course Syllabus
For information on Computer Information Systems and Computer Science programs and courses at Community College of Philadelphia try:
Description Computer Information Systems 205 - Database Management Systems 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. Prerequisites: CIS 103.
Upon completion of this course students will be able to:
Who Should Take Course and Why This course is structured for student wanting advance training in designing, implementing and interacting with relational databases using professional Relational Database Management Systems RDMS. Additionally, students wanting to survey advanced concepts in the Database Theory, Database Programming, and Database Implementation should take this course.
Instructor:
This Fall 2019 semester, the CIS Programs are recommending that students purchase one of the Cengage Unlimited packages when purchasing the textbook for this course. Cengage is offering a program named Cengage Unlimited. The Cengage Unlimited Program permits students to access any Cengage digital textbook for a single fee.
One of the reasons that the Computer Technology Department has opted to try this program is that it can save students a lot of money in textbook expenses. Many courses that a typical student takes in their path to completing the Computer Science program at CCP uses a Cengage textbook. Below is a list of courses that many Computer Science students may use is their path to completing the program that uses a Cengage Publishers textbook
There are also some courses in other CIS programs that are using Cengage textbooks. Student may opt to purchase one of the Cengage Unlimited packages or they may purchase the textbook individually. Every student should make the decision based on the courses that they are scheduled for and their personal preference in textbook formats. Some students may prefer a physical textbook, and some may take the option for a digital format. The Cengage Unlimited packages are for students that prefer the textbook in a digital format. The Cengage Unlimited option also permits students to rent and obtain a physical copy of the textbook at reduced rate. The rate is $ 7.00 per copy of the textbooks that they are using for the semester. Students must have purchased a Cengage Unlimited package to rent the physical book at his reduced rate.
Textbook Title: Database Systems: Design, Implementation and Management Authors: Carlos Coronel, Steven Morris Publisher: Cengage ISBN: 978-1-305-62748-2 Hard Copy Book Price: $ 250.00
CENGAGE UNLIMITED - 4 Month Access Printed Access Card ISBN: 9780357700037 $119.99 MSRP
CENGAGE UNLIMITED - 1 Year Access Printed Access Card ISBN: 9780357700044 $179.99 MSRP
CENGAGE UNLIMITED - 2 Year Access Printed Access Card ISBN: 9780357700051 $239.99 MSRP
We will also rely heavily upon the courses textbook, classroom notes, online tutorials, Internet references and exercises distributed through the Canvas Learning Management System (LMS) by the instructor. Each week, Canvas, the Website for the class, will be updated to include links to the upcoming week’s material and assignments. Also, weekly announcement will be sent describing new concepts and weekly assignments. The Website for the class is accessed through the Canvas (LMS). We will review how to access the Canvas LMS in our introduction to the course lecture, the first day of class.
From the start of the course, students will need to use a professional text editor that is SQL enabled. Students with Windows Operating Systems (OS) may use the free open source text editor named (Note Pad ++) or Visual Studio Code, they are both SQL enabled text editors; I will demonstrate how to use them in one of our face to face meetings. If you are working from home, and using Microsoft Windows, I strongly recommend using Note Pad ++ when creating SQL script in the class. All SQL text files must be submitted with an SQL extension.
If you are using an Apple Desktop (OS) or a Linux Desktop OS to execute your SQL Script, I will suggest some additional professional industry recommended application tools and text editor applications to you in weekly class announcement. Visual Studio Code will operate in Apple OS Platforms. If you have an apple Mac OS platform, this is the recommended tool to use for writing SQL script. All SQL script must be written using a text editor, not a word processor. SQL script submitted in Word Processing format will not be accepted. All SQL text files must be submitted with an SQL extension.
SOFTWARE FOR THE COURSE Students taking this course are entitled to a Microsoft Imagine account. Microsoft Imagine, formerly known as DreamSpark, this is a Microsoft program to provide students with free software design and development tools. Once again, at no charge. This will provide the privilege of downloading many Microsoft products free of charge. Microsoft Office however, is not included in the list of products that are available to you for free download. It may take a couple of weeks to get your Imagine accounts activated. I will wait for the final class list before sending the final class list to the Microsoft Imagine account manager. If you require a productivity suite such as Microsoft Office, you may download a free open source office suite such as Libre-Office. Additionally, for productivity suits activities and tasks, you may use a web services such as Google Docs or Microsoft 365 to write your professional documents for the course. To my understanding, all students will have access to install Microsoft Office 365 at no cost on your Personal Computers through your MyCCP account. To my understanding you have up to five installs for 5 different personal devices We will use additional utility 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/
MICROSOFT VISIO During the first half of the course, students will explore and get exposed to concepts and skill sets in Database Modeling. It is strongly encouraged to put extra effort into modeling your assignments using a professional modeling tool. The modeling tool of choice for this class will be Microsoft Visio; you may also use Microsoft Word and its drawing tools, as the modeling assignments will not be very sophisticated.
*** All submitted ER Modeling Assignments must be submitted as a PDF document with your name embedded in the document ***.
Optionally, you can use an online service such as Gen My Model. This may be a helpful tool to students who wish to use Mac Computers at home. MS Visio only can only be installed on a Windows Operating System. Gen My Model is an online tool that you can use through your web browser. It can be used as a substitute modeling tool for Mac Users to make ER Diagrams. Windows and Linux users can also use this tool as an alternative to MS Visio. There will is only one assignment where a Visio Crows Foot Style Diagram will be required. If you do not have access to MS Visio, you can use college resources in the SACC Open Computer Lab to complete this assignment. The minimum requirement for all other modeling assignments will be a Chen Diagram. You will be able to do Chen Diagramming with a professional Word Processor such as Microsoft Word. Use the link below to access Gen My Model Mac Users also have the option of installing a virtual machine on your Mac, and then acquiring a version of Windows from your Microsoft Imagine registration. Once Windows is installed on the Virtual Machine, you can download and install Visio to your Windows running on your virtual machine. I included a download to Virtual Box, a free virtual machine software program.
Another online service to make ER Diagrams is the Draw.io web service.
Topics, Schedule and Links to Class Notes The class meets Tuesday and Thursday 9:40 am to 10:55 pm in room C3-12 from September 3, 2019 through December 15, 2019. This is a hybrid version of CIS 205. This section meets face to face in the classroom and online using Canvas. Students will have access to the course online using the Canvas Learning Management System (LMS). You will be able to access all class resources online including a digital version of the textbook using the Canvas LMS. All assignments must be submitted through the Canvas LMS.
The class meets both face to face in class and online for assignment submissions and supplemental material during the Hybrid section of CIS 205. Details of the course schedule, such as notes on upcoming topics in classes, will be posted in Canvas as the course progresses. Some content may get more emphasis then others and some material may move to different weeks depending on the needs of the class. At times I may augment topics, assignments and schedules as needed. This is a 7-week Hybrid Computer Technology course. The class also uses some online tools, the primarily tool will be the Canvas Learning Management (LMS). We will also correspond regularly using CCP Email Canvas Messaging, and Canvas Announcements. It is your responsibility to review your CCP Email and Canvas Announcements regularly for class announcements and updates.
For the official College Academic Calendar, see http://www.ccp.edu/site/academic/academic_calendar.php
Projected Weekly Schedule
Grading During the semester there are several different types of graded activities
Final grades will determined based on the percentage of the total points each student has earned during the semester. Grades will be calculated by dividing the total points earned by the total possible points that you could have earned during the semester. The Canvas LMS may not accurately display your up to date class percentile. You should keep a running total of the points that you earned and the total possible points you could have earned each week during the semester. This will provide you with the most accurate view of your grade during any week. Below is a chart of percentages as they relate to a letter grade.
A – 90% to 100 % | B – 80% to 89 % | C – 70% to 79 % | D – 60% to 69 % | F - less than 60 %
If you have questions about specific grades or your overall progress at any time during the semester, then please consult with me. I will be glad to review individual items and your overall grade at any time. See me during lab times in class or you may schedule an appointment with me during my posted office hours for the semester.
All College policies regarding attendance, classroom behavior, etc., will be enforced, and may affect your grade as the instructor deems appropriate.
Assignments Each Module in Canvas contains a list of assignments for that module. In CIS 205 each module may contain the following types of assignments: SQL Assignments must be submitted as text documents format, preferably with an SQL extension, not in a word processor format. ER Diagram Assignments must be submitted in PDF Format. Metadata Assignments must be in a Word Processor Table Format, Spreadsheet format or PDF Format.
In Class Practice Assignments: This type of assignments in done in class during lab time or lecture time. This typically will involve following along in class as your professor demonstrate the skills needed to do the homework assignment in the module. In some instances it will also involve a little problem solving on your part. Sometimes the problem solving will be an individual independent task. Other times it will involve a collaborative effort in groups or as a class. The skills that will be illustrated parallel the skills needed to do the associated homework assignment in the module. In you miss the in class demonstration, you are still responsible for the in class assignment. In the event that you miss attending an in class practice assignment demonstration, you should collaborate with students or schedule a meeting during your professors scheduled office hours for assistance. Most in class practice assignments will remain open a couple of days past the day the activity was reviewed in class.
All Practice Assignments must be submitted through the assignment submission drop box in the Canvas LMS Email submissions will not be accepted
Homework Assignments: This type of assignment is done outside of the classroom. You may use college resources or your own personal resources to complete the assignment. The college provides SACC Open Computer Labs for your use. These labs are on every CCP Campus. You should research the hours of availability of the SACC Labs if you choose to use college resources for your homework assignments.
You may also use your own personal resources to complete the homework assignments. All of the software used in this course is free Open Source Software. The software can be obtained by downloading and installing the programs to your own personal computer. The software will run on a variety of Operating System (OS) platforms including Windows, Apple OSX and Linux. A couple of the software applications are Windows specific. You can make adjustments to this using alternative applications. This may require a little extra effort on your part. The recommended OS for this course in Microsoft Windows. There are some additional difficulties using some of the course software on a MAC OS
All Homework Assignments must be submitted through the assignment submission drop box in the Canvas LMS. Email submissions will not be accepted
Discussion Assignments: This type of assignment is an asynchronous chat between you and your classmates. This means that everyone is not participating at the same time. In most cases you will have at least a week to participate in the discussion assignment. It is best to start participating early in this type of assignment. From time to time I will participate to make sure everyone is on track of the topic. In order to get full credit for this type of assignment, you must post your own reply to the discussion topic. After posting your own reply, you must read the posts of several other classmates. You must then reply to the posts of at least two other participants in the discussion. This includes the replies of your other class mates or your instructor for this course.
Weekly Quiz Assignments: This is type of assignment is a chapter quiz. Most modules in this course is associated with a corresponding chapter in your textbook. Most weeks will include a brief quiz of concepts and terminology covered in the assigned chapter associated with the module. To prepare quizzes, you should thoroughly study the associated chapter. If the section is face to face, you should also attend the scheduled lecture of the topic prior to taking the quiz. If the section is online or hybrid, you should repeatedly study the chapter prior to taking the quiz. Quizzes re primarily multiple choice and (true or false) questions The quizzes will be administered online through the Canvas LMS
Projects: There will be at least 1 major comprehensive project, which together with your weekly assignments will count towards your final grade. Some smaller projects and weekly assignments will be completed collaboratively in groups. Group Project grading will be a combination of group contribution and individual contribution. Students should start to interact with other students in the class to start forming groups. Students should inquire about each other’s availability and pick a group leader to take responsibility for coordinating group activities.
In Collaborative Projects, each student must submit their own copy of the project into Canvas
As previously mentioned, most weeks will have one or more discussion topics to respond to. Discussion forum points will count towards your final grade. There will be additional graded lab work and weekly assignments that will prepare you for the projects and exams; these will also count towards your final grade. You will have to use the material learned in class, textbook and additional class material to complete work in the lab assignments and projects. More information about lab assignments and projects will be posted for download in the Weekly Modules of the Module section in our courses website, Canvas, as the semester progresses. In Collaborative Projects, each student must submit their own copy of the project into Canvas Quizzes There will be a series of weekly quizzes in the course. In fourteen week versions of this course, there will be a weekly quiz. In seven week versions of this course, there will two weekly quizzes instead of one weekly quiz. A comprehensive final exam will be optional for students wanting to increase their final grade.
Assignment Submissions – All assignments are to be submitted through the file submission portal using the submit link for the assignment in the Canvas LMS. All submitted assignments document names must include your name and assignment name in the document being submitted. Any assignment submissions not following this naming format will not be accepted. Assignments will not be accepted through email. Do not attempt to submit your assignments as email attachments. If missed the assignment’s deadline date, you must request the reopening of the submission portal once the submission portal has closed. I will reopen the submission portal if the reason is justified. If I reopen an assignment, I will announce the reopening to the entire class. This will permit an equal opportunity for everyone. I do not accept hand written or printed material. Assignments must be created using a modern productivity tool such as text editors, Word processors, Spreadsheet, Presentation application. Assignments submitted late are subject to a late penalty. Once an Assignment’s Scores are released and Assignment Feedback is provided, that assignment will no longer we accepted for assessment. Do not send assignments by email, they will not be accepted by email.
Some important Submission Notes
Notes from the Instructor – Keys to Successful Learning Education is a Social Process Architects use the metaphor of the campfire and the cave to describe spaces they are designing. A campfire is a place where people come together to be with one another to work, play, etc. A cave is a place where a person can rest, read, etc. alone quietly. Architects design business spaces to have both campfires and caves – places where they can conduct business and commerce with other people and places where people can work alone quietly when necessary. Successful students need to spend time both at the campfire and in the cave. They need to engage with teachers and other students in classrooms labs, online forums, and so on, but they also need to have a time and place to work alone, reading studying, and developing a personal understanding of the course material. In other words, education, like life itself, is both a social process and a personal psychological process.
We learn from other people and with other people. You should take the opportunity to communicate with and work with other students and your teacher. You can learn from them and they can learn from you. The course will be easier and you will learn more if you become part of the social fabric of the course.
Yet, ultimately, we learn best by developing a personal understanding of the course material. We each need to spend time studying away from others to develop a personal, inner understanding of the course material beyond what can be learned communally.
This course moves along quickly. There will be reading and written homework assignments each week, So, you will need to quickly establish a pattern for how you will participate in the class each week and when you will find time to do your course work, alone, and working with others. Learning Demands Participation Woody Allen once said “The hardest part of making a movie is to get the actors to show up on time. The rest is a piece of cake.” The same thing is true for learning – students who show up for class and do their work each week will do well.
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.
This is especially true in a weekly-oriented distance education course. Your grade is directly related to how much you participate in the course.
Computer Labs All instruction will be in a computerized classroom with one workstation per student. Each workstation is connected to the College-wide network, with Internet and e-mail access, so students may e-mail files between the classroom and home. Class time includes approximately two hours per week of lab time. You will still find it necessary to complete work outside of class.
The College has several open lab facilities for students. For more information visit the Student Academic Computing Center in room C3-17. An introduction to these facilities is included in the classes at Community College of Philadelphia that are prerequisite to this class.
Students are expected to utilize College-owned computer facilities as part of this class, including physical facilities, networks and Internet access and to become familiar with the policies and accepted behavior for these facilities.
The classroom-based version of this course meets for five hours per week. You should allow several hours per week for study and several hours per week for your lab assignments and homework assignments. The College has a number of open lab facilities for students who wish to do their work on-campus. For more information see; ATTENDANCE POLICY FOR FACE TO FACE SECTIONS:
Canvas and Computer Resources 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:
Student Academic Computing Centers (SACC)
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
- Policies: The CIS Department adheres to all College Policies. These can be found in your Student Handbook or at the following hyperlink:
Financial Aid:
Please see the College catalog regarding impact to Financial Aid if you drop this course.
Messages:
It is best to reach me via e-mail (cnelson@ccp.edu). Please include your name, and course number in the subject line. If the email is concerning an assignment, include the name of the assignment in the email.
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. Homework and/or lab assignments should not be done during lecture.
ACADEMIC INTEGRITY POLICY & PROCESS: See the uploaded document detailing Community College’s Academic Integrity Policy & Process. In summary, 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. 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.
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.
ACADEMIC INTEGRITY POLICY & PROCESS: AS FOR THIS COURSE
STARFISH CONNECT Starfish Connect is a communication tool for students and faculty. Through Starfish instructors can provide feedback to you about course progress. Throughout the term, you may receive progress emails regarding your academic performance. The emails are designed to be helpful and increase your success in courses. Be sure to open any emails you receive and follow the recommendations. Instructors may also recommend that you contact a specific campus resource, such as the Learning Lab or Counseling Center. If an instructor makes a referral, you may also be contacted directly by this campus service as a follow-up. To access Starfish Connect, simply log into Canvas and click on the link, Starfish Connect. You can even set up a student profile. If you need assistance with Starfish Connect, you can email questions to starfishconnect@ccp.edu
For more information on the degree programs & certificates offered by the Computer Technologies Department, visit the following links provided:
Degree Options
Computer Science Degree http://ccp.edu/college-catalog/degree-programs/associate-science/computer-science
Cyber Security Degree
Computer Information Systems (CIS) - Information Technology (IT) Degree
Network Technology Management and Administration Degree
Proficiency Certificates
Computer Programming and Software Development Proficiency Certificate
Cyber Security I Proficiency Certificate
Cyber Security II Proficiency Certificate
Network and Systems Administration Proficiency Certificate
Web Development Proficiency Certificate
Important Dates for the Fall 2019 Semester:
Last edited Monday, 9/2, 2019 by C. Nelson |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||
Last edited Monday, January 15, 2018 by C. Nelson
Course Summary:
| Date | Details | Due |
|---|---|---|