COMP06186 2012 Database Development 1

General Details

Full Title
Database Development 1
Transcript Title
Database Development 1
Code
COMP06186
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_JSCIE_X06 201400 Certificate 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 Design and Development.

Learning Outcomes

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

1.

Design a logical model for a database from a given specification

2.

Design and manage the physical structure of a database

3.

Enforce data integrity using constraints, defaults, and rules

4.

Interrogate a database using SQL

Module Assessment Strategies

Contineous assessment will take place in both class room and laboratory environments requiring the student to practrically apply their learning to prescribed case study scenarios.

Indicative Syllabus

Logical database design
   -Entity Relationship Diagrams
   -Normalisation
Data Types and Tables
Database Integrity
   -Constraints
   -Rules
   -Relationships
Database Interrogation
   -Advanced SQL Scripting

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 Physically design and create a database Continuous Assessment UNKNOWN 15 % Week 5 2,3
2 Practical Evaluation Logically Design A Database Continuous Assessment UNKNOWN 15 % Week 9 1
3 Practical Evaluation Insert, Delete, Update and Retrieve data from a database Continuous Assessment UNKNOWN 20 % Week 14 4

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 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 Lectures Database Implementation 2 Weekly 2.00
Laboratory Practical Computer Laboratory Database Implementation 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