Transcript Introduction to Database Technology course

Introduction to Database
Technology course
DT228/3
Semester 1
Breakdown of course
• This course is valued at 5 ECTS points.
• There are 36 contact hours, leaving 64 self-study hours.
• Weekly contact hours:
– 1 hour lecture
– 1 hour tutorial
– 1 hour lab
• Self-Study expectations:
–
–
–
–
Finish all lab / tutorial exercises assigned to you.
Undertake one lab test
Undertake one assignment, as part of a group.
Learn the theoretical and practical content of the course.
Lectures
• Design
– Designing a data model using Normalisation
• Practical
– Standard SQL and Oracle PL/SQL to allow for
lab classes.
• Theoretical
– Architecture and usage of RDBMS.
– Theory of concurrent usage, architecture,
data protection, security, recovery.
Tutorials
• Practice of database schema design.
• Problems relating to concurrency and
transaction design.
• Design of a relational model (in a group)
for a system from a set description.
• Design and specification of queries and
transactions that would be required by the
users of the designed system.
Practicals
• Introduction to Oracle SQL*Plus.
• Implementation of standard query types on a
populated schema.
• Creation and population of a schema as
designed in tutorials.
• Implementation of task-based queries.
• Implementation of task-based transactions,
using commit and roll-back, taking concurrency
issues into account.
• Some time will be given to doing your lab test
and assignment.
Assessment
• 30% practical:
– 10% lab test.
– 20% group system implementation.
• 70% examination (2 hours):
– 4 questions, answer 3.
• Q1 compulsory, worth 40%,
– based on tutorial and practical work.
• Q2, 3 and 4 worth 30% each.
– Based on tutorial, practical and theory work.
You will learn
• Data modelling
• Relational database theory
• Use of Oracle Database 10g, using the
SQL*Plus and iSQL*Plus tools.
• Design and implement:
– Queries in SQL
– Transactions in SQL
– Procedures, Functions, Packages and
Triggers in PL/SQL
Data modelling
• How to model data from the meaning of
the stored data.
• Derive a data model from system data
entries and outputs.
• Use Data Normalisation to improve your
model.
Models you will see
• Sample schema
– Builders’ providers – I will use this to
demonstrate techniques
– Football competition coordination – We will
build this through simple exercises
• YOUR GROUP schema
– YOU and two others from your class will
design and build this.