Question
Making ERD for computer repair company can someone help me draw this out please. Draw me ERD and add attributes with relationships. Add to it
Making ERD for computer repair company can someone help me draw this out please. Draw me ERD and add attributes with relationships. Add to it if you can this is my general idea. I need to see what it would look like
I have different types of USERS for a system.
A USER can be one of the following
CUSTOMER ---> Can only have one ACCOUNT ----> Which may have 0 or more UNITS
REPAIR_TECHNICIAN ----> has access to list of UNITS --> can change STATUS of UNITS ---> Can move UNITS to a different location in the repair shop. Can deduct parts from PARTLIST
SHIPPING ---> can view UNITS and ACCOUNT and add a charge for shipping to ACCOUNT per unit. Only one charge for shipping per unit. can move unit to different location
BILLING----> can view UNITS, PARTLIST, ACCOUNT and edit/add/remove charges
INVENTORY_CONTROL ---> can make full changes to PARTS LIST edit/add/remove/organize
SQUARE TRADE ---> can view ACCOUNT and UNITS. Can request info from BILLING and SHIPPING
MODERATOR ----> can add/remove/edit users in the different groups below moderator can view and edit BILLING, SHIPPING, PARTSLIST , REPAIR_TECHNICIAN work as well as ACCOUNT and UNITS
OWNER ---> Can make changes to whatever they want and view what ever they want
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started