REINFORCING DATABASE CONCEPTS BY USING ENTITY RELATIONSHIPS DIAGRAMS (ERD) AND NORMALIZATION TOGETHER FOR DESIGNING ROBUST DATABASES

2017 Issues in Information Systems  
Most books on Accounting Information Systems include chapters on Entity relationship diagrams (ERD) and on normalization of databases. These concepts have to be taught within a framework on topics that include Enterprise Systems, E-business, and Internal Controls. This paper discusses how the concepts of ERD and normalization were introduced and used together to design a database in a graduate-level accounting information class at a southeastern university. The course made use of Oracle's Data
more » ... e of Oracle's Data Modeler for ER diagrams and Microsoft Access for normalization to streamline and reduce the drudgery involved in the process. The learning was significantly better with this approach than the approach in which these concepts were taught in isolation.
doi:10.48009/1_iis_2017_148-155 fatcat:tyvup3fzevcahkntanumxgcvmm