ncoded contact information

website design services web design service online shops service optimisation and seo services graphical design servicese-commerce service search engines services graphic design services
nCoded: > Technical Tutorials > Web Design Tutorials

Archive for the ‘Web Design Tutorials’ Category

MySQL Databases, Normalization, ER Diagrams & Data Dictionaries

Posted by admin On May - 15 - 2009

When creating or modify databases and their tables, it is essential that you understand how the tables relate, or how you want them to relate. Normalization is the process whereby tables are optimised via referential integrity to remove duplication, redundancy, and errors.

Two key ways to represent the fields, tables, and relationships is via ER (Entity-Relationship) Diagrams and Data Dictionaries. The ER Diagram is just that; a diagram (similar to a UML Class or Object diagram) which shows the tables and their data fields, as well as the relationship between tables.

The Data Dictionary is listing of the formatting  used to create you tables - eg relationships are viewed as Primary and Foreign keys etc. All the tables and their fields and formatting, as well as the Table Relationshops are also fully documented.

The ER Diagram is useful for taking a High Level view of the overall database including Relationships, where as the Data Dictionary is Essentially as it gives you key specific data - such as the field type, size, length, etc.

  • Share/Save/Bookmark
Database Tutorials, Programming Tutorials, Web Design Tutorials

Google Chatback Live Support

Posted by admin On May - 15 - 2009

The following is taken from the Google Chat back page; As you can see the information is clear and intuitive.

A Google Talk chat back badge will let visitors to your web page chat with you. They’ll be able to chat with you whenever you’re signed in to Google Talk [under your Google Account log-in] For more information, visit the help center.

Each time you visit this page, we generate a new badge for you so you can use badges with different settings on different web pages. For example, you can share your status message on your personal blog and not on your public blog. To change a badge later, just return to this page and get a new one.

You just build a chatback widget (eg badge) and then display it on your website. When you logged into Google it will automatically establish a Live chat system via Google chat back (eg messagener)

Google Chatback Demo

The below is a real live demo (where we are always offline!)

  • Share/Save/Bookmark
Google Tutorials, Web Design Tutorials

Open Website Designs

Posted by admin On April - 22 - 2009

 

In the current economic downturn, for very small business, we would always advise that they use a pre-built open website design, as it not only lowers initial design and development costs, but also gives the client the chance to see their new website (90% of it) before any work begins.

If you have worked with small business then you will no doubt recognise the fact that initial designs can be a complete nightmare that never seems to end. One part the website design gets changed or evolved, and then often a few days or weeks later the client will ask if ‘we can try this or that’. By using an open design you essentially can get your client to sign-off (on the design) upfront leaving them to concentrate on content rather than design.

In most of the cases that we have worked with the client has been more than happy to keep the designers link in place, thereby shaving days of initial design and development time - which can be quite a substantial saving - up to 80% of project costs in some cases.

For those that are adamant that they do not want the designers link, then in a lot of cases we have worked on, the designer is more than happy for them to remove the link for a small fee.

In order to present and highlight the professional designs currently being released as Open Designs, we have now created a new website called: Open Websites - built using exactly the same technique - e.g. the customisation of an existing open website design.

We hope to work with some of the providers of these designs in order to make the process of either employing the designer to customise the design further, or to remove the designer’s link, a much easier affair.

  • Share/Save/Bookmark
Web Design Tutorials
Website & E-Commerce Solutions


nCoded Website, IP & Content © 2003 - 2009 nCoded - All Rights Reserved - No part of this website may be reproduced without permission.