Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Please review db design

Author  Topic  PGG_CA Starting Member 24 Posts Posted - 2006-02-24 : 16:47:51 I've been given an Access database that I need to migrate to SQL Server, but the database is not properly designed. I know the importance of good db design, so I ventured on designing it before I do the migration. Please critique the design and let me know how I can improve it. Access DB Features table Fields: ID BookTitle AuthorName AgeGroup Genre isCanadian Here are the rules. The book can have several authors, can be used by one and only one age group and can belong to several genres. Here's my design: Author table author_id lastname firstname Book table book_id book_title iscanadian? group_id Genre table genre_id genre_type Author_Book table author_id book_id Book_Genre table book_id genre_id Age_group table group_id group_description