Course Code: INFO161 Course ID: 2618 Credit Hours: 3 Level: Undergraduate
This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization, and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. 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. The book meets the topical requirements for the Microsoft Office Specialist (MOS). 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|
|11/30/20 - 04/30/21||05/03/21 - 06/27/21||Spring 2021 Session I||8 Week session|
|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|
|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:
- Explore the history and evolution of databases.
- Differentiate between the hierarchical, network, and relational database models.
- Explain the architecture and the developing components of a relational database.
- Examine the process for database applications.
- Describe the role of database applications in Information Technology Management.
- Identify the principles of normalization.
- State the concept of cardinality of relationships between tables (relations).
- Analyze the concepts of primary key integrity, referential integrity, and transactional integrity.
- Define the rudiments of the Structured Query Language (SQL).
- Develop code that interacts with relational database.
You will complete the assignments as directed in MyClassroom . The required data files are included in the eresource website and in the course.
Classroom interaction is a vital part of the online experience. Valuable knowledge can be gained from understanding the experiences of other class participants. You will earn participation points for activity in the online discussion.
Each week one or more questions will be posted in the online discussion. Each student will provide at a minimum a 150-word response preferably no later than each Wednesday, to answer the online discussion questions. Additionally, you must provide a peer review of similar length in response to another student’s online discussion input. Your peer review will review/analyze an input and provides justification why you agree/disagree with the information in the student input. You must always be courteous (professional) even in disagreement. Submission of Assignments and Project Documents: Please include your name, course number (ex. INFO161), assignment name and due date at the top of your submissions. Make sure you follow a standard and consistent file naming convention, such as for example: INFO161_Assignment1_JohnSmith.docx. Then upload the assignment
Reflection Paper Assignment
- Create a 3-5 page Word document, name it INFO161_ReflectionPaper_LastName_FirstName.docx
- In this paper discuss the following:
- any database experience you had before you took this course
- what you learned in this class that you may apply in your current or future work
- one way you could use databases for your daily activities
- whether you liked working with databases - would you make a career as a database developer or administrator?
- You do not need to support with citations but if you do follow APA style guidelines
- The structure of your paper should must follow this example:
- Page 1 - the title page - must only have the title of the paper, your name, course name and session, university name, instructor name, and the date you would be writing the paper
- Page 2 to at least page 4 (or more up to 6) discuss the points described above
- Page 5 (or more) - title it as "References" and include any reference you used for your citations in your discussion - following APA Style guidelines
- Turnitin feature will be turned on in the assignment area to verify academic honesty
Weekly learning objective details in course
- Microsoft Word 2003 or later or any word processor with the ability to export a *.txt file.
|Book Title:||MOS Study Guide for Microsoft Access Expert Exam MO-500 - e-book available in the APUS Online Library|
|Publication Info:||Microsoft Press|
|Book Title:||INFO161 - required software for this course is not covered by the APUS Book Grant. Purchase information is available here - https://apus.libguides.com/c.php?g=241438&p=3514444. Cost may vary by subscription length.|
Not current for future courses.