CIS 1 Homework #9: Databases

Due date May 3. Late deadline May 10.

Reading:

Part 1: Study Questions 10 points

Answer the following questions in a document called HW9.

1-5. Page 623 Understanding Computers Exercises

6. Read the information on Page 624 Hot Topics 1 Terrorist Databases. Search the Internet to find out about these or other law enforcement databases. Just write a one-paragraph summary about the database.

7. (2 points) Search the Internet for an incident where data was stolen from a database in the past year.

a. What is the URL of the web page describing the incident?

b. Describe what kind of data was stolen and when and how it happened.

8. What is SQL used for?

Part 2 Creating an Access Database 15 points

Do Cases and Places 1: Design and Create an E-Commerce Database on page AC 71. The instructions from the textbook are as follows:

Students often have very little money to furnish dorm rooms and apartments. You and two of your friends have decided to use the skills you learned in your e-commerce class to create a Web site specifically for college students to buy and sell used household furnishings. Design and create a database to store the data that you need to manage this new business. Then create the necessary tables and enter the data from the Case 1-1 Second-Hand Goods document.

Create a new database named HW9 using Microsoft Access. If you do not have Access, you can use the computer labs on campus.

Make sure your database includes the following:

Email the HW9 database file and the Word document from Part 1 to me.