Pearson eText for Modern Database Management -- Instant Access (Pearson+)
13th Edition
ISBN: 9780137305940
Author: Jeffrey Hoffer, Ramesh Venkataraman
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 1, Problem 1.45PAE
Consider the project data model shown in Figure 1-16
- Create a textual description of the diagrammatic representation shown in the figure. Ensure that the description captures the rules/constraints conveyed by the model.
- In arriving at the requirements document, what aspect of the diagram did you find was the most difficult to describe? Which parts of the requirements do you still consider to be a little ambiguous? In your opinion, what is the underlying reason for this ambiguity?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
I'm designing an ER diagram for a project and I have to represent an entity called User, with the attributes: Username, Password and Role.
But the role contains (Supervisor and Farmer)
My question is should role be a multivalue property (attribute) or should it be two separate entities?
Either way, how would it be represented in the ER diagram? (if it was an attribute or two entities)
Design the Entity Relationship Diagram (ERD) showing entities, attributes, primary key and relationship cardinality for the
following scenario.
Any employee works for only a department and under supervision of a manager (where manager is also an employee).
Employee's address, city code & city name also has been recorded. Every employee may work for multiple project, but an
employee may be on vacation and not assigned to any projects. Working hour may be different for an employee for
different projects. Projects are broken into tasks; A task is created for one project and assigned to one department.
Requisitions are made for projects; Each requisition could ask for any number of items; Items could be: equipment item
or materials item and are coded in a similar way; Each requisition is for one project and is made to one supplier.
The important data fields are employee_id, employee_name ,employee_address, employee_email, department_id,
department_name, location, city_code, city_name,…
In this phase each student will select a real life problem that can be solved using database systems. Once you pick your project, start by writing a small description no more than 1 page to explain the project description. In this phase a project description is required only.
In this 2ND phase all you have to complete is preparing the UML diagram for the project that you have selected in Phase I
Chapter 1 Solutions
Pearson eText for Modern Database Management -- Instant Access (Pearson+)
Ch. 1 - Prob. 1.1RQCh. 1 - Prob. 1.2RQCh. 1 - Prob. 1.3RQCh. 1 - Prob. 1.4RQCh. 1 - Prob. 1.5RQCh. 1 - Prob. 1.6RQCh. 1 - Prob. 1.7RQCh. 1 - How are relationships between tables expressed in...Ch. 1 - What does the term data independence mean, and why...Ch. 1 - Prob. 1.10RQ
Ch. 1 - Prob. 1.11RQCh. 1 - Prob. 1.12RQCh. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Prob. 1.15RQCh. 1 - Prob. 1.16RQCh. 1 - Prob. 1.17RQCh. 1 - Prob. 1.18RQCh. 1 - Prob. 1.19RQCh. 1 - Prob. 1.20RQCh. 1 - Prob. 1.21RQCh. 1 - Prob. 1.22RQCh. 1 - Prob. 1.23RQCh. 1 - Prob. 1.24RQCh. 1 - Prob. 1.25RQCh. 1 - Prob. 1.26RQCh. 1 - Prob. 1.27PAECh. 1 - Prob. 1.28PAECh. 1 - Prob. 1.29PAECh. 1 - Prob. 1.30PAECh. 1 - Prob. 1.31PAECh. 1 - Prob. 1.32PAECh. 1 - Great Lakes Insurance would like to implement a...Ch. 1 - Figure 1-22 shows an enterprise data model for a...Ch. 1 - Prob. 1.35PAECh. 1 - Prob. 1.36PAECh. 1 - Prob. 1.37PAECh. 1 - Prob. 1.38PAECh. 1 - Prob. 1.39PAECh. 1 - Prob. 1.40PAECh. 1 - Prob. 1.41PAECh. 1 - Prob. 1.42PAECh. 1 - Prob. 1.43PAECh. 1 - Prob. 1.44PAECh. 1 - Consider the project data model shown in Figure...Ch. 1 - Answer the following questions concerning Figures...Ch. 1 - Prob. 1.47PAECh. 1 - Helen Jarvis wants to determine the most important...Ch. 1 - In this chapter, we described four important data...
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
- Please elaborate on the requirement engineering processes of elicitation, specification, and validation. Test out a few different approaches to collecting criteria.arrow_forwardDesign a system to track advance payments made to employees. Use uml diagrams and design patterns in this system. The design steps will be as follows. Step 1 - Prepare an analysis document on the given topic. Step 2 - Create a Use case diagram for your requirement that contains at least 3 actor, 10 use case and use all relationship type Step 3 - Create an activity diagram for requirement Step 4 - Create a class diagram for all requirement that contains at least 10 class, necessary relations and types. Add the important attributes of the classes to the model. Step 5 - Use three design patterns, at least one creation, one structural, and one behavioral pattern, integrated into your classroom design. Step 6 - Code one of the design patterns you use with java. Note: The design should be homogenate. Excessive usage of any property type, object type, or function type is not suitable. For example, for creating 10 relations between classes, the number of relation types for aggregation,…arrow_forwardDraw ER diagram for the following upload the diagram ?? A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A. chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.arrow_forward
- Please show me the EER schema diagram as well as the documentation report. Here is more information for the diagram and documentation report. The EER diagrams for your designs as well as documentation describing any assumptions you made, and the reasons for your design choices. Draw the EER diagrams using the notation in the textbook. You can use any drawing tool for drawing your diagrams.arrow_forwardAs a part of using the six-step process for the development of the EA, the architects need to focus on the data types required. Which step of the six step helps in retrieving this information. Discuss in detail.arrow_forwardSketch ER Diagramarrow_forward
- Please Design an Entity Diagram for the following Fictional Scenario using entities: SEASON, LEAGUE, DIVISION, CLUB and TEAM. Also, please show the relationship type and datatype. Thank You!arrow_forwardas a continuation of the problem in the screenshot Create an activity diagram for requirementarrow_forwardThis week, we’ve been discussing relationships on use cases. Relationships in a use case diagram are a powerful mechanism to organize and reuse requirements. For this week’s Critical Thinking activity, create three diagrams with examples for a scenario of your choosing: actor-actor actor-use case, and use case-use case. Provide a 1-2 page overview and analysis of your diagrams, noting the relationships between them.arrow_forward
- Draw the Context Level and DFD Level 1 Diagram for the case-study below.arrow_forwardEntity Relationship Diagram Can you make changes because I think I made some mistakes while working on these entitties and implement the relationships of this ERD? (see attached photo)arrow_forwardb) An ER/EER diagram modeling your database (use appropriate symbols, and don’t forgetassociative entities where appropriate). This will be based on the business rules you created, somake sure you’ve written clear rules! (30 points)• Feel free to use an appropriate design tool you would like for your ER diagram (e.g.http://draw.io), or do it by hand and scan it in; just make sure it is legible and that itfollows the notation/style taught in class. Do NOT use other styles, such as “Visio”notation that includes PK/FK.c) A list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. (30 points)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
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
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