MySQL:Hire Co:DDL:Business

Sales, Hire and Repair Company - Creating the Business table (DDL)
When reports and forms are created for a database it is usual that they include the name of the business and other relevant details such as, their address, phone, and web site. If we 'Hard Code' these onto the form it makes it difficult to adapt the system for another company. For example, all the forms and reports will need to be modified to the new business.

This process can be greatly simplified by putting the business details into their own one record table. Reports and forms will use this data to display the business name, and should the application be 'on-sold' to another company, just updating the data in this table will automatically change all the forms and reports. This is one important distinction between a 'custom' made solution and one that can be sold 'off-the-shelf'.

Create the database and table and add some data
Create the following text file and call it HireBus.sql

Now run this script in MySQL