enter image description here
Create a database design for a Car-Motorcycle Repair Shop by creating an ERD Crow’s Foot Notation and Relationship Table, with the following conditions:
- Analyze the entity and relate the results to the purchase receipt at the motorbike repair shop.
AHASHH Jaya Mobil Subang Tel: (0260) 41122
Mechanic ID Customer Name
PURCHASE NOTE
Isabella Swan AP.
Vehicle Police No
: B 33 LA,
: Car
Nama Part
Quantity
Price
Amount
Light
2
Rp. 125,000 Rp. 250,000
Full Service
1
Rp. 1,500,000 Rp. 1,500,000
Total
Invoice No. Date: 022200519: 05/20/2019
Rp. 1,750,000
- The system coverage includes:
a. Spare parts sales
b. Repair services
c. Procurement of spare parts
d. Payment of debt to suppliers (can be in several terms)
e. Mechanic payroll
Note: the mechanic’s salary component consists of food & transport allowance and repair services performed
f. Please add assumptions/other information if necessary
Lord Dexter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.