Posted on in Programming
The widespread use of computers has made database interaction a daily occurrence. Although databases can be large and complex, they are generally defined by basic terms that come together to create the larger system. Understanding these database basics helps users understand the underlying structure of the system and how they …
Posted on in Programming
Modern programs are not developed as singular, autonomous applications. Programmers have learned that many different programs use the same routines over and over again. By developing these routines as independent modules or libraries, programmers gain the advantage of quickly adding functionality to their programs. Modularization allows the detail of often-repeated …
Posted on in Programming
In his excellent series on WordPress Theme SEO, Nathan Rice describes a method to include META tags in WordPress themes rather than relying on plugins. Since I recently updated the Slaptijack theme to include META descriptions and keywords, I thought I would detail the process. If you are interested in …
Posted on in Programming
Decision structures (also known as selection structures) are used in programming to take an action based on the result of a question (Farrell, 2008). An if-then-else statement is the most basic kind of decision structure. The question is represented as a Boolean expression that results in a true or false …
Posted on in Programming
Referential integrity and business rules are two subjects that individuals new to database design find confusing. Relational databases use tables to represent things and events. It is often necessary for a table to refer to another table. In this case, the two tables have a relationship. Referential integrity ensures that …
Posted on in Programming
For those not acquainted with the vernacular of relational databases, many frequently used terms can be hard to grasp. These terms are often difficult to comprehend, but the concepts they describe can be illustrated in plain English. When a database administrator or developer is working with someone not fluent in …
Posted on in Programming
When planning for a new application, all organizations are faced with deciding whether to develop the application in-house or purchasing an off-the-shelf software package. Developing the application in-house has the benefit of ensuring the application is custom-fit to the organization's needs. Unfortunately, this custom-fit may result in an application that …
Posted on in Programming
Like many other kinds of businesses, a landscaping business needs a billing system.
As is often the case, billing systems require an incredible level of customization
thanks to the various intricacies of most companies' pricing structures. Designing
a billing system to fit the specific needs of an individual organization is …
Posted on in Programming
A database is a collection of files used by an organization in support of its daily operations. The files in a database are commonly called tables because their data is organized into rows and columns. Databases allow for easy storage and retrieval of the data kept within the files that …
Posted on in Programming
Before a programmer can sit down and create a new application, she must understand the nature of the problem the application is designed to solve. Programming projects often begin with a relatively simple problem. These simply stated problems often mask a much more complicated issue. Rarely do programmers create applications …
