COMP06257 2018 Introduction to Database Management

General Details

Full Title
Introduction to Database Management
Transcript Title
Introduction to Database Manag
Code
COMP06257
Attendance
N/A %
Subject Area
COMP - 0613 Computer Science
Department
COEL - Computing & Electronic Eng
Level
06 - Level 6
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2018 - Full Academic Year 2018-19
End Term
9999 - The End of Time
Author(s)
John Weir, Padraig Harte
Programme Membership
SG_KSODV_H08 201800 Bachelor of Science (Honours) in Computing in Software Development SG_KNCLD_H08 201800 Bachelor of Science (Honours) in Computing in Computer Networks and Cloud Infrastructure SG_KNCLD_B07 201800 Bachelor of Science in Computing in Computer Networks and Cloud Infrastructure SG_KCMPU_H08 201800 Bachelor of Science (Honours) in Computing SG_KSODV_B07 201800 Bachelor of Science in Computing in Software Development SG_KNETW_C06 201800 Higher Certificate in Science in Computing in Computer Networks SG_KSODV_C06 201800 Higher Certificate in Science in Software Development SG_KCMPU_C06 201800 Higher Certificate in Science in Computing in Computing SG_KCMPU_B07 201800 Bachelor of Science in Computing in Computing SG_KSODV_H08 201900 Bachelor of Science (Honours) in Computing in Software Development SG_KCMPU_H08 201900 Bachelor of Science (Honours) in Computing SG_KCMPU_C06 201900 Higher Certificate in Science in Computing in Computing SG_KCMPU_B07 201900 Bachelor of Science in Computing in Computing SG_KNCLD_B07 201900 Bachelor of Science in Computing in Computer Networks and Cloud Infrastructure SG_KNCLD_H08 201900 Bachelor of Science (Honours) in Computing in Computer Networks and Cloud Infrastructure SG_KSODV_B07 201900 Bachelor of Science in Computing in Software Development SG_KNCLD_H08 202000 Bachelor of Science (Honours) in Computing in Computer Networks and Cloud Infrastructure SG_KCMPU_H08 202000 Bachelor of Science (Honours) in Computing SG_KSODV_H08 202000 Bachelor of Science (Honours) in Computing in Software Development SG_KCNCS_H08 202100 Bachelor of Science (Honours) in Computing in Computer Networks and Cyber Security SG_KCNCS_B07 202100 Bachelor of Science in Computing in Computer Networks and Cyber Security SG_KSODV_B07 202100 Bachelor of Science in Computing in Software Development SG_KSODV_H08 202100 Bachelor of Science (Honours) in Computing in Software Development SG_KCMPU_H08 202100 Bachelor of Science (Honours) in Computing SG_KCMPU_C06 202100 Higher Certificate in Science in Computing SG_KCMPU_B07 202100 Bachelor of Science in Computing SG_KSODV_H08 202200 Bachelor of Science (Honours) in Computing in Software Development SG_KCMPU_H08 202200 Bachelor of Science (Honours) in Computing SG_KSODV_H08 202400 Bachelor of Science (Honours) in Computing in Software Development SG_KCMPU_H08 202400 Bachelor of Science (Honours) in Computing SG_KNCLD_H08 202400 Bachelor of Science (Honours) in Computing in Computer Networks and Cloud Infrastructure
Description

This module builds on the student experience of Introduction to Database Technology or similar. Now familiar with basic database components, their specification and constraints, and having applied them to an identified problem space, we now extend on the scope of this basic introduction. Students will work both individually and in groups to grapple with problems of greater complexity. The student will be introduced to database coding and will then will learn techniques and tools to optimise this code. They will also cover data security and learn about techniques and tools to secure data.

Learning Outcomes

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

1.

Configure a database to maximise data retrieval

2.

Design and develop logical views of data in a database

3.

Use database views  to manage database security

4.

Configure database views to optomise data retrieval

5.

Program a database using a database procedural language

Teaching and Learning Strategies

Practical Approach to teaching ‑ problem based learning techniques will be applied where appropriate.

Virtual Machines will be used to allow flexibility and enhance learning

Module Assessment Strategies

 

50% continuous assessment. Students have to complete a project with staged submissions throughout the semester. The project will require the student to practically apply their learning to prescribed case study scenarios. There will be a final laboratory based exam at the end also worth 50%.

 

 

 

Repeat Assessments

Repeat Exam to cover learning outcomes.

Indicative Syllabus

Configure a database to maximise data access

  • Data Storage.
  • Cache Hit Ratio.
  • Index Types.
  • Index Properties.
  • Index Decision Factors.
  • Creating & Scripting Indexes.
  • Reorganising and Rebuilding Indexes.

 

Design and develop logical views in a database

  • Design a views based on requirements.
  • Create a view based on a design.
  • Configure the properties of a view.

Use database views to manage database security

  • Create database users.
  • Assign a database user security privileges to a view.
  • Use 3rd party software to allow a database user access data through a view.

 Configure database views to optimise data retrieval

  • Configure view properties so as to create materialised views.
  • Create materialised views.

Program a database using a database procedural language.

  • Program Design using IPOs
  • Control of Flow Statements
  • Using external Variables
  • Using Internal Variables
  • Error checking

 

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
50 %
End of Semester / Year Formal Exam
50 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Project to optimise data retrieval from a given scenario. Then design, create, configure and optimise database views from a given specification. Then create a small database program from a given scenario. Coursework Assessment Project 50 % OnGoing 1,2,3,4,5
             
             

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Practical Evaluation End of Module Laboratory Exam Final Exam Open Book Exam 50 % End of Term 1,2,3,4,5
             
             

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Lecture Theatre Lectures database management 2 Weekly 2.00
Practical / Laboratory Computer Laboratory Implementing database management 2 Weekly 2.00
Independent Learning Not Specified Independent Learning 3 Weekly 3.00
Total Full Time Average Weekly Learner Contact Time 4.00 Hours

Required & Recommended Book List

Recommended Reading
2013-07-26 Cloud Database Development and Management Auerbach Publications

Although todays job market requires IT professionals to understand cloud computing theories and have hands-on skills for developing real-world database systems, there are few books available that integrate coverage of both. Filling this void, Cloud Database Development and Management explains how readers can take advantage of the cloud environment to develop their own fully functioning database systems without any additional investment in IT infrastructure.

Filled with step-by-step instructions, examples, and hands-on projects, the book begins by providing readers with the required foundation in database systems and cloud-based database development tools. It supplies detailed instructions on setting up data storage on Windows Azure and also explains how readers can develop their own virtual machines with Windows Server 2012 as the guest operating system.

The books wide-ranging coverage includes database design, database implementation, database deployment to the cloud environment, SQL Database, Table Storage service, Blob Storage service, Queue Storage service, and database application development. The text deals with all three aspects of database design: conceptual design, logical design, and physical design. It introduces the SQL language, explains how to use SQL to create database objects, and introduces the migration of the database between Windows Azure and the on-premises SQL Server. It also discusses the management tasks that keep both SQL Database and Windows Azure running smoothly.

Detailing how to design, implement, and manage database systems in the cloud, the book provides you with tools that can make your cloud database development much more efficient and flexible. Its easy-to-follow instructions will help you develop the hands-on skills needed to store and manage critical business information and to make that data available anytime through the Internet.

Module Resources