Database Design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
max,

put these fields in a table named "exampleTitles".
Title
Subtitle
Place of publication
Year of publication
Number of sites
Click to expand...
*make the Title field the primary key

put these fields in a new table named "Keywords"
Title
Keywords
Click to expand...
don't set a primary key


put these tables in a new table named "authors"
Authors
Title
Click to expand...
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 (e-mail address removed)
 
Access .... aggghhhh!!! :-)

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

***************************
Think Outside the Box!
***************************
 
Answered in the SQL Server Programming group.

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

***************************
Think Outside the Box!
***************************
 
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.
 
Back
Top