1 / 2

Book Book ID (PK) Book Desc

Writes.

darrin
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

More Related