Skip Navigation
 

INFO321 - Database Management Systems

Course Details

Course Code: INFO321 Course ID: 2948 Credit Hours: 3 Level: Undergraduate

This course is a study of major advancements in database technology that have taken place in recent years. It does not assume any prior background in the field of databases, and, hence, starts with basic introductory concepts, but covers advanced topics as well. The course will cover both conceptual and hands-on material in the area of database management, thus enabling students to have the maximum amount of comprehension and retention of material covered in the course. The student must have access to MS Access. 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
12/31/18 - 05/31/19 06/03/19 - 07/28/19 Spring 2019 Session D 8 Week session
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
02/25/19 - 08/02/19 08/05/19 - 09/29/19 Summer 2019 Session I 8 Week session
03/25/19 - 08/30/19 09/02/19 - 10/27/19 Summer 2019 Session D 8 Week session
04/29/19 - 10/04/19 10/07/19 - 12/01/19 Fall 2019 Session B 8 Week session

Current Syllabi

The successful student will fulfill the following learning objectives:

  1. Describe the evolution of relational databases as a tool for information management.
  2. Assess the key components of a database management system.
  3. Assess the process and methodologies for designing databases.
  4. Explain the functions of database administration.
  5. Examine the rudiments of the Structured Query Language (SQL).
  6. Evaluate database table normalization.
  7. Evaluate the data integrity, security, and availability issues related to relational databases.
  8. Design a database management system with the skills gained from this course.

The grading will be based on eight graded assignments, seven weekly Forum postings, an individual project paper with topic, outline, and presentation assignments, a network design diagram, an open book quiz, and a case study.

  1. There will be seven assignments (4-5% each) counting a total of 31% of the final grade. The assignments will follow each of the major milestones of the course. These assignments will be problems or questions from the text. They are a combination of Lesson Reviews and Lesson Activities and/or Labs. They are selected to provide the student with information to understand the concepts discussed. Assignments should be prepared in Microsoft Word and uploaded into the student folder by the due date. Assignment also may include work in MS Access and uploading of the Access file in the assignment area.
  2. There will be eight weekly Forum postings you will need to respond to. Answers should be 3-4 paragraphs with a topic sentence that restates the question and supporting sentences using the terms, concepts, and theories from the required readings. Each answer should be a minimum of 250 - 300 words (about 6 to 8 good sentences). You may attack, support or supplement other students’ answers using the terms, concepts and theories from the required readings. All responses should be a courteous paragraph that contains a topic sentence with good supporting sentences. You may respond multiple times with a continuous discussion with points and counter points. The key requirement is to express your idea and then support your position using the terms, concepts and theories from the required readings to demonstrate to me that you understand the material. The Forum postings will count as 24% (3% for each forum posting) of the final grade. In an online environment communication and exchange of ideas is critical. These Forum postings allow us the opportunity to discuss trends in the technology we are studying, future possibilities, updates and above all, allow us an opportunity to get to know each other and work as a group. This can only happen, when students and instructors work together. It is not out of the ordinary when students participate in a "hot" discussion and the exchange of ideas and arguments is achieved. Forum submissions are due by Wednesday of each week, in order to give other students the opportunity to read your post and respond.

Instructions to review and submit Forum input:

  1. Log into the classroom
  2. Click the “Forum” link
  3. Click the appropriate Forum under the column labeled “Group Name”
  4. Choose a specific thread to see all the messages and choose a specific message to reply.
  5. Click on the “reply to this message” link.
  6. Provide your input.
  7. Click the “submit” button.

Forum Grading Rubric

Your post should add value to the classroom discussions to be counted for participation. It can be a new analogy, scenario, case study, different viewpoint or even a good question.

  1. There will be a Term Project (17%) with Project Proposal (5%), and Final Term Project (12%) throughout the session, due the 8th week
  2. There will be two one hour long and non-proctored quizzes (5% each) in week 4 and week 7 which count as 10% of the final grade. The quizzes are multiple-choice selections and will be open book and open note.
  3. There will be a Case Study in week 6, counting as 18% of the final grade. Strongly encouraged to start at least 1-2 weeks earlier than when it is due.

Due Dates

All assignments, Forum Peer Reviews, quizzes, tests, papers, projects are due Sunday of each week by 11:59:00 PM (Forum Initial posts are due on Wednesday 11:59:00 PM)

Announcements

In the announcement area there will be an overview of the information for the week, a summary of the assignments, and key terms enabling focused studying of concepts from the readings. These key

terms will be used as the basis for the mid-term and final exams. This information will be located in the announcements section of the online classroom.

Lecture

Each week, students will review the power point lecture located in the Resources section of the online classroom.

Case Study - week 6 - (18%):

You are a star consultant from "Databases R US" IT consulting and managing firm. Just graduated from APUS and this is your first critical job. You just got hired by "Home Solutions Inc" a construction and parts company to help them with their customer and parts data management. Unfortunately, the company has been depending on the owner's nephew for their data needs and Joe has done his best to come through for the family business. His lack of experience with data management is hurting the business as they have been unable to successfully keep track of their inventory system, customers and sales. Joe has put together a spreadsheet, see below, and they have been using it as a database of sorts, to track their customers and inventory.

Your specific tasks to help the business are in parenthesis are the percentage that correspond to the per item payment (grade weight):

1) Review the existing spreadsheet, and their sample data and make any assumptions you need about the company. Make any comments about the approach that you are going to follow, as you see fit. (10%)
2) Redesign the spreadsheet into a database with tables, add any fields that you think could be useful, even though it is not absolutely necessary. Explain your actions as you go along.
3) Perform a functional dependency analysis, and include it as part of your deliverables, for every step of the normalization process (25%)
4) Clearly take the existing un - normalized structure through distinct 1NF, 2NF and finally 3NF stages, using the shorthand representation. All three stages of normalization have to be clearly defined and depicted for full payment by the proprietor. Do not forget Primary keys assignment.(25%)
5) Finally, create an MS Access prototype (actual database), including the data provided, with the newly designed tables. Upload the prototype to the assignment area as part of the deliverables (5%).
6) Create a Query (In MS Access) that may include one or more tables, as needed, that provides the answer to the following request: List the Invoice number, Customer Name, and Parts Description for purchases by Customers that have an Account Balance of $3,000 or higher. Short them with the highest balance being displayed first (Descending values) (5%)
7) Create one Form: New Customer Input - this form should include any relevant fields that you think "Home Solutions Inc" might need (In MS Access) (5%)
8) Create One Report: Items Price List - this report should include any relevant fields that you think "Home Solutions Inc" might need (In MS Access) (5%)

Term Project and Proposal (17%)

The Term project is a database design exercise. It includes a Project Proposal and the actual Term Project

1) Term Project Proposal week 5 (5%)

You should select a data storage problem of your interest and identify the various pieces of data that should be stored in a database. Then, in the actual Term Project, take it through the normalization process and design the actual database tables (see Assignment Term Paper for complete details of this).
You should submit your term project proposal in Week 5 for approval by the instructor and submit the completed work in the final week.
The Proposal for the Term Project, MS Word doc - 500 words minimum - should include:

1) Name and main idea of the project
2) Purpose and goal of the project
3) Possible users and administrators
4) How is this work being done now, without the database and how will the database specifically improve the process
5) Data elements to be involved: entities, attributes - High Level
6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of use and prototyping but long term will switch to a more robust platform like MS SQL, or Oracle, or remain in MS Access)
7) Other interesting related points

2) Term Project delivery week 8 (12%)

You should select a data storage problem of your interest and identify the various pieces of data that should be stored in a database.

Make sure that your Term Paper follows the following format/outline:

1) Term Paper Abstract
2) Purpose and goal of the project
3) Users and administrators
4) How is this work being done now, without the database and how will the database specifically improve the process
5) Data elements to be involved: entities, attributes - Detailed Level
6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of use and prototyping but long term will switch to a more robust platform like MS SQL, or Oracle, or remain in MS Access)

7) Take the database through the normalization process and design the actual database tables.
8) Do include the functional dependency analysis
9) Do include any Primary and Foreign Key designation, as needed, as well as an explanation of why you designated them as such.
10) Document the whole process and information in MS Word document. Especially make sure that you include the description of the various entities, attributes in detail, their inter-relationship and the way the database is going to be used.

You should submit your term project proposal in Week 6 for approval by the instructor and submit the completed work in the final week in a Word Document (1,000 word minimum) Relevant parts of the Project Proposal may be incorporated in the above outline, modified from earlier versions/submissions as needed

Quiz Completion Procedures

  1. Log into the classroom
  2. Click the “exams” link
  3. Click the “INFO321 Quiz week4” or “INFO321 quiz week 7” link.

Submission of Written Assignments

Although distance learning provides an optimal amount of flexibility, students are expected to follow the syllabus expectations and schedule.

NOTE: Submitted assignments are time stamped using east coast time. This time stamp is my verification of an on time submittal. If you live in another time-zone, keep this in mind when submit assignments. Use the time-zone converter at this link http://www.timezoneconverter.com/cgi-bin/tzc.tzc to help you submit assignments in a timely manner.

Written assignments – term project/PPE/database exercise submission instructions:

  1. Log into the classroom.
  2. Click the “assignments” link.
  3. Click the corresponding assignment (i.e. INFO321 Week 1 Assignment).
  4. Upload file to the assignment. Ensure the file is a MS Word document.
  5. Check the box “submit for grading.”
  6. Click the “submit” button.

LATE ASSIGNMENTS

Students are expected to submit classroom assignments by the posted due date and to complete the course according to the published class schedule. As adults, students, and working professionals I understand you must manage competing demands on your time. Should you need additional time to complete an assignment please contact me before the due date so we can discuss the situation and determine an acceptable resolution. Routine submission of late assignments is unacceptable and may result in points deducted from your final course grade. Assignments submitted late without a prearranged extension will be subject to a 10% late penalty. No late assignments will be accepted after the last day of the course.

NameGrade %
Forums 24.00 %
Forum 1 3.00 %
Forum 2 3.00 %
Forum 3 3.00 %
Forum 4 3.00 %
Forum 5 3.00 %
Forum 6 3.00 %
Forum 7 3.00 %
Forum 8 3.00 %
Exercise 1 - 4 16.00 %
Week1 Database Exercise 4.00 %
Week2 Database Exercise 4.00 %
Week3 Database Exercise 4.00 %
Week4 Database Exercise 4.00 %
Exercise 5 - 7 15.00 %
Week5 Database Exercise 5.00 %
Week6 Database Exercise 5.00 %
Week7 Database Exercise 5.00 %
Case Study 18.00 %
Case Study Week 6 18.00 %
Term Project 17.00 %
Term Project Proposal week 5 5.00 %
Week8 Term Project 12.00 %
Quizzes 10.00 %
Quiz week 7 5.00 %
Quiz week 4 5.00 %
Extra Credit 2.00 %
Extra Credit for Database Project wk8 2.00 %

Optional Text

Publication manual of the American Psychological Association (6th ed.). (2010). Washington, D.C.: American Psychological Association.

Web-based Readings (Optional)

Software Requirements

  • MS Word or any word processor with the ability to export a *.txt file.
  • MS Access 2010 Availability
  • Adobe Acrobat Reader (Click here for free download)

Selected Bibliography

Begg, C., Connolly, T., & Strachan, A. (2004). Database Systems: A Practical Approach to Design, Implementation and Management. Boston, MA: Addison-Wesley

Chen, P. (n.d). Entity-Relationship Modeling: Historical Events, Future Trends, and Lessons Learned. Retrieved 2 November, 2007 from http://bit.csc.lsu.edu/~chen/pdf/Chen_Pioneers.pdf

Date, C. (2000). The Database Relational Model: A Retrospective Review and Analysis : A Historical Account and Assessment of E. F. Codd's Contribution to the Field of Database Technology. Boston, MA: Addison Wesley

Date, C. (2005). Databases in Depth. Sebastopol, CA: O’Reilly Publishing

Gennick, J. (2004). SQL Pocket Guide. Sebastopol, CA: O’Reilly Publishing

Henderson, M. (2003). Database Design for Mere Mortals. Boston, MA: Addison-Wesley Professional

Keogh, J. and Davidson, K. (2004). Data Structures Demystified. New York, NY: McGraw-Hill Osborne

Kroenke, D. (2004). Database Concepts. Upper Saddle River, NJ: Prentice Hall

Oppel, A. (2004). Databases Demystified. New York, NY: McGraw-Hill Osborne

Petersen, J. (2002). Absolute Beginner’s Guide to Databases. Indianapolis, IN: Que

Riordan, R. (2005). Designing Effective Database Systems. Boston, MA: Addison-Wesley

Book Title:Illustrated Microsoft Office 365 & Access 2016: Comprehensive, 1st ed - the VitalSource e-book is provided inside the classroom
ISBN:9781305878006
Publication Info:VS-Cengage
Author:Lisa Friedrichsen
Unit Cost:$166.47
Electronic ISBN:9781337015837
Electronic Unit Cost:$35.00
Book Title:Database Systems: A Practical Approach to Design, Implementation, and Management, 6th ed - the VitalSource e-book is provided inside the classroom
ISBN:9781269886628
Publication Info:VS-Pearson
Author:Connolly, Thomas ; Carolyn Begg
Unit Cost:$137.67
Electronic ISBN:9781269875356
Electronic Unit Cost:$37.80
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

Previous Syllabi

Not current for future courses.