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
Videos
Textbook Question
Chapter 5, Problem 5.8CE5
Discuss the advantages and disadvantages of the model you created in your answer to question 5-7 and the model in Figure 5-28.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What are the key components requested in the model shown in figure 2
Study the details below and create ERD diagram for each question below.
Drone / Video: a Drone may take many Videos; a Video is taken by one Drone.
A Video instance is optional for a Drone; a Drone instance is required for a Video.
A Facility may be recorded by many Videos; a Video records one Facility.
A Video instance is optional for a Facility; a Facility instance is required for a Video.
A Video may be the basis of many Analyses; an Analysis is based on one Video.
An Analysis instance is optional for a Video; a Video instance is required for an Analysis
Using a diagram, explain the prototype model. What are the benefits, drawbacks, and applications of this model?
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
- Suppose you are working within the framework of the conceptual model in Figure Q4.5. FIGURE Q4.5 THE CONCEPTUAL MODEL FOR QUESTION 5arrow_forwardProvide an analysis of the pros and cons of each model and specify the additional or omitted steps that you think might improve its performance.arrow_forwardExplain the benefits and drawbacks of each model, as well as the step(s) that you believe should be added or removed in order to make each model more effective.arrow_forward
- Based on the provided information below, what is the ERD Diagram to this fictional senerio that includes its primary key and attributes?arrow_forward2. Consider the ER diagram on the next slide. (i) What is the key of entity set A (ii) What is the key of entity set B (ii) What is the key of entity set C Be sure to explain how you got your answers. b2 b3 a2 a3 b1 a1 a4 b4 A B R1 1 1 c1 c2 c3 c5 c4 N R2arrow_forwardUsing the ERD diagram above, identify an attribute that might represent a Derived Attribute. Once you identify, explain why this is so. Is this the only attribute? Are there others?arrow_forward
- Please draw the ER diagram. Explain how you know which one is entity, attribute, and all constraints. Explain each step of the diagram.arrow_forwardProblems 1 and 3 on pages 234 - 236 of the course textbook. You must use Draw.IO or MS Visio to complete this case study.Create an ER diagram Explain all normalization issues that exist in the ER Diagram. I want the ER Diagram before normalization and after normalization. Explain all normalization problems that you corrected between the first and second ER diagram. Normalize the data in the ER Diagram to 3NF See the video for a demonstration on how to do this: https://www.youtube.com/watch?v=Nq91b4TQ29Q Create a dependency diagram using the information from your ER diagram. See the video for a demonstration on how to do this: https://www.youtube.com/watch?v=wFOJnRxqrp8 You must label all determinants and dependencies. Note: You must convert your DrawIO files to .jpg, gif or bmp images before you upload the assignment to Canvas. Copy and paste all diagrams into an MS Word document. Please make sure that you enlarge all diagrams so they can be easily…arrow_forwardDraw this ER Diagram, but note that: Ths diagram should adhere to compressed Chen notation : The ER diagram consists of four entities: Pet, Challenge, User, and Vote. The Pet entity has attributes such as id (primary key), name, species, age, and description to store information about each pet profile. The Challenge entity has attributes such as id (primary key), pet1_id and pet2_id (foreign keys referencing the Pet entity), start_date, end_date, and likes to store information about each challenge between two pets. The User entity has attributes such as id (primary key), name, and email to store information about users who participate in voting and challenge creation. The Vote entity has attributes such as id (primary key), challenge_id (foreign key referencing the Challenge entity), user_id (foreign key referencing the User entity), and vote to store information about user's vote for a particular challenge.arrow_forward
- Provide guidelines for naming and defining relationships in ER-Model.arrow_forwardFor each entity, there needs to be an indication of whether it is one-to-one, one-to-many or many-to-many relationship. Here are the answers I have but I could use more guidance with it. I struggle with this type of question. BOOK and BOOK COPY (1:1) COURSE and COURSE-SECTION (M:N) COURSE-SECTION and ROOM (M:1) INSTRUCTOR and COURSE (1:M) ROOM and INSTRUCTOR (M:1)arrow_forwardGiven the ER diagram above, answer the following questions: a. Name an entity type that has more than 2 relationships. b. Name one ket attribute and the entity type it belongs to. c. Name one one-to-one relationship and the entity types it relates. d. Name one many-to-many relationship and its entity types. e. Name one relationship attribute. f. What is the cardinality of relationship ‘employs’? g. What is the cardinality of relationship ‘textUsed’? h. Name one weak entity type i. Does it have a partial key? If yes, name it. ii. Name its identifying entity type iii. Name its identifying relationship Question 2 A bank provides services to customers. The banks is identified by its code and has a name and an address. The bank has several branches. A branch is identified by its code that is unique for a given bank. The branch name and address are also stored in the database. Customers deal with the bank through the bank branches. So, a customer belongs to a specific bank branch. Customers…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database 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
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