Note: This course code has changed from CIT 111 to ITM 111. You may occasionally see references to the old course code or title.

Overview

This course teaches the basic elements of database management systems. It introduces students to the concepts of logical and physical relationships in a data model and the concept of inner join. Students will use a computer aided software engineering (CASE) tool to design, create and query a database.

This course does not fulfill a requirement for students majoring in computer information technology. It is a requirement for students majoring in information systems and for several minors, clusters, and emphasis.

Course Topics

• Database management systems
• Relational databases
• Tables, rows, columns
• Normalization
• Constraints
• Queries
• SQL

Requirements

Prerequisites

There are no pre-requisites for this course.

Required Resources

No textbook is required for this course, all readings and videos are found on Canvas.

This course requires you to complete videos and readings located on the Canvas course before the first class of each week.

You are also required to install a database management system (DBMS) on your computer and use that DBMS to design and implement small databases. You must have a computer, with current operating system software installed, to use in class.  

Go to Software/Hardware requirements to see the department's hardware and software requirements. For the best hands-on learning experience, each student should have access to a reliable laptop computer that they bring to each class session, with:

• sufficient user or administrator privileges to install new software on that computer
• an i5 or better processor capable of hyper-threading
• sufficient RAM to comfortably operate virtual machines on the laptop (8GB or more recommended, 4GB minimum (if you have extreme patience and pain tolerance)
• sufficient battery power to use the computer throughout each class session for in-class activities

Students unable to meet this technology requirement should contact me during the first week of the semester.

Proctored Exams and Assessments

This course will use an online proctoring software called Proctorio. This makes it possible for students to take assessments and exams without a human proctor present. Proctored exams can be accessed like any other exam, once the software has been installed. Exams will be recorded by Proctorio and reviewed by the BYUI Testing Center. Any questionable exams will be forwarded to the instructor for further review.

For step-by-step instructions on Proctorio installation, please refer to this help guide article.

Structure

Course Outcomes (CO)

Each student will develop fundamental knowledge and skills in using, designing, and building relational databases by doing the following:

1. Explain how data and databases are used in business systems.
2. Demonstrate design and creation of relational databases.
3. Use a DBMS (Database Management System) and CASE (Computer-Aided Software Engineering) tool.
4. Construct Create, Insert, Update, and Delete statements.
5. Query a database using single and multiple tables, including built-in aggregate functions and WHERE clause filtering.

Major Assignments

The table below is meant to help you see the relevance of each major assignment as it pertains to the course outcomes (CO).

Weekly Patterns

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

*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 other readings, taking a short quiz, and doing the practice activities individually or in groups.
2. Students will teach one another by sharing code together on assignments and providing feedback.
3. Students will ponder the question, "How does this apply to my life, and how can I use this in my schooling and work?"
4. Students will prove through assessments and projects.

Expectations

Feedback

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

Workload

Time Consumption 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!

Late Work

Late Work There is a 20% penalty applied to any late work for each day past the due date.  Work turned in later than 5 days after the due date will receive no credit.

Grading Policies

Your final grade in this course will be based on your performance in the following categories:

To see the relative weight of each assignment in the course, view the grade book. The grade book is in the upper-left corner of your I–Learn page (parallel to your name in I–Learn).

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.