Re: How you would design the DB structure?

>
> How you would design the DB structure?
>
> kmku_at_hkusua.hku.hk (Ku Kam Ming)
> Tue, 12 Mar 1996 03:56:51 GMT
> The University of Hong Kong
>
> Newsgroups:
> comp.databases.oracle
>
> If I need a DB to record info. of books, and the fields are:
> 1) title and
> 2) authors
> There is one title per book (record) but there may be many authors per
 book.
> So, what is the BEST solution to design the sturcture of DB:
> A) the no. of char. of author field set to a very large number, say
 10000
> B) create fields, author1, author2, .... author100 such that each
 field
> store one author name.
> Thanks in advance,

Trying to resurrect my rudimentary logical modeling skills yielded something like:

 Book                   Book_Author              Author
-----------------      -----------------      -------------------
| Book_uniq_key |      |Book_uniq_key  |      | Author_uniq_key |
|---------------|      |Author_uniq_key|      |-----------------|
| Title         |----->|---------------|<-----| Author_name     |
| etc.          |      |               |      | etc.            |
|               |      |               |      |                 |
-----------------      -----------------      -------------------
  

HTH!

    _/_/_/_/_/ _/_/_/_/    _/_/_/_/       //  John R. Call
       _/     _/     _/   _/     _/      //  The Boeing Company
      _/     _/_/_/_/    _/             //  Wichita, Kansas 
_/   _/     _/    _/     _/     _/     //  b540jc_at_wbv1.sna.ks.boeing.com
_/_/_/ _/  _/      _/ _/ _/_/_/_/ _/  //  These are my opinions only...