Course Syllabus

Note: This course code has changed from CIT 225: Database Design and Development to ITM 220: SQL. You may occasionally see references to the old course code or title.

Course Description

The course deals with concepts and principles of database theory, application, and management technologies. It focuses on the logical and physical database design and implementation. The course covers the use of UML semantic to describe Entity Relationship Designs (ERDs) and SQL to implement relationships between entities. SQL will be used to query and transact against a sample database. 

Requirements

Prerequisites

Student must complete ONE of the following course:

  • CSE 111 - Programming with Functions 
  • ITM 111 - Introduction to Databases 
  • CIT 160 - Introduction to Programming 
  • CS 101 - Introduction to Programming 
  • CS 124 - Introduction to Software Development

Required Resources

This course uses a low-cost, auto-access textbook. Read the information in the Textbook Information module in the course to learn how to access your textbook, and how to opt-out of this automatic purchase, if desired.

Required Resources
Resource Title/Description
(books, software, etc.)
Author/Provider Ed./Vol. 13-Digit ISBN (if applicable)
Learning SQL Alan Beaulieu 3rd 9781492057611

You will install the MySQL Server and MySQL Workbench. During the course, you will use the MySQL sakila sample database to work through the examples in the textbook. You will also use MySQL Tutorial web pages.

Structure

Course Outcomes (CO)

  1. Use basic DDL, DML, DCL, and TCL SQL commands.
  2. Design and model a database.
  3. Compare, contrast, and convert SQL dialects.
  4. Plan and write cross, inner, natural, left, and right joins.
  5. Upload and merge large data sources.
  6. Research independently SQL syntax differences.

Weekly Patterns

The table below displays typical weekly activities, due dates, and activity descriptions. 

Weekly Patterns
Due Date* Learning Model Activity Title Description
Midweek Prepare Prepare & Reading Read the chapters and slides before taking a self-assessment quiz.
Midweek Teach One Another Discussion Board Share inspirational thoughts and assist your classmates or request help from your peers by asking and answering questions on the week's lab or materials.
Midweek Teach One Another  Exercise Practice the weekly content exercises with a teammate and then take a quiz.
End of Week Ponder Quiz Take a quiz to measure content learned for the week.
End of Week Prove Paper Submit a report according to the case study expectations.

*Set your time zone within user preferences so the dates and times for course activities will display correctly for your time zone.

Learning Model

  1. Students will prepare by reading the textbook and slides, taking a short quiz, and doing the practice activities individually or in groups.
  2. Students will teach one another by sharing inspirational thoughts and assist their classmates or request help from your peers by asking and answering questions on the week's lab or materials.
  3. Students will ponder with a weekly quiz on the week's content.
  4. Students will prove through a case study report.

Expectations

Feedback

You can expect to receive grades and feedback within 7 days of the due date for all assignments.

Workload

Remember, because this is a three-credit course, you will spend approximately nine hours each week doing the homework. Do not plan otherwise. The most important thing to remember is to pace yourself. Set aside time throughout the week to complete your assignments.

Because this course follows the organization of the Learning Model, there are many opportunities to teach and work together with your peers. You should not treat this as an independent study course, where you can work ahead on your own. In fact, if you are working ahead on your own, you will be missing key activities where peer review is required. Instead, stay within the weekly schedules set in the course schedule and put any additional time into helping others in peer review activities. Make sure to complete all learning activities for one week before the next one begins!

Group Work

Discussion boards are a chance to share, teach, and learn from one another. You may work in groups on the Prepare and Reading and Exercise activities in this course but you must submit your own work.

Late Work

As a sign of professionalism and respect, complete your work on time. 

Grading Scale

Grading Scale
Letter Grade Percent
A 100% - 93%
A- 92% - 90%
B+ 89% - 87%
B 86% - 83%
B- 82% - 80%
C+ 79% - 77%
C 76% - 73%
C- 72% - 70%
D+ 69% - 67%
D 66% - 63%
D- 62% - 60%
F 59% and lower

University Policies

Students with Disabilities

Brigham Young University-Idaho is committed to providing a working and learning atmosphere that accommodates qualified persons with disabilities. If you have a disability and require accommodations, please contact the Disability Services Office at (208) 496-9210 or visit their website and follow the Steps for Receiving Accommodations. Reasonable academic accommodations are reviewed for all students who have qualified documented disabilities. Services are coordinated with students and instructors by the Disability Services Office.

This course may require synchronous meetings. If you are currently registered with the Disability Services Office and need an interpreter or transcriber for these meetings, please contact the deaf and hard of hearing coordinator at (208) 496-9219.

Other University Policies

Student Honor and Other Policies

Please read through the document called University Policies. It gives important information about the following topics:

  • Student Honor
    • Academic Honesty
    • Student Conduct
      • Sexual Harassment
  • Student with Disabilities
  • Complaints and Grievances
  • Copyright Notice

Go to the Student Resources module to review further resources and information.

Course Summary:

Date Details Due