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
Textbook Question
Chapter 5, Problem 5.15CS5
Examine the columns in Figure 5-33. Name three characteristics of pianos that are not represented in this table.
- a. If you were a consultant advising Dean, what criteria should you and he use in deciding whether to include that additional data?
- b. Is this
database a model of an inventory of pianos, or is it a model of Dean’s model of an inventory of pianos? Explain the difference.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use the database tables shown to answer Problems (a) to (d) below.
a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.
b) Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. [6 Points]
c) Create the relational diagram to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC
d) Create the Crow’s Foot ERD to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC.
Consider the employee database of Figure 2.17. What are the appropriate primary keys?
Suppose that we have to create a database for a car dealership.
Identify 2 entities
How the entities you identified are related?
write the business rule
create the crow's foot diagram as well as the Chen model diagram.
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
- What exactly is a database relationship? With the use of examples, define Cardinality and Modality of a Relationship.arrow_forwardIn the realm of database administration, normalization is a major concern. Whether your job title is DBA, DA, or all three, this is a must-have tool. From your vantage point, what are some of the most crucial considerations that must be made before the normalization phase begins?arrow_forwardcan you help me with the following database question? I have attached them below.arrow_forward
- Where do data characteristics and data items stand in relation to one another? How does scope apply to an attribute?arrow_forward8. List all of the attributes of a movie. 9. According to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why, or why not? 10. Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why, or why not?arrow_forwardPlease help me with this SQL database diagram and correct if you think something is wrong here you can use paper to explain this database model connecting all these entities using primary and foreign key also explain relationship between them.arrow_forward
- How would you explain the benefits of having a data model to someone who designs databases?arrow_forwardFor this discussion, think of two different databases used by two different types of businesses. Consider and compare the data characteristics and relationships used in each of the two databases and explain how and why the database characteristics, entities, and relationships would be different. Also explain how and why the database characteristics, entities, and relationships would be similar.arrow_forwardDraw the ER-Diagram for the following database schema. Specify the types of relationships in detail on the diagram. Customers {Customer_ID, C_Name} Employees {Employee_ID, E_Name} Orders { Order_No, Customer_ID , Employee_ID, } Order_Details {Order_No, Product_No} Products {Product_NO, Product_Name}arrow_forward
- Given the following business scenario, create a Crow’s Foot ERD usinga specialization hierarchy if appropriate for this case study. The Database is for a railway reservation system which facilitates thepassengers to enquire about the trains available on the basis of source and destination,booking and cancellation of tickets, enquire about the status of the booked ticket, etc.The database is for maintaining the records of different trains, train status, andpassengers. The record of train includes its number, name, source, destination, and dayson which it is available, whereas record of train status includes dates for which ticketscan be booked, total number of seats available, and number of seats already booked. Passengers can book their tickets for the train in which seats are available. For this,passenger has to provide the desired train number and the date for which ticket is to bebooked. Before booking a ticket for a passenger, the validity of train number andbooking date is…arrow_forwardHow are relationships between entities represented in the relational data model?arrow_forwardAn attribute is a characteristic or property of an entity. If person is an entity, would the same attributes be used to describe a person in different databases that store medical, student, and fitness club data? Why or why not?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY