Database Logo

Click the database icon (or any heading) to toggle the website's paragraphs & images!


About Databases

What is a database and what is it used for?

Just what is a database? A database is a set of organised data.

Why, When and How can Database Design Solutions help you?

By the way, we're dedicated not only to building databases but also to solving all manner of IT problems!

Why Database Design Solutions?

 

What is a User Interface?

You may have heard of Microsoft Access, which has been used in the IT industry since 1992.

Microsoft Access logo

Feel free to take a look at the following switchboard designs from these previous projects from D.D. Solutions: simply click the logos to open full-sized images of their respective switchboards.

Grove Securities Database Switchboard

Grove Logo

Great Bay Marina Database Switchboard

Great Bay Logo

Wakes Music DB Switchboard

Wakes Music Logo

 

Development Software

Just so you can see how things are done, we use the following development software in our work at D.D.S.:

Access 2016

MS Access 2016

Excel 2016

Excel 2016

Access 2016 in action (WakesMusicDB)

MS Access 2016: WakesMusicDB

Access 2016 VBA coding in action

MS Access 2016: VBA coding

MySQL console

MySQL console

MySQL Workbench

MySQL Workbench

SQL Server

MS SQL Server

MS Visual Studio 2017

MS Visual Studio 2017

 

And now, it's your call...

Have a think about what you now know about databases. Could it save you time and money and/or increase productivity to implement one in your business as so many others, from tiny to gigantic, have done to good effect? Could it help maximise the efficiency of your business instead of using Microsoft Excel spreadsheets or some dog-eared notebook? Or do you already have a database system in place and feel that it could use an upgrade, such as integration into your web service?

If you feel that you could utilise D.D. Solutions' IT services, please contact me at this email address or via mobile phone at 0421 028 606.

 

Even More Information...

Finally, here's some information that seemed out of place in the main flow of this page and would seem to only fit properly in a footer area... for those who are interested in learning more about these fields of IT:

SQL and RDBMSes

A relational database is different from a flat-file database in that a relational database contains several or many tables containing data which is linked to other data in various ways. Microsoft Access is just one example of an RDBMS (relational database management system). Others include Oracle's MySQL (and its open-source fork MariaDB), Oracle's own proprietary RDBMS of the same name, Microsoft's SQL Server and its Transact-SQL or T-SQL form of SQL, PostgreSQL, and others.

SQL stands for Structured Query Language, which basically refers to the power of a relational database management system to run queries on data and bring forth the results that you need. For example, you may have a database of James Bond movies which you want to access in order to find out all the villians who starred in the Bond movie GoldenEye. Microsoft Access allows you to do this with a Query Wizard, whereas SQL language allows you to do this via the command line. Here is the result of the query in PostgreSQL:

Query on Villains in the Bond movie GoldenEye



James Bond query

SQL and the web have long been connected, and it is not unusual to see database driven websites using a combination of MySQL and PHP or some other server-side programming language.

Design Principles

Microsoft Access allows you to enter data into records where it will be stored for later retrieval. Similarly, other database programs, as in the PostgreSQL example above, allow you to examine data more or less however you like or are capable of.

Entering commands into a console is the way in which to create a database from the data provided, although you can load SQL scripts in programs like pgAdmin and MySQL Workbench. It is necessary to have a clear idea of the structure of the database before creating it, and to speed things up, one may use an Excel spreadsheet to format the data before entering it into the database.

Aside from a user interface (which is often a luxury that is dispensed with in larger solutions), generally behind every great database the following steps are taken and the following components included:

 

Prior Creations

In addition to the MS Access databases I have showcased above, I would like to present my Certificate III and IV revision websites, which are packed with information on all things IT:

Like this on Facebook: Database Design Solutions