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
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
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