Golden Orange is a publishing company. The operations database will keep track of the following: books, writers, agents, and editors.

Entities$/$Tables:

$$ For each book published: There is a unique book identifier $($INT$),$ book title $($varchar $20),$ genre $($char $10),$ date of publication $($Date$),$ and number of pages $($Int$)$

$$ For each writer: There is a unique writer identifier $($INT$),$ as well as the writer$$s first $($varchar $20),$ and last name $($varchar $30)$

$$ For each agent: there is a unique agent identifier $($INT$),$ as well as the agent$$s first $($varchar $20),$ and last name $($varchar $30),$ years of experience $($Int$)$

$$ For each editor: there is a unique editor identifier $($INT$),$ as well as the editor$$s first $($varchar $20),$ and last name $($varchar $20),$ area of expertise $($varchar $10)$