Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions