Archive for database
You are browsing the archives of database.
When NOT to normalise the database
When talking of Database Normalisation, textbooks often talk of BCNF, fifth and higher normal forms. However, in practice (in large software/ERPs) I have rarely noticed normalisation beyond Third Normal form. In fact, there is a certain degree of redundancy that is desirable. While doing database design, I believe there are two critical aspects that should [...]
Generating sequential numbers in a database
You are creating an application that allows organisations to manage employees. One of the tasks that it has to do is generate an employee ID when a new employee is being entered. One way of doing this is through this query: SELECT max(empl_id)+1 FROM employee; However, this query presents a problem in a multiuser environment: [...]
Using SQL potential
How to use the database SQL to its full potential. The idea is to reduce procedural coding and thereby improve performance, reduce defects.
