O'Reilly logo

iReport 3.7 by Shamsuddin Ahammad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. A Sample Database

We have used a MySQL database as the data source for our various reports. In this appendix, we will learn about:

  • The design of the database
  • Installing MySQL
  • Configuring a MySQL server
  • Creating a database and tables in MySQL using MySQL GUI tools
  • Backing up and restoring database

Designing the database

Before developing the database in MySQL or any other database management system, we need to design the database properly. Database designing includes identifying the entities or tables, attributes, constraints, and the relationships among the entities. We are going to design and develop a database for monitoring the sales, purchase, and stock of products. It's an inventory management database.

List of entities

The list of entities ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required