Database Design

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

re: Database Design

max,

put these fields in a table named "exampleTitles".[color=blue]
>Title
>Subtitle
>Place of publication
>Year of publication
>Number of sites[/color]
*make the Title field the primary key

put these fields in a new table named "Keywords"[color=blue]
>Title
>Keywords[/color]
don't set a primary key


put these tables in a new table named "authors"[color=blue]
>Authors
>Title[/color]
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 BU2002@aol.com

re: Database Design

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

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

***************************
Think Outside the Box!
***************************


"Brian Underhill via DotNetMonster.com" wrote:
[color=blue]
> max,
>
> put these fields in a table named "exampleTitles".[color=green]
> >Title
> >Subtitle
> >Place of publication
> >Year of publication
> >Number of sites[/color]
> *make the Title field the primary key
>
> put these fields in a new table named "Keywords"[color=green]
> >Title
> >Keywords[/color]
> don't set a primary key
>
>
> put these tables in a new table named "authors"[color=green]
> >Authors
> >Title[/color]
> 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 BU2002@aol.com
>[/color]

re: Database Design

Answered in the SQL Server Programming group.

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

***************************
Think Outside the Box!
***************************


"max" wrote:
[color=blue]
> 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[/color]

re: Database Design

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" <max@discussions.microsoft.com> wrote in message
news:6789027D-E3E2-4EEC-8A11-B244E3F96394@microsoft.com...[color=blue]
> 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[/color]

re: Database Design

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" <max@discussions.microsoft.com> wrote in message
news:6789027D-E3E2-4EEC-8A11-B244E3F96394@microsoft.com...[color=blue]
> 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[/color]