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 | Start Month | Session | Weeks |
|---|---|---|---|---|
| 05/21/2022 - 11/04/2022 | 11/07/2022 - 01/01/2023 | November | Fall 2022 Session I | 8 Week session |
Current Syllabi
The successful student will fulfill the following learning objectives:
- Explore the advantages and disadvantages of databases
- Demonstrate the use of a Query by Example database
- Appraise the power of SQL
- Create SQL queries
- Utilize SQL commands
- Design a normalized database
- Discuss the different functions a DBMS does
- Differentiate between a DBA and a Developer
- 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.
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.
| Name | Grade % |
|---|---|
| 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 % |
| Discussions | 45.00 % |
| Week 1: Database Pros and Cons | 5.63 % |
| Week 2: SQL's Power | 5.63 % |
| Week 3: Views and Stored Procedures | 5.63 % |
| Week 4: Normalization | 5.63 % |
| Week 5: Design | 5.63 % |
| Week 6: DBMS | 5.63 % |
| Week 7: DBA and Developer roles | 5.63 % |
| Week 8: Compare OLTP and OLAP | 5.63 % |
The successful student will fulfill the following learning objectives:
- Explore the advantages and disadvantages of databases
- Demonstrate the use of a Query by Example database
- Appraise the power of SQL
- Create SQL queries
- Utilize SQL commands
- Design a normalized database
- Discuss the different functions a DBMS does
- Differentiate between a DBA and a Developer
- Differentiate the various types of databases such as OLTP, OLAP, and Statistical Databases
| Book Title: | Concepts of Database Management, 7th ed.- the VitalSource eBook is provided inside the classroom |
| ISBN: | 9781111825911 |
| Publication Info: | VS-Cengage |
| Author: | Pratt Adamski Staff |
| Electronic ISBN: | 9781285501154R120 |
| Electronic Unit Cost: | $28.39 |
| 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 |