Create a databse and all the required tables using mysql or SQL server with the

Question

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.

Explanation / Answer

Tables:

Inovice - invoiceId, Date , billAmount

Techinician - TechId , techCost

ComputerCenter - centerId , InvoiceId

SpareParts - itemId , itemCost , itemName

RepairType - RepairId , TechId , repairTyp

JobSheet - JobId , CustomerId , centerId ,repairId

Customer - CustomerId , orderDate, amountPaid, deviceName

I hope the relations are fine this way.
In bold are the primary key and if that same olumn is used again it is used as foreign key in other tables.
Hope it is fine?

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.