|
Module Title |
Introduction to Databases
|
|
Module Code |
CA218
|
|
School |
School of Computing
|
Online Module Resources
|
| Module Co-ordinator | Dr Claus Pahl | Office Number | L2.27 |
|
Level |
2
|
Credit Rating |
5
|
|
Pre-requisite |
None
|
|
Co-requisite |
None
|
|
|
Module Aims
|
To provide students with an introduction to and an overview of database systems including database design, Entity Relationship data modelling, the relational model of data and SQL, as well as an overview of some database products.
|
|
Learning Outcomes
|
As a result of this course, students will be in a position to design and implement a database for real world application, covering all stages of the process from conceptual design and layout through to writing SQL for transactions. Students will also be very familiar with SQL.
|
|
Indicative Time Allowances
|
|
|
Hours
|
|
Lectures |
24
|
|
Tutorials |
12
|
|
Laboratories |
12
|
|
Seminars |
0
|
|
Independent Learning Time |
27
|
|
|
|
|
Total |
75
|
|
Placements |
|
|
Assignments |
|
|
|
NOTE
|
Assume that a 5 credit module load represents approximately 75 hours' work, which includes all teaching, in-course assignments, laboratory work or other specialised training and an estimated private learning time associated with the module.
|
|
Indicative Syllabus
|
|
· Chapter 1. Information Systems
· Chapter 2. Database Overview
· Chapter 3. Storage Structures
· Chapter 4. Entity-Relationship Data Modelling
· Chapter 5. Relational Model of Data
· Chapter 6. SQL
· Chapter 7. Overview of Database Products
· Chapter 8. The System Catalog
· Chapter 9. Views
· Chapter 10. Database Design & Normalisation
· Chapter 11. Web Databases and JDBC
|
| Assessment | | Continuous Assessment | 25% | Examination Weight | 75% |
|
|
Indicative Reading List
|
|
Essential
Fundamentals of Databases , Elmasri and Navathe, , 1999
Supplementary
|
|
|
|
Programme or List of Programmes
|
| BSSA | Study Abroad (DCU Business School) |
| BSSAO | Study Abroad (DCU Business School) |
| CAIS | BSc in Computer Applications (Inf.Sys.) |
| CASE | BSc in Computer Applications (Sft.Eng.) |
| ECSA | Study Abroad (Engineering & Computing) |
| ECSAO | Study Abroad (Engineering & Computing) |
| HMSA | Study Abroad (Humanities & Soc Science) |
| HMSAO | Study Abroad (Humanities & Soc Science) |
| MS | BSc in Mathematical Sciences |
| SHSA | Study Abroad (Science & Health) |
| SHSAO | Study Abroad (Science & Health) |
| Archives: | |
