Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a databse and all the required tables using mysql or SQL server with the following requirement and insert data into the tables: Create tables

Create a databse and all the required tables using mysql or SQL server with the following requirement and insert data into the tables:

Create tables like invoice table , technician table , computer center table, spare parts or items table, repair type table , job sheet table. like this just think on different entities and create the databse schema for the below requirement.

The owners of a small computer repair shop would like to keep track of the repair jobs for computers they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job.

When customers bring their computers in to be repaired, they make a deposit on the repair job and are given a date to return and pickup their computer. Repairmen then perform repairs on the customers computers based on the repair job, and detail the labor costs and the items used for each repair job.

When customers return they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and pickup the repaired computer using this payment receipt.

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

More Books

Students also viewed these Databases questions