CIS 54 - Spring 2019

Introduction to Client/Server Relational Database Management Systems

Time

Thursdays 5:30pm to 9:35pm

Room

Room 828 Aptos Main Campus

Lab

Open Lab - 1 hour per week TBA

Units

4

Book
Database Concepts (7th Edition)
Links

Course Calendar

Week

Date

Topic

1

1/31

Welcome

Pages
Labs

2

2/7

Introduction to DBMS

Reading

Chapter 1

Pages
Labs
Project

3

2/14

The Relational Model

Reading

Chapter 2

Pages
Labs
Project

4

2/21

The Relational Model

Reading

Chapter 2

Pages
Labs
Book
Queen Anne Curiosity Shop Project Questions on pages 116-118
Project

5

2/28

The Relational Model

Reading

Chapter 2

Pages

6

3/7

SQL - Selects

Reading

Chapter 3

Pages
Labs
Week06 SQL Practice

7

3/14

SQL - Selects

Reading

Chapter 3

Pages

8

3/21

Midterm

-

3/28

Spring Break

09

4/4

SQL - Creating Tables

Reading

Chapter 3

Pages
Project
Queen Anne Project (in Jupyter)

10

4/11

SQL - Subqueries and Joins

Reading

Chapter 3

Pages
Labs
Queen Anne Joins (in Jupyter)

11

4/18

SQL - Outer Joins

Reading

Chapter 3

Pages
Labs
Projects

12

4/25

Data Modeling

Reading

Chapter 4

Pages

13

5/2

Database Design

Reading

Chapter 4

Pages

14

5/9

Transactions and Concurrency

Reading

Chapter 6

Pages
Labs
Project

15

5/16

Database Security

Reading

Chapter 6

Pages

16

5/21

Final Exam

Course Description

Teaches the the use and administration of a Client/Server Relational Database Management System. Covers the installation and administration of MySQL Client/Server Relational Database Management Installation along with the design, creation and administration of enterprise databases, performance tuning, security, and disaster recovery. Additional topics include: SQL (Structured Query Language), data types, functions, normalization, and a brief introduction to server-level programming and language interfaces for developing database-driven websites, emphasizing PHP systems. May be offered in a Distance-Learning Format.

Student Learner Outcomes

  • Implement and analyze databases.

  • Maintain database management systems and data.

Objectives

  • Discuss the functionality of relational database management systems.

  • Install a relational database management system.

  • Apply administration utilities to administer a database management system.

  • Identify how information is physically stored in a database.

  • Synthesize a database query using SQL.

  • Write and debug SQL statements inserting, updating, and deleting records in a database.

  • Create and drop user databases.

  • Create, rename, modify, and delete tables and indexes.

  • Design a database with efficient data retrieval that is easy to maintain.

  • Populate a database using import methods and database transfer tools.

  • Describe and implement transactions and locking.

  • Describe and perform the process of securing a database.

  • Analyze the security of a database installation.

  • Describe the security architecture in a database and assign user privileges.

  • Discuss security best practices.

  • Administer repair of a corrupted database.

  • Create and implement a backup and restore strategy.

  • Describe and implement methods for optimizing database performance.

Grading Policy

  • 60% Labs and Homework

  • 20% Midterm

  • 20% Final

TBA (To Be Arranged) Lab Hours

This course meets weekly at the times shown in the Cabrillo Schedule of Classes and above. In addition each student is required to spend lab time every week in either the CIS Lab (room 830) or online using one of the online accounts issued to you. Students may choose the time and day for their TBA Lab Hours where they will work on lab assignments designed to give them practical hands-on experience and continue the learning process. These TBA lab hours are required and tracked. It is the student’s responsibility to complete the TBA lab hours, which start on Week 1 of the term. Tip: A great time to do TBA lab hours is in the CIS Lab during my STEM hours. If that is not possible, questions can always be posted on the class discussion group.

Class Pacing and Due Dates

Assignments are due most weeks during the term. Each class builds on the previous class so it’s important to keep up with the assignments. Keeping pace with the lectures will help you get the most out of in-class lab activities. However, I would much rather you do an assignment late than not at all. Late work will be accepted until a reasonable amount of time before the end of the semester. There will be a nominal penalty for late assignments.

If you have an emergency that prevents you from submitting assignments on time, please email me for an accommodation.

Classroom Etiquette

It is important to have an effective, distraction-free classroom environment for learning. To minimize distractions all cell-phones should be turned off or at least silenced. Never carry on conversations during the lecture as this is probably the most annoying distraction possible to those sitting nearby.

For students in the physical classroom, computers can be turned on for viewing lecture slides locally, Google-ing related technical information, and doing classroom exercises. A student’s full attention is desired so the computers should not be used during lecture for email or anything that would distract them or others from the material being taught.

For students in the virtual classroom, use the “Raise hand” icon in CCC Confer to let the instructor know you have a question. The chat window can be used to ask questions and communicate with the instructor or other classmates. For students dialing in please use *6 on your phone to mute/unmute your line so background noises in your location don’t distract the class.

Please plan on coming to all classes. If class will be missed let the instructor know ahead of time. It is the student’s responsibility to get any missed material or information from other classmates (the forum is a good way to do this). Please note that being disruptive is grounds for being dropped from the class by the instructor.

Academic Conduct

Instructors at Cabrillo will not tolerate any forms of academic dishonesty. We do not accept remarkably similar assignments. Students who engage in violations of academic integrity (cheating, plagiarizing print or electronic sources, copying computer files, web site content) as outlined in Cabrillo’s Student Rights and Responsibilities document are subject to disciplinary action by the instructor including receiving an “F” for the assignment, being dropped from the course with a “W” or being issued an “F” for the course.

Special Learning Needs

Veterans or students with disabilities, including “invisible” disabilities such as chronic diseases, learning, and psychological disabilities, are encouraged to explain their needs and appropriate accommodations to the instructor during office hours. Please bring a verification of your disability from the Learning Skills or DSPS offices and a counselor or specialist’s recommendations for accommodating your needs.

As required by the Americans with Disabilities Act (ADA), accommodations are provided to insure equal opportunity for students with verified disabilities. If you need assistance with an accommodation, please contact the Learning Skills Program at 831-479-6220 (for students with learning disabilities and attention deficit disorders) or Disabled Student Programs and Services (DSPS) at 831-479-6379 or 831-479-6421 (TTY) to make arrangements as soon as possible.

Students interested in receiving accommodations and services can contact the ASC at (831) 479-6379 to schedule an appointment to meet with one of the ASC counselors. Please arrive 15 minutes prior to the scheduled appointment to fill out necessary paperwork. ASC is located outside Room 1073 in The Hub, upstairs behind the library.

Missing Classes and Drops

It is the student’s responsibility to officially withdraw from classes. If you miss more than two classes or two lab assignments, the instructor may drop you from the course enrollment unless prior arrangements have been made and agreed to.