Skip to main content
NounStudy
Back to Course Catalog
CIT208Social Sciences2 Unitsintermediate

Information Systems

This course introduces the concepts of Information Systems, SQL, and database programming. It covers conceptual modeling, schema design, functional dependency, regular expressions, and relational algebra. Students will learn to write SQL statements, use JDBC to access databases, and understand web services and XML. The course also explores database recovery techniques and provides a foundation for designing and managing information systems.

Generate AI Study Notes

Transform this course into personalized study materials with AI

195h
Study Time
13
Weeks
15h
Per Week
basic
Math Level
Course Keywords
Information SystemsSQLDatabaseXMLWeb Services

Course Overview

Everything you need to know about this course

Course Difficulty

Intermediate Level
Builds on foundational knowledge
65%
intermediate
➕
Math Level
Basic Math
🔬
Learning Type
Hands-on Practice

Course Topics

Key areas covered in this course

1

Information Systems

2

Structured Query Language (SQL)

3

Database Design

4

Conceptual Modeling

5

XML

6

Web Services

7

Database Recovery

Total Topics7 topics

Requirements

Knowledge and skills recommended for success

Basic computer literacy

Introduction to programming

💡 Don't have all requirements? Don't worry! Many students successfully complete this course with basic preparation and dedication.

Assessment Methods

How your progress will be evaluated (3 methods)

assignments

Comprehensive evaluation of course material understanding

Written Assessment

tutor-marked assignments

Comprehensive evaluation of course material understanding

Written Assessment

final examination

Comprehensive evaluation of course material understanding

Computer Based Test

Career Opportunities

Explore the career paths this course opens up for you

Database Administrator

Apply your skills in this growing field

Information Systems Manager

Apply your skills in this growing field

Web Services Developer

Apply your skills in this growing field

Data Analyst

Apply your skills in this growing field

SQL Developer

Apply your skills in this growing field

Industry Applications

Real-world sectors where you can apply your knowledge

BankingHealthcareE-commerceGovernmentEducation

Study Schedule Beta

A structured 13-week journey through the course content

Week
1

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

2h

Unit 1: Introduction to Information Systems

2 study 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.
Week
2

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

2h

Unit 2: Introduction to Basic SQL

2 study hours
  • •Explain the basics of SQL programs.
  • •Define standard keywords of SQL programs.
  • •Work on any SQL platform/server.
  • •Manage and access databases easily.
Week
3

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

2h

Unit 3: SQL Syntax I

2 study 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.
Week
4

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

3h

Unit 4: SQL Syntax II

3 study 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.
Week
5

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

2h

Unit 5: More SQL Statements

2 study hours
  • •Write SQL statements.
  • •Use the ORDER BY statement.
  • •Use the INSERT INTO statement.
  • •Update a group of data.
  • •Delete rows from a table.
Week
6

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

2h

Unit 6: Database Programming and JBDC

2 study 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.
Week
7

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

2h

Unit 1: Conceptual Modelling and Schema Design

2 study hours
  • •Understand the meaning of conceptual modeling.
  • •Learn about schema designs.
  • •Understand database relationships.
  • •Study mapping EER to relational data model.
Week
8

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

2h

Unit 2: Functional Dependence

2 study 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.
Week
9

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

2h

Unit 3: SQL Syntax I

2 study hours
  • •Write the regular expression equivalence of a character or string.
  • •Convert any regular expression to its character or string equivalence.
Week
10

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

2h

Unit 4: Relational Algebra

2 study 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.
Week
11

Module 3: Web services, XML and database recovery

2h

Unit 1: Web Services

2 study hours
  • •Describe the basic concept and application of web services.
  • •Identify web services framework.
  • •Describe web services architecture.
Week
12

Module 3: Web services, XML and database recovery

2h

Unit 2: Introduction to XML

2 study 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.
Week
13

Module 3: Web services, XML and database recovery

4h

Unit 3: XML and XML Queries

2 study hours
  • •Define XML.
  • •Write and use XML Queries to solve real-life problems.

Unit 4: Database Recovery

2 study 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.

This study schedule is in beta and may not be accurate. Please use it as a guide and consult the course outline for the most accurate information.

Course PDF Material

Read the complete course material as provided by NOUN.

Access PDF Material

Study Tips & Exam Preparation

Expert tips to help you succeed in this course

1

Review all SQL syntax and practice writing queries for different scenarios.

2

Create flashcards for key concepts in database design and normalization.

3

Practice converting ER diagrams to relational schemas and vice versa.

4

Focus on understanding the different types of web services and their applications.

5

Study the rules for XML documents and practice writing well-formed XML.

6

Create a concept map linking the different types of information systems and their uses.

7

Work through all examples in the study units and attempt similar exercises.

Related Courses

Other courses in Social Sciences that complement your learning

POL228

Introduction To Comparative Politics

3 Units
TSM244

Tourist Sites: Products & Operations Ii

2 Units
ECO231

Micro Economic Theory I

2 Units
View All Social Sciences Courses