Skip Navigation
 

INFO471 - Relational Databases With Oracle: Forms & Reports

Course Details

Course Code: INFO471 Course ID: 2651 Credit Hours: 3 Level: Undergraduate

This course is a study and application of the User Interaction for enterprise relational database systems. Topics include: the architecture of Forms and Reports interface, the anatomy of the Form Module and its various components, such as: blocks, frames, items, attributes, editors, windows, canvases, messages, alerts, menus, and objects. This course also examines the implementation of data integrity using various types of triggers, including: input, non-input, message, alerts, query, validation, navigational, and transactional; it also addresses reusability and interface efficiency using modular Program Units, Libraries, Menus, and Pop-up Menus. This course is also a study and application of the theory, concepts, and applications associated with parameterized and non-parameterized Data Retrieval and Analysis. It also appraises report template libraries to standardize reports for the enterprise; and the Reports Server to manage and disseminate reports across the enterprise. Students must have access to Oracle 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. (Prerequisite: INFO171 or equivalent)





Prerequisites

Course Schedule

Registration Dates Course Dates Session Weeks
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
04/29/19 - 10/04/19 10/07/19 - 12/01/19 Fall 2019 Session B 8 Week session

Current Syllabi

After completing this course the student will be able to:

  • Understand Oracle ADF and develop with ADF
  • Understand ADF business components
  • Build a simple business service
  • Use the ADF Model tester
  • Develop entity objects
  • Develop view objects
  • Define an application module
  • Build data bound table user interface
  • Build data bound query search forms
  • Understand exceptions
  • Understand bounded task flow activities

Students are expected to maintain routine contact with the instructor throughout the course. While the number of contacts may vary according to the specific course and individual student need, the University requires periodic weekly contacts during the semester. Contact will consist of professor notes and email feedback. The method of the forums will be on-line related to issues concerning forum assignments, quizzes, mini case lab assignments, and exams.

TEXTBOOK READINGS
The main book for the course, Oracle ADF Real World Developer's Guide- E-book available in the APUS Online Library, will be used for textbook readings. Review the table at the end of the syllabus to see assigned readings for each week. Access the E-Book through the Resources in the classroom.


ASSIGNMENTS

There are 8 assignments for this course. The weekly assignments for this course are located under the Assignments Section of the course. You will find all the files needed to complete the projects located under Resources on the left side of the APUS classroom. The projects that are required to be completed for this course will be listed as part of the forum for the week it is due. Also, see the table at the end of the syllabus for a short list of projects and due dates.



FORUMS

The Forum assignments for this course are designed to promote interactivity among students and enhance the online learning process. The Forum provides maximum flexibility because you do not have to be online at the same time as another person and you can read what other students have written.

Forum Timing: For the forums, I encourage you to post your work by midnight on Wednesday, and continue to follow your classmates' posts for the remainder of the week, and post the follow-up peer responses prior to midnight on Sunday. The deadline for your Forum Posts is midnight on Sunday evening of each week. Your follow-up posts can add additional insight to a classmate's opinions or can challenge their opinions. Use examples from the readings, or from your own research, to support your views, as appropriate. Be sure to read the follow-up posts to your own posts and reply to any questions or requests for clarification. You are encouraged to conduct research and use other sources to support your answers.

Required Participation: Please keep in mind that the forum assignments require you to make at least 1 post to the forum with at least 350 words about the topic and also respond to at least 2 peers’ posts with at least 150 words. Please be advised that there will be point deductions if you do not comply with these requirements of the assignment. Each one of you will have a different and unique experience that we can all learn from. Your participation in the Forums unleashes the power of synergy in our classroom. To facilitate this interaction, please be prompt when posting your forum work for each week; this provides time for the others to actively engage in the dialogue. For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. There is no need to also post your forum work in the assignments area of the classroom. Refer to the forum matrix at the end of the syllabus for more details on grading. I hope this is a great learning experience in this class.

Week 1 Forum: The Forum Introduction and an introduction to Oracle ADF will consist of an introduction of yourself and research and analysis by students on Oracle ADF. For this week, we will be discussing how you would define Oracle ADF, and what some benefits of this layered architecture are? We will also look at some advantages and disadvantages associated with ADF Business Components?

You can use your text book as well as a web search for relevant articles and information to assist you in your response. (at least two web sites). Please be advised that there will be point deductions if you do not comply with the requirements of the assignment. To get the maximum value from this class, I would encourage you to go over and above the required minimum number of responses to posts by responding to at least 2 other post as described in the instructions. Each one of you has personal insight and life experiences that are unique and invaluable to our class experience. Your participation in the Forum unleashes the power of synergy into our classroom. All posting are due by Sunday. For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this is a great start to learning in this class.

Week 2 Forum: For this week’s Forum, we will be looking at entity and view objects. Our first task for this forum is to look at the components that make up an entity object. We will then discuss the framework components used by the view object to set up the infrastructure for query execution. And then we will look at how to manage the result set. A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas. I want to also see that you have put some thought into the question. Also, read and respond to AT LEAST 2 other student to show that you have learned what they are describing. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this adds to your learning in this class.

Week 3 Forum: For the Week 3 Forum, you will be exploring BLOB and CLOB data types. How would you define a BLOB data type? And how would you define a CLOB data type? In your discussion, be sure to include 2 different real world examples of each data type. A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas. Please include any aspects that you have learned so far in the course. Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. I want to see that you have put some thought into the discussion. Also, read and respond to AT LEAST 2 other students to show that you have learned and can also appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this adds to your learning in this class.

Week 4 Forum: For the Week 4 Forum, we will be discussing the application module. How would you define the application module? What are three applications/duties of the application module? A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas. Please include any aspects that you have learned so far in the course. Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. I want to see that you have put some thought into the discussion. Also, read and respond to AT LEAST 2 other students to show that you have learned and can also appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this adds to your learning in this class.

Week 5 Forum: For the Week 5, we will be discussing the ADF framework, and how this relates to building a user interface. We will look at the advantages of using the ADF framework, and how this can be beneficial to a business. We will also look at some basic steps for designing a typical ADF page.

A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas. I want to see that you have put some thought into the discussion. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

Week 6 Forum: For the Week 6 Forum, we will be discussing implicit navigation. We will describe how implicit navigation works. We will then describe at least 3 configurable properties that may be seen in a bounded task flow. A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas.

Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. Again, as in the other discussions, I want to see that you have put in a lot of thought. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

Week 7 Forum: For the Week 7 Forum, we will be discussing data validation. For this discussion, we will define validation. Also, look at some reasons why it is important to validate your data. A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas.

Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. Again, as in the other discussions, I want to see that you have put in a lot of thought. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

1. Describe the Single View Controller and model project.

2. Describe at least 2 guidelines needed for setting up the application source using the microkernel approach?

Week 8 Forum: For the Week 8 Forum, we will be discussing the Single View Controller and the model project. As you explore this idea, look at the guidelines needed for setting up the application source using the microkernel approach. A web search for relevant articles and information should be employed to assist you in your response. (at least two web sites). Also be sure to refer to your textbook for additional ideas.

Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. Again, as in the other discussions, I want to see that you have put in a lot of thought. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (try to respond by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

QUIZZES

There will be 2 open book quizzes to be taken after the readings are completed. Each quiz is posted in the electronic classroom under the Tests and Quizzes Section. Quiz 1 covers Chapters 1-4 and Quiz 2 covers Chapters 5-8

GRADING: Please see the student handbook to reference the University’s grading scale. My typical grading schedule is to look at your assignments throughout the week after they are due. If time allows, I will grade ahead for those of you who have worked ahead but it is my policy to grade your assignments with the rest of the class as they become due.

8 Forums 40%

8 Project Assignments 40%

2 Quizzes 20%

NameGrade %
Forum 40.00 %
Week 1 5.00 %
Week 2 5.00 %
Week 3 5.00 %
Week 4 5.00 %
Week 5 5.00 %
Week 6 5.00 %
Week 7 5.00 %
Week 8 5.00 %
Assignments 40.00 %
Week 1 Assignment 5.00 %
Week 2 Assignment 5.00 %
Week 3 Assignment 5.00 %
Week 4 Assignment 5.00 %
Week 5 Assignment 5.00 %
Week 6 Assignment 5.00 %
Week 7 Assignment 5.00 %
Week 8 Assignment 5.00 %
Quizzes 20.00 %
Quiz 1 10.00 %
Quiz 2 10.00 %
Book Title:Oracle Reports Services 12c - Download Oracle Reports from http://www.oracle.com/technetwork/middleware/reports/overview/index.html
ISBN:Software Note
Book Title:Oracle Forms - Download Oracle Forms from http://www.oracle.com/technetwork/developer-tools/forms/overview/index.html
ISBN:Software Note
Book Title:Oracle Database 12c - Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
ISBN:Software Note
Book Title:Oracle ADF Real World Developer's Guide- E-book available in the APUS Online Library
ISBN:9781849684828
Author:Purushothaman Jobinesh
Unit Cost:$68.71
Book Title:To find the library e-book(s) req'd for your course, please visit http://apus.libguides.com/er.php to locate the eReserve by course #. You must be logged in to eCampus first to access the links.
Author: No Author Specified

Previous Syllabi

Not current for future courses.