Module: Business Database Management I

Module Specifications..

Current Academic Year 2023 - 2024

Please note that this information is subject to change.

Module Title	Business Database Management I
Module Code	CA227
School	School of Computing
Module Co-ordinator	Semester 1: Jane Kernan Semester 2: Jane Kernan Autumn: Jane Kernan
Module Teachers	Jane Kernan
NFQ level	8	Credit Rating	10
Pre-requisite	None
Co-requisite	None
Compatibles	None
Incompatibles	None

None
Array

Description

This module aims to familiarise the student with all aspects of database deployment in the modern business environment. It aims to ensure that the student has a sound grasp of key database technologies and software architectures and their environments and how these support on business processes and systems. The module gives the student a practical understanding of the pivotal nature of business information in the context of database systems and their integration with important ancillary business applications (Spreadsheets etc.). It provides the student with the practical skills which will allow them to understand all aspects of database management from the point of view of provision of timely information to key business processes.

Learning Outcomes

1. Explain the principles and practices of database management in business organisations.
2. Explain what business information is, and how it is acquired efficiently.
3. Demonstrate a comprehensive understanding of the software architecture of a major database management system which is deployed widely in industry.
4. Apply the development lifecycle of software applications which use database technology. The student will be familiar with the design and implementation and rollout stages of such applications.
5. Interpret and proficient in basic database schema design techniques.
6. Apply basic formal processes which allow a database designer to construct a well designed schema. The student will be proficient in fundamentals of database schema design.
7. Design and build basic database applications using a variety of interfaces to the database (SQL, PHP, scripts, Spreadsheets)
8. Interact with a large database management system and ancillary application systems (Spreadsheets and bespoke applications).

*Type*	*Hours*	*Description*
Workload	Full-time hours per semester
Lecture	48	In class learning
Laboratory	48	No Description
Independent Study	154	No Description
Total Workload: 250

All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml

Indicative Content and Learning Activities

Assessment Breakdown
Continuous Assessment	40%	Examination Weight	60%

Type	Description	% of total	Assessment Date
Course Work Breakdown
Short Answer Questions	class test	5%	Week 5
Assignment	understanding how to interpret business rules and ER Diagram	5%	Week 8
Written Exam	SQL Exam	10%	Week 10
Group project	Plan, design and develop a fully working database system	20%	Sem 2 End

Reassessment Requirement Type
Resit arrangements are explained by the following categories; 1 = A resit is available for all components of the module 2 = No resit is available for 100% continuous assessment module 3 = No resit is available for the continuous assessment component
This module is category 1

Indicative Reading List

Fred R. McFadden, Jeffrey A. Hoffer, Mary B, Prescott: 0, Modern database management, 0201383721

Other Resources

None

Programme or List of Programmes

COMBUS	BSc in Computing for Business
EC	BSc in Enterprise Computing

Date of Last Revision

19-JAN-10

Archives: