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

Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module.

Learning Outcomes

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


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


(LO3) At the end of the modulestudents should be able to develop the ability touse SQL as a data definition and data manipulation language, and to develop acritical understanding of querying a relational database withSQL.


(LO4) At the end of the module students should be able to develop a systematic understanding of transaction management and concurrency control in database systems.


(S1) Skills in using technology - Using common applications (work processing, databases, spreadsheets etc.)


(S2) Critical thinking and problem solving - Creative thinking


(S3) Critical thinking and problem solving - Critical analysis


(S4) Critical thinking and problem solving - Synthesis


(S5) Skills in using technology - Information accessing


(S6) Numeracy/computational skills - Confidence/competence in measuring and using numbers


(S7) Problem solving


(S8) Business and customer awareness


(S9) Information Technology (IT) skills


(S10) Computer science principles

Learning Strategy

Teaching Method 1 - Lecture
Description:
Attendance Recorded: Not yet decided


Teaching Method 2 - Tutorial
Description:
Attendance Recorded: Not yet decided