CS 155A MySQL Databases

Spring 2018

Online Course Information
Print the Course Syllabus
Catalog Description

A course in the use of the MySQL database management system to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the MySQL language. The course includes a brief introduction to the programming aspects of MySQL.

Student Learning Outcomes (SLOs)

Upon completion of this course, students will be able to:

  • SLO #1 - Describe the basic concepts of databases, tables, relationships, and normalization.
  • SLO #2 - Analyze business requirements; design and implement queries to satisfy those requirements using all of the major components of the SQL language for accessing data, including inner and outer joins, aggregate queries and subqueries and a variety of the intrinsic functions supplied by MySQL.
  • SLO #3 - Manipulate a MySQL database using client software to create and modify database objects such as tables, constraints, relationships, and views following a database design as well as design and implement simple user-defined functions.
  • SLO #4 - Create queries to manipulate data in the database using Data Manipulation Language statements.
Textbook
MySQLRequired Textbook: Murach's MySQL (2nd Edition) by Joel Murach ISBN 978-1-890774-82-0 I post additional notes for this class.
Programming Assignments

There will be weekly assignments throughout the semester. The SQL assignment due dates are Mondays at 11:59 PM, unless told otherwise. Assignments should be submitted through the Canvas website, and I will return assignment grading reports to the same website. Assignments are listed under "Assignments" in Canvas.
All assignments must be individually and independently completed. I will provide feedback and post assignment grades within a week of the due date.

Assignments will be in the form of SQL scripts. Scripts should be text only with the .sql extension. You will need to label your assignments with your first initial, last name, and the name of the assignment. Example: hibrahim_assignment1.Zip the files to upload to Canvas (hibrahim_assignment1.zip).

Grading

This course allows Pass/No Pass grading. Check the official calendar for the deadline to make this choice. Your final grade is determined by points you earn in the following areas:

Submission

Total Points

Percentage %

SQL Assignments & Quizzes

450

45%

Final Project  

100

10%

Midterm Exam

200

20%

Comprehensive Final Exam

250

25%

TOTAL

1000

100%

Grading Scale:

% of Points

Letter Grade

90 – 100

A

80 – 89

B

70- 79

C

60 – 60

D

< 60

F

Fail/Withdraw

FW

Quizzes

There will be bi-weekly quizzes listed under "Quizzes" in Canvas containing a series of multiple-choice and short-answer questions to reinforce knowledge of SQL commands and relational database systems. Quizzes are always due on Monday by 11:59 PM. Unlike assignments, late submissions will NOT be accepted for the quizzes The quizzes and exams are given online and are open book.

Final Project

This is a comprehensive project that will require and integrate all of the skills you have learned in this course. This project will focus on relational databases and SQL. You will use the MySQL system for this project. The student will design, create, and populate a working database from description requirements provided by the instructor.

Exams

Midterm Exam: This is an online exam scheduled on Friday March 16,2018.
, Final Exam: This is an online exam scheduled on Wednesday December 16 2018.


The exams will be available for exactly 18 hours starting 6:00 AM on the due date and be due no later than midnight. You must take the exams within that 18 hour period.
All exams and quizzes will take place on Canvas.
Do not wait until the last minute to take an exam as you are responsible for unforeseen circumstances, such as if a technical problem occurs. You may see true/false, multiple-choice, short-answer, and programming questions.

Late Policy

There are weekly programming assignments that assigned every Monday and due by the following Monday at 11:59 PM unless specified otherwise. Programming assignments will be accepted up to four days past the original due date. They will be considered late and will receive a 10% deduction, with no exceptions. For example, if a programming assignment is due on Monday at 11:59 PM, it can be turned in by 11:59 PM on Friday.

Discussion Forums

Since this is an online course that utilizes discussion forums, it is important for all students to participate in the course promptly actively. The Canvas Forum is the main place for our class discussion. You can ask questions regarding course materials, assignments, and exams on the forum. Students are expected to participate in all discussions. Please consider the following general participation expectations:

  • Login regularly and actively participate in the course activities.
  • Post discussion forums and other assignments on time as indicated each week.
  • Complete the assigned reading before posting your question(s) — answers to most questions can be found in the reading assignments.
  • No code sharing is allowed on the forums.

Think of these forums as our online classroom. The forums on the website are a good way of interact with other students, exchange thoughts, ask and answer questions as well as take part in the public discussion. I will check the weekly forums on a daily basis and will respond to questions as needed. I also highly encourage students to read and respond to posts from fellow peers. You must also post an introduction within the first week to avoid being dropped as a no-show.

Academic Accommodations
If you need classroom or testing accommodations because of a disability, or have emergency medical information to share with me, or need special arrangements in case the building needs to be evacuated, please make an appointment with me as soon as possible. Students seeking disability-related accommodations are also encouraged to register with Disabled Students Programs and Services located in Room 323 of the Rosenberg Library (415) 452-5481. Please see the DSPS website for more information and alternate locations.
Standards of Conduct
Students who register in CCSF classes are required to abide by the CCSF Student Code of Conduct. Violation of the code is the basis for referral to the Student Conduct Coordinator or dismissal from a class or the College. See the Office of Student Affairs and Wellness. Collaborating on or copying of tests or homework in whole or in part will be considered an act of academic dishonesty and result in a grade of 0 for that test or assignment. I encourage students to share information and ideas, but not their work. .