A07 Instructions.pdf - CS200 Assignment 7 u2013 FileMaker...

CS200 Assignment 6 Page 1 of 4
CS200 Assignment 7 – FileMaker: Introduction to Databases
Due Monday June 24
th
2019, 11:59 pm
Readings and Resources
On Learn:
Database Resources > Database Design: Intro
Database Resources > Database Design : Why Use a Relational Database Design
Files
ForAssign6.doc
for answering questions 4 and 5.
Library.fm
containing three tables.
Book Table:
includes information about the
Genre
of the book (romance, adventure,
juvenile, science fiction, mystery, history, literature, non-fiction, pop-fiction). It also
includes the
Author
and
Publisher
of each book.
Author Table:
includes information about the
Country
the author lives (Canada, United
States, England, Ireland, Mexico). The Author generally chooses to publish his/her
books all with the same publishing company so the company is also listed here. Authors
will make an average between $10,000 and $2,000,000 on each book that they publish.
Publisher Table:
has information about the publishing company, including how much
they make on average each year. Generally, they make between $1,000,000 and