User Account

All Pages

How many entity types are involve in a tertiary relationship

Assignment Help Database Management System
Reference no: EM131340344

Database Design Quiz 25 Questions

Question 1
A highly organized collection of data is a database management system.
True
False

Question 2
Financial data residing in a database is not a corporate resource.
True
False

Question 3
Modality is the maximum number of entity occurrences involved in a relationship.
True
False

Question 4
Unary relationships contain one entity type.
True
False

Question 5
In a database, if there is more than one candidate key one MUST be identified as a primary key.
True
False

Question 6
A concurrency problem is defined as multiple data sets stored in the database.
True
False

Question 7
The most significant problem with data redundancy in a database is data integrity.
True
False

Question 8
Data redundancy can result in requiring unnecessary storage space for the database.
True
False

Question 9

Many-many relationships should be converted to associative entities on an Entity-Relationship diagram.
True
False

Question 10

There are two modes of data access known as sequential and direct access.
True
False

Question 11

Data within a database is typically controlled and manipulated by:
A. MY SQL Workbench

B. Database Management Software

C. MS Word

D. MS Excel

Question 12

A unique identifier of an entity is ____
A. Relationship

B. Cardinality

C. Attribute

D. Binary

Question 13

In an M-M relationship, the combination of or the association between two entities is known as ____
A. Cardinality

B. Modality

C. Associative entity

D. Intersection data

Question 14

A _______ relationship associates occurrences of an entity type with other occurrences of the same entity type.
A. Binary

B. Tertiary

C. Unary

D. Secondary

Question 15

How many entity types are involved in a tertiary relationship?
A. 1

B. 2

C. 3

D. 4

Question 16

The means by which an analyst records, documents, and diagrams the business environment is known as ________.
A. Relationship Identification

B. Data Association

C. Data Analysis

D. Data modeling

Question 17

In a DBMS, Referential Integrity contains three rules which are:
A. Restrict

B. Cascade

C. Set-to-null

D. Read

E. All of the above

F. A, B, and C

Question 18

The process of arranging attributes of entities in a given business environment into database structures is known as:
A. Physical Database design

B. Database structuring

C. Logical Database design

D. Relationship mapping

Question 19

Each row of a database is known as a ______
A. File

B. Field

C. Entity

D. Record

Question 20

An entity's attribute in a database management system is referred to as a ________.
A. Record

B. Relationship

C. Field

D. Row

Question 21

A foreign key is defined as _________.
A. The key attribute of an entity

B. An identifier of the relationship

C. Primary key of an entity

D. Primary key of a relation that appears in another relation

Question 22
An attribute or field that uniquely appears in every row of the relation is known as ____.
A. Key field

B. Primary Key

C. Foreign Key

D. Intersection ID

Question 23
Each table column in a database entity is commonly known as a ____________.
A. Record

B. Relationship

C. Field

D. Primary Key

Question 24
The purpose of a database is to _____________.
A. Eliminate redundancy

B. Centralize data

C. Integrate data logically

D. All of the above

E. None of the above

Question 25

In your own words write the definition of referential integrity.

Reference no: EM131340344

Questions Cloud

Discuss the concept of the intersection table : Discuss the concept of the intersection table. Why is it needed in many to many relationships? Referential integrity "rules" trigger some cleanup of your data when insertion, update, or deletion events would typically cause data anomalies.
Define the following concepts given below : With the links below, please define the following concepts using an example such as Darwin's finches, the Lemurs of Madagascar, flowering plants of Hawaii etc).common ancestor,adaptive radiation.
What is the climax of the text : What point-of-view is the text written in? Is the narrator reliable or unreliable - Who is the protagonist? The antagonist? The foil? The minor characters - What is the central conflict of the text and how does it change the protagonist and What is t..
Calculate the current drawn from a 240 v supply : Calculate the current drawn from a 240 V supply for each connection.
How many entity types are involve in a tertiary relationship : How many entity types are involved in a tertiary relationship? The process of arranging attributes of entities in a given business environment into database structures is known as.
Calculate the current drawn from the battery : A 12 Ω and a 6 Ω resistor are connected in parallel across the terminals of a battery of emf 6 V and internal resistance 0.6 Ω .
Calculate lj pathmarks diluted earnings per share : L.J. Pathmark reported net profit of EUR 250,000 for 2005.- Calculate L.J. Pathmark's basic earnings per share.- Calculate L.J. Pathmark's diluted earnings per share.
Which theories best explain their behavior : Most importantly, look at the situation of the characters in the film, and analyze their motivations and goals for becoming involved in the extremely sophisticated and complex criminal act, in terms of the Social Theories of Criminology that we ha..
Are there any performance indicators : Referring to those elements, are there any performance indicators which tell us whether value is being created?

Reviews

Write a Review

Database Management System Questions & Answers

  Identify and create database tables

Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF)

  Write pseudocode to represent the logic of a program

Write pseudocode to represent the logic of a program that allows the user to enter values for the width and length of a room's floor in feet. The program outputs the area of the floor in square feet.

  Plot the data on a scatter plot

Plot the data on a scatter plot. Determine the ideal number of clusters. Choose random center points (centroids) for each cluster. Using a standard distance formula measure the distance from each data point to each center point.

  Error code in unning this program in raptor

I need an input statement that would allow the user to input any day of the week for steps walked and be able to input any number for step walked on any day of the week.

  What would be the primary keys for each

What would be the primary keys for each of those? What would be the foreign keys among those to create the necessary relationships?

  Determine functional dependencies of table

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  Create an entity relationship diagram using uml notation

Create an Entity Relationship diagram using UML notation. To receive full credit for this assignment, your diagram must be well organized and include.

  Populate vehicles and customers table with at least ten rows

You can create your database on Nova or any other Oracle system you wish, but you must use the Oracle RDBMS. Populate the VEHICLES and CUSTOMERS tables with at least ten rows each. Populate your SALES table with at lease ten rows.

  A prestigious university has recently implemented a

a prestigious university has recently implemented a consolidation strategy that will require it to centralize their

  How much usage it might receive and where to set the price

YOF EWS10 H1 - Extreme H20 1. In a nearby community, there is a small river that can be used for tubing. The management is trying to figure out how much usage it might receive and where to set the price in order to make a profit.2:

  Hotel management system database project

Hotel Management System Database Project - A hotel is a hive of numerous operations such as front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping,..

  One of the needs that your client has is a databaseto

one of the needs that your client has is a database.to design a database a database planner should spend a considerable

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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