Solutions Manual for A Practical Guide to Database Design, 2e By Rex Hogan (All Chapters)

Solutions Manual for A Practical Guide to Database Design, 2e By Rex Hogan (All Chapters) Chapter 1 Questions 1. Do you consider MYSQL to be a Relational Database System? Why or why not? ANS: Frankly, either a Yes or NoSolutions Manual for A Practical Guide to Database Design, 2e By Rex Hogan (All Chapters) Chapter 1 Questions 1. Do you consider MYSQL to be a Relational Database System? Why or why not? ANS: Frankly, either a Yes or No is acceptable if justified appropriately. I personally don’t consider MQSQL to be a RDBMS. Each table is implemented in its own flat file. If a new column is added, the original file is copied into a new file having the additional column. This, in my opinion, does not meet the criteria of being able to dynamically make changes while the table is being used. Those saying Yes could base that judgement on its ability to respond to SQL queries. 2. In the context of a database transaction, what is a “unit of work”? Why is it important? ANS: A “unit of work” is a series of updates to the database that are guaranteed to either succeed as a group, or all be reversed should some error or problem occur. It is important because the database will always contain