Module Delivered in

Programme CodeProgrammeSemesterDelivery
TA_KACOM_BBachelor of Science (Honours) in Computing3Mandatory
TA_KAITM_BBachelor of Science (Honours) in IT Management3Mandatory
TA_KACOM_DBachelor of Science in Computing3Mandatory
TA_KITMG_DBachelor of Science in IT Management3Mandatory
TA_KCOMP_CHigher Certificate in Science in Information Technology3Mandatory

Short Title:Database
Full Title:Database
Module Code:DBAS H2001
 
NFQ Level:6
 
ECTS Credits:5
Reviewed By:FINBARR FEENEY
Description:This subject aims to instil an understanding of the role of a DBMS in an information system. student will learn database design techniques and will gain expertise in the main constructs of SQL.
Learning Outcomes:
On successful completion of this module the learner will be able to
  1. Explain the architecture and main functions of a DBMS
  2. Apply appropriate modelling and design techniques to produce a database schema
  3. Use SQL to define and manipulate data in an industrial-strength database (e.g. Oracle)
  4. Use stored procedures and triggers to aid abstraction and enforce referential integrity
 

Module Content & Assessment

Content
  • INTRODUCTION TO DATABASE CONCEPTS
    Overview of relational databases, 3-layer architecture of DBMSs, principal functionalities of DBMSs.
  • DATABASE DESIGN
    Logical Design; Bottom Up Design, Normalisation to Third Normal Form and BCNF; Top-down Design, Entity Relationship Diagrams.
  • DATA QUERY & MANIPULATION USING SQL
    SQL; Basic Queries; Querying multiple tables: inner, outer, and self joins; Aggregate functions; Set queries; Inserting, altering, and deleting data.
  • DATA DEFINITION USING SQL
    Mapping Data Definition: tables, integrity constraints, indexes, views
  • DATABASE OBJECTS
    Stored Procedures, Stored functions, Triggers in a Database (e.g. Oracle and PL/SQL)
Assessment Breakdown%
Course Work40%
End of Semester Formal Examination60%
 Outcome addressed% of totalAssessment Date
Formal End-of-Semester ExaminationNone60%Semester End
Coursework Breakdown
TypeDescriptionOutcome addressed% of totalAssessment Date
No coursework

IT Tallaght reserves the right to alter the nature and timings of assessment

 

Module Workload & Resources

This course has no full time workload.
Resources
Required Book Resources
  • Ramez Elmasri, Shamkant B. Navathe 2007, Fundamentals of database systems, Pearson Addison Wesley Boston [ISBN: ISBN: 0321122267]
  • Chip Dawes, Biju Thomas 2000, OCP, SYBEX San Francisco, Calif. [ISBN: ISBN: 0782126820]
  • Sanjay Mishra and Alan Beaulieu 2002, Mastering Oracle SQL [ISBN: ISBN: 0596001290]
Recommended Book Resources
  • C. J. Date 2004, An introduction to database systems, Pearson/Addison Wesley New York [ISBN: ISBN 0321197844]
  • McFadden, F., Hoffer, J. & Prescott, M. 2005, Modern Database Management, Longman Higher Education
  • Rajshekhar Sunderraman 2003, Oracle 9i Programming: A Primer, Addison Wesley [ISBN: ISBN: 0321194985]
  • Rick Greenwald and David C. Kreines 2003, Oracle in a nutshell, O'Reilly [ISBN: ISBN: 0596003366]
  • Rick Greenwald, Robert Stackowiak, and Jonathan Stern 2001, Oracle essentials, O'Reilly Sebastopol [ISBN: ISBN: 0596001797]