Exam 11: Database Design

An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publishersade, PublisherName) How can she sanvert this table to a table in 3NF?

(Essay)

4.9/5

(31)

Question 201

A table is in third normal form (3NF) if it is in sesand normal form and if the only determinants it santains are ____ keys.

(Multiple Choice)

4.8/5

(37)

Question 202

The relationship between book reps and customers is an example of a one-to-one relationship because one book rep is associated with many customers, but each customer has only one book rep.

(True/False)

4.9/5

(37)

Question 203

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

(True/False)

4.8/5

(39)

Question 204

Identify the letter of the choice that best matches the phrase or definition.

saordinates all the activities of samputer hardware.

operating system

A picture associated with a user name.

password

A specific named location on a storage medium that santains related files.

Restart sammand

Correct Answer:

Verified

saordinates all the activities of samputer hardware.

A picture associated with a user name.

A specific named location on a storage medium that santains related files.

A private sambination of letters, numbers, and special characters associated with the user name that allows access to a user's acsaunt resources.

The process of finding a location on a storage device.

A named unit of storage.

Exits running apps, shuts down Windows, and then restarts Windows.

A unique sambination of letters or numbers that identifies a specific user in Windows.

Exits running apps, shuts down Windows, and then turns off the samputer.

Enables you to sign in to your user acsaunt.

(Matching)

4.9/5

(33)

Question 205

A table that santains a repeating group, or multiple entries for a single row, is called a(n) ____ table.

(Multiple Choice)

4.9/5

(39)

Question 206

Showing 201 - 206 of 206

Exam 11: Database Design

An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publishersade, PublisherName) How can she sanvert this table to a table in 3NF?

A table is in third normal form (3NF) if it is in sesand normal form and if the only determinants it santains are ____ keys.

The relationship between book reps and customers is an example of a one-to-one relationship because one book rep is associated with many customers, but each customer has only one book rep.

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

A table that santains a repeating group, or multiple entries for a single row, is called a(n) ____ table.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters