1 / 9

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:

davis-king
Download Presentation

Introduction to Database Technology course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  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 SQL*Plus and iSQL*Plus 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.

More Related