COMP06187 2012 Database Development 2

General Details

Full Title
Database Development 2
Transcript Title
Database Development 2
Code
COMP06187
Attendance
N/A %
Subject Area
COMP - Computing
Department
COMP - Computing & Creative Practices
Level
06 - NFQ Level 6
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2012 - Full Academic Year 2012-13
End Term
9999 - The End of Time
Author(s)
Padraig Harte
Programme Membership
SG_KWDEV_B07 201200 Bachelor of Science in Computing in Web Dev and Creative Media SG_KSYSN_B07 201200 Bachelor of Science in Computing in Systems and Networking L7 SG_KCMPT_B07 201300 Bachelor of Science in Computing SG_KCOMP_H08 201500 Bachelor of Science (Honours) in Computing SG_KCOMP_G06 201500 Higher Certificate in Science in Computing SG_KCOMP_G07 201500 Bachelor of Science in Computing SG_KSYSN_B07 201500 Bachelor of Science in Computing in Systems and Networking L7 SG_KWDEV_B07 201500 Bachelor of Science in Computing in Web Dev and Creative Media SG_KCOMP_H08 201600 Bachelor of Science (Honours) in Computing SG_KSYSN_B07 201700 Bachelor of Science in Computing in Systems and Networking L7 SG_KWDEV_B07 201700 Bachelor of Science in Computing in Web Dev and Creative Media SG_KSDEV_B07 201700 Bachelor of Science in Computing in Software Development SG_KCOMP_H08 201700 Bachelor of Science (Honours) in Computing
Description

The student will acquire an intermediate set of skills in Database programming and management

Learning Outcomes

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

1.

Program a database using a database procedural language

2.

Optomise database retrieval

3.

Optomise a database using views

4.

Manage database access through views

Module Assessment Strategies

Continuous assessment will take place in a laboratory environment employing practical evaluation to real life scenarios

Indicative Syllabus

RDBMS Programming Overview

Program Design using IPOs

Control of Flow Statements

Using external Variables

Using Internal Variables

Error checking

De-Normalisation principles

Optomising Databases using Indexes

                Data Storage

                Cache Hit Ratio

                Index Types

Index Properties

Index Decision Factors

Creating & Scripting Indexes

Reorganising and Rebuilding Indexes

Views

                Designing and Creating Views

                Virtual and materialized Views

                Setting view properties

                Assigning permissions to Views

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 Practical Evaluation Design and implement Database indexing strategies Continuous Assessment UNKNOWN 15 % Week 6 2
2 Practical Evaluation Desing and Immplent Database Retrieval using Views Continuous Assessment UNKNOWN 15 % Week 10 2,3
3 Practical Evaluation Desing and implement Stored procedures Continuous Assessment UNKNOWN 20 % Week 14 1

End of Semester / Year Assessment

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

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Not Specified Lecture on Database Design & Implementation 2 Weekly 2.00
Laboratory Practical Computer Laboratory RDBMS Programming and Management 2 Weekly 2.00
Total Full Time Average Weekly Learner Contact Time 4.00 Hours

Module Resources

Non ISBN Literary Resources

SQL Server 2008 Relational Database Design and Implementation Kevin Kline (August 2008)

Sams Teach Yourself SQL in 21 Days 4th Edition Ron Plew, Ryan Stephens

Programming Microsoft SQL Server  2012: Leonard Lobel, Andrew Brust

Other Resources

None

Additional Information

None