COMP06254 2018 Introduction to Database Technology
Full Title
Introduction to Database Technology
Transcript Title
Introduction to Database Techn
Code
COMP06254
Attendance
N/A %
Subject Area
COMP - Computing
Department
COEL - Computing & Electronic Eng
Level
06 - NFQ 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_KAPPL_H08 201800 Bachelor of Arts (Honours) in Computing in Application Design and User Experience
SG_KSMAR_H08 201800 Bachelor of Science (Honours) in Computing in Smart Technologies
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_KSMAR_C06 201800 Higher Certificate in Science in Computing in Smart Technologies
SG_KSMAR_B07 201800 Bachelor of Science in Computing in Smart Technologies
SG_KGAME_C06 201800 Higher Certificate in Science in Games Development
SG_KGADV_B07 201800 Bachelor of Science in Computing in Games Development
SG_KAPPL_C06 201800 Higher Certificate in Science in Computing in Application Design and User Experience
SG_KAPPL_B07 201800 Bachelor of Arts in Computing in Application Design and User Experience
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_KSOFT_B07 201800 Bachelor of Science in Computing in Software Development
SG_KAPPL_H08 201900 Bachelor of Arts (Honours) in Computing in Application Design and User Experience
SG_KSMAR_H08 201900 Bachelor of Science (Honours) in Computing in Smart Technologies
SG_KSODV_H08 201900 Bachelor of Science (Honours) in Computing in Software Development
SG_KCMPU_H08 201900 Bachelor of Science (Honours) in Computing
SG_KSMAR_C06 201900 Higher Certificate in Science in Computing in Smart Technologies
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_KSMAR_H08 202000 Bachelor of Science (Honours) in Computing in Smart Technologies
SG_KNCLD_B07 202100 Bachelor of Science in Computing in Computer Networks and Cloud Infrastructure
SG_KNCLD_B07 202100 Bachelor of Science in Computing in Computer Networks and Cloud Infrastructure
SG_KAPPL_H08 202100 Bachelor of Arts (Honours) in Computing in Application Design and User Experience
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_KGADV_B07 202100 Bachelor of Science in Computing in Games Development
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_KSMAR_H08 202100 Bachelor of Science (Honours) in Computing in Smart Technologies
SG_KSODV_H08 202200 Bachelor of Science (Honours) in Computing in Software Development
SG_KCMPU_H08 202200 Bachelor of Science (Honours) in Computing
Description
The student will be introduced to database technologies and 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.
Decide the appropriate database technology that should be used for a given specification
2.
Design a logical model for a database from a given specification
3.
Design and manage the physical structure of a database
4.
Enforce data integrity using constraints, defaults, and rules
5.
Interrogate a database using SQL
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
Decide the appropriate database technology that should be used for a given specification.
- Relational Databases
- NoSQL databases
- Graph Databases
- Cloud Databases
Design a logical model for a database from a given specification.
- Entity Relationship Diagrams
- Normalisation
Design and manage the physical structure of a database
- Metadata Databases
- Tables
- Schemas
- Services
Enforce data integrity using constraints, defaults, and rules
- Entity Integrity
- Referential Integrity
- Domain Integrity
Interrogate a database using SQL
- 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 | Project to create and design a database and then insert, delete, update and retrieve data from this database | Project | Individual 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 | Not Specified | Lectures Database Implementation | 2 | Weekly | 2.00 |
| Practical / Laboratory | Computer Laboratory | Database Implementation | 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
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
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