Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
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
Do you have any examples to back up your assertion that many-to-many links cannot be provided by a relational database? Please share them with us if you do.
can you help me with the following database question? I have attached them below.
Indicate the changes you need to make to the design of the BITS database to support the following situation.A client is not necessarily represented by a single consultant but can be represented by several consultants.
Chapter 5 Solutions
Using MIS (10th Edition)
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
- Are you acquainted with the procedure for adding user data to a database?arrow_forwardWhen do we call something an anomaly? Did a database contain three outliers that were particularly unusual? Examine the issues that have arisen because of the anomalies you've discovered, and provide a solution to those issues.arrow_forwardDo you have any instances to support your claim that a relational database cannot provide many-to-many connections? If so, please share them with us.arrow_forward
- 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.arrow_forwardDo you have any instances to back up your claim that a relational database cannot provide many-to-many connections? If so, please share them with us.arrow_forwardGive some instances of how you would utilize the data dictionary to monitor the security of the database, using SQL statements to demonstrate your point.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_forwardIs there anything more difficult in database design than dealing with time-varying data? If that's the case, how would you approach the situation?arrow_forwardIs there anything more challenging than dealing with data that changes over time when it comes to the architecture of databases? In the event that this is the case, how would you recommend dealing with the situation?arrow_forward
- The following action is being done by both database users and database creators:arrow_forwardGive an explanation as to why a relational database cannot enable many-to-many connections, and offer an example to back up your argument.arrow_forwardDo you have any instances to back up your claim that a relational database is incapable to provide many-to-many connections? If so, please share them with us. In the event that this is the case, please do not hesitate to share your results with us.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