2014•Unpublished venueRequires access

Doing database design with MySQL

Jerzy Letkowski

Abstract

Most of the database textbooks, targeting database design and implementation for information systems curricula support the big database systems (Oracle, MS SQL Server, DB/2, etc.). With respect to the most important aspects of the database management: design and implementation; one should not ignore MySQL—the most widely used, open source, relational database management system developed in Sweden in 1995 and now owned by Oracle Corporation. This paper shows two database-design learning cases. The first one deals with a forward-engineering technique used to transform a data model into a physical database. The second case shows how to reverse-engineer an existing database into a data model. Both the cases utilize MySQL Workbench and MySQL Community Server. By contrast Microsoft Access can only reverse engineer a physical database into its relationship diagram.

About this research paper

What this paper is about

Why it matters

OpenAlex reports 39 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Database design, Physical data model, Computer science, Database, Database server, Oracle, Database model, Database testing