College of Science

Courses

Database Systems

Course Code C0505 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

Subject

Week

An introduction to information system:

-          Information concepts.

-          System concepts.

Systems development.

First

-          A Database Systems:
       -    Design, Implementation, and Management.

-    What is RDBMS.

-                      What a database is, the various -   -     Types of databases.

The importance of database design.

Second

Using Structured Query Language (SQL) to:

-          Create database

-          Rename database

-          Drop database

Select database

Third

Using DDL and DML to:

-          Create table

-          Insert table

-          Alter table

Drop table

Fourth

Using SQL Clauses with query statements:

-          Where Clause

-          From Clause

-          Distance Clause

-          Order by Clause

Group by Clause

Fifth

How many types of Operator in SQL:

-          Comparison operators

-          Arithmetic operators

-          Logical operators

Operators used to negate conditions.

Sixth

The Relational Database Model:

-                    Integrity Rules

Relational Algebra

Seventh

The Relational Database Model:

-    The Data Dictionary and the  System Catalog

Relationships within the Relational Database

Eighth

Database Design:

-    The information system

The systems development life cycle

Ninth

Database Design:

-    The database life cycle

Conceptual design

Tenth

Database Design:

-    The database life cycle

Conceptual design

Eleventh

Database Design:

-    DBMS software selection

Logical design

Twelfth

Database Design:

Centralized vs.

Thirteenth

decentralized design

Fourteenth

Project Design Group I, II, III of different systems

Fifteenth