Database Design

[max]

Hello,

I am not so experienced in database design and in my job now I have to
design a database for publications. The problem is the design should be
worked out as soon as possible.:( The publication database should contain the
following details:

Title
Subtitle
Authors
Place of publication
Year of publication
Number of sites
Keywords

There could be several authors and several keywords.

Could anybody tell me a good design for this attributes and what database
will be fit best?

thanks in advance

lg
max

[Brian Underhill via DotNetMonster.com]

max,

put these fields in a table named "exampleTitles".

Title
Subtitle
Place of publication
Year of publication
Number of sites *make the Title field the primary key

put these fields in a new table named "Keywords"Title
Keywords don't set a primary key
put these tables in a new table named "authors"Authors
Title

don't set a primary key

Now, (using MS ACCESS you would right click the tables list and select the
relationships. Then add all three tables. Then Drag the Title field for the
Titles table and drop it on the Title field in each of the other tables. It
will bring up a dialog box that asks if the relation ship is correct. It
should be ONE-To-Many. the 1 will appear on the titles table and an infinity
sign will appear on each of the other table relationships.)
this is a relational database. I have the example I could send you....just e-
mail me at BU****@aol.com

[Cowboy (Gregory A. Beamer) - MVP]

Access .... aggghhhh!!! :-)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Brian Underhill via DotNetMonster.com" wrote:

max,

put these fields in a table named "exampleTitles".

Title
Subtitle
Place of publication
Year of publication
Number of sites

*make the Title field the primary key

put these fields in a new table named "Keywords"

Title
Keywords

don't set a primary key
put these tables in a new table named "authors"

Authors
Title

don't set a primary key

Now, (using MS ACCESS you would right click the tables list and select the
relationships. Then add all three tables. Then Drag the Title field for the
Titles table and drop it on the Title field in each of the other tables. It
will bring up a dialog box that asks if the relation ship is correct. It
should be ONE-To-Many. the 1 will appear on the titles table and an infinity
sign will appear on each of the other table relationships.)
this is a relational database. I have the example I could send you....just e-
mail me at BU****@aol.com

[Cowboy (Gregory A. Beamer) - MVP]

Answered in the SQL Server Programming group.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"max" wrote:

Hello,

I am not so experienced in database design and in my job now I have to
design a database for publications. The problem is the design should be
worked out as soon as possible.:( The publication database should contain the
following details:

Title
Subtitle
Authors
Place of publication
Year of publication
Number of sites
Keywords

There could be several authors and several keywords.

Could anybody tell me a good design for this attributes and what database
will be fit best?

thanks in advance

lg
max

[clintonG]

You can learn a lot by studying the models made available at DatbaseAnswers
[1]

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

[1] http://www.databaseanswers.com/
"max" <ma*@discussions.microsoft.com> wrote in message
news:67**********************************@microsof t.com...

Hello,

I am not so experienced in database design and in my job now I have to
design a database for publications. The problem is the design should be
worked out as soon as possible.:( The publication database should contain
the
following details:

Title
Subtitle
Authors
Place of publication
Year of publication
Number of sites
Keywords

There could be several authors and several keywords.

Could anybody tell me a good design for this attributes and what database
will be fit best?

thanks in advance

lg
max

[Nick Malik [Microsoft]]

is this homework?

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"max" <ma*@discussions.microsoft.com> wrote in message
news:67**********************************@microsof t.com...

Hello,

I am not so experienced in database design and in my job now I have to
design a database for publications. The problem is the design should be
worked out as soon as possible.:( The publication database should contain
the
following details:

Title
Subtitle
Authors
Place of publication
Year of publication
Number of sites
Keywords

There could be several authors and several keywords.

Could anybody tell me a good design for this attributes and what database
will be fit best?

thanks in advance

lg
max