EBK USING MIS
10th Edition
ISBN: 9780134658919
Author: KROENKE
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5, Problem 5.14CS5
Explanation of Solution
Justification of the decision to choose the Access instead of spreadsheet:
In this case “Mr. Dean” is processing his data only in a particular area called piano and it is sufficient to store data of one specific topic into a spreadsheet but considering the way of presenting these information in desired way based on the specific choice based on few selection criteria “Mr. D” has chosen to store the contents in the access
If “Mr. D” has decided to use spreadsheet to store his data, he can be view the required data set of the piano only through sorting
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
When it comes to database structure, the Database Approach is the approach of choice in today's commercial world. Explain why this strategy is chosen over the File Approach, citing three reasons.
Is there a way to manage the database developers?
Do you have any specific examples to back up your statement that
many-to-many links cannot be stored in a relational database? Tell us about
them if you have any.
Chapter 5 Solutions
EBK USING MIS
Ch. 5.2 - Prob. 1EGDQCh. 5.2 - Prob. 2EGDQCh. 5.2 - Prob. 3EGDQCh. 5.2 - Prob. 4EGDQCh. 5.2 - Prob. 5EGDQCh. 5.2 - Prob. 6EGDQCh. 5.2 - Prob. 7EGDQCh. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQCh. 5.3 - Prob. 2SAQ
Ch. 5.3 - Prob. 3SAQCh. 5.3 - Prob. 4SAQCh. 5.8 - Prob. 1SGDQCh. 5.8 - Prob. 3SGDQCh. 5.8 - Prob. 4SGDQCh. 5.8 - Prob. 5.1ARQCh. 5.8 - Prob. 5.2ARQCh. 5.8 - Prob. 5.3ARQCh. 5.8 - Prob. 5.4ARQCh. 5.8 - How are data models used for database development?...Ch. 5.8 - Prob. 5.6ARQCh. 5.8 - Prob. 5.7ARQCh. 5.8 - Prob. 5.8ARQCh. 5 - Draw an entity-relationship diagram that shows the...Ch. 5 - Consider the relationship between Adviser and...Ch. 5 - Prob. 5.3UYKCh. 5 - Prob. 5.4UYKCh. 5 - Study Figure 5-28 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-28 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-28 into a...Ch. 5 - Prob. 5.1CE5Ch. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 5.12CE5Ch. 5 - Explain why a one-table database could be stored...Ch. 5 - Prob. 5.14CS5Ch. 5 - Examine the columns in Figure 5-33. Name three...Ch. 5 - Prob. 5.16CS5Ch. 5 - Prob. 5.17CS5Ch. 5 - Explain the statement A database is an abstraction...Ch. 5 - Prob. 5.19CS5Ch. 5 - Prob. 5.2MMLCh. 5 - Prob. 5.21MML
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- QUESTION: Discuss different types of subqueries that are used in database with appropriate example.arrow_forwardDo you have any specific examples to back up your assertion that many-to-many links cannot be stored in a relational database? If you have, we'd appreciate it if you'd tell us about them.arrow_forwardWhat happens if your database doesn't have referential integrity? What mistakes are possible?arrow_forward
- What is the main difference between key-value stores and document stores? How does this difference affect the ability of the database to query data and to create an index?arrow_forwardThe size of a table in a relational database may be reduced by using the select process to remove unnecessary columns.Should I be happy or sad about this?arrow_forwardWhen would it be reasonable to make the assumption that two select statements taken from the same database are consistent with one another? What type of circumstances would warrant such an assumption?arrow_forward
- can you help me with the following database question? I have attached them below.arrow_forwardAre you acquainted with the procedure for adding user data to a database?arrow_forwardWhen it comes to database structure, the Database Approach is the approach of choice in today's corporate world. Consider the following three reasons why this strategy is preferable to the File Approach:arrow_forward
- A select operation in a relational database may prune unnecessary columns from a table, making it more manageable.What do you think?arrow_forwardWhat is normalization? What are some of the problems caused by incomplete or improper normalization of the database?arrow_forwardThe Database Technique is the preferred approach in the business sector nowadays when it comes to database construction. Take into account the following three justifications for why this approach is better than the File Approach:arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education