extended-abstract

Rapid Aspect-Oriented Assessment of Relational Database Design Assignments

Author:

Vangel V. AjanovskiAuthors Info & Claims

SIGITE '22: Proceedings of the 23rd Annual Conference on Information Technology Education

Pages 86 - 87

https://doi.org/10.1145/3537674.3555794

Published: 21 September 2022 Publication History

Get Access

Abstract

It can be argued that assignments in a Databases course, where students are required to build a database instance based on specifications provided in the form of Entity-Relationship Diagrams and descriptions, are one of the best ways to evaluate students’ practical knowledge because they simultaneously cover a variety of topics and cognitive levels. Organizing an exam with such assignments is a time-consuming process, even more so in a large course. This work proposes a rapid aspect-oriented assessment process and presents a software system that automates most of the tasks needed to administer and assess an exam that includes such assignments.

References

[1]

Vangel Ajanovski. 2021. dbLearn*: Open-Source System and a Set of Practices for Conducting Iterative Exercises and Exams in a Databases Course. In Proceedings of the 22st Annual Conference on Information Technology Education. ACM, SnowBird UT USA, 61–62. https://doi.org/10.1145/3450329.3478317

Digital Library

Google Scholar

[2]

Vangel Ajanovski. 2021. Educational Project Management and Resource Provisioning System – Project-Based Learning on a Scale. Association for the Advancement of Computing in Education (AACE), 39–44. https://www.learntechlib.org/primary/p/219637/

Google Scholar

[3]

Asanthika Imbulpitiya, Jacqueline Whalley, and Mali Senapathi. 2021. Examining the Exams: Bloom and Database Modelling and Design. In Australasian Computing Education Conference(ACE ’21). Association for Computing Machinery, New York, NY, USA, 21–29. https://doi.org/10.1145/3441636.3442301

Digital Library

Google Scholar

[4]

Anthony Kleerekoper and Andrew Schofield. 2018. SQL Tester: An Online SQL Assessment Tool and Its Impact. In Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education(ITiCSE 2018). ACM, New York, NY, USA, 87–92. https://doi.org/10.1145/3197091.3197124

Digital Library

Google Scholar

[5]

Joshua License. 2017. testSQL: Learn SQL the Interactive Way. In Proceedings of the 2017 ACM Conference on Innovation and Technology in Computer Science Education(ITiCSE ’17). ACM, New York, NY, USA, 376–376. https://doi.org/10.1145/3059009.3072991

Digital Library

Google Scholar

[6]

Julia R. Prior. 2014. AsseSQL: An Online, Browser-based SQL Skills Assessment Tool. In Proceedings of the 2014 Conference on Innovation & Technology in Computer Science Education(ITiCSE ’14). ACM, New York, NY, USA, 327–327. https://doi.org/10.1145/2591708.2602682

Digital Library

Google Scholar

Cited By

View all

Chatvichienchai S(2023)Empowering Database Manipulation Skills: A Holistic Approach Integrating User-Friendly Database Tools and Spreadsheet Software2023 5th International Workshop on Artificial Intelligence and Education (WAIE)10.1109/WAIE60568.2023.00032(136-140)Online publication date: 28-Sep-2023
https://doi.org/10.1109/WAIE60568.2023.00032

Index Terms

Rapid Aspect-Oriented Assessment of Relational Database Design Assignments
1. Information systems
  1. Data management systems
    1. Database design and models
    2. Query languages
2. Social and professional topics
  1. Professional topics
    1. Computing education

Recommendations

dbLearn*: Open-Source System and a Set of Practices for Conducting Iterative Exercises and Exams in a Databases Course
SIGITE '21: Proceedings of the 22nd Annual Conference on Information Technology Education

The author's approach in teaching databases, focuses on acquiring competences needed to use and develop systems of realistic complexity, typical for a micro or small company. Each student works towards gaining experience with various database designs ...
Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation
CICSYN '15: Proceedings of the 2015 7th International Conference on Computational Intelligence, Communication Systems and Networks

Relational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, ...
Extending UML for Object-Relational Database Design
«UML» '01: Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools

The most common way of designing databases is using de E/R model without taking into account other views of the system. However, new object-oriented design languages, such as UML (Unified Modelling Language), permit modelling the full system, including ...

Comments

Information & Contributors

Information

Published In

SIGITE '22: Proceedings of the 23rd Annual Conference on Information Technology Education

September 2022

158 pages

ISBN:9781450393911

DOI:10.1145/3537674

Editors:
Ray Trygstad
Illinois Institute of Technology, USA
,
Yong Zheng
Illinois Institute of Technology, USA

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 21 September 2022

Check for updates

Author Tags

Qualifiers

Extended-abstract
Research
Refereed limited

Conference

SIGITE '22

Sponsor:

SIGITE

SIGITE '22: The 23rd Annual Conference on Information Technology Education

September 21 - 24, 2022

IL, Chicago, USA

Acceptance Rates

Overall Acceptance Rate 176 of 429 submissions, 41%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1
Total Citations
View Citations
46
Total Downloads

Downloads (Last 12 months)6
Downloads (Last 6 weeks)1

Reflects downloads up to 05 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Chatvichienchai S(2023)Empowering Database Manipulation Skills: A Holistic Approach Integrating User-Friendly Database Tools and Spreadsheet Software2023 5th International Workshop on Artificial Intelligence and Education (WAIE)10.1109/WAIE60568.2023.00032(136-140)Online publication date: 28-Sep-2023
https://doi.org/10.1109/WAIE60568.2023.00032

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

HTML Format

View this article in HTML Format.

HTML Format

Abstract

References

Cited By

Index Terms

Recommendations

dbLearn*: Open-Source System and a Set of Practices for Conducting Iterative Exercises and Exams in a Databases Course

Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation

Extending UML for Object-Relational Database Design

Comments

Information

Published In

Sponsors

Publisher

Publication History

Check for updates

Author Tags

Qualifiers

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

HTML Format

Share

Share this Publication link

Share on social media

Affiliations