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

  Write a join query that for every order

Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the customer who placed the order.

  Advantages of database approach over file-system approach

How and why did database management systems become the organizational data management standard? Describe some advantages of database approach over file-system approach.

  Justification hello good night what is the justification

hello good night what is the justification for utalizing database management system approach i3939m not

  Describe the benefits and present trends of data

your database has been a hit. you have been called back to the customers headquarters and they want a detailed report

  Dba denormalized products database to enhance performance

The DBA denormalized some of the data in Premiere Products database to enhance performance, and one of the resulting tables is following.

  Study on managing the software enterprise

This course is for those in a management capacity, or those interested in management, involving the strategic consideration of software acquisition, development and project management.

  Compare two non-sequential file structure models

Compare the two non-sequential file structure models. What advantages does the first one have over the second and what advantages does the second have over the first?

  Explain the di?erence between external internal and concept

Explain the di?erence between external, internal, and conceptual sche-mas. How are these di?erent schema layers related to the conceptsof logical and physical data independence?

  How many cylinders does the disk have

Consider a disk with a sector size of 512 bytes, 2000 tracks per surface, 50 sectors per track, ?ve double-sided platters, and average seek time of 10 msec.

  Problem on relational algebra

The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

  Write names-e-mail addresses for customers by foreign key

Illustrate all data in each of the four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Evaluate the success wellco and pharmacare shareholders

Evaluate the success WellCo and PharmaCARE shareholders

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