Explain entity integrity and referential integrity

Assignment Help English
Reference no: EM13803662

Question 1. Which object would you use to enter, delete, or modify data?

Criteria

Form

Query

Table

Question 2. In what situation would Excel be a better choice than Access?

You have a limited amount of data.

You have an extensive amount of data.

You need to maintain constant connectivity to an external database.

You require a relational view of your data.

Question 3. All of the following are Report Wizard Layout types EXCEPT

block.

outline.

stepped.

summary.

Question 4. All of the following filters work EXCEPT

filter by selection with an equal condition.

filter by selection with a comparison operator.

filter by selection with an edit operator.

filter by form with a comparison operator.

Question 5. A report creation tool that will automatically pull in the fields from a table or query is the

report tool.

report design.

report wizard.

blank report.

Question 6. A field that uniquely identifies each record in a table is a

link.

relationship.

primary key.

foreign key.

Question 7. Which of the following should be considered when designing a database?

How calculated fields are used

Store data in its smallest parts

The relationship between attribute keys

The relationships between records

Question 8. All of the following describe a caption property EXCEPT

allows for placing spaces between words.

can take the place of a field name in Datasheet View.

can be used in place of a field name in an expression.

the caption appears in Datasheet, Report, and Form views.

Question 9. All of the following summarize characteristics of a PivotTable EXCEPT

can display information that is typically found in Datasheet totals.

can only be created from a table.

data is organized and summarized in an easy-to-read view.

is created by dragging fields from a field list into appropriate drop zones.

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. When building a calculated field, formulas can be created using the

form wizard.

expression builder.

report builder.

table wizard.

Part 2-

Question 1. When certain attributes cannot be entered into a database without the existence of other attributes; such as not being able to add a new course to the schedule unless a student is enrolled in the course, then this would be an illustration of:

Insert anomaly

1:M relationship

Update anomaly

Foreign Keys

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 is a term used to describe the names of controls, fields, or properties?

Function

Identifier

Operator

Value

Question 4. Which of the following expressions is NOT correct?

Cost: [Price] * [Qty]

DiscountAmt = [Price] * [Qty] * [Discount]

PrPerSqFt: [SalePr] / [SqFt]

Sales: [GP] * [Qty]

Question 5. To display data as percentages of a whole, use the following chart.

Bar

Line

Pie

Scatter Plot

Question 6. Effective PivotTables and PivotCharts are usually based on a

form.

query.

report.

table.

Question 7. The ________ interface displays a menu that provides the ability to open the various objects within the database, and to move easily from one object to another.

Form

Utility

Switchboard

Object

Question 8. Open Exclusive means that

a password is required to open the Access database.

only one person has access to the Access database at any time.

only selected persons can have access to the Access database.

two or more people cannot open the same Access database at the same time.

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. After creating an ACCDE file, you

can convert it back to its source format.

will see a "file already in use" message that continues to display to all other users.

will be able to modify forms and reports but not tables.

will need to go back to the original file if an underlying object requires a change.

Question 11. Which statement below is NOT true of the one-to-many relationships?

It is the least used type of relationship.

OrderID is a unique identification number that would be used in the Orders table and Order Details table.

Each record in the Orders table may match one, more than one, or no records in the Order Details table.

Each record in a Orders table matches only one record in the Customers table.

Question 1. Let's imagine this scenario. Development of a database system is about to start. Before development actually starts, the Director of Systems Development asks you to evaluate the database schema design and report your observations. Given this scenario what would you look for? Please discuss and explain.

Question 2. Explain entity integrity and referential integrity. Give an example of each.

Question 3. Conceptual design begins with a big-picture view, and details gradually added before the implementation process begins. With this in mind, what is the first step in the conceptual design process for ERD construction? In your own words, describe how you would accomplish this first step.

Question 4. If you were given an ERD that contained an M:N relationship between Orders and Products, what would you need to do in order to create the tables and relationship in Access?

Reference no: EM13803662

Questions Cloud

Design a new textbook for a psychology and science class : Design a new textbook for a psychology class, science class, etc. Invent a new telephone. Design a new suitcase. Design new clothes for soldier/teacher/cook/student/etc.
Individual assignment demonstrative communication paper : Individual Assignment Demonstrative Communication Paper
Define presidential doctrine and summarize regional events : Define presidential doctrine and summarize the regional or global events during the Cold War leading up to the formation of the presidential doctrine
Development of an er diagram and database implementation : Development of an ER Diagram and Database Implementation- To give you practical experience in using Entity-Relationship and Relational Database modelling techniques
Explain entity integrity and referential integrity : Explain entity integrity and referential integrity. Give an example of each. Conceptual design begins with a big-picture view, and details gradually added before the implementation process begins.
Individual assignment information technology acts paper : Individual Assignment Information Technology Acts Paper
Assignment efficiency and collaboration proposal : Assignment Efficiency and Collaboration Proposal
Explain how cultural diplomacy could be used : Explain how cultural diplomacy could be used to solve a "real life" problem. Provide a description of the problem and a solution. Please also mention one specific "real life" problem.
Explain the historical evolution of habeas corpus : Explain the historical evolution of habeas corpus, including its English and American traditions. The explanation of its evolution within the American tradition should include the general meaning of the right of habeas corpus in the U.S.

Reviews

Write a Review

English Questions & Answers

  Write a profile

Write a profile on bishop poleni.

  Education system

Write a rearch paper on education system

  Write an report

The U.S. President Barack Obama said America can "win the future" by rebuilding its manufacturing sector (on June 8, 2011, after visiting an automotive training center at a community college in Virginia, outside Washington). Do you agree, and why?

  Discuss the accuracy of this statement

'Consideration does not have to be adequate or commercially realistic, nor does it need to be expressed in monetary terms, it merely needs to be "sufficient".' Discuss the accuracy of this statement.

  Write an essay on the youngest billionaire

Write an essay on the youngest billionaire

  Transformational leadership in the public sector

The more hierarchical an organization's authority structure, the lower the reported practice of transformational leadership behaviors.

  Modal verbs or modal constructions

Identify all the modal verbs or modal constructions in the passage

  Write a latter to mom thanking to adopting and caring

Write a latter to mom thanking for adopting and caring,

  Ways of knowing & authority in your discipline

To explore and become familiar with your discipline; to prepare you for your major researched essay.

  Writing an effective business letter

Prepare a letter in either block or modified block format, addressed to your employer or supervisor and copied to your marker.

  Discuss the kingdom of saudi arabia

Discuss the Kingdom of Saudi Arabia

  Developing an annotated bibliography

Developing an annotated bibliography

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd