College of Science

Courses

Information Management

Course Code C0160 Th 4 Pr 4 CrHrs 3

A study of the necessary management, file, and data structures within the context of the design, implementation, and use of a database management system. Topics include administration of data resource and program development in creating, maintaining, and accessing a database. Students will use current microcomputer (SQL server) and Large Scale (Oracle) application software within the database management system environment.

The purpose of this course: First, to explains the IS concepts. Second, the course also lists the basic components that form the IS and its roles in an organization and business. Third, the course leads to analyze in groups to study on IS in organization. In addition, the course covers the fundamentals of database systems including data modeling and relationships and normalization. Further, this course explains the SQL query statements in order to design a real database using SQL server.

Distribution of Marks

Final Mark

Final Exam

Second Term

Mid-Year

First Term

100

Prac.

Theor.

Prac.

Theor.

Prac.

Theor.

Prac.

Theor.

20

30

5

5

10

20

5

5

References

SN

Stair, Ralph M, & Reynolds, George W (2012) Principles of Information Systems. 10th edition. Cengage Learning.

1

Carlos Coronel and Steven Morris (2015) Database Systems - Design, Implementation, and Management (11th Edition). Cengage Learning.

2

Bryan Syverson and Joel Murach (2016) Murach’s SQL Server 2016 for Developers. 

3

Introduction to Information Management System

Database Systems: Design, Implementation, and Management

Database Systems: Design, Implementation, and Management

Database Systems: Design, Implementation, and Management

Entity- Relationships Model: Entities 

Entity- Relationships Model:   Attributes

Relation keys: super key, primary key, candidate key, foreign key

Introduction to relational Model

Mapping the ER Model to Relational DBs

Mapping the ER Model to Relational DBs

Normalization

Normal Forms: Normalization

Normal Forms: Decomposition

Multivalued Dependencies

Denormalization