A one-to-many relationship is

Assignment Help Database Management System
Reference no: EM13773820

Question 1. Which of the following is an example of an entity in a business?

Company
Business owner
CEO
Employees

Question 2. Which of the following is NOT a step in the Database Life Cycle?

Database Design
Maintenance and Redevelopment
Performance
Testing

Question 3. All of the following explain index usage EXCEPT

a primary field uses an index.
adding an index to a table might decrease overall database performance slightly.
an index can reduce the amount of time it takes for Access to run queries and reports.
indexes are created using the Index property type.

Question 4. A crow's foot

is a Boolean field.
is used to describe attributes.
points to the child table.
points to the parent table.

Question 5. A one-to-many relationship is

a relationship that guarantees that a record is unique.
an association between a record and its fields.
used to describe attributes.
when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.

Question 6. An associative table is

used to identify primary keys between tables.
a child of two parent tables that are in a many-to-many relationship.
an integrity element within a table relationship.
a tool that allows you to locate an excel file.

Question 7. Which does NOT apply to the following relationship image?

A one-to-many relationship is shown between Orders and Order Details.
The display is showing the Design View of relationships.
Order Details has a composite primary key.
Within the Orders Details table, the ProductID field will contain unique values only.

Question 8. Entity attributes are represented as

fields.
files.
records.
tables.

Question 9. Which of the following is NOT true of a birth date field?

A birth date is considered a constant.
A birth date would be defined as a date/time field.
The Age field is the same as a birth date field.
Date arithmetic can be applied to a birth date field.

Question 10. Which of the following is a special-definition setting used on a field containing an employee's date of hire?

Date arithmetic
Constant
Date/time field
Calculated field

Reference no: EM13773820

Questions Cloud

How would you respond under these circumstances : How would you respond under these circumstances? Outline your decision-making process using ethical decision-making guidelines. Be sure to address the counterpoints to your arguments and why you decided against them
Assignment summarizing and presenting data : Revise the report submitted in Week Two based on the feedback provided by the instructor in the team assignment, and insight gained by reading.
Tidal wave energy generation method : Well, hydropower is a great clean energy and it is in good use everywhere in the world. What are its pros and its cons? cite an example of a large hydroelectric project and offer some insight of the good and the bad.
Mythological and cultural origins of the story : Identify the villain and describe his or her characteristics and role in the hero's quest.
A one-to-many relationship is : A one-to-many relationship is a relationship that guarantees that a record is unique. an association between a record and its fields.
Professional in employee relations : Prepare a 350- to 700-word paper in which you address the following:
Hypotheses fracking causing global warming : After defining the topic of Global Warming, refining your hypothesis, and specifying the units of analysis in the Hypothesis research stage, you will now collect scholarly articles on your refined hypothesis. The Literature Review will consist of ..
Conducting personal business from the court chambers : Conducting personal business from the court chambers and Publicly endorsing and campaigning for a candidate for judicial office
Perform a risk assessment and develop a contingency plan : Perform a risk assessment and develop a contingency plan to manage the risk of sales falling 20% - Develop an argument for the changes and negotiate those changes with her.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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