COMP518

Database and Information Systems

Aims

To provide a deep, systematic and critical understanding of the nature of
information systems and particularly database systems, including web
technology for databases.

Syllabus

DB and DBMS: Access and Oracle (1 lecture)

The relational model and relational algebra (2 lectures)

Database analysis and design techniques: ER models (6 lectures)

Conceptual design Entity Relationship models (2 lectures)

Logical design (2 lectures)

Normal forms (2 lecture)

Transaction management (5 lectures)

Transactions (2 lectures)

Serializability, Atomicity (1 lecture)

Concurrency control, Locking (2 lectures)

SQL and its dialects (5 lectures)

Database connectivity (1 lectures)

The JDBC environment

Web Technologies and DBMSs (2 lectures)

Recommended Texts

Connolly and Begg, Database Systems.

Silberschatz, Korth and Sudarshan, Database Systems Concepts

Tahaghoghi, Learning Mysql

Nixon, Learning PHP,Mysql and Javascript

Learning Outcomes

At the end of the module students should have a critical understanding of the nature of relational databases.

At the end of the module students should be able to design and implement large-scale database systems.

At the end of the module students should develop a basic understanding of web technologies applied to databases and database connectivity.

Learning Strategy

Formal Lectures: Students will be expected to attend two hours of formal
lectures in a typical week plus two hours of supervised tutorial. Much of
the material will be presented in the form of "do-it-yourself" work sheets.

Private study: In a typical week students will be expected to devote six
hours of unsupervised time to private study. The time allowed per week for
private study will typically include three hours of time for reflection and
consideration of lecture material and background reading, and three hours
for completion of "do-it-yourself" worksheets and practical exercises.