Writes
This presentation is the property of its rightful owner.
Sponsored Links
1 / 2

Book Book ID (PK) Book Desc PowerPoint PPT Presentation


  • 44 Views
  • Uploaded on
  • Presentation posted in: General

Writes.

Download Presentation

Book Book ID (PK) Book Desc

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Book book id pk book desc

Writes

  • A.BadMouth Press works with several different authors who write the books it publishes. Some authors have written only one book, while others have written many; also, some books are co-author by multiple authors. BadMouth also works with multiple printers; each book, though, is printed by only one printer. An editor at BadMouth Press works with several authors at a time, editing and producing their book projects; it is the editor's job to turn over the final camera-ready copy to the printer when the manuscript has been copy edited and typeset.

1. Identify the entities

Editor

Editor ID (PK) Editor Name

Editor Addr e

Author

Author ID (PK)

Author Name

Author Addr

Book

Book ID (PK)

Book Desc

Printer

Printer ID (PK)

Printer Name

Writes

1. Review Relationships

Books writtten by many authors

Books only have one printer

Editors work for multiple authors

Author/Book

Auth-book (PK)

Author ID(FK)

Book ID (FK)

Author

Author ID (PK)

Author Name

Author Addr

Book

Book ID (PK)

Book Desc

Printer ID(FK)

Written

Has editting

Prints

Printed By

Editor

Editor ID (PK) Editor Name

Editor Addr

Editor/Author

Edit-auth (PK)

Editor ID(FK)

Author ID (FK)

Printer

Printer ID (PK)

Printer Name

Edits


Book book id pk book desc

Flight

Flight ID (PK)

Flight date

Crew

Crew ID (PK) Crew Name

Crew Addr

Pilot

Pilot ID (PK)

Pilot Name

Airplane

Airplane ID (PK)

Airplane type

  • A.SkyHigh Airlines has three major resources: airplanes, pilots, and crew members. Pilots and crew members have respective home bases, which they return at the end of an assigned flight. A flight must have at least one pilot and one or more crew members attached to an airplane. Each airplane has a maintenance base.

1. Identify the entities

Home Base

Home Base ID (PK) Home Base Place

Main Base

Main Base ID (PK)

Main Base place

2. When there is a 1-1 relationship no association table is necessary

Resides

Pilot

Pilot ID (PK)

Pilot Name

Home Base (FK)

Flight

Flight ID (PK)

Flight date

Main Base

Main Base ID (PK)

Main Base place

Home Base

HmeBaseID (PK)

Home Base Place

Planned

Flys

Resides

Resides

Flight

Flight info(PK)

Flight Id (FK)

Crew ID (FK)

Pilot ID(FK)

Airplane ID (FK)

Crew

Crew ID (PK) Crew Name

Crew Addr

Home Base(FK)

Flys

Airplane

Airplane ID (PK)

Airplane type

Main Base(FK)

Scheduled


  • Login