logo image

Appendix C: Databases

What kind of attribute would be given for a person who does not have an email address?
Null-valued attribute
Which of the following is a possible business rule?
*All of these.
A DVD title can have many copies.
A customer can purchase many DVDs.
DVDs can be purchased by many customers.
Which of the following is a type of attribute?
Single-valued attribute
*All of these
Multi-valued attribute
Null-valued attribute
What is a characteristic of a table?
Field
What has only a single value of each attribute of an entity?
Single-valued attribute
What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?
Null-valued attribute
What kind of attribute would be age?
Derived attribute
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
One-to-one relationship
What is a statement that defines an aspect of a business?
Business rule
What is a technique for documenting the entities and relationships in a database environment?
Entity-relationship diagram
What is a collection of related data elements?
Record
Which of the following statements is accurate?
Each business rule will have entities and sometimes even attributes.
A typical business may have hundreds of business rules.
*All of these.
A correct business rule for one organization may not be correct for another organization.
What kind of attribute would be date of birth?
Stored attribute
What exists to represent the relationship between two other entities?
Composite entity
What is composed of rows and columns that represent an entity?
Table
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
One-to-many relationship
What is a foreign key?
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
What occurs when two entities can be related to each other in many instances?
Many-to-many relationship
What kind of attribute can be calculated using the value of another attribute?
Derived attribute
What is a primary key?
A field that uniquely identifies a given record in a table
What expresses the specific number of instances in an entity?
Cardinality
What has the potential to contain more than one value for an attribute?
Multi-valued attribute

Need essay sample on "Appendix C: Databases"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy