Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 4, Problem 1P
Explanation of Solution
ER Diagram:
The following figure illustrates the Entity Relationship Diagram (ERD) for given business rules in Crow’s Foot notation:
Explanation:
- The “ASSIGNMENT” entity is optional for the “PROJECT”, because it allows a user to create a new project without creating a new assignment...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
How to make a Crow's Foot ERD for the following: A company has a number of employees. The attributes of EMPLOYEE include Name, Address, and Birth-date. The company also has several projects. The attributes of Project include Project_Code, Description, and Start_date. Each employee may be assigned to one or more projects, or may not be assigned to any project. A project is required to have at least one employee assigned, but may have several employees assigned.
Use the following business rules to create a Crow’s Foot ERD. Present all appropriate connectivities and cardinalities in the ERD.
A department employs many employees, but each employee is employed by one department.
Some employees are not assigned to any department.
A division operates many departments, but each department is operated by one division.
An employee may be assigned many projects, and a project may have many employees assigned to it.
Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. a. A department employs many employees, but each employee is employed by one department. b. Some employees, known as “rovers,” are not assigned to any department. c. A division operates many departments, but each department is operated by one division. d. An employee may be assigned many projects, and a project may have many employees assigned to it. e. A project must have at least one employee assigned to it. f. One of the employees manages each department, and each department is managed by only one employee. g. One of the employees runs each division, and each division is run by only one employee. Given these data requirements, design a logical/relational data model for this company. Use Microsoft Visio for your diagrams. You can add substantial detail to your data model by including sample attributes for each of the entities. Specify primary and foreign…
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - Prob. 11RQCh. 4 - Discuss two ways in which the 1:M relationship...
Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
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
- Use the following business rules to create a Crow’s Foot Entity Relationship Diagram. Write all appropriate connectivities and cardinalities in the ERD. Add other linking entities as needed. • A department employs many employees, but each employee is employed by one department. • Some employees, known as “rovers,” are not assigned to any department. • A division operates many departments, but each department is operated by one division. • An employee may be assigned many projects, and a project may have many employees assigned to it. • A project must have at least one employee assigned to it. • One of the employees manages each department, and each department is managed by only one employee. • One of the employees runs each division, and each division is run by only one employee.arrow_forwardQ1arrow_forwardA company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A). Draw ER Model For the companyB). Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names.C). do you have any associative entities on your ERD? If so, what are the identifers for those associative entities?arrow_forward
- A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A. Draw ER Model For the company B. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. C. to youhave any associative entities on your ERD? If so, what are the identifers for those associative entities?arrow_forwardDesign 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,…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_forward
- To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory : with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and agearrow_forwardCreate an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project's principal investigator). Each project is worked on by one or more professors (known as the project's co- investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project's research assistants). When graduate students work on a project, a professor must supervise their work on the project.arrow_forwardSpecify the degree of this relationship (1:1, 1:M, or M:N): The attributes of employee include ID, Name, Address, and Birth_Date. Employees work on projects. The attributes of project include Project_Code, Description, and Start_Date. Each employee may be assigned to many projects. A project is required to have at least one employee assigned.arrow_forward
- Electronic ERD drawing for these requirements: The ER diagram for the scenario you described would include entities for Services, Employees, and Customers, with relationships connecting them. The relationships would likely include: - A "manages" relationship between Employees and Services, where one employee can manage one service, and one service can be managed by one employee. - A "provides" relationship between Services and Customers, where one service can be provided to one customer, and one customer can receive multiple services. - A "has" relationship between Customers and Bill, where one customer can have many bills, and one bill can belong to one customer. NOTE: No handwriting arrow_forwardCreate an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor (known as the project’s principalinvestigator). Each project is worked on by one or more professors (known as the project’s co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project’sresearch assistants). When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office. Departments have a professor (known…arrow_forwardDirection: Discuss briefly the pyramid interview structure by giving its descriptions/strengths. Also, give a minimum of three(3) questions (in order, based on pyramid structure) if the said structure will be used to interview the operations manager about the system that they are currently using.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 LearningInformation Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning