Consulting support during conceptual database design in the presence of redundancy in requirements specifications: an empirical study

International Journal of Human Computer Studies

Volumn 54, Issue 1, 2001, Pages 25-51

  Batra, Dinesh ^a   Antony, Solomon R ^b  

^a FLORIDA INTERNATIONAL UNIVERSITY   (United States)

^b TEXAS TECH UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATA STRUCTURES; DATABASE SYSTEMS; ERROR CORRECTION; EXPERT SYSTEMS; HEURISTIC PROGRAMMING; REQUIREMENTS ENGINEERING; SPECIFICATIONS; USER INTERFACES;

CONCEPTUAL DATABASE DESIGN; CONSULTING SYSTEM; DATA MODELLING ERRORS; REQUIREMENTS SPECIFICATIONS;

HUMAN COMPUTER INTERACTION;

EID: 0035107784     PISSN: 10715819     EISSN: None     Source Type: Journal    
DOI: 10.1006/ijhc.2000.0406     Document Type: Article

References (54)

1. ANDERSON J. R., BOLE C. F., REISER. Intelligent Tutoring System. Science. 228:1985;456-462.
2. ANTONY S., BATRA D., SANTHANAM R. Empirical validation of knowledge-based systems for conceptual database design. Proceedings of the American Conference on Information Systems. 1999.
3. BATRA D., ANTONY S. Novice errors in database design. European Journal of Information Systems. 3:1994;57-69.
4. BATRA D., HOFFER J. A., BOSTROM R. P. Comparing representations with the relational and extended entity relationship models. Communications of the ACM. 33:1990;126-139.
5. BATRA D., SEIN M. Improving conceptual database design through feedback. International Journal of Man Machine Studies. 40:1994;653-676.
6. BATRA D., ZANAKIS S. H. A conceptual database design methodology based on Rules and Heuristics. European Journal of Information Systems. 3:1994;228-239.
7. BILLMAN D. Inductive learning of syntactic categories. 1983;University of Michigan.
8. BOCK D. B., RYAN T. Accuracy in modelling with extended entity relationship and object oriented data models. Journal of Database Management. 4:1993;30-39.
9. BOUZEGHOUB M., GARDARIN G., METAIS E. Database design tools: an expert system approach. PIROTTE A., VASSILIOU Y. Proceedings of the 11th International Conference on Very Large Databases. 1985;82-95 Morgan Kaufmann, San Mateo.
10. CARROLL J. M., KELLOGG W. A. Artifact as theory-nexus: Hermeneutics meets Theory-based Design. CHI Proceedings. 1989.
11. CHEN P. P. The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems. 1:1976;9-36.
12. CHOOBINEH J., KONSYNSKI B. R., MANNINO M. V., NUNAMAKER J. F. An Expert System based on forms. IEEE Transactions on Software Engineering. 14:1988;242-253.
13. CODD E. F. A relational model of data for large shared banks. Communications of the ACM. 13:1970;377-387.
14. COHEN J. A coefficient of agreement for nominal scales. Educational and Psychological Measurements. 1:1960;37-46.
15. DAVIS A. M. Software Requirements: Objects, Functions, and States. 1993;Prentice-Hall, Englewoods Cliffs.
16. DEMO B., TILLI M. Expert system functionalities for database design tools. SRIRAM D., ADEY R. Applications of Artificial Intelligence in Engineering Problems: Proceedings of the 1st International Conference. 1986;1073-1082 Springer-Verlag, Berlin.
17. DULLEA J., SONG I.-Y. An analysis of cardinality constraints in redundant relationships. Proceedings of the International Conference on Information and Knowledge Management, Las Vegas, Nevada, USA. 1997:1997;270-277.
18. EVANS J. Thinking and Reasoning: Psychological Approaches. 1983;Routledge and Kegan Paul, London.
19. FELDT L. S. A comparison of the precision of three experimental designs employing a concomitant variable. Psychometrika. 23:1958;335-354.
20. FITTS P. M. Perceptual-motor skill learning. MELTON A. W. Categories of Human Learning. 1964;243-285 Academic Press, New York.
21. HAMMER M., MCLEOD D. Database description with SDM: A semantic database model. ACM Transaction of Database Systems. 6:1981;351-386.
22. JARVENPAA S. L., MACHESKY J. J. Data analysis and learning: an experimental study of data modelling tools. International Journal of Man-Machine Studies. 31:1989;367-391.
23. JONES T. H., SONG I.-Y. Analysis of binary/termary cardinality combinations in entity-relationship modelling. Data and Knowledge Engineering. 19:1996;39-64.
24. JUHN S., NAUMANN J. D. The effectiveness of data representation characteristics on user validation. Proceedings of the 6th International Conference on Information Systems. 1985.
25. KAWAGUCHI A., TAOKA N., MIZOGUCHI R., YAMAGUCHI T., KAKUSHO O. An intelligent interview system for conceptual design of database. ECAI 1986: The 7th European Conference on Artificial Intelligence. 1986;. p. 1-7.
26. KIRK R. Experimental Design: Procedures for the Behavioral Sciences. 1995;Brooks/Cole Publishing Company, Pacific Groves.
27. KORTH H. F., SILBERSCHATZ A. Database research faces the information explosion. Communications of the ACM. 40:1997;139-142.
28. LORD R. G., MAHER K. J. Cognitive theory in industrial and organizational psychology. DUNNETTE M. D., HOUGH L. M. Handbook of Industrial and Organizational Psychology. 2:1991;Consulting Psychologists Press, Inc. Palo Alto.
29. MCFADDEN F. R., HOFFER J. A., PRESCOTT M. B. Modern Database Management. 1998;Addison Wesley, Reading.
30. MCFADDEN F. R., HOFFER J. A., SRINIVASAN A. A Casebook for Database Management. 1991;Benjamin/Cummings, Redwood City.
31. MAIER D. The Theory of Relational Databases. 1988;Computer Science Press, Rockville.
32. NORMAN D. A., BOBROW D. B. On data-limited and resources-limited processes. Cognitive Psychology. 7:1975;44-64.
33. RAM S. Deriving functional dependencies from the entity relationship model. Communications of the ACM. 38:1995;95-107.
34. RAM S., CURRAN S. M. An automated tool for relational database design. Information Systems. 14:1989;1989.
35. RASMUSSEN J. Information Processing and Human-Machine Interaction. 1986;North-Holland, Amsterdam.
36. REASON J. Human Error. 1990;Cambridge University Press, New York.
37. REINER D. Database design tools. BATINI C., CERI S., NAVATHE S. B. Conceptual Database Design: An Entity-Relationship Approach. 1992;Benjamin/Cummings, Redwood City.
38. ROUSE W. B. Models of human problem-solving: detection, diagnosis and compensation for complex engineering systems. Proceedings of IFAC Conference on Analysis, Design and Evaluation of Man-Machine Systems. 1981.
39. SCHEER A. W. Enterprise-wide Modelling: Information Systems in Industry. 1989;Springer-Verlag, Berlin.
40. SCHIFFMAN S. J., MEILE L. C., IGBARIA M. An examination of end user types. Information and Management. 22:1992;207-215.
41. SENDERS J. H., MORAY N. P. Human Error: Cause, Prediction, and Reduction. 1991;Lawrence Earlbaum Associates, Hillsdale.
42. SHOVAL P., SHIRAN S. Entity-relationship and object-oriented data modelling - an experimental comparison of design quality. Data and Knowledge Engineering. 21:1997;297-315.
43. SILVER M. S. Decision support systems: directed and non-directed change. Information Systems Research. 1:1990;47-70.
44. SONG I.-Y., JONES T. H., PARK E. K. Binary relationship imposition rules on ternary relationships in ER modelling. Proceedings of the Second International Conference on Information and Knowledge Management. 1993;. p. 57-66.
45. SRINIVASAN A., TE'ENI D. Modelling as constrained problem-solving: an empirical study of the data modelling process. Management Science. 41:1995;419-434.
46. STOREY V. C., GOLDSTEIN R. C. A methodology for creating user views in database design. ACM Transactions on Database Systems. 13:1988;305-338.
47. STOREY V. C., GOLDSTEIN R. C. Knowledge-based approaches to database design. MIS Quarterly. 17:1993;1-46.
48. STOREY V. C., THOMPSON B. B., RAM S. Understanding database design expertise. Data and Knowledge Engineering. 16:1995;97-124.
49. TAUZOVICH B. An expert system for conceptual data modelling. Proceedings of the 8th International Conference on the Entity-Relationship Approach. 1989;. p. 329-344.
50. TEOREY T. J, YANG D., FRY J. F. A logical design methodology for relational databases using the extended entity-relationship model. Computing Surveys. 18:1986;197-222.
51. TEOREY T. J. Database Modeling and Design: The Entity-Relationship Approach. 1990;Morgan Kaufmann, San Mateo.
52. TURBAN E. Expert Systems and Applied Artificial Intelligence. 1992;Macmillan Publishing, New York.
53. UML Notation Guide, 1997.
54. VESSEY I., CONGER S. A. Requirements specifications: learning object, process, and data methodologies. Communications of the ACM. 37:1994;102-113.