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.
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)
- Use basic DDL, DML, DCL, and TCL SQL commands.
- Design and model a database.
- Compare, contrast, and convert SQL dialects.
- Plan and write cross, inner, natural, left, and right joins.
- Upload and merge large data sources.
- Research independently SQL syntax differences.
Weekly Patterns
The table below displays typical weekly activities, due dates, and activity descriptions.
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
- Students will prepare by reading the textbook and slides, taking a short quiz, and doing the practice activities individually or in groups.
- 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.
- Students will ponder with a weekly quiz on the week's content.
- 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
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 |
---|---|---|