CS200 Assignment 7 – FileMaker: Introduction to Databases Due Monday March 3, 2020, 11:59 pm
Readings and Resources
On Learn: Database Resources > Database Design: Intro
Database Resources > Database Design: Why Use a Relational Database Design
Files
ForAssign7.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 $200,000,000.
CS200 Assignment 7
Page 1 of 4
Book Table
Book ID
Title
Genre
Cost
Year of Publication Publisher ID Author ID
Author Table
Author ID
First Name
Last Name
Birth Year
Country
Average Income per Book Publisher ID
Publisher Table
Publisher ID Publisher Name Address
City
Gross per Year Sales Rep Phone Number
Assignment Objectives
• To become familiar with the interface of a database management application.
• To gain an understanding of reports and queries in a database management system.
• To gain an understanding of the importance and function of a relational database.
• To practice proper field defining and data validation.
Assignment Strategy
• Questions 1-3 must be done independently.
• Questions 4 and 5 may be done independently or with a partner. If you do work with a partner, please add both or your names, hand in codes and Student ID numbers to the file and name the file with both Usernames (username1_username2)
Your Tasks
1. (25%) Open the Library.fm file and define the fields with the appropriate field type and appropriate field options, for each of the three tables. Use the diagram on page 1 as a reference.
2. (10%) Open ForAssign7.doc and list the primary and foreign keys for each table. When listing the foreign key, state which table and field it is pointing to. Rename the file username_A7.docx.
CS200 Assignment 7 Page 2 of 4
3. (15%) Create a layout in the Author Table called Author Listing, that looks like the following. It should be sorted by Country and by Last Name.
4. [15%] Using the ForAssignA7.docx file, design a two table database with a minimum of 5 fields per table. Fill in the appropriate field types and data options. Identify the primary and foreign keys and identify how the tables are related. (Identify your partner if you are working with one.) This file may be used built over the next few assignments and used for your final assignment.
5. [20%] Either with a partner or individually, compare and contrast named styles in MS Word and in FileMaker Pro. You should have a minimum of 5 points to compare and contrast. Note that FileMaker Pro implements named styles in Layout Mode.
Your approach to Question 5 should be to build models of how FileMaker Pro implements named styles, and then to draw the requested comparisons. You will need to construct this model both by reading the available documentation, and by experimenting with FileMaker Pro.
Include some examples for each application. Include screenshots of the applications if this will be helpful.
Place your answer to this question in a Word file called username_a7q5.doc (or username1_username2_a7q5.doc).
CS200 Assignment 7 Page 3 of 4
Submission Instructions
• Create a folder called username_Assign6.
• Rename library.fmp to username_library.fmp.
Put username_library.fmp , username_A7.docx and username_a7q5.doc in this folder.
• Compress this folder and name it username_Assign7.zip. Submit it to the Assignment 7
DropBox on Learn.
CS200 Assignment 7 Page 4 of 4