Experiencing MIS
8th Edition
ISBN: 9780134792736
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5, Problem 13CS
Explanation of Solution
Justification for the decision to choose 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 this information in desired way based on few selection criteria , Mr. Dean” has chosen to store the contents in the access
database . - If “Mr. Dean” has decided to use spreadsheet to store his data, he can be view the required data set of the piano only through sorting
mechanism. - It is unable to view the data of his required choice.
- But if “Mr...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Can you offer any in-depth analysis of the database's file structure?
Do 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.
Could you please explain the main parts of the database?
Chapter 5 Solutions
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQCh. 5 - Prob. 6EGDQ
Ch. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 5 - Prob. 1ARQCh. 5 - Prob. 2ARQCh. 5 - Prob. 3ARQCh. 5 - Prob. 4ARQCh. 5 - Prob. 5ARQCh. 5 - Prob. 6ARQCh. 5 - Prob. 1UYKCh. 5 - Prob. 2UYKCh. 5 - Prob. 3UYKCh. 5 - Study Figure 5-17 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-17 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-17 into a...Ch. 5 - Prob. 9CECh. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 11CECh. 5 - Prob. 12CSCh. 5 - Prob. 13CSCh. 5 - Prob. 14CSCh. 5 - Prob. 15CSCh. 5 - Prob. 16CSCh. 5 - Prob. 17CSCh. 5 - Prob. 18CSCh. 5 - Prob. 19MMLCh. 5 - Prob. 20MLM
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
- 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_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_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_forward
- A select operation in a relational database may prune unnecessary columns from a table, making it more manageable.What do you think?arrow_forwardThe DBA asks for your help in planning not the data archive (not backup) for the following BITS database: Determine which data from the database to archive; that is, for each table, specify whether data needs to be archived. If it does, specify which data, when it should be archived, and whether it should be archived with data from another table.arrow_forwardHow do you know whether database-as-a-service (DBaaS) is the best option for your library?arrow_forward
- What happens if your database's referential integrity is not enforced? Are there any common mistakes?arrow_forwardWhen would it be reasonable to make the assumption that two select statements drawn from the same database are consistent with one another? What type of circumstances would warrant such a reasonable assumption?arrow_forwardIn relational database storage, what are the pros and drawbacks of the following options? Keep each relationship in a separate file.arrow_forward
- Please help me answer these three questions regarding Oracle database. All are T or F. Explanation is much appreciated as well. Group functions do ignore NULL values Multiple row functions works on each records one by one and they return one result per each record Multiple row functions works on group of records all at once but they also return one result per each data setarrow_forwardExplain the concept of database indexing. How does indexing improve query performance? Discuss different types of indexing methods and when to use them.arrow_forwardWhat problems might arise if your database does not have proper referential integrity? What errors are possible?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 Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable 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