Skip Navigation
 

INFO221 - Relational Database Concepts

Course Details

Course Code: INFO221 Course ID: 2622 Credit Hours: 3 Level: Undergraduate

This course is an introduction to the concepts, management issues, and advantages of relational database management systems. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. This course examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, backward recovery), database security (authentication and authorization), and database administration. This course also explores distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.





Course Schedule

Registration Dates Course Dates Session Weeks
11/26/18 - 05/03/19 05/06/19 - 06/30/19 Spring 2019 Session I 8 Week session
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
03/25/19 - 08/30/19 09/02/19 - 10/27/19 Summer 2019 Session D 8 Week session

Current Syllabi

The successful student will fulfill the following learning objectives:

  1. Explore the advantages and disadvantages of databases
  2. Demonstrate the use of a Query by Example database
  3. Appraise the power of SQL
  4. Create SQL queries
  5. Utilize SQL commands
  6. Design a normalized database
  7. Discuss the different functions a DBMS does
  8. Differentiate between a DBA and a Developer
  9. Differentiate the various types of databases such as OLTP, OLAP, and Statistical Databases

Submit all assignments in Assignment folder for the appropriate assignment. Post all Forums under the appropriate Forum

Assignment Requirements

This course has a strong writing component. The goal is to organize, synthesize, and demonstrate your comprehension of core concepts investigated during this course by applying a combination of the terms, concepts, and details you have learned in a systematic way. As important as "the details" that you analyze and arrange in your writing, however, are the conclusions you draw from those details, and your predictions, responses to, and ultimate interpretation of those details.

Forum Introduction:

You are required to introduce yourself to your classmates in an online discussion. There are also eight Forum topics for students to participate in.

Papers:

You will be required to write one short paper this session. The specifications are as follows:

1. Font (double-spaced) Arial 12 pt font.

2. In addition to the required number of pages for the assignment, you must also Include a reference page (bibliography), written in APA style and a title page. Be sure to give all of your papers a descriptive title! The APA style is located at the http://www.apus.edu/Online-Library/tutorials/apa.htm

3. Papers must be uploaded inside the electronic classroom.

4. Page margins Top, Bottom, Left Side and Right Side = 1 inch, with reasonable accommodation being made for special situations

5. Your paper must be in your own words, representing original work.

6. Be sure to run a Spell / Grammar checker.

NameGrade %
Premiere Exercises 50.00 %
Week 1: Relational Algebra 6.25 %
Week 2 Assignments Queries 6.25 %
Week 3 Assignments SQL 6.25 %
Week 4 Normalization 6.25 %
Week 5 Assignment Design 6.25 %
Week 6 DBMS 6.25 %
Week 7 DBA and Developer roles 6.25 %
Week 8 Management 6.25 %
Essay 5.00 %
Week 4 Essay 5.00 %
Forums 45.00 %
Forum Week 1 5.63 %
Forum Week 2 5.63 %
Forum Week 3 5.63 %
Forum Week 4 5.63 %
Forum Week 5 5.63 %
Forum Week 6 5.63 %
Forum Week 7 5.63 %
Forum Week 8 5.63 %
Book Title: Students must have access to the required software. APUS does not supply this software. The listing can be found at http://apus.libguides.com/bookstore
Author: N/A
Publication Info: N/A
ISBN: N/A
Book Title: Concepts of Database Management, 7th ed.- The VitalSource e-book is provided via the APUS Bookstore
Author: Pratt Adamski Staff
Publication Info: Cengage
ISBN: 9781111825911
Book Title: You must validate your cart to get access to your VitalSource e-book(s). If needed, instructions are available here - http://apus.libguides.com/bookstore/undergraduate
Author: N/A
Publication Info: N/A
ISBN: N/A

Book Title:Students must have access to the required software. APUS does not supply this software. The listing can be found at https://apus.libguides.com/c.php?g=241438&p=3514444
Author: No Author Specified
Book Title:Concepts of Database Management, 7th ed.- the VitalSource e-book is provided inside the classroom
ISBN:9781111825911
Publication Info:VS-Cengage
Author:Pratt Adamski Staff
Unit Cost:$120.10
Electronic ISBN:9781285501154
Electronic Unit Cost:$35.00

Previous Syllabi

Not current for future courses.