Information Systems

1. Explain the term information system and its various types.
2. Write Structured Query Language (SQL) statements to retrieve and manipulate data.
3. Describe the basic concepts and applications of web services.
4. State the rules of XML documents and identify programming interfaces.
5. Explain the meaning, classification, and properties of functional dependency.
6. Define the concept of regular expression and apply it to pattern matching.

13 weeks, about 29 hours in total. Yours will differ.

1. Week 1Module 1: Introduction to Information Systems, SQL and Database Programming with JDBC

   • Unit 1: Introduction to Information Systems · 2 hours

     Read the introduction to Information Systems.. Understand the different types of Information Systems.. Relate the history of Information Systems.. Describe the Information Systems department..

2. Week 2Module 1: Introduction to Information Systems, SQL and Database Programming with JDBC

   • Unit 2: Introduction to Basic SQL · 2 hours

     Explain the basics of SQL programs.. Define standard keywords of SQL programs.. Work on any SQL platform/server.. Manage and access databases easily..

3. Week 3Module 1: Introduction to Information Systems, SQL and Database Programming with JDBC

   • Unit 3: SQL Syntax I · 2 hours

     Write simple SQL programs.. Familiarize yourself with standard keywords of SQL programs.. Understand how to construct a good SQL statement.. Manage and access databases using create, select, where, and logical operators..

4. Week 4Module 1: Introduction to Information Systems, SQL and Database Programming with JDBC

   • Unit 4: SQL Syntax II · 3 hours

     Write simple SQL programs.. Familiarize yourself with standard keywords of SQL programs.. State how to construct a good SQL statement.. Manage and access databases using create, select, where, and logical operators..

5. Week 5Module 1: Introduction to Information Systems, SQL and Database Programming with JDBC

   • Unit 5: More SQL Statements · 2 hours

     Write SQL statements.. Use the ORDER BY statement.. Use the INSERT INTO statement.. Update a group of data.. Delete rows from a table..

6. Week 6Module 1: Introduction to Information Systems, SQL and Database Programming with JDBC

   • Unit 6: Database Programming and JBDC · 2 hours

     Explain the term database and Database Management Systems (DBMS) in use.. Construct entity relationship diagrams.. Identify the basic database objects.. Program a database using JDBC.. Use JDBC in real-world applications..

7. Week 7Module 2: Conceptual modeling, Schema design, Functional dependency, Regular expression and Relational algebra

   • Unit 1: Conceptual Modelling and Schema Design · 2 hours

     Understand the meaning of conceptual modeling.. Learn about schema designs.. Understand database relationships.. Study mapping EER to relational data model..

8. Week 8Module 2: Conceptual modeling, Schema design, Functional dependency, Regular expression and Relational algebra

   • Unit 2: Functional Dependence · 2 hours

     State the meaning, classification, and properties of functional dependency.. Define the closure of a set of functional dependency.. Outline and identify the basic types of keys.. Explain database normalization..

9. Week 9Module 2: Conceptual modeling, Schema design, Functional dependency, Regular expression and Relational algebra

   • Unit 3: SQL Syntax I · 2 hours

     Write the regular expression equivalence of a character or string.. Convert any regular expression to its character or string equivalence..

10. Week 10Module 2: Conceptual modeling, Schema design, Functional dependency, Regular expression and Relational algebra

    • Unit 4: Relational Algebra · 2 hours

      Explain what a query language does.. Differentiate between procedural and non-procedural languages.. Have a good knowledge of fundamental operations in Relational Algebra.. Use basic operators in Relational Algebra to form queries.. Construct Relational Algebra expressions to perform operations..

11. Week 11Module 3: Web services, XML and database recovery

    • Unit 1: Web Services · 2 hours

      Describe the basic concept and application of web services.. Identify web services framework.. Describe web services architecture..

12. Week 12Module 3: Web services, XML and database recovery

    • Unit 2: Introduction to XML · 2 hours

      Explain why XML was created.. List the rules of XML documents.. Define what an XML document can and cannot contain.. Explain the programming interfaces that work with XML documents.. Explain what the main XML standards are and how they work together.. Describe how companies use XML in the real world..

13. Week 13Module 3: Web services, XML and database recovery

    • Unit 3: XML and XML Queries · 2 hours

      Define XML.. Write and use XML Queries to solve real-life problems..

    • Unit 4: Database Recovery · 2 hours

      Describe the basic concept of database recovery and heterogeneity.. Describe the classification and techniques of database.. Describe the classification criteria for heterogeneous database.. Describe the database recovery log and technique.. Describe database sharing in a heterogeneous database system..