CIS1 Late Task #10 Assignment: Database

40 points Due date: December 6. Ends December 9.

Reading:

• Chapter 14 "Databases and Database Management Systems" in Understanding Computers.
• Access Chapter 1 "Creating and Using a Database" in the Office 2007 textbook. Read in front of the computer so you can practice the steps shown in the chapter.

In this assignment you will:

• Answer study questions about databases.
• Create a database.
• Answer multiple choice quiz questions on Chapter 14

Part 1: Study Questions 10 points

Answer the following questions in a document called Task10study. Upload it to Tasks, Tests and Surveys when complete.

Page 623 Understanding Computers Exercises answer questions 1-5

6. (2 points) 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?

Part 2 Creating an Access Database (20 points)

Do In the Lab 3 Creating the Ada Beauty Supply Database starting on page AC69 in Office 2007 with the additional information below.

Name the database Task10

Set the primary key in each table.

You do not have to change any database properties as mentioned in the last paragraph on page AC70. Just upload the Task10 database file to Tasks, Tests and Surveys when complete.

Part 3 Quiz 10 points

Answer multiple choice questions about Chapter 14 in Understanding Computers.