Asignment

Prt 1

Question 1. MS Visio is used during Database design for the following reasons.
It depicts entities and relationships between entities.
It sets data type for attributes.
It calculates formulas.
It can query information.

Question 2. What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like "How many UPS tubes were shipped Monday?" and "What was the total revenue generated from UPS Express Box Large in November 2013?"
Foreign keys
Primary keys
Parameter query
Table connections

Question 3. The Navigation Pane allows you to:
Open Tables
Open Views
Filter By Datatype
Filter By Group and Navigate to Category

Question 4. Which of the following is a/are question(s) that you should ask before you create an Access report?
What is the purpose of the report?
Who will use the report?
How will the report be distributed?
All of the above questions should be asked.

Question 5. Which one of the following report sections appear once on every report page?
Report Header section
Report Footer section
Page Footer section
Detail section

Question 6. A field that uniquely identifies each record in a table is a
link.
relationship.
primary key.
foreign key.

Question 7. SQL is a fourth-generation language that is
flat-file oriented and nonprocedural.
oriented toward static data.
procedural and record oriented.
table oriented and nonprocedural.

Question 8. A property that provides a user friendly name to a column in Datasheet view is a(n)
caption.
default value.
input mask.
rule.

Question 9. A functional dependency is
a logical relationship between attributes of a table.
a logical primary key.
a composite key.
a unique identifier.

Question 10. Which of the following is NOT true of a property?
A property is an object's characteristic or attribute.
Tables, forms, queries, and reports have a set of properties.
A property sheet is used to make changes.
Design properties are displayed in Datasheet view.

Question 11. Which function is used to isolate a specific portion of a date, such as year, month, or day in a date field?
Date
DateDiff
DateParse
DatePart

Part 2

1. All of the following describe form usage EXCEPT a form user should have less input errors than a table user.
a form can show data from only one table.
forms restrict data entry to one record at a time.
you can create Access forms to match paper forms.

Question 2. A calculated control
contains a formula that displays the result.
is a bound box.
is a text box containing a description.
is an unbound box that the user will fill in with a numeric value.

Question 3. Which of the following describes a poor design consideration for a form?
Arrange controls closely together or in a sequence that is easy to read by the user.
Each form should have a different theme.
Make labels descriptive and clear.
Right-align labels followed by a colon and left-align bound controls.

Question 4. Data aggregates
are used to perform calculations on individual records in a table or query.
cannot be used in a report.
perform calculations on entire columns of data.
return multiple values.

Question 5. First normal form can be identified by
a row of a table holds data that pertains to one and only one instance.
all the entries in a column must be the same data.
the order of rows does not matter.
All of the above

Question 6. A validation rule
can prohibit values from being entered that may not meet a
criterion.
compares a field to a table.
is an error message that appears when a value is incorrectly
entered into a field.
makes a value entered into a field appear in a particular
format.

Question 7. The Switchboard Manager is an Access utility that is used
by all database users.
to create and manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.

Question 8. An encrypted file is
created by scrambling the content.
protected by a password.
saved with a specific file extension.
unreadable if it is opened through a tampering tool or another program.

Question 9. A digital signature
helps ensure that a file has not been tampered with and will be safe to open.
is used with database files exclusively.
is a tracking system of a file.
must be obtained from a certification authority, such as VeriSign.

Question 10. The ACCDT file format type refers to a(n)
database.
digitally signed database.
executable database.
template.

Question 11. Which database property type increases the efficiency of a search on the designated field in the physical database?
Validation rule
Validation text
Indexed
Expression

Part 3

Question 1. Describe the client/server architecture. Explain the client role. Explain the server role. Give an example.

Question 2. Explain business logic and describe how it relates to a relational database.

Question 3. Describe the update problem caused by a denormalized design.

Question 4. When constructing a database, two rules are followed by the database designer to ensure the integrity of keys. Describe each rule and discuss common violations.