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
business
database management systems
Fundamentals Of Database Management Systems 2nd Edition Mark L. Gillenson - Solutions
Explain the concept of referential integrity.
Describe how unary and ternary relationships are implemented in a relational database.
Understand how the join operator facilitates data integration in relational database.
Describe how relational data retrieval is accomplished using the relational algebra select, project, and join operators.
Describe how one-to-one, one-to-many, and many-to-many binary relationships are implemented in a relational database.
Describe the major types of keys including primary, candidate, and foreign.
Define such basic relational database terms as relation and tuple.
Describe the concept of logical database design.
Design relational databases by converting entity-relationship diagrams into relational tables.
Describe the data normalization process.
Describe a variety of physical database design techniques ranging from adding indexes to denormalization.
List and describe the inputs to the physical database design process.
Describe how disk storage devices work.
Describe the principles of file organizations and access methods.
Learn basic SQL commands to manipulate data.
Learn basic SQL commands to build data structures.
Test tables for irregularities using the data normalization process.
Perform the data normalization process.
Explain why the relational database model became practical in about 1980.
Describe the principles of a relational query optimizer.
Describe a strategy for writing SQL SELECT statements.
List the five basic principles of the database concept.
Discuss the problems encountered in a non-database information systems environment.
Compare sequential access of data with direct access of data.
Identify the four basic operations performed on stored data.
Define data-related terms such as entity and attribute and storage-related terms such as field, record, and file.
Model data in business environments by drawing entity-relationship diagrams that involve unary, binary, and ternary relationships.
Recognize and describe intersection data.
Describe one-to-one, one-to-many, and many-to-many unary, binary, and ternary relationships.
Describe how data can be considered to be a manageable resource.
List the three problems created by data redundancy.
Describe the nature of data redundancy among many files.
Write SQL SELECT subqueries.
Write SQL SELECT commands that join relational tables.
Write SQL SELECT commands to retrieve relational data using a variety of operators including GROUP BY, ORDER BY, and the built-in functions AVG, SUM, MAX, MIN, COUNT.
Explain why providing support for data independence is an important feature of the database approach.
Explain why providing support for such control issues as data security, backup and recovery, and concurrency is an important feature of the database approach.
Explain why the ability to store multiple relationships is an important feature of the database approach.
State the primary defining feature of a database management system.
Explain the relationship between data integration and data redundancy in one file.
Recognize which relationships in the business environment are unary, binary, and ternary relationships.
What expectation should there be for a database management system with regard to handling data control issues such as data security, backup and recovery, and concurrency control? Why?
Name the four basic operations on stored data. In what important way is one in particular different from the other three?
What is sequential access? What is direct access?Which of the two is more important in today’s business environment? Why?
Give an example of and describe an application that would require sequential access in:a. The university environment.b. The insurance company environment.c. The furniture store environment.
Give an example of and describe an application that would require direct access in:a. The university environment.b. The insurance company environment.c. The furniture store environment.
Should data be considered a true corporate resource?Why or why not? Compare and contrast data to other corporate resources (capital, plant and equipment, personnel, etc.) in terms of importance, intrinsic value, and modes of use.
Defend or refute the following statement: ‘‘Data is the most important corporate resource because it describes all of the others.’’
What are the two kinds of data redundancy, and what are the three types of problems that they cause in the information systems environment?
What factors might lead to redundant data across multiple files? Is the problem managerial or technical in nature?
Describe the apparent tradeoff between data redundancy and data integration in simple linear files.
What is the difference between a record type and an occurrence of that record? Give some examples.
What is the relationship between:a. An entity and a record?b. An attribute and a field?c. An entity set and a file?
Name soe entities and attributes in a furniture store environment.
What are some of the ways that relational query optimizers can handle joins?
What information does a relational query optimizer use in making its decisions?
How do relational query optimizers work?
What is a relational query optimizer? Why are they important?
Name some entities and attributes in an insurance company environment.
What is a subquery in an SQL SELECT statement?
How do you construct a Join operation in an SQL SELECT statement?
Describe the purpose of the HAVING clause. How do you decide whether to place a row-limiting predicate in the WHERE clause or in the HAVING clause?
Describe the purpose of the GROUP BY clause.Why must the attribute in the GROUP BY clause also appear in the SELECT clause?
In your own words, describe the key quality of a DBMS that sets it apart from other data handling systems.
Do you think that the single-file redundancy problem is more serious, less serious, or about the same as the multifile redundancy problem? Why?
What are the two defining goals of a database management system?
Describe the basic format of the SQL SELECT command.
In a general way, describe how to write an SQL SELECT command to accomplish a relational Select operation.
In a general way, describe how to write an SQL SELECT command to accomplish a relational Project operation.
In a general way, describe how to write an SQL SELECT command to accomplish a combination of a relational Select operation and a relational Project operation.
What is the purpose of the WHERE clause in SQL SELECT commands?
List and describe some of the common operators that can be used in the WHERE clause.
Describe the purpose of each of the following operators in the WHERE clause:a. ANDb. ORc. BETWEENd. INe. LIKE
What is the purpose of the DISTINCT operator?
What is the purpose of the ORDER BY clause?
Explain the difference between running SQL in query mode and in embedded mode.
How does the SQL SELECT command relate to the relational Select, Project, and Join concepts?
What is the purpose of the SQL SELECT command?
What expectation should there be for a database management system with regard to handling multiple relationships? Why?
What are the problems with the ‘‘horizontal’’ and‘‘vertical’’ solutions to the handling of multiple relationships as described in the chapter?
Explain the difference between the SUM and COUNT built-in functions.
What would the alternative be if database management systems were not designed to handle data control issues such as data security, backup and recovery, and concurrency control?
What expectation should there be for a database management system with regard to data independence?Why?
What are the four major DBMS approaches? Which approaches are used the most and least today?
What are the four basic operations that can be performed on stored data?
What is Structured Query Language (SQL)?
Name several of the fundamental SQL commands and discuss the purpose of each.
Name the five SQL built-in functions and describe the purpose of each.
Describe the significance of data extraction into XMLin the Internet environment.
Worldwide, vacation cruises on increasingly larger ships have been steadily growing in popularity. People like the all-inclusive price for food, room, and entertainment, the variety of shipboard activities, and the ability to unpack just once and still visit several different places. The first of
Sports are universally enjoyed around the globe.Whether the sport is a team or individual sport, whether a person is a participant or a spectator, and whether the sport is played at the amateur or professional level, one way or another this kind of activity can be enjoyed by people of all ages and
What is data modeling? Why is it important?
What is the Entity-Relationship model?
What are the differences among a unary relationship, a binary relationship, and a ternary relationship?
Explain and compare the cardinality of a relationship and the modality of a relationship.
Explain the difference between a one-to-one, a oneto-many, and a many-to-many binary relationship.
Can a many-to-many binary relationship have no intersection data? Explain.
Can intersection data be placed in the entity box of one of the two entities in the many-to-many relationship? Explain.
What is an associative entity? How does intersection data relate to an associative entity?
Describe the three cases of unique identifiers for associative entities.
Showing 3100 - 3200
of 3225
First
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Step by Step Answers
Get 50% OFF
Claim Now
