Course Outcomes

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


The class makes extensive use of the assigned electronic textbooks and external supporting materials.

Required textbooks:

Optional textbook:

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 software.


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:

Lab Pre Final Pre Vocab Vocab Final Query Final Devo Participation
Week #01 20.0
Week #02 40.0
Week #03 78.0
Week #04 110.0
Week #05 50.0
Week #06 88.0
Week #07 48.0
Week #08 22.0
Week #09 44.0
Week #10 72.0
Week #11 46.0
Week #12 56.0
Week #13 10.0
Week #14 10.0 1.0 5.0 150.0 150.0 50.0
Sub-Total 694.0 1.0 5.0 150.0 150.0 50.0
Grand Total 1050.0

Lab Assignments

The lab assignments develop knowledge of SQL in an Oracle dialect. As stated by Elder Bednar, students should be enabled to act not be acted upon (“Seek Learning by Faith”).


You will only need to complete the Oracle lab.

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 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:


You will need to complete the Oracle exams.

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).