Database Design Features

The physical programming of a database requires programming individual database design features.

Below is a list of common components that must or may be programmed to build a database.

 

Database Tables

Fields

Tables

Import / Export / Link Tables

Tables Key Relationships

primary keys

foreign keys

one-to-many

many-to-one

one-to-one

many-to-many

must or may

Referential Integrity

 

Database Queries

Select Query

Crosstab Query

Parameter Query

Union Query

Append Query

Update Query

Make Table Query

Delete Query

SQL Query

Calculated Fields

Filters

Indexes

 

Database Forms

Forms Format

Forms based on tables, queries, or junction-tables

Subforms

Calculated Form Fields

Form Field Filters

Form Command Buttons

Form Control Tips

Form Input Masks

Input Validation Rules

Form Lookup Fields

Form Value Lists

 

Database Graphs

Visual Graphs or Charts

 

Database Reports

Report Format

Report with Subform Report

Report on unique Parameter Search

Report on unique Parameter Value

 

Database Security

Encryption

Password Protection

 

Database Switchboard

Switchboard Form

Switchboard Controls

 

Database Online

Database Splitting

Static Web Pages

Active Web Pages

Data Entry Form Web Pages

Database Queries Online

Database Transactions Online

Database Security Online

 

CLIENT REFERENCES

Goodman Fielder Ltd

Insurance Resources Ltd

 

 

 

 

 

Database Development Services

Database Programming

Database Customisation

Database Integration with other Systems, Databases, Spreadsheets, Text Files, and or Application Software, and or Enterprise Information Systems (i.e. SAP).

Programming of Database Reports

Database Macro and Stored-Procedures Programming

Development of Database Visual User Interfaces

Documentation, User Manuals, Management and User Policies and Procedures

We use Visual Basic 6, Visual Studio 2008, and Visual Express 2008 as the development tools of choice.

We can program databases using:

We can 'wrap' databases into stand-alone software applications, that can be run on almost operating platforms.

For SAP development we recommend:

KleinStar SAP Consulting

 

Database Prototypes
 
Sales Reports Database
Sales Reports Database
This database 'reports' only, it is linked to spreadsheets that contain dozens of columns and hundreds of thousands of records in rows. The database links to the SAP produced spreadsheets and contains 32 queries that produce 204 unique reports based on the linked spreadsheet data.  
The spreadsheets are updated in real-time through SAP, and the database is reflecting the changes and / or added records in its sales reports which are 'real-time' or 'live' reports. The system allows for easy archiving of reports through one-click button driven report export functions, as well as report previews.
 
 
Stock & Debtors Database
Stock & Debtors Database
This 'relational' database captures data, stores all data records and produces reports. Integrated Stock and Debtors System with Stock Management, Customer Order Entry, Inventory Control, Stock Level and Credit Tracking.
The database includes standard and advanced queries, forms and reports, accessible through a main menu switchboard.  
 
   
Membership Database  
Membership Database  
This Membership Database keeps track of members contact details, income sources, details of dependants, services required, money pledges, and advertising channels.  
   
 

 

Intellia Ltd

CONTACT FORM

Your Organization

Your Position

Your Name

Your E-Mail

SUBJECT:

YOUR MESSAGE:

 

 

 

 

 

 

 

Database Development

see also | Database Management |

Database design is the process of producing a detailed data model of a database. Database development is the physical construction of the database, according to design specifications. We design and develop databases based on client needs.

Before an existing database can be developed further, or a new database can be designed, - the business needs, and the data to be stored in the database must be determined in cooperation with a person who does have expertise in that domain, and who is highly aware of business operations, and what data must be stored within the system and what information and reporting needs the business or organization has.

This process is one which is generally considered part of requirements analysis, and requires skill on the part of the database designer to elicit the needed information from those with the domain knowledge (expert knowledge)..

When the requirements specifications have been documented, the data model for the database design is drawn up. This process is part of the information engineering, and software modelling process before the database can be physically programmed.

This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database.

 

Database Development

Database development is the physical programming of a database based on the requirements specifications that derived from a business analysis.

Databases can be programmed using a variety of database programming languages and tools.

We can develop databases, and database-centric software solutions to suit your requirements.

The first step in the development process, is to fully engage with you and your company to produce a detailed and quality assured requirements document. We will then model a system that will fulfill these requirements using Microsoft Visio as the tool of choice for the logical diagramming of the proposed system.

The next step is to build a physical prototype of the database using either the Microsoft Database development route, or an Oracle Database as the development tool of choice.

The prototype may then be changed, refined, or extended to fit the clients requirements more closely. It is quite common that new requirements emerge once the client has the opportunity to use the initial prototype. By that stage the client will be more fully aware of what can programmatically and technically be done, the client through interaction with our business analyst / programmer will have become more aware of what other requirements may be worthwhile incorporating in the new database.

We are familiar with with the different software development life cycle methodologies, and know the strengths and weaknesses of each development process. It is our task to make you realize the potential in your information, to help you identify and take advantage of opportunities that will maximize the effectiveness of a new system and benefits to your business, while eliminating any risks and threats that a new system and your business may be facing.

 
Development Tools: Programming Environments
       
ACCESS 2007.jpg
    Microsoft Database Development
    Microsoft Access 2007: office.microsoft.com/access
net logo.jpg
    Microsoft .NET www.microsoft.com/net
asp_net_logo_small.gif
    Microsoft ASP.NET www.asp.net
       
toolkit_visio.jpg
    Microsoft Database Modelling
    Microsoft Visio 2007: office.microsoft.com/visio
       
visual studio.jpg
    Windows Application Development
    Microsoft Visual Studio
www.microsoft.com/express
       
OracleDatabaseLogo.jpg
    Oracle Database Development
    Oracle Database: www.oracle.com/database
       
 
 
Download Free Sample Database Stock and Debtors
Stock and Debtors Database   Download >>
 
 
Download Free Database Documentation Templates
Data Dictionary Catalogue Template   Download >>
Data Dictionary Data Element Template   Download >>
Data Normalisation Template   Download >>
Data Store Template   Download >>
Data Structure Template   Download >>
Systems Outline Template   Download >>
Program Specifications Template   Download >>
Work Scope (Context Diagram) Sample   View Sample >>
Business Event Use CaseTemplate   Download >>
Product Use Case (Scenario) Template   Download >>
Activity Diagram (Use Case) Sample   View Sample >>
Requirements Shell Template   Download >>
Business Rules Template   Download >>
Non Functional Requirements Template   Download >>
Entity Relationship Diagram Sample   View Sample >>
Data Flow Diagram Sample   View Sample >>
Pseudo Code Dictionary Template   Download >>
     
 
Database Software for Purchase

The database titles listed below are available on CD-Rom that will be mailed to you. The CD-Rom contains the database, that must be installed using the setup.exe file provided. All our software applications are stand-alone applications that can be run on all microsoft windows platforms (95, 98, 2000, XP, Vista). * If required, we can convert the applications for you into Oracle *SQL.

We can also deliver these applications as internet-ready databases, to provide your website with e-commerce capabilities.

We are always happy to customize and develop all of our applications to suit your businesses individual goals.

 
 
Database Software Titles
  Sales and Invoice System Price $40.00 301px-Compact_disc_svg.png Security and Patrol System Price $40.00 301px-Compact_disc_svg.png
         
  Treatment, Repairs and Maintenance System Price $40.00 301px-Compact_disc_svg.png Club and Members Database Price $20.00 301px-Compact_disc_svg.png
         
  Sales Order Shipping System Price $40.00 301px-Compact_disc_svg.png Subscription System Price $30.00 301px-Compact_disc_svg.png
         
  Indent Order System Price $40.00 301px-Compact_disc_svg.png Mail Order Sales System Price $40.00 301px-Compact_disc_svg.png
         
  Time Sheet System Price $30.00 301px-Compact_disc_svg.png Cost-Profit System Price $40.00 301px-Compact_disc_svg.png
         
  Resources and Rations System Price $30.00 301px-Compact_disc_svg.png Accounts Payable System Price $40.00 301px-Compact_disc_svg.png
         
  Performance Score System Price $20.00 301px-Compact_disc_svg.png Accounts Receivable System Price $40.00 301px-Compact_disc_svg.png
         
  Sales Management System Price $40.00 301px-Compact_disc_svg.png Consulting Invoice System Price $30.00 301px-Compact_disc_svg.png
         
  Stock and Sales System Price $40.00 301px-Compact_disc_svg.png Claims and Expenses System Price $10.00 301px-Compact_disc_svg.png
         
  Trade Services System Price $40.00 301px-Compact_disc_svg.png Production Decision and Control System Price $50.00 301px-Compact_disc_svg.png
         
  Library Borrowing System Price $20.00 301px-Compact_disc_svg.png Owner and Real Estate System Price $30.00 301px-Compact_disc_svg.png
         
  Club and Member System with Sales Invoicing Price $40.00 301px-Compact_disc_svg.png Payroll, Wages and Salaries System Price $40.00 301px-Compact_disc_svg.png
         
  Weighted Criteria Decision System Price $25.00 301px-Compact_disc_svg.png    
         
         
  Top of Page     To enquire about our database software products e-mail: databases@intellia.co.nz