|
Even the simplest
relational database system depends on a sound theoretical basis in
relational algebra. Codex uses a structured and phased design methodology
for analysing, modelling and documenting a set of requirements for
every database development.
Our structured approach always involves working interactively with
the commissioning client and their users. We employ a data-driven
approach in which concepts of data (and data flow) are first modelled
diagrammatically to facilitate communication about the client's information
requirements and ensure that each user's perspective of the data is
fully understood. Conceptual data modelling is followed by logical
data design using established normalisation techniques to minimise
data redundancy and data anomalies.
Physical database development is tailored to specific proprietary
database products. Codex has experience of database development using
high-level tools provided with off-the-shelf relational database products
from leading manufacturers. In addition, we can perform low-level
development using a combination of SQL-compliant database engines,
APIs and a range of programming languages.
We can advise in the particular performance and security requirements
made by hosting online databases and the provision of dynamic Web
content. We have experience of working with Web server scripting engines
and SQL database servers, and specialise in the popular high-performance
combination of PHP and MySQL.
|
|
| Database
Design |
 |
Requirements
analysis |
|
Entity-relationship
modelling |
|
Normalisation |
|
Resource discovery
metadata |
| |
|
| Desktop
Database Development |
|
ANSI standard
SQL and variants |
|
SQL-compliant
databases (MS Access with VBA coding, MySQL, Oracle) |
|
SQL-compliant
database engines and APIs (MS Jet, Borland BDE, ODBC, JDBC,
ADO, ADO.NET) |
|
Procedural
programming languages (C, Pascal and Cobol) |
|
Object-based
programming languages (VB and VBA) |
|
Object-oriented
programming languages (Java, C#, VB.NET and Delphi) |
| |
|
| Web Database
Development |
|
Server scripting
languages (PHP and Perl) |
|
SQL database
servers (MySQL and Oracle) |
|
|
