HomeworkLib
Question

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

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

Homework Answers

Answer #1

Here car is the weak entity as it does not have any Primary Key attribute to define it. It depends on Employee and department.

0 0
Add a comment
Know the answer?
Add Answer to:
One company has many departments.  A department has many cars and many employees. An employee can loan...
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

  • ) 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...

  • Pass Task3. Read the following narrative: Jims Gyms have a number of fitness clubs. Each club has a name, establishment date, and a description. Clients (who have an ID and name) can join one or more...

    Pass Task3. Read the following narrative: Jims Gyms have a number of fitness clubs. Each club has a name, establishment date, and a description. Clients (who have an ID and name) can join one or more of these fitness clubs. As a client joins a club, the date that the client joined is to be recorded Draw an ERD based on this information. Expand all M:M relationships. Do not introduce any surrogate keys. The ERD may be neatly hand drawn...

  • Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number,...

    Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and department names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many...

  • The employee is table, the best candidate for primary key is Select one: a. Department ID...

    The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...

  • 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...

  • Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...

    Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and participations. The administrators of Tiny College are so pleased with your design and implemen- tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanc- tioned travel. For example, the...

  • This is about ERD. Question: The Gotham Buildings Department (GBD) is a city agency that tracks...

    This is about ERD. Question: The Gotham Buildings Department (GBD) is a city agency that tracks all the buildings within a metropolitan area in the northeast United States. The GBD maintains data about the location, size, and construction date of each building. It also keeps track of specific renovations made to each building over time, and also demolition of a building, if that occurs. For each building, the GBD keeps data about the building's lot number, which is unique, the...

  • Please note: • This is an assignment about Entity Relationship modeling. It’s not about creating database...

    Please note: • This is an assignment about Entity Relationship modeling. It’s not about creating database using DBMS. The output of this modeling usually shows diagrams and descriptions. • Please use any diagram notations that the textbook ever used. You may use generic drawing tools in office applications, or diagram/flow-chart tool such as MS-Visio to produce ER diagrams. • Please provide appropriate attributes that satisfy the information requirements to all entities and relationships. • Late assignments will be graded down...

  • DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed Apr...

    DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...

  • Actions that damage a company and its employees should be stamped out, everyone would agree. But ...

    Actions that damage a company and its employees should be stamped out, everyone would agree. But should the people responsible be stamped out, too? HBR CASE STUDY The Reign of Zero Tolerance by Ben Gerson "Mr. Pemberton?" manager. The guards had radioed her that the "Yes, that's me," Simon replied distractedly, his back turned. target wasn't putting up much resistance. "Your personal belongings will be messen The two burly gentlemen who had suddenly gered to your home later today," Sallie...

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