Welcome to Design Guide
Design Article
. For a permanent link to this article, or to bookmark it for further reading, click here.
Web-designing and Databases
from: Jon St. George - Designs-By-Jon.comMost of the sites today use databases to organize and arrange their content which also allows users to register and leave comments. Even though databases are fairly commonly used, they are still not well understood. When you use a database on the internet for your website, you shouldn’t go for any database: you should go for concepts built up over decades of database development and proven effective. Here are some of helpful database ideas.
Relational Databases-These are easily the most common databases used now. Here, data is stored in tables. The columns are called fields and the rows are called records. A table can have two fields: firstname and lastname. Here the 'relational' part is in fact noteworthy, though, is when it comes to the way tables in a database relate to the other tables. Each record of each table has an ID number (theoretically known as the 'primary key') which then lets you refer to the record in a new table.
SQL Databases-SQL stands for 'Structured Query Language' and is the most popular language for making queries to relational database systems. A query is basically a way of asking the database to find a record for you that matches the criteria mentioned.
Learning SQL entirely can be complex but that difficulty is helped by the fact that you can have your way by knowing a very few SQL commands as you are unlikely to use many. Some of the common commands are:
CREATE- This command is used to create new database tables. You just tell the database the fields (columns) you want, and the type of data (text, dates, etc.) each field is going to contain.
SELECT- This command is used to search tables. You make use of operators like =, < and > to find the record you want.
INSERT- This command allows you to add new records to the table.
DELETE- This command removes existing rows from the table. This command uses similar syntax as used in the command ‘SELECT’.
Knowing the databases well would help you to sort out any problems, if any arises.
Design News
Droid X vs IPhone 4: Motorola defends Droid X antenna design - Khabrein
 MiamiHerald.com | Droid X vs IPhone 4: Motorola defends Droid X antenna design Khabrein iPhone 4 and Droid X comparison is getting longer with every passing day. Everyone wants to compare the two best mobile handsets that have hit the market in ... Motorola defends Droid X antenna design |
If Mad Men looks messy, it's by design - Winnipeg Free Press
If Mad Men looks messy, it's by design Winnipeg Free Press Yes, AMC has negotiated seamless tie-ins with Banana Republic (clothes), Design Within Reach (furniture) and Zippo (those cigarettes aren't lighting ... |
Dell Streak - CNET
 CNET | Dell Streak CNET The good: The Dell Streak offers an unprecedented combination of processor power, screen size, and design quality. Support for 3G, Wi-Fi, and Bluetooth hit ... |
Oklahoma Christian University's interior design program accredited - NewsOK.com
Oklahoma Christian University's interior design program accredited NewsOK.com The Council for Interior Design Accreditation has granted a six-year accreditation to the interior design program at Oklahoma Christian University. ... |
APTwater using Autodesk software to design clean water reactors - Trading Markets (press release)
 Centre Daily Times | APTwater using Autodesk software to design clean water reactors Trading Markets (press release) Autodesk Inc (Nasdaq: ADSK | PowerRating), a provider of design, engineering and entertainment software, announced yesterday that Californian water ... Autodesk Helps APTwater Increase Availability of Clean Water |
Money Approved for Design of Suicide Barrier on Golden Gate Bridge - New York Times
 AOL News | Money Approved for Design of Suicide Barrier on Golden Gate Bridge New York Times A Bay Area agency approved $5 million in federal money for the final engineering and design. The Metropolitan Transportation Commission, the agency that ... Funding OK'd for design of Golden Gate suicide net Decision On $5 Million For Golden Gate Bridge Suicide Net Design Expected Today MTC approves $5M for Golden Gate bridge suicide barrier |
A Window on Wilkes: Bainbridge School Board OKs School's New Design - Kitsap Sun
A Window on Wilkes: Bainbridge School Board OKs School's New Design Kitsap Sun The design for a new Wilkes Elementary School passed the Bainbridge school board's muster on Thursday, moving the project into the final planning stages ... |