Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
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
Modern Database Management
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_forward3. Do there appear to be any weak entities in the description of the data requirements in this project module? Justify your answerarrow_forwardQ. Write the below image in our own hand by clear writting. and also explain the diagram.arrow_forward
- Design 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 an E-R diagram to model the following situation. Be sure to include in your diagram all the relevant entities, attributes, relationships, functionality (N:1 or N:M) and whether any are mandatory. You can either draw the diagram by hand and submit it as a photograph/scan or you can create the diagram in a program with drawing tools (Word, Powerpoint etc.). Upload your diagram by the deadline. [HINT: There are 3 entities and 2 relationships in the model answer]. A bus depot includes a maintenance section that repairs faulty buses. Each bus is identified by its fleet number, its make, the year it was manufactured and its registration number. When a vehicle breaks down, a report is submitted describing the nature of the problem and the time when the incident occurred. These reports are consecutively numbered as they are received and include the time when the bus was returned to the depot for repair. One or more mechanics fix the bus. Mechanics are identified by their staff number,…arrow_forwardWhen you are constructing the framework, it is important to keep possible roadblocks in mind and to be specific about the kind of issues that you anticipate facing. So, anything. What, precisely, is the significance of this?arrow_forward
- Draw 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_forwardcan you help me with my assignment?arrow_forwardDescribe the stages of the prototyping process, from concept generation to final validation. What are the critical challenges at each stage?arrow_forward
- Develop a cross-reference grid to compare the communication and collaboration tool requirements with the features available within the application. In this grid, it is expected that the x-axis should include functional requirements that you identify from the assignment, while the y-axis should include at least five tools that are evaluated through this assignment. In addition to your completed grid, include a short reflection summarizing your evaluation of the tools and proposing an effective tool for the scenario.arrow_forwardDefine possible issues when you are developing the framework, and then take into account potential roadblocks as you are putting your answers into action. No matter what. Is there any significance to this at all?arrow_forwardSketch ER Diagramarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY