Posted by Erland Sommarskog on 02/23/06 00:47

Shwetabh (shwetabhgoel@gmail.com) writes:
> I am working on a software to manage the labelling database. The DBASE
> IV database tables are to be converted to MS SQL server database. Each
> table consists of around 45 to 60 records.There is only one field which
> is common in all tables and is unique. I will be using that field as
> the primary key. Would I be wrong if I create a database in SQL and add
> all DBASE IV tables according to the names of the files they are stored
> in?
> I can send you the sample database if needed.
>
> As for extensibility, since the database will be stored in seperate
> tables in SQL server database, I think there should be no problem. Am I
> correct in my assumption?

As David said, with those volumes there is no reason to consider a "smart"
design for performance. As I said, focus on maintainability and
extensibility. And ease of development. That may be a single-table
design, but most likely it's a more normalised design.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]