Simple ER Diagram

Draw 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. ER Diagram can be in MS Word.

[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, name and qualifications. The time when each bus is ready for service after repair is recorded and also the time spent by each mechanic on each repair job.

Steps for constructing Entity-Relationship diagrams

ER Diagrams...

1. Identify the entities and relationships in the English description.

2. For each entity draw and label a rectangle

3. For each relationship draw and label a diamond between the appropriate entities

4. Link the relationships to the entities using straight lines

5. List the attributes of each entity (and, if applicable, relationship)

6. Identify the key attribute for each entity

7. Label the links with the functionality of the relationship (1:1, 1:N or N:M)

8. Work out the membership class of each entity in each relationship (optional or mandatory)

Evner: SQL, Database Design

Se mere: design diagram following situation doctors prescribe drugs patients, e r diagram, e/r diagram, E-R diagram, coding, draw e-r diagram and convert it into a relational schema, draw er diagram online, e-r diagram to sql example, e-r diagram for online movie ticket booking system, draw er diagram for the following scenario, draw the er diagram for the given scenario, simple er diagram for company database, how to draw er diagram in microsoft word, draw er diagram, er diagram for e commerce website pdf, how to draw er diagram, e-r diagram of hospital with a set of patients and medical doctors, design and draw an er diagram that captures the information about the university, draw er diagram online free, draw.io er diagram, er diagram for e healthcare system

Om arbejdsgiveren:
( 1 bedømmelse ) London, United Kingdom

Projekt ID: #31627206

Tildelt til:


Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link https://www.freelancer.com/u/hoaxuy Flere

₹1700 INR på 1 dag
(16 bedømmelser)

3 freelancere byder i gennemsnit ₹2067 timen for dette job

(8 bedømmelser)
(2 bedømmelser)