Use of software tools in teaching relational database design

McIntyre, David R.; Pu, Hao-Che; Wolff, Francis

doi:10.1016/0360-1315(95)00041-j

Cited by 4 publications

(6 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…There are further studies which focus on different aspects including specialized tools for specific topics in DSE (Mcintyre et al, 1995;Nelson & Fatimazahra, 2010). For instance, Mcintyre et al (1995) conducted a survey about using state of the art software tools to teach advanced relational database design courses at Cleveland State University. However, the authors did not discuss the DSE curricula and pedagogy in their study.…”

Section: Related Workmentioning

confidence: 99%

“…Keeping the importance of interactive tools in DSE in perspective, various authors have proposed different interactive tools over the years, such as during 1995-2003, when different authors proposed various interactive tools. Some studies (Abut & Ozturk, 1997;Mcintyre et al, 1995) The Internet has started to become more common in the first decade of the twenty-first century and its positive impact on the education sector was undeniable. Cost effective, student teacher peer interaction, keeping in touch with the latest information were the main reasons which made the instructors employ web-based tools to teach database in the education sector.…”

Section: Rq2 Evolution Of Dse Researchmentioning

confidence: 99%

See 1 more Smart Citation

Advances in database systems education: Methods, tools, curricula, and way forward

et al. 2022

View full text Add to dashboard Cite

Fundamentals of Database Systems is a core course in computing disciplines as almost all small, medium, large, or enterprise systems essentially require data storage component. Database System Education (DSE) provides the foundation as well as advanced concepts in the area of data modeling and its implementation. The first course in DSE holds a pivotal role in developing students’ interest in this area. Over the years, the researchers have devised several different tools and methods to teach this course effectively, and have also been revisiting the curricula for database systems education. In this study a Systematic Literature Review (SLR) is presented that distills the existing literature pertaining to the DSE to discuss these three perspectives for the first course in database systems. Whereby, this SLR also discusses how the developed teaching and learning assistant tools, teaching and assessment methods and database curricula have evolved over the years due to rapid change in database technology. To this end, more than 65 articles related to DSE published between 1995 and 2022 have been shortlisted through a structured mechanism and have been reviewed to find the answers of the aforementioned objectives. The article also provides useful guidelines to the instructors, and discusses ideas to extend this research from several perspectives. To the best of our knowledge, this is the first research work that presents a broader review about the research conducted in the area of DSE.

show abstract

Section: Related Workmentioning

confidence: 99%

Section: Rq2 Evolution Of Dse Researchmentioning

confidence: 99%

Advances in database systems education: Methods, tools, curricula, and way forward

et al. 2022

View full text Add to dashboard Cite

show abstract

“…In (Mcintyre, Pu, & Wolff, 1995) authors propose the use of an expert system (named RA) in the teaching of relational database design. Students used RA to produce relational database schemata from business forms and asked to compare this design procedure to the traditional (based on normalization theory) from the nontechnical end user point of view.…”

Section: Researches About the Human Factors During Conceptual Modellimentioning

confidence: 99%

“…In (Goldstein, & Storey, 1989) and (Hall, & Gordon, 1998) there is evidence that designers confuse entities with attributes and despite ER simplicity, users need methodological support to apply it. In (Antony, & Batra, 2002) is mentioned that novice designers express redundant relationships and it is proposed that the difficulties with relationships are related to their combinatorial semantics.In (Mcintyre, Pu, & Wolff, 1995) authors propose the use of an expert system (named RA) in the teaching of relational database design. Students used RA to produce relational database schemata from business forms and asked to compare this design procedure to the traditional (based on normalization theory) from the nontechnical end user point of view.…”

mentioning

confidence: 99%

Improving database design teaching in secondary education: action research implementation for documentation of didactic requirements and strategies

Fessakis

Dimitracopoulou

Komis

2005

Computers in Human Behavior

View full text Add to dashboard Cite

Database design and use has educational interest for utilitarian and learning reasons. Database technology has significant economic impact and the demand for database design can not be covered by the existent educated experts. Furthermore the database management systems available at schools could be used for the design and implementation of high quality learning activities. Databases are general purpose modeling environments that enable problem solving using conceptual frameworks closer to the solver and the problem than the machine architecture. Databases design introduction in the curricula of secondary education programs raises educational research questions. Research questions concern the didactics of the subject as well as the value of database design based learning activities. In this paper we present some of the more significant findings of an action research concerning the database design in secondary education. Research questions concern the ideas of students about databases and their difficulties during database design. Data, collected using a variety of research activities, are analyzed and discussed and teaching strategies are proposed. Keywords: Database modeling and design, Cognitive difficulties, Secondary Education IntroductionDatabase technology has significant economic impact. Labor statistics organizations predict that database management is likely to experience of the faster growth in jobs for the period 1998-2008(Antony & Batra, 2002. This is mainly because administration systems and many internet applications are based on databases. The increasing demand for database construction results on a significant percentage of databases developed by employees without formal related training. The data base design from uneducated people (e.g. end users) raises issues concerning effectiveness of the produced solutions (Batra, Hoffer, & Bostrom, 1990). The above facts state utilitarian reasons for large scale database design education.Furthermore Data Base Management Systems (DBMS's) as general purpose modeling environments (Hancock, & Kaput, 1990) are cognitive tools (Jonassen, 2000) that enable their users to exploit computational resources for problem solving providing conceptual frameworks closer to the user and the problem than the computer architecture. Databases represent the structural characteristics of physical systems. In contrast with other structural modeling techniques (e.g. conceptual maps), databases are interactive and executable models facilitating learning activities in * Corresponding author E-mail addresses: [gfesakis, adimitr]@rhodes.aegean.gr (Fessakis G., Dimitracopoulou A.), komis@upatras.gr (Komis V). of 3Tuesday , September 02, 2003Elsevier R e v i e w C o p y which the learner actively reflects his own perception of the physical system under study. Database design can be used for the development of learning activities consistent to modern learning theories and didactic approaches. The above observations combined with the wide availability of user friendly DBMS's at sc...

show abstract

“…Little research has been done on the specific demands of teaching database design. McIntyre et al (1995) developed a system in Prolog that functioned as a traditional expert system. It queried students about the parameters of the problem and helped them build a design.…”

Section: Literature Reviewmentioning

confidence: 99%

An Expert System Helps Students Learn Database Design

Post

Whisenand

2005

Decision Sci J Innov Edu

View full text Add to dashboard Cite

Teaching and learning database design is difficult for both instructors and students. Students need to solve many problems with feedback and corrections. A Web-based specialized expert system was created to enable students to create designs online and receive immediate feedback. An experiment testing the system shows that it significantly enhances student learning. The system also provides a more neutral learning environment in terms of personal factors such as gender and prior class work.

show abstract

Use of software tools in teaching relational database design

Cited by 4 publications

References 4 publications

Advances in database systems education: Methods, tools, curricula, and way forward

Advances in database systems education: Methods, tools, curricula, and way forward

Improving database design teaching in secondary education: action research implementation for documentation of didactic requirements and strategies

An Expert System Helps Students Learn Database Design

Contact Info

Product

Resources

About