#REQUEST.pageInfo.pagedescription#

Site Navigation

COMP7025 - Database Systems 1

banner1
Title:Database Systems 1
Long Title:Database Systems 1
Module Code:COMP7025
 
Credits: 5
NFQ Level:Fundamental
Field of Study: Computer Science
Valid From: Semester 1 - 2011/12 ( September 2011 )
Module Delivered in 7 programme(s)
Module Coordinator: TIM HORGAN
Module Author: ARTHUR TOBIN
Module Description: Over the past two decades there has been enormous growth in the number and importance of database applications. Databases are used to store, manipulate and retrieve data in nearly every type of organisation, including business, health care, education, libraries and even our mobile phones. Hence, a course in database systems has become one of the most important courses in the computer science and information systems curriculum today.
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1 Explain the basic concepts of Database Management Systems and the Relational database model.
LO2 Devise solutions to database queries using interactive SQL DML commands
LO3 Design small-scale databases using the relational data model and basic normalization.
LO4 Implement a database using SQL data definition language
Pre-requisite learning
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named CIT module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
No recommendations listed
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
3094, 3201
Co-requisite Modules
No Co-requisite modules listed
Requirements
This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. You may not enrol on this module if you have not acquired the learning specified in this section.
No requirements listed
Co-requisites
No Co Requisites listed
 

Module Content & Assessment

Indicative Content
Database concepts and the Relational Data Model
Basic concepts in DBMS: Data Integration and sharing, comparison with traditional data processing systems; DBMS architecture; Data Independence; Procedural/non procedural languages; Relational Model terminology: Keys, Integrity, Views.
SQL Manipulation
Manipulating data in SQL; Processing Single & Multiple Tables - SELECT commands. Functions & Group By.
Small-Scale Database Design
Use of normalization to develop small scale databases, and produce relations that are well structured, i.e. are in 3NF or BCNF where appropriate.
SQL Data Definition
Database Definition in SQL - CREATE SCHEMA, DROP SCHEMA, CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE VIEW, DROP VIEW, CREATE INDEX, DROP INDEX, CHECK commands.
Assessment Breakdown%
Course Work100.00%
Course Work
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Short Answer Questions Database Programming using SQL 2 30.0 Week 5
Short Answer Questions Small-scale Database Design & Implementation using Basic Normalization and SQL. 3,4 20.0 Week 10
Multiple Choice Questions Database Programming & Implementation 1,2,3,4 50.0 Sem End
No End of Module Formal Examination
Reassessment Requirement
Coursework Only
This module is reassessed solely on the basis of re-submitted coursework. There is no repeat written examination.

The institute reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture No Description 2.0 Every Week 2.00
Lab Labs will involve the use of database manipulation usinge.g. Ingres, Oracle, or Microsoft Access 2.0 Every Week 2.00
Independent & Directed Learning (Non-contact) No Description 3.0 Every Week 3.00
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 4.00
Workload: Part Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture No Description 2.0 Every Week 2.00
Lab Lab/Tutorial 2.0 Every Week 2.00
Independent & Directed Learning (Non-contact) No Description 3.0 Every Week 3.00
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 4.00
 

Module Resources

Recommended Book Resources
  • Thomas M. Connolly, Carolyn E. Begg,, Database Systems: A Practical Approach to Design, Implementation and Management, 5th Ed. [ISBN: 9780321523068]
Supplementary Book Resources
  • C.J. Date, Introduction to Database Systems, 8th Ed., Addison Wesley [ISBN: 0321189566]
  • Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 5th Ed., Addison Wesley [ISBN: 032141506X]
This module does not have any article/paper resources
This module does not have any other resources
 

Module Delivered in

Programme Code Programme Semester Delivery
CR_KSDEV_8 Bachelor of Science (Honours) in Software Development 3 Mandatory
CR_KITMN_8 Bachelor of Science (Honours) in IT Management 3 Mandatory
CR_KDNET_8 Bachelor of Science (Honours) in Software Development and Computer Networking 3 Mandatory
CR_KWEBD_8 Bachelor of Science (Honours) in Web Development 3 Mandatory
CR_KCOMP_7 Bachelor of Science in Computing 3 Mandatory
CR_KITSP_7 Bachelor of Science in Information Technology 3 Mandatory
CR_KCOMP_6 Higher Certificate in Computing 3 Mandatory

Cork Institute of Technology
Rossa Avenue, Bishopstown, Cork

Tel: 021-4326100     Fax: 021-4545343
Email: help@cit.edu.ie