All Matches

Solution Library

Expert Answer

Textbooks

Search Textbook questions, tutors and Books

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Tutors
Study Help
Hire a Tutor
AI Study Help New

Search
Sign In
Register

study help
computer science
database design for mere mortals

Questions and Answers of Database Design For Mere Mortals

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

Services

Sitemap
Fun
Definitions
Become Tutor
Study Help Categories
Recent Questions
Expert Questions

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Campus Ambassador

Secure Payment

Download Our App

© 2024 SolutionInn. All Rights Reserved