This is a fully online, asynchronous course. There are no required scheduled class meetings. Students are expected to complete the weekly learning activities, assignments, and discussions by the posted due dates.
This course provides a comprehensive overview of the principles and practices involved in the design and implementation of databases. Through a combination of theoretical foundations and practical applications, students will learn to create efficient and effective database systems to meet the information needs of organizations. The course covers essential topics such as database modeling, relational database management systems (RDBMS), normalization, SQL programming, and database administration. Successful completion of ITSM 1203 Information Technology Fundamentals and ITSM 1303 Programming logic are recommended prior to taking this course.
Goals and Objectives
Upon completion of this course, you will be able to:
- Demonstrate Understanding of Database Concepts
- Apply Database Design Principles
- Execute SQL Commands
- Design and Implement Database Systems
- Ensure Database Security and Integrity
- Utilize Advanced Database Concepts
- Analyze and Solve Database Problems
- Collaborate Effectively in Database Projects
- Evaluate Database Management Systems
Faculty Contact Information
Virtual office hours: by appointment / Email me to schedule a 1-to-1 Online Meeting
Course Information
At the end of this course, students will be able to:
- Demonstrate Understanding of Database Concepts
- Apply Database Design Principles
- Execute SQL Commands
- Design and Implement Database Systems
- Ensure Database Security and Integrity
- Utilize Advanced Database Concepts
- Analyze and Solve Database Problems
- Collaborate Effectively in Database Projects
- Evaluate Database Management Systems
- MODULE 1. INTRODUCTION TO DATABASE MANAGEMENT
- MODULE 2. THE RELATIONAL MODEL: INTRODUCTION, QBE, AND RELATIONAL ALGEBRA
- MODULE 3. THE RELATIONAL MODEL: SQL
- MODULE 4. THE RELATIONAL MODEL: ADVANCED TOPICS
- MODULE 5. DATABASE DESIGN: NORMALIZATION
- MODULE 6. DATABASE DESIGN: RELATIONSHIPS
- MODULE 7. DATABASE MANAGEMENT SYSTEMS PROCESSES AND SERVICES
- MODULE 8. DATABASE INDUSTRY CAREERS
- MODULE 9. DATABASE INDUSTRY TRENDS
Students are required to purchase a Cengage MindTap access code, which includes the eBook and all required course materials.
Required Textbook:
Concepts of Database Management, 10th Edition (2021)
Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt, and Mary Z. Last
ISBN-13: 9780357422083
MindTap + eBook Access Code:
ISBN-13: 9798214027852
All assignments and assessments are completed through Cengage MindTap. Always access MindTap through the links provided in Canvas. Launching MindTap outside of Canvas may prevent grades from transferring correctly to the Canvas gradebook.
Student evaluation is based on successful completion of assigned readings, MindTap activities, hands-on database assignments, quizzes, discussions, AI activities, and other course assessments. Assignment point values are available in Canvas and Cengage MindTap and may be adjusted if assignments are added, modified, or removed during the semester.
Students are encouraged to complete all assignments by the posted due dates. While a short grace period may be provided for some assignments, no submissions will be accepted after an assignment's closing date unless otherwise approved by the instructor. Any final exam or final assessment must be completed within the published availability period and cannot be submitted after the closing date.
Corresponding Grading Scale
- 90-100% = A
- 80-89% = B
- 70-79% = C
- 60-69% = D
- 59% or lower = F
Business, Technology & Human Services
Dean, Paul Carlson; 815-802-8858; V105; pcarlson@kcc.edu; Division Office – W102; 815-802-8650
Academic Integrity
KCC considers academic integrity violations a serious offense. Violations include, but are not limited to, plagiarism, cheating, unauthorized use of artificial intelligence (AI), fabrication/falsification, and personal misrepresentation.
The first incident of academic dishonesty will result in a warning. A second incident will result in a grade of zero on the assignment. A third incident will be reported to the appropriate college officials in accordance with KCC policy.
SimCheck software may be used to evaluate written coursework for potential plagiarism. Students are expected to properly cite all sources and complete their own work unless collaboration is specifically authorized.
Refer to KCC's Code of Campus Affairs and Regulations, Section 17.2, for additional information regarding academic integrity.
Attendance
Attendance is recorded and reported to the Admissions and Financial Aid offices. Because this is a fully online course, students are expected to log in regularly, participate in course activities, and submit assignments by the posted deadlines.
Students who do not participate for seven consecutive days may be considered excessively absent and may be withdrawn from the course in accordance with KCC policy.
Refer to KCC's Code of Campus Affairs and Regulations, Section 3.0, for additional attendance information.
Course Expectations
Students are expected to:
- Complete assigned readings and course activities before the posted deadlines.
- Access all Cengage MindTap assignments through Canvas to ensure grades transfer correctly.
- Monitor Canvas regularly for announcements, due dates, and course updates.
- Communicate professionally and respectfully with the instructor and classmates.
- Use AI tools ethically and only when permitted for a specific assignment.
- Complete all coursework with honesty and integrity.
Assignments and Grading
Coursework includes readings, MindTap activities, hands-on database assignments, quizzes, discussions, and other assessments.
Students are responsible for submitting assignments by the published due dates. Unless otherwise announced, late work will not be accepted after an assignment closes.
Students should regularly review the Canvas Gradebook and notify the instructor promptly if an assignment or grade appears to be missing.
Mechanics
College-level writing is expected on all written assignments. Proper spelling, grammar, punctuation, sentence structure, and appropriate citations are required when applicable. Text messaging abbreviations and informal writing styles should not be used in academic submissions.
This course is conducted in a fully online, asynchronous learning environment. Students are expected to communicate professionally and respectfully in all interactions with the instructor and classmates. This includes discussion posts, replies, emails, Canvas messages, and any other course communications.
Students are expected to:
- Participate actively in weekly learning activities and discussions.
- Communicate respectfully and professionally with classmates and the instructor.
- Follow all assignment instructions and course policies.
- Demonstrate academic integrity in all submitted work.
- Use artificial intelligence (AI) tools ethically and only as permitted within individual assignments.
- Regularly monitor Canvas for announcements, feedback, and due dates.
Enrollment in this course indicates the student's agreement to adhere to the Kankakee Community College Code of Conduct and to contribute to a respectful, supportive, and productive online learning environment.
| Module | Topics & Readings | Major Learning Activities |
|---|---|---|
| Module 1 | Introduction to Database Management | JC Consulting Case Exercises |
| Module 2 | The Relational Model: Introduction, QBE, and Relational Algebra | Skills Assessment Activity |
| Module 3 | The Relational Model - SQL | Skill Assessment Activity, JC Consulting Case Exercises |
| Module 4 | Advanced Relational SQL Topics | JC Consulting Case Exercises, Skill Assessment Activity, Quick Lesson Assessment |
| Module 5 | Database Design - Normalization | JC Consulting Case Exercises, Skill Assessment Activity |
| Module 6 | Database Design - Relationships | JC Consulting Case Exercises, Skill Assessment Activity |
| Module 7 | DBMS Processes and Services | JC Consulting Case Exercises, Skill Assessment Activity |
| Module 8 | Database Industry Careers | JC Consulting Case Exercises, Career Reflection |
| Module 9 | Database Industry Trends | JC Consulting Case Exercises, Quick Lesson Assessment, Career Reflection |
| Module 10 | Midterm Review & Assessment | Post-Assessment Quiz |
| Module 11 | Final Project Introduction | Milestone 1: Final Project Introduction & Scenario Exploration |
| Module 12 | Start the Project | Milestone 2: Scenario Analysis & ERD Drafting |
| Module 13 | Continue Project | Milestone 3: Normalization & Table Definitions |
| Module 14 | Finalize Design | Milestone 4: Finalized Design & Complete Documentation |
| Module 15 | Finalize Project | Final Project Submission |
| Module 16 | Final Week | Final Reflection |
College Policies, Resources and Supports
For information related to the Student Code of Conduct Policy, Withdrawal Policy, Email Policy, and Non- Attendance/Non-Participation Policy, please review the college’s Code of Campus Affairs and Regulations webpage, which can be found at catalog.kcc.edu under the Academic Regulations & Conduct Guide.
KCC offers various academic and personal resources for all students. Many services are offered virtually, as well as in person. Please visit Student Resources - Kankakee Community College to access student resources services such as:
- Clubs and organizations
- Counseling and referral services
- Office of disability services
- Student complaint policy
- Transfer services
- Tutoring services, etc.
The materials on this course are only for the use of students enrolled in this course for purposes associated with this course. Further information regarding KCC's copyright policy is available at https://kcc.libguides.com/copyright.
|Course syllabus/calendar is subject to change.