Database Management Systems 2 (5 Credits)

Course details

This 5-credit module is intended to introduce students to data design and modelling using a database technology in the context of the business environment.

Learning Outcomes:

On completion of this module the learner will/should be able to:

• Illustrate the usefulness of database systems in an SME environment
• Contribute to the design, implementation and operation of a database management system typical to the business sector.
• Plan and design a database using Entity Relationship Modelling.
• Normalise a set of entities.
• Be familiar with data integrity and security concepts

Syllabus:

The module will be taught predominantly through lecturers.

Database Theory:

• Introduction to databases
• The database management system
• Components of the DBMS Roles in the database environment
• Advantages and disadvantages of DBMS
• The relational model Integrity constraints
• Database planning, design and administration
• Fact finding techniques

Entity Relationship Modelling:

• Entity types
• Relationship types
• Attributes Structural constraints
• Problems with ER models

Normalisation:

• The purpose of Normalisation
• How normalisation supports database design
• Data redundancy
• Functional dependencies