Deck 12: Databases

Question 1

You are analyzing a company's customer and order information. Because each customer can place multiple orders, you know this is a(n) -to-many relationship.

Answer 1

One to many relationship
When one record is related to many records then this relationship is called as one to many relationships. One parent record can have any number of children nodes but a child record will have only one parent record in this relationship.
A customer can order any number of music tracks hence this relationship is one-many relationship. This relationship can be shown diagrammatically as: Therefore, the appropriate word to fill in the blank is one.

Question 2

You are creating a movie review database, and one field stores the "star rating" that a popular reviewer gave each movie. Movies are rated from one to four stars, so the Stars field is valid only if the number is between 1 and 4. To ensure that nobody enters a value below 1 or above 4, you can use a field rule to filter the data as it's entered into the table.

Answer 2

Field validation rule
Field validation is used by the database designers for setting up a filter data which is entered into a particular field.
For example, the price of a music CD is from $5 to $600. No music CD has a value more than $600.
When a user wants to enter a value $23.67 than by the omission of decimal point it will be treated as $2367, then a message is shown to the database designer for entering a correct value.
When user is given a limit to enter 1 to 4 stars for the movie review, then entering a number more than 4 will cause an error of entering the correct number as field validation rule set up filters for specified data fields.
Therefore the appropriate word to fill in the blank is validation.

Question 3

You are designing the database structure for a mail-order catalog company. You recognize that a many-to-many relationship exists between an order and the items listed on the order. That clue indicates that you should separate the data into two , one called Orders and the other called Order Details.

Answer 3

Record types
For any record, the templates are referred as record type. Record type represents the name of field instead of data. Examples of record type include name, title, album etc.
There exist many-to-many relationships, between list and orders. The clue states that user should have two separate data (Orders and Order Detail). Orders and Order Detail are the record types. It is because the data entered in the respective fields.
Therefore, the appropriate word to fill in the blank is record types.

Question 4

Create a descriptive example that would help explain the concepts of data mining, data warehouses, predictive analytics, and OLAP to an average adult who has no technical expertise.

Question 5

For each of the following pairs of record types, draw an ERD showing whether the relationship is one-to-one, one-to-many, or many-to-many:
Author-Book Person-Social Security number
House-Mailbox Musician-CD

Question 6

Use diagrams to explain different ways of providing Web access to the data in a database.

Question 7

The simplest model for storing data is a(n) file that consists of a single two-dimensional table.

Question 8

A(n) database stores records in a collection of tables that can be joined by common data fields.

Question 9

Your friend is working on some Web pages, and you notice that they contain tags such as Ella Ellison and 1960/05/26. You surmise that your friend is using instead of HTML.

Question 10

Modern database software supports data , which means keeping data separated from the program modules that manipulate the data.

Question 11

ASP, PHP, Ruby, and Java are used to write -side scripts.

Question 12

Provide five examples of data you would store in real, integer, text, logical, date, memo, BLOB, and computed fields.

Question 13

A computed field is calculated during processing and stored temporarily in memory. True or false?

Question 14

Database designers use a process called to minimize data redundancy in a database.

Question 15

List the techniques that a database designer can use to reduce data entry errors.

Question 16

In SQL, the DATA command adds fields to a database. True or false?

Question 17

The SQL command can change the data in a specified field in one or more records.

Question 18

Using a real-world entity, like a comic book collection or a recipe file that can be stored in a database, divide the information into fields and record types. Explain the steps you need to take to normalize the data.

Question 19

cannot prevent a database from being lost or stolen, but it can make the data it contains unusable.

Question 20

A database is a procedure that monitors and records user activity within a database.

Question 21

Using your own examples, explain the differences between sorting and indexing.

Question 22

Are you concerned about your personal data being included in government data mining operations?

Question 23

You want to print a professionally designed list of all the records in your database. To organize and format the list, you use a report generator to create a reusable report .

Question 24

Describe how a database report template works. List five principles for creating effective report templates.

Question 25

You're working for a company that's just getting started with a database project. Your supervisor wants "the most standard kind of database," so you recommend using database management software.

Question 26

You are designing a record type that holds customer information. You should use a(n) data type for the fields that hold information such as telephone numbers and Social Security numbers because although this data looks like numbers, you'll never need to use it to perform mathematical calculations.

Question 27

Describe flat files and six other database models. Give examples that illustrate each model.

Question 28

Imagine that you must access a library card catalog using SQL. Write an SQL query that you would use to search for any books by J. K. Rowling in a table called Books, where authors' names are stored in a field called AuthorName and book titles are stored in a field called Title.

Question 29

List eight ways the information in a database can be used and applied.

Question 30

Define basic database terminology, such as fields, records, record types, record occurrences, and cardinality.

Question 31

The terms class , attribute , and method apply to databases.

Question 32

Explain the extent to which encryption, user privileges, and audits can secure a database.

Question 33

Online processing allows decision makers to look for relationships between multiple data dimensions.

Question 34

A(n) can be used to diagram the associations between data that is stored in several record types. (Hint: Use the acronym.)

Question 35

is a markup language that allows field tags, data, and tables to be incorporated into a Web document. (Hint: Use the acronym.)

Question 36

Describe the status of privacy legislation in your country, providing examples of relevant laws and regulations.

Question 37

Most of today's word processing and spreadsheet software offers tools for managing simple flat files containing fields and records. True or false?

Question 38

To access the data in a database from a remote computer or network workstation, you can use database software.

Question 39

In addition to storing records in sorted order, a database can be to produce a list of keys that can be used to alphabetize or otherwise organize the records.

Question 40

List the steps you can take to protect your privacy and identity when working with databases.

Question 41

A primary contains data unique to a record, such as a Social Security number or ISBN.

Question 42

To filter data entered into a field, the database designer can set up a field rule.

Question 43

In SQL, the JOIN command allows you to add fields to a database. True or false?

Question 44

In search specifications, AND, OR, and NOT are examples of search operators, also called operators.

Question 45

To search for data in a specific field, you can use the SQL command .

Question 46

Individuals can minimize their vulnerability to database security breaches by looking for a way to -out so that data is not sent to third parties.

Question 47

The qualities that make computer databases efficient also make them vulnerable to security breaches. True or false?

Question 48

Passwords, firewalls, and locked data centers are all types of controls that can prevent unauthorized use of a database.

Question 49

You own a fly-fishing shop and maintain an inventory database that, along with inventory data, stores the names of the wholesalers from which you buy each item. Hot Rod Wholesalers just changed its name to Northern Rod and Reel, so you need to update your database. The best way to accomplish this task would be to perform a(n) update that changes every instance of "Hot Rod Wholesalers" to "Northern Rod and Reel."

Question 50

Should your government continue to develop and deploy data mining techniques designed to identify terrorists?

Question 51

Do you think that governments should apologize and compensate individuals who are inappropriately harmed by data mining operations?

Question 52

Explain the capabilities of various data management tools, such as commercial applications, word processing software, spreadsheet software, custom data management software, and database management software.