Create an erd to capture the business

Assignment Help Computer Engineering

Reference no: EM133218763

Question: You have been hired by Patriot Electronics (PE), a company that repairs smartphones, laptops, tablets, computers, and MP3 players. The CEO wants you to create a database to help run the business.

Create an ERD to capture the following business rules: When a customer brings a device to PE for repair, data must be recorded about the customer, the device, and the repair. The customer's name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and serial number are recorded [or verified if the device is already in the system).

Only customers who have brought devices into PE for repair will be included in this system. Since a customer might sell an older device to someone else who then brings the device to PE for repair, it is possible for a device to be brought in for repair by more than one customer.

Reference no: EM133218763

Questions Cloud

Worst case runtime of any comparison : Prove that the worst case runtime of any comparison-based sorting algorithm is O(n lg n).

How many stall cycles do we need between : In a 5-stage pipelined ARM processor without forwarding, how many stall cycles do we need between ADD R2, R3, R4 and ADD R4, R3, R2?

Identify the different types of legal proceedings : David, a farmer, supplies organic free range eggs on a regular basis to the Peak Park Hotel and Country Club. Identify the different types of legal proceedings

Construct a nearest-neighbor classifier : Construct a nearest-neighbor classifier from this data set. How would you go about designing a nearest-neighbor classifier in this case?

Create an erd to capture the business : Create an ERD to capture the business rules: When a customer brings a device to PE for repair, data must be recorded about the customer,

Option for protecting perimeter of network : A virtual private network (VPN) is the best option for protecting the perimeter of a network.

Describe the goals of federal and state regulation : Describe the goals of federal and state regulation of the healthcare system. Why do they get involved? Explore an example of a governmental regulation

Encrypt and decrypt : Encrypt and decrypt the following numbers using the RSA algorithm: 45 55 65 75 85. Mandatory Instruction: The modulus must be greater than 85

Should all images of drinking and smoking be banned from TV : Do TV shows and films glorify drug usage and encourage youths to enter the drug trade? Should all images of drinking and smoking be banned from TV

User Account

All Pages