HomeworkLib
Question

) Identify the ERD components from the given scenario. A company has several departments. Each department...

) Identify the ERD components from the given scenario. A company has several departments. Each department has a supervisor and at least one employee. Employees must be assigned to at least one, but possibly more departments. At least one employee is assigned to a project, but an employee may be on vacation and not assigned to any projects. The important data fields are the names of the departments, projects, supervisors and employees, as well as the supervisor and employee number and a unique project number. ANSWER: • Entities: • Attributes:

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
) Identify the ERD components from the given scenario. A company has several departments. Each department...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

    Exercise 1: ERD Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. A department employs many employees, but each employee is employed by only one department. Some employees, known as "rovers," are not assigned to any department. A division operates many departments, but each department is operated by only 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...

  • ERD requirements: In your ERD*, you must include: • All entities and the relationships among them;...

    ERD requirements: In your ERD*, you must include: • All entities and the relationships among them; • Reasonable attributes for each entity; • Notations of all PKs and FKs • Cardinalities for each relationship. ERD Cases: Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have been told to use in the course. A laboratory has...

  • Project Database Description After the requirement collection and analysis phase the software project of a database...

    Project Database Description After the requirement collection and analysis phase the software project of a database application about a company is described as follows: The company is organized into departments. Each department has an unique name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have multiple locations(cities). A dept controls a number of projects, each of which has a unique...

  • Create a complete ERD for the problem described in problem ch team those cond Identif ....

    Create a complete ERD for the problem described in problem ch team those cond Identif . Identify . Identif . Identif PLAY . Draw . Draw Part 2 Design Concepts blems 1. Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD . A department employs many employees, but each employee is employed by only one department Some employees, known as "rovers," are not assigned to any department. . A...

  • One company has many departments.  A department has many cars and many employees. An employee can loan...

    One company has many departments.  A department has many cars and many employees. An employee can loan his/her department’s car for a business trip.  Every department needs to keep track the car rental history including “start date”, “return date”, “start mileage”, and “end mileage”.  Design an ERD based on above requirements.  Please identify (strong and weak) entities, attributes, and (identifying and non-identifying) relationships clearly

  • 10. For each employee in the department with code ACCNT, find the employee ID and number...

    10. For each employee in the department with code ACCNT, find the employee ID and number of assigned hours that the employee is currently working on projects for other departments. Only report an employee if she has some current project to which she is assigned more than 50% of the time and the project is for another department. Report the results in ascending order by hours. 11. Find all departments where all of their employees are assigned to all of...

  • University Scenario Draw a detailed ERD with primary keys, foreign keys, and all provided attributes. If...

    University Scenario Draw a detailed ERD with primary keys, foreign keys, and all provided attributes. If none are given in the scenario, provide at least one additional attribute for each entity. Scenario: When a person applies for a classified staff position at a large university in the Seattle area, information about that person, including his or her social security number, name, address, and phone is stored. People applying for classified staff positions do not apply for a specific job, but...

  • A relational database is to be designed for a medium sized Company named Global Support Solutions (GSS) dealing with ind...

    A relational database is to be designed for a medium sized Company named Global Support Solutions (GSS) dealing with industrial applications of computers. The Company delivers various products to its customers ranging from a single application program through to complete installation of hardware with customized software. The Company employs various experts, consultants and supporting staff. All personnel are employed on long-term basis, i.e. there are no short-term or temporary staff. Although the Company is somehow structured for administrative purposes (that...

  • you are required to develop a simple HR application for a small accounting firm that wishes...

    you are required to develop a simple HR application for a small accounting firm that wishes to keep track of all the employees at the firm; storing details about their salary, phone numbers and Date of Birth. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe...

  • Create an ERD using Lucid Chart for the following description. Be sure to include all necessary...

    Create an ERD using Lucid Chart for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. Don’t forget foreign keys. You have been asked to build a database for a technology company called TechNow. The company owner needs to keep track of the customers that buy their products, the employees that work at TechNow, the offices that the employees use, the vendors that provide them with products, and the products themselves....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT