Teaching Database Design and the Importance of Integrity
Teaching Database Design and the Importance of Integrity
Author(s): Peter PeinlSubject(s): Social Sciences, Education, Library and Information Science, Information Architecture, Electronic information storage and retrieval, Education and training, Other, Higher Education
Published by: Нов български университет
Keywords: Database; design; integrity; abstraction
Summary/Abstract: The costs to correct mistakes made in the early phases of database projects often rise exponentially with the number of phases between detection and correction. Therefore an adequate preparation of beginners as part of their university education, practically and conceptually, is able to avoid many mistakes. This paper outlines a systematic classroom approach to guide through the design of a database including faithful, rule based translation into an equivalent relational schema and its implementation using the SQL language. Experiences from teaching that course in a real classroom are compared to those made in spring/summer 2020, when the course had to be taught in a virtual classroom because of the Corona pandemic.
Journal: Computer Science and Education in Computer Science
- Issue Year: 16/2020
- Issue No: 1
- Page Range: 29-37
- Page Count: 9
- Language: English