Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 8.7
1 and 2. Create a database of records. This is a continuation of Case 8-17.
4. Create a query that selects all customers living in zip code 12345. The selected records will
5. Create a query that selects all customers living in Texas with zip code 12345. The resulting
6. Create a query that selects all credit customers. The resulting records will depend upon the
underlying data that each student creates.
8-19. Furry Friends Foundation I (Creating a New Database from Scratch)
This case introduces students to a relational database. It requires them to set up the database,
1.
2. The Contributor ID is used as the primary key for the FFF contributor table. The key is
filing state or federal taxes.
3. Each student will need to add a unique contributor ID, their last name, first name, street
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 8.8
4. The relationships between the tables are joined by Contributor ID in the Contributor File and
Code.
1. This is a continuation of Case 8-19.
2. This requires students to create three records using their own name and contributions to the
underlying data that each student creates.
3. Create a query of all contributors donating to cats. The results should include the entry that
4. Create a query of all contributors who donated over $50. If the student made contributions
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 8.9
5. Create a query of all contributors who donated over $100 to dogs. If the student made a
is:
1. Create a record structure as specified in the problem. The primary key should be the Social
changed to “yes”.
2. This problem requires the following validation rules:
Data field Validation Rule Validation text
Work Phone extension: >100 And <999 see below
Pay rate: >=12.50 And <=55.00 see below
No. of tax exemptions: <=6 see below
Core Concepts of Accounting Information Systems, 13th Edition, by Simkin, Rose, and Norman
SM 8.10
3. Example records:
Last
Name
First
Name
Social
Security
Number
Home Phone
Work Phone
Extension
Tax
Exemp
-tions
Depart
– ment
Smith
Andrew
123-45-6789
(111) 222-3333
123
1
A
Strawser
Barbara
234-56-7890
(222) 333-4444
143
2
B
Wolfe
Carolyn
345-67-8899
(333) 444-4567
456
3
C
4. Examples of validation text messages (not necessarily the ones for the problem):
SM 8.11
8-22. North Beach College (Enforcing Referential Integrity)
1. Suggested data types for each field in the database tables are as follows:
Table
Data field
Data type
Car Registration Table
Social Security Number
Text
Last Name
Text
First Name
Text
Phone Number
Text
License Plate State
Text
License Plate Number
Text
Ticket File Table
Ticket Number
Numeric (Integer)
License Plate State
Text
License Plate Number
Text
Date
Date
Violations Code
Text
Fine
Numeric (floating point)
Parking Violations Code Table
Code
Text
Explanation
Text
3. This part of the case requires students to create at least three parking tickets for each car
registrant.
4. This part of the case requires students to create a record in the ticket file that contains a non-
5. This part of the case requires students to link the tables together and to enforce referential
integrity.
6. This part of the case requires students to again create a record in the ticket file that contains a
7. This part of the case requires students to attempt to delete a record from the Parking
Violations code table. They should not be able to do so because the database system
enforces referential integrity.