Experiencing MIS
8th Edition
ISBN: 9780134792736
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 17CS
Explanation of Solution
Explanation of the statement:
A
Ways in processing abstraction is more effective than examining the pianos:
- Considering this case, the database is considered to be the abstraction of actual inventory of pianos that “Mr. Dean” contains.
- Use of database is far convenient to process the property of “Mr. Dean” that is the pianos that are present at different locations and those data can be handled in an easier way because it will provide accurate results when processing the database contents which are present at different locations.
- “Mr. Dean” stored most of pianos at different locations and that information at stored in the database...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Design a representation of the data in terms of entities , attributes and relationships between entities . Construct an E - R diagram to depict this representation . Show the cardinalities and all necessary information . Draw the solution on a piece of paper . Add your name and Upload you file here . You are asked to design a database for a sales company which needs to keep track of its sales orders in addition to employees ' information . 1- The company has salespersons . For each Salesperson , we need to know his ssn , name , date of start at work , address and phone number.2- A sales person plays the role of an agent for customers.3- A customer has only one agent , but the same salesperson can be an agent for several customers . Customers are identified by their emails . The company also stores a customers ' name , address , phone number and birthdate . 4- Customers place orders . Each customer can place many orders . 5- Orders are identified by their serial number , issuance date…
Draw a clear and complete ER diagram
Do you have any evidence to support your claim that many-to-many relationships cannot be supported by a relational 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
Similar questions
- The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardUsing a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardIn the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?arrow_forward
- What are the benefits of adopting one data model for conceptual and logical design rather than two separate models, or one model for each? Which database models, such as the E-R and relational database models, are some examples?arrow_forwardDo those who design databases need to be aware of any specific approach that, depending on the context in which it is used, may have the potential to have a significant impact on the efficiency with which a database performs?arrow_forwardSeveral advantages may be gained by switching to a hierarchical database structure from a relational one.The question at hand is whether or not the aforementioned assertion holds water.arrow_forward
- In what ways is it better to use the same data model for both conceptual and logical design, instead of two separate models for each? Many different types of database models are used, like the E-R and relational database models.arrow_forwardWhat are the advantages of using the same data model for both conceptual and logical design as opposed to two distinct models, as opposed to using two different models? What are some examples of database models such as the E-R and relational database models?arrow_forwardRead the description below and identify the tables, columns, primary key, foreign keys, and composite foreign keys that would be needed to create this database system using the logical model concept. A company sells books on the web and can deliver them to all of North America. It needs a system to manage sales and keep track of customer information, the books the customer bought and how much each customer paid for per book. A customer can purchase multiple books in a single transaction. Create the model using the necessary tables, columns and relationships. Tip: You need at least 4 tables for this model.Feel free to explain or take notes on your diagram.What matters for this question is not the number of tables and columns, but rather the logic you use when developing the model. You must represent it by respecting the following textual notation. Table name: is represented by the first word in capital letters in front of the parentheses. i.e. TABLE ();Columns name: are inside the…arrow_forward
- Database is defined as organized collection of logically related data. Explain “Logically Related” with two instances of the entity student. Detailed answer please. I will like correct and detailed. Thank you!arrow_forwardCreate an ER diagram based on the picture thank uarrow_forwardHow does the "bottom-up" approach to database design differ from the "top-down" approach?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning