COMP08159 2023 Information Systems

Design a relational database schema for a software application

Develop a set of relational tables and develop the relational database

Query a relational database using SQL

Implement basic table joins and stored procedures

This module will be delivered online. Multiple short (20 minutes) videos will be made available on a weekly basis, along with appropriate reading materials. The learners will be encouraged to use Moodle to ask/answer questions and learn from each other.

There will be two assessments (one of which is on-site or remotely proctored) in weeks 4 and 8 (20% and 30% respectively). Students will undertake a final project in the final four weeks of the semester. It is a requirement to pass this project in order to pass the project.

The repeat project will cover all the learning outcomes. Where appropriate, learners may interviewed (onsite or via Skype etc.) to ensure ownership of the work submitted.

Design a relational database for a software application

• The evolution of the relational database model
• Database entities and attributes and relationships between them
• Approaches for good database design (e.g. normalization)
• Database data types, sharding, ACID properties etc.

Develop a set of relational tables and develop the relational database

• The three stages of normalization and alternatives
• Database data types (int, char, money etc.)
• Developing an entity relationship diagram
• Data integrity issues when updating, deleting and inserting records
• Primary, foreign keys etc.

Query a relational database using SQL

• Introduction to SQL programming
• SQL concepts (selecting, ordering, grouping)
• Perform basic CRUD operations using SQL

Implement basic table and stored procedures

• Table Joins
• Stored procedures
• Views