This is the first installment in an explanation of Database Design for Ultradev E-commerce application developers. It's based on my database experience (and all the mistakes I made along the way) with ...

Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...

A proper database design cannot be thrown together quickly by novices. A practiced and formal approach to gathering data requirements and modeling data is mandatory. This modeling effort requires a ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema.

Instead, you should use ANSI SQL, which is a platform-independent database language. Whenprogramming for DBMS independence, not all systems fully support the ANSI SQL standard.

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...