Software and Web Application
Design and Development

Home > Database Design and Development

Web Application Development

Basic Web Design and CSS

CSS With a Fixed Layout CSS With a Flexible Layout CSS With a Flexible Fixed Layout Using a Table For Layout Advanced CSS Mobile Devices

Building Interactive Web Pages

Client Side Scripting Using the DOM Server Side Scripting

Site Management and Performance

Planning and Monitoring Open Source Options Security and Privacy Improving Reliability

Software Application Development

UML Modeling Object Oriented Design Distributed Systems

Databases

Database Design and Development

External Links

World Wide Web Consortium W3C HTML Validation CSS Validation WebXACT Accessibility Guidelines Jakob Nielsen's Usability Guidelines

Example Pages

Accessibility Through CSS Client Side Scripting Using Javascript Server Side Scripting Using PHP

Database Design

Efficient databases are built upon a well-planned database schema. Relationships between entities need to be accurately represented and techniques such as Normaliization utilized to elimate duplication as far as possible.

Duplication can lead to a loss of data integrity and complicate maintenance.

Other issues to be considered include data security, encryption and transaction management, while the intelligent construction of SQL queries and the effective use Views can greatly improve database efficiency.

Example of a database entity diagram from a Hospital Database
Contact Details: Mark Kenyon
email: mk@abc.com