COMP07195 2020 Database Technologies

General Details

Full Title
Database Technologies
Transcript Title
Database Technologies
Code
COMP07195
Attendance
N/A %
Subject Area
COMP - Computing
Department
BUS - Business
Level
07 - NFQ Level 7
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2020 - Full Academic Year 2020-21
End Term
9999 - The End of Time
Author(s)
Aine Doherty, Mary Carden
Programme Membership
SG_MBUSI_H08 202000 Bachelor of Arts (Honours) in Business & ICT
Description

This module will introduce the basics of relational and non-relational database design using Microsoft Access and a NoSQL Database . It will discuss and develop a range of data retrieval and manipulation methods. These techniques will be applied to a relevant business case study and will develop a range of skills enabling students to apply relational and non-relational database technology skills in the workplace.

Learning Outcomes

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

1.

Define tables and views with appropriate constraints to ensure data integrity and relational integrity

2.

Identify and distinguish between data and meta-data

3.

Manipulate data in a relational database using SQL

4.

Modify data in a non-relational NoSQL database

5.

Develop a database for a business application

Teaching and Learning Strategies

There will be one hour per week to to explain theory using examples where appropriate. The remaining two hours will be spent working in Computer labs where your tutor will give direct instruction and advice. Lab sheet based activity will be used throughout the students are encouraged to work through and complete these tasks.

Module Assessment Strategies

Two open book assessments will be undertaken by the students under controlled circumstances totalling 75% of the marks. The students will be given a previously unseen assignment that is based on the database and SQL statements they have been learning. They can use textbooks and online and/or course resources but they are not permitted to communicate in any way. The end of Semester practical will be a significant practical where they will be required to create a database for a business application.

The students will be given 25% of the assessment marks for various single attempt quizzes throughout the semester. These will occur between weeks 3 to 10 and will compose of 5 quizzes overall at 5% each. The questions will be based on questions from formative quizzes that they have previously seen.

Repeat Assessments

A repeat assessment open book assessment covering all of the course content can be set. However, it should be at the discretion of the course board as to whether the student may have to re-attend for the module as this is a 100% CA.

Indicative Syllabus

Define tables and views with appropriate constraints to ensure data integrity and relational integrity

  • Create single and related database tables
  • Create database views and forms
  • Create table columns with appropriate data types
  • Add primary and foreign key constraints to relevant table values
  • Remove rows from tables, being cognizant of constraint issues.

Identify and distinguish between data and meta-data

  • Identify data and datatypes 
  • Identify meta-data 
  • show and develop understanding of the differences between them in a DBMS

Manipulate the data in a relational database using SQL

  • Select ,Insert, Update and Delete  data in a database using specific criteria and appropriate data types
  • Use relational operators and INNER and OUTER JOINs to query multiple tables.

Modify Data in a non-relational NoSQL database

  • Gets, puts, listing, scans and query data in a noSQL database 
  • Compare to the relational database features and understand its advantages

Develop a database for a business application 

  • All information obtained will be used to build a database for a business application case study that will show the real world use of databases and the storage of data.
  • The database will contain data around a small business to store information about employees,stock and customers
  • The database will be developed and certain tasks will be carried out on the data to manipulate and retrieve data as required

 

 

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
100 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Multiple Choice Quizes Continuous Assessment Multiple Choice 25 % OnGoing 1,2,3,4
2 Practical Exam Practical Practical Evaluation 50 % Week 11 5
3 Midterm Continuous Assessment Closed Book Exam 25 % Week 7 1,2,3,4

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Laboratory Practical Computer Laboratory Practical 3 Weekly 3.00
Independent Learning Not Specified Independent Learning 4 Weekly 4.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Required & Recommended Book List

Required Reading
2018-01-16 Introductory Relational Database Design for Business, with Microsoft Access John Wiley & Sons
ISBN 9781119329411 ISBN-13 1119329418

A hands-on beginners guide to designing relational databases and managing data using Microsoft Access Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Ecksteins twenty years experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience. Relational Database Design for Business, with Microsoft Access helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases. This text: Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access Moves swiftly from conceptual fundamentals to advanced design techniques Leads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization Introductory Relational Database Design for Business, with MicrosoftAccess is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary hands-on learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL.

Required Reading
2014-09 Sams Teach Yourself NoSQL with MongoDB in 24 Hours Pearson Education
ISBN 9780672337130 ISBN-13 0672337134

"Now, in just 24 lessons of one hour or less, you can learn how to leverage MongoDB's immense power. Each short, easy lesson builds on all that's come before, teaching NoSQL concepts and MongoDB techniques from the ground up."--

Module Resources