The end goal of database design is to be able to transform a logical data model ... Certain data types require a maximum length to be specified. For example, a character data type could be specified ...

Sample Database Diagram - SQL Server 7.0 Here is a sample E-commerce ... Whatever you do in your Products Table will have a distinct impact on the design of your Orders and OrderDetails tables.