Introduction to Database Technology course - PowerPoint PPT Presentation

1 / 9
About This Presentation
Title:

Introduction to Database Technology course

Description:

Standard SQL and Oracle PL/SQL to allow for lab classes. Theoretical ... Implementation of task-based queries. ... based on tutorial and practical work. Q2, 3 ... – PowerPoint PPT presentation

Number of Views:69
Avg rating:3.0/5.0
Slides: 10
Provided by: poby
Category:

less

Transcript and Presenter's Notes

Title: Introduction to Database Technology course


1
Introduction to Database Technology course
  • DT228/3
  • Semester 1

2
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.

3
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.

4
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.

5
Practicals
  • Introduction to Oracle SQLPlus.
  • 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.

6
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.

7
You will learn
  • Data modelling
  • Relational database theory
  • Use of Oracle Database 10g, using the SQLPlus
    and iSQLPlus tools.
  • Design and implement
  • Queries in SQL
  • Transactions in SQL
  • Procedures, Functions, Packages and Triggers in
    PL/SQL

8
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.

9
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.
Write a Comment
User Comments (0)
About PowerShow.com