Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need ER diagram of this, database management system Mobile Repair Shop Database System MobRepair is a mobile repair shop located in Bahrain. You are

i need ER diagram of this, database management system
image text in transcribed
image text in transcribed
Mobile Repair Shop Database System MobRepair is a mobile repair shop located in Bahrain. You are to develop a mobile repair management system (MRMS) to help them improve the performance of the current situation and overcome the problems that arise nowadays. Currently, MobRepair uses manual system to record their customer and other business information. A customer drops off his malfunctioning mobile and asks for its repair. The employee records the request and writes a brief description of the problem. When the mobile is fixed the customer is called to pay and collect his/her mobile. Design a database system for a Mobile Repair Shop. When customers bring their mobiles in to be repaired, they make a deposit on the repair job and are given a date to return and take their mobile. Employees then perform repairs on the customers' mobiles based on the repair job and detail the labor costs and the items used for each repair job. This repair shop is specialized only on repair of smart mobile phones. Total costs of each service consists of cost of used parts, cost of specific repair and repairman's hourly rate. When customers return they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and take the repaired mobiles using this payment receipt. ER and database tables: To get you started with of the project, assume that the designer of the database has come up with an appropriate ER diagram. A suggested set of tables are given below. Note that you may need to add more tables or add more fields to have a more logically related functioning database system. For example, we need to keep track of which repair job is done by a given employee in the shop. hours

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_2

Step: 3

blur-text-image_3

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

Master The Art Of Data Storytelling With Visualizations

Authors: Alexander N Donovan

1st Edition

B0CNMD9QRD, 979-8867864248

Students also viewed these Databases questions

Question

Describe the sources of long term financing.

Answered: 1 week ago

Question

b. What groups were most represented? Why do you think this is so?

Answered: 1 week ago