New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
computer science
database design for mere mortals
Database Design For Mere Mortals 4th Edition Michael J Hernandez - Solutions
What is a subset table?
State the three reasons why keys are important.
What are the four main types of keys?
What is the purpose of a candidate key?
State four items of the Elements of a Candidate Key.
True or False: A candidate key can be composed of more than one field.
Can a table have more than one candidate key?
What is an artificial candidate key?
What is the most important key you assign to a table?
Why is this key important?
How do you establish a primary key?
What must you do before you finalize your selection of a primary key?
What is an alternate key?
What do you ensure by establishing table-level integrity?
Why should you review the initial table structures?
State two major reasons why field specifications are important.
What do you gain by establishing field-level integrity?
What are the three categories of elements in a field specification?
Name the three types of specifications.
Why is it beneficial for you to compose a proper field description?
What does the Data Type element indicate?
What does the Character Support element indicate?
What types of keys are indicated on a field specification?
True or False: Null represents a blank value.
What is the significance of the Range of Values element?
What is the purpose of an Edit Rule?
When do you use a generic specification?
State two major reasons why a relationship is important.
Name the three types of relationships.
Which relationship will pose the most problems?
State two problems you could possibly encounter with a many-to-many relationship.
What is a self-referencing relationship?
How do you begin the process of identifying the relationships among the tables in the database?
What are the two types of questions you can ask to help you identify existing relationships?
What shorthand symbol do you use to designate a one-to-many relationship in the table matrix?
How do you determine what type of relationship officially exists between each pair of tables in the matrix?
How do you establish a one-to-many relationship?
True or False: Retrieving information from tables with a selfreferencing relationship can be tedious and somewhat difficult.
How do you establish a self-referencing many-to-many relationship?
How do you refine the foreign keys in the database?
What two element categories must you modify for a foreign key’s field specification?
What is the function of a deletion rule?
What two types of participation can you designate for a table?
What does the degree of participation indicate?
Why can you refer to a view as a virtual table?
State two reasons why views are valuable.
Name the types of views you can define as you design the logical structure of the database.
What determines the type of modifications you can make to a view’s data?
What is the only requirement you must fulfill to define a multicable data view?
Why doesn’t a data view contain its own primary key?
What is a grouping field?
True or False: You can modify the data in an aggregate view.
What is the difference between a validation table and a validation view?
Name two points you would consider when identifying view requirements.
When should you use calculated fields?
How do you define a view that displays only science-fiction books?
Showing 100 - 200
of 156
1
2
Step by Step Answers
Get 50% OFF
Claim Now
