Database Assignment using books database


Download the books09.accdb database and answer the following questions.

This assignment will be done in class as a group assignment and each group should submit one answer.

One member of the group will be designated the leader for this assignment, the leader should submit the answer along with the list of the group members. If you disagree, you can note that and your discussion points on the assignment.

If you are a distance learning student or a student option student that was not in class, I will send you the email for your group which will include two other students from the class and the designated group leader. You can then do the assignment by email communications. You might organize this project by each doing the assignment and then comparing and discussing things where you do not agree.

This is the data in the table, check the database to see the structure/layout of the table.



isbn

title

author_prim

topic

publisher

yearPub

price

0-321-47712-X

Advanced Visual Basic 2005

Gaddis, Tony

VB

Pearson

2007

99.29

0-4701286-1-9

HTML, XHTML, and CSS Bible

Schafer, Steven

XHTML

Wiley

2008

20.11

0-5968-0244-7

CSS: The Missing Manual

McFarland, David

CSS

Pogue Press

2009

23.09

0-610-03440-8

CGI/Perl

Zak, Diane

CGI/Perl

Course Technology

2001

67.95

0-619-03520-X

Cascading Style Sheets

Skylar, Joel

CSS

Course Technology

2001

54.95

0-619-21284-5

Oracle 9i SQL

Morris-Murphy, Lannes

Oracle

Course Technology

2003

72.95

0-735714-25-8

More Eric Meyer on CSS

Meyer, Eric

CSS

New Riders

2004

48.99

0-9752402-0-X

XML Web Development with PHP

Myer, Thomas

XML

SitePoint

2005

39.95

0-980-45527-8

Build Your Own Web Site the Right Way Using HTML & CSS

Lloyd, Ian

XHTML

SitePoint

2008

19.77

1-111-11111-1

New Perspectives on Blended HTML, XHTML and CSS

Bojack, Henry

CSS

Course Technology

2009

86.95

1-4188-3629-X

Oracle 10g: SQL

Casteel, Joan

Oracle

Course Technology

2007

72.95

1-423-92546-7

New Perspectivs on HTML and XHTML

Carey, Patrick

XHTML

Course Technology

2008

60.46

1-590-59747-8

HTML with CSS and XHTML

Shultz, David

XHTML

Apress

2007

14.81

1-5927-3000-0

Developing Online Games

Mulligan, Jessica

Games

New Riders

2003

49.99



If I have a series of conditions, I can refer to the conditions as condition A, condition B, condition C, condition D etc. For example, condition A might be checking for a specific topic or condition A might check for a year greater than a given year etc.


Question #1: What is the table name and what is the primary key for the table?


Question #2: Which query tests for two things that both have to be true?


Question #3: When two things both have to be true, this is an _______ relationship.


Question #4: Which query tests to see if one of two conditions is true?


Question #5: When either one of two things has to be true, this is an _________ relationship.


Question #6: Which query tests to see if condition A and condition B are true or whether condition C and condition D are true.


Question #7: Which query tests to see if condition A is true and also that either condition B or condition C are true.


Question #8: Which query tests to see if condition A and condition B are true or if condition C is true.


Question #9: Which query tests to see if condition A is true or condition B and condition C are both true.


Question #10: How do you set up an Access query to show that one thing has to be true when the query also asks other questions that involve the criteria line and the or line.


Question #11: What if I had a query that asked if condition A was true or condition B was true or condition C was true. How would I set that up. Experiment to figure this out.





















Question #12: Which query would produce the results shown in this flowchart?

















































Question #13: Which query would produce the results shown in this flowchart?

















































Question #14: Which query would produce the results shown in this flowchart?

















































Question #15: Which query would produce the results shown in this flowchart?