Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 2, Problem 2.27PAE
You may have been assigned a CASE or a drawing tool to develop conceptual data models. using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter? What E-R notations did not translate well to your tool? How did you incorporate the E-R notation that did not directly translate into the tool's notation?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Explain prototype model with diagram. What are the advantages, disadvantages and use of this
model.
Describe each and every step about diagram, clearly ?
Create a conceptual model
In your conceptual diagram, you need
to show all the relationships and data
types apply (include all the entities from
the case study above)
Chapter 2 Solutions
Modern Database Management (12th Edition)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQCh. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Prob. 2.12RQCh. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - For each of the descriptions below, perform the...Ch. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - The entity type STUDENT has the following...Ch. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Prob. 2.35PAECh. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
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
- Data modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardData modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardThe Model-View-Controller design pattern partitions data access from business logic, data presentation from user interaction, and user interaction from data presentation. Moreover, it also partitions data presentation from user interaction. In this discussion or explanation, discuss or offer.arrow_forward
- Data Preparation Describe what you did with the data prior to the modelling process (data cleaning). Show histograms of the one example variable before and after any pre-processing that you carried out. If you corrected any mis- typed entries in the data, report what you changed. Carry out descriptive analysis and explain each what they represent, use as many graph as possible and provide the descriptionsarrow_forwardUsing a clear picture, describe the iterative process of calibrating a model.arrow_forwardWhat is the anticipated modeling approach for each given model, and why is it chosen?arrow_forward
- With all of those applications that we can use to create a complete block diagram from a high level overview into a super detailed block diagram (which is called the Schematic Diagram).Which application or software tool do you prefer in creating a block diagram? and Explain Why? (Is it user friendly? Much efficient? Does have more features? Easier to navigate?arrow_forwardUsing a diagram, explain the prototype model. What are the benefits, drawbacks, and applications of this model?arrow_forwardMake a diagram or figures that shows high cohesion and loose coupling.arrow_forward
- The Model-View-Controller design pattern separates data access from business logic, data presentation from user interaction, and user interaction from data presentation. Discuss or provide an explanation.arrow_forwardHow should a decent data flow diagram be created?arrow_forwardPlease provide a description of the best practices for developing excellent data-flow diagrams.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 LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher: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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY