Syllabus
Course Outcomes
- Ability to use basic DDL, DML, DCL, and TCL SQL commands.
- Ability to design and model a database.
- Ability to compare, contrast, and convert SQL dialects.
- Ability to plan and write cross, inner, natural, left, right, and full joins.
- Ability to upload and merge large data sources.
- Ability to research independently SQL syntax differences.
Course Description
This 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 semantics 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.
Course Prerequisites
- CIT 160
Textbook
The class makes extensive use of the assigned electronic textbooks and external supporting materials.
Required textbooks:
- Introduction to Databases, M. McLaughlin, 2014
- Oracle Database 11g PL/SQL Programming Workbook
- Oracle Database 12c PL/SQL Programming
- MySQL Workbench: Data Modeling & Development
- Compare prices for your textbooks through the University Store Price Comparison Site. University Store Price Comparison Site
Optional textbook:
- The Linux Command Line, W.E. Shotts, 2012, ISBN 978-1593273897
Hardware Requirements
Students must have a laptop computer with the following requirements: 6GB RAM, 64-bit processor capable of hyper-threading.
Software Requirements
Students should install a copy of VMWare Workstation for the Windows Operating System or VMWare Fusion for the Mac OS X Operating System to run a Fedora Linux preconfigured system. Students may substitute another virtualization software provided the students can be self-supporting during the course and migrate the VMWare instance or download, install, and configure all Oracle and MySQL software.
Assignments
Reading assignments are due at the beginning of the week as noted in the Schedule.
The instructor will answer questions on course content and material in the appropriate Notes From Instructor pages and during his/her weekly Office Hour. It is the student's responsibility to review the material, prepare, and ask questions.
The details of the assignments and class policies are as follows:
| Exam Preparation | Lab | Exam | Finals | Total | |
|---|---|---|---|---|---|
| Week #01 | 10.0 | 20.0 | 60.0 | 90.0 | |
| Week #02 | 10.0 | 20.0 | 60.0 | 90.0 | |
| Week #03 | 10.0 | 20.0 | 60.0 | 90.0 | |
| Week #04 | 10.0 | 20.0 | 60.0 | 90.0 | |
| Week #05 | 10.0 | 10.0 | 60.0 | 80.0 | |
| Week #06 | 35.0 | 35.0 | |||
| Week #07 | 40.0 | 40.0 | |||
| Week #08 | 10.0 | 25.0 | 60.0 | 95.0 | |
| Week #09 | 25.0 | 25.0 | |||
| Week #10 | 45.0 | 45.0 | |||
| Week #11 | 35.0 | 35.0 | |||
| Week #12 | 10.0 | 20.0 | 30.0 | ||
| Week #13 | - | ||||
| Week #14 | 20.0 | 200.0 | 220.0 | ||
| Total | 100.0 | 315.0 | 360.0 | 200.0 | 975.0 |
Lab Assignments
The lab assignments develop knowledge of SQL in an Oracle or MySQL dialect. As stated by Elder Bednar, students should be enabled to act not be acted upon (“Seek Learning by Faith”).
Note
You will only need to complete the Oracle lab OR the MySQL lab. You will not need to complete both.
Objectives are noted on each lab assignments. Individual assignments mean that you should not share code with other students.
Labs may be submitted late for 70% credit up to the last Friday before the week of finals.
Exams
Exams have two purposes: (1) to test your SQL database vocabulary, and (2) to test your ability to understand and explain SQL statements. Exams are open book and notes, but you should not share or pool questions with other students. Pooling questions to create study banks would be an honor code violation. The assessments are:
- Tests to check your understanding and differentiate what you've done in your individual lab assignments.
- The final vocabulary exam which checks your ability to assigning meaning to words.
- The final query exam which checks your ability to find syntax problems with SQL statements.
Note
You will only need to complete the Oracle exams OR the MySQL exams. You will not need to complete both.
If you are unable to take a scheduled exam or quiz because of a qualifying emergency, you must notify the instructor that you’re unable to take the quiz before it closes. A qualifying emergency includes serious illness, personal injury, death of an immediate family member, etc.
If you miss a scheduled quiz or exam for reasons other than a qualifying emergency, you lose the opportunity to earn those points.
Reasonable Accommodation for Students with Disabilities
In compliance with applicable disability law, qualified students with a disability may be entitled to “reasonable accommodation.” It is the student's responsibility to disclose to appropriate personnel in the Disability Services Office any special need he/she may have and to provide the appropriate documentation of the disability.
The student will then be provided with paperwork for classroom accommodation that must be given to the instructor. This should be done early in the semester (preferably within the first two weeks).