Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
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 solutionStudents have asked these similar questions
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
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,…
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,…
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
- I need help with creating Activity Diagram and Sequence Diagram for the below Use Case Diagram. Please provide Diagrams as well as an explanation.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_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_forward
- 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)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_forwardTask A: You have to use the same information system and business processes identified and used in assignment 1 to solve the below sub tasks. 1. Using a suitable diagram, explain how a structured design technique can be applied to your proposed system. The diagram must include higher level (one) and lower-level modules (three) to show the process of decomposition,arrow_forward
- Define 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_forwardPlease elaborate on the requirement engineering processes of elicitation, specification, and validation. Test out a few different approaches to collecting criteria.arrow_forwardDraw the following diagrams to depict the scenario towards the development of the system:i. Flowchartii. The Context Level Diagramiii. Entity Relationship Diagramiv. Data Flow Diagram for FOSCO specifying the key attributes of eachentity type, and the structural constraints on each relationship type.v. Use case diagram for the case.arrow_forward
- The topic in question is The Complexities of Drone Agriculture Draw a context diagram and Level1 and Level 2 Data Flow Diagram (DFD) and Data Dictionary of Level 1 and 2, of your assigned project. Deduce a Structure Chart Diagram from your project DFD diagrams using transform or transaction analysis. Draw Unified Modified Language (UML) Use Case Diagram, Class Diagram, Object Diagram, Sequence Diagram, Activity Diagram and State Chart Diagram of your assigned project.arrow_forwardProvide a numbered list of all of the items in your IT project that must be tested. You may want to organize your list with headings or groupings of testing type for clarity. For each item that is on your list, indicate whether the test to be performed is Unit Testing, Integration Testing, System Testing, or User Acceptance Testing. The testing items are specific to your IT project and must directly relate. This assignment is not about defining the types of testing and should not include citations. It must be 100% original work that ties back directly to your specific IT project.arrow_forwardDefine potential issues when you are developing the framework, and after that, take into account any roadblocks as you are putting your answers into action. In any case. Does it make a difference or does it not?arrow_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 EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable 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