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.
|Registration Dates||Course Dates||Session||Weeks|
|12/28/20 - 06/04/21||06/07/21 - 08/01/21||Spring 2021 Session D||8 Week session|
|01/25/21 - 07/02/21||07/05/21 - 08/29/21||Summer 2021 Session B||8 Week session|
|02/22/21 - 07/30/21||08/02/21 - 09/26/21||Summer 2021 Session I||8 Week session|
|03/29/21 - 09/03/21||09/06/21 - 10/31/21||Summer 2021 Session D||8 Week session|
The successful student will fulfill the following learning objectives:
- Describe the evolution of relational databases as a tool for information management.
- Assess the key components of a database management system.
- Assess the process and methodologies for designing databases.
- Explain the functions of database administration.
- Examine the rudiments of the Structured Query Language (SQL).
- Evaluate database table normalization.
- Evaluate the data integrity, security, and availability issues related to relational databases.
- Design a database management system with the skills gained from this course.
The grading will be based on eight weekly Forums, seven graded assignments, a Term Project, and two open book Quizzes.
- There will be seven assignments (5-7% each) counting a total of 41% 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 or based on material in 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 (or a Word compatible product) and uploaded into the student assignment folder by the due date. Assignments also may include work in MS Access and uploading of the Access file in the assignment area.
- 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 critique, 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 32% (4% 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:
- Log into the classroom
- Click the “Forum” link
- Click the appropriate Forum under the column labeled “Group Name”
- Choose a specific thread to see all the messages and choose a specific message to reply.
- Click on the “reply to this message” link.
- Provide your input.
- 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.
The Forum grading rubric can be found in the Forum instructions.
- There will be a Term Project (17%) due the 8th week
- There will be two 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.
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). Forum posts must be made by Sunday of the week they are due – posts will not be accepted after that date for grading – without prior approval. The Weekly assignments and Term Project may be submitted once for grading – double check you have included all the required attachments before finalizing a submission.
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.
Each week, students will review the power point lecture located in the Resources section of the online classroom.
Term Project and Proposal (17%)
The Term project is a database design exercise.
The term project will complete the database design (functional dependencies / normalization) – only the tables are designed - there is no expectation of designing an overall application. The detailed instructions can be found in the online assignment box (at the time of release).
Quiz Completion Procedures
- Log into the classroom
- Click the “exams” link
- 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:
- Log into the classroom.
- Click the “assignments” link.
- Click the corresponding assignment (i.e. INFO321 Week 1 Assignment).
- Upload file to the assignment. Ensure the file is a MS Word document.
- Check the box “submit for grading.”
- Click the “submit” button.
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 expect you to manage competing demands on your time. Should you need additional time to complete an assignment 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”. Bulk uploading of late assignments is not acceptable.
Without prior agreement, 2% points per day will be deducted from “Assignments” that are submitted after the due date. Submissions that are made more than 1 week after the due date may not be accepted for grading – all assignments must be submitted by the last day of class.
ALL “Forum” postings must be made on time. Students are expected to contact me prior to a Forum due date to request additional time. Forum posts made after the weekly due date will not be accepted for grading without prior approval.
No submissions will be accepted for grading after the last day of the course.
Requests for an extension to a due date must be accompanied with a justification and a plan to complete each outstanding assignment. The extension may or may not be granted. Ensure you use the APUS formal course extension process – these requests must be made prior to the last day of class.
Course extensions do not reset the due dates for Assignments or Forums that were due prior to the course extension request.
DISCLAIMER STATEMENT Course content may vary from the outline to meet the needs of this particular group.
|Forum 1||4.00 %|
|Forum 2||4.00 %|
|Forum 3||4.00 %|
|Forum 4||4.00 %|
|Forum 5||4.00 %|
|Forum 6||4.00 %|
|Forum 7||4.00 %|
|Forum 8||4.00 %|
|Exercise 1 - 4||20.00 %|
|Week1 Database Exercise||5.00 %|
|Week2 Database Exercise||5.00 %|
|Week3 Database Exercise||5.00 %|
|Week4 Database Exercise||5.00 %|
|Exercise 5 - 7||21.00 %|
|Week5 Database Exercise||7.00 %|
|Week6 Database Exercise||7.00 %|
|Week7 Database Exercise||7.00 %|
|Term Project||17.00 %|
|Week8 Term Project||17.00 %|
|Quiz week 7||5.00 %|
|Quiz week 4||5.00 %|
Publication manual of the American Psychological Association (6th ed.). (2010). Washington, D.C.: American Psychological Association.
Web-based Readings (Optional)
- Chaterjee, J. (2005). Introduction to RDBMS, OODBMS and ORDBMS. Retrieved November 1, 2007 from http://www.aspfree.com/c/a/Database/Introduction-to-RDBMS-OODBMS-and-ORDBMS/
- Interactive Online SQL Training. (n.d.) Retrieved November 1, 2007 from http://sqlcourse.com/
- Microsoft Access 2010 Query Tutorial (n.d.). Retrieved January 19, 2010 from http://office.microsoft.com/en-us/access-help/create-queries-for-a-new-database-RZ101772999.aspx
- Litt, S. (1996). Normalization. Retrieved July 31, 2004 from http://www.troubleshooters.com/littstip/ltnorm.html
- The Relational Model (n.d). Retrieved November 2, 2007 from http://www.tometasoftware.com/files/relational_model_revised.pdf
- Chappell, M. (n.d.). Choosing a Database for Your Organization. Retrieved November 3, 2007 from http://databases.about.com/od/administration/a/choosing_a_db.htm
- Chappel, M. (n.d.). Password Protect an Access Database. Retrieved November 3, 2007 from http://databases.about.com/od/tutorials/ss/passwordprotect.htm
- Mullins, C. (2002). What is a DBA? Retrieved November 2, 2007 from http://www.dbazine.com/ofinterest/oi-articles/dba-1
- MS Word or any word processor with the ability to export a *.txt file.
- MS Access Availability
- Adobe Acrobat Reader (Click here for free download)
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|
|Electronic Unit Cost:||$32.00|
|Book Title:||Database Systems: A Practical Approach to Design, Implementation, and Management, 6th ed - the VitalSource e-book is provided inside the classroom|
|Author:||Connolly, Thomas ; Carolyn Begg|
|Electronic Unit Cost:||$35.00|
|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|
Not current for future courses.