COURSE TITLE: INFORMATION SYSTEMS

Introduction

Deals the various forms of information technology used by people to accomplish specific organizational or individual objectives.
It also gives an insight into computer technology and data communications technology which are the specific  technologies  that  collectively  sum  up  into  information  technology  as  a  whole.  
Since information comprises of data, this course takes you through the various ways through which data is created  and  manipulated  to  produce  relevant  information  needed.  It  also  deals  with  the  various advances  in  computer  hardware,  software,  and  networking  technologies  which  have  spurred  an
evolution in the structure, design, and use of corporate information systems.
This course is divided into three modules. The first module deals with the basic introduction to the
concept of Information Systems, SQL and Database Programming with JDBC.
The second module deals with Conceptual modeling, Schema design, Functional dependency, Regular
expression and Relational algebra.
The third module deals with Web services, XML and database recovery.
This Course Guide gives you a brief overview of the course content, course duration, and course
materials. 
What you will learn in this course
The  main  purpose  of  this  course  is  to  provide  the  necessary  tools  for  designing  and  managing
Information Systems. It makes available the steps and tools that will enable you to make proper and
accurate decision on Database designs and operations whenever the need arises. Thus, we intend to
achieve through the following: 

Course Aims

I.      Introduce the concepts associated with Information systems development;
II.      Provide necessary tools for analyzing, designing, developing a Database of any size;
III.      Provide you with the necessary foundation in Database programming 
IV.      Introduction of Web services and their architectural frameworks; and
V.      Provide you with the necessary foundation on the use of XML

Course Objectives

Certain objectives have been set out to ensure that the course achieves its aims. Apart from the course
objectives, every unit of this course has set objectives. In the course of the study, you will need to
confirm, at the end of each unit, if you have met the objectives set at the beginning of each unit. By the
end of this course you should be able to:
I.      Explain the term information system.
II.      Identify the various types of Information System.
III.      Write Structured Query Language statements.
IV.      Know the meaning, classification and properties of functional dependency and the description
of Relational Algebra.
V.      To use Structured Query Language (SQL) to retrieve data from and manipulate data in a
database.
VI.      To use the JDBC to access databases.
VII.      Describe the basic concept and application of web services.
VIII.      Identify web services framework.
IX.      The rules of XML documents.
X.      Programming interfaces that work with XML documents.
XI.      Understand the concept of regular expression

Working Through This Course

In order to have a thorough understanding of the course units, you will need to read and understand the contents, practice the steps by designing an Information system of your own, and be committed to learning and implementing your knowledge.
This course is designed to cover approximately seventeen weeks, and it will require your devoted attention.

MODULE ONE

UNIT 1:                                  Introduction to Information Systems
UNIT 2:                                  Introduction to Basic SQL
UNIT 3:                                  SQL Syntax I
UNIT 4:                                  SQL Syntax II
UNIT 5:                                  More SQL Statements
UNIT 6:                                  Database Programming and JBDC

MODULE TWO

UNIT 1:                                  Conceptual modelling and Schema Design

UNIT 2:                                  Functional Dependency
UNIT 3:                                  Regular Expression
UNIT 4:                                  Relational Algebra

MODULE THREE

UNIT 1:                                  Web Services
UNIT 2:                                  Introduction to XML 
UNIT 3:                                  XML and XML Queries 

UNIT 4:                                  Database Recovery