===================================================================== ===================================================================== UML TO RELATIONAL ===================================================================== ===================================================================== ENTITIES ===================================================================== Customer( customerID, customerName, phoneNum, CCnum, cardType ) Device (deviceID, startDate, endDate, customerID ) Employee ( employeeID, employeeName, e-mail, address, SSN ) Manufacturer ( manufacturerID, manufacturerName, phoneNum, supplierAddress) Model ( modelName, yearReleased, screenSize, batterySize, ram, manufacturerID ) Order ( orderID, orderDate, orderStatus, employeeID ) Payment (paymentID, paymentType, amount, date-time, customerID, repairOrderID) RepairRequest ( repairOrderID, date, dmgDesc, repairLog, typeOfRrepair. hoursWorked, employeeID, deviceID, ) ReplacementParts ( partID, sellName, sellCost, boughtCost, MSRP, quantity ) Supplier ( supplierID, supplierName, supplierAddress ) RELATIONSHIPS ===================================================================== contains ( orderID, partID, boughtCost, quantity ) order/ReplacementParts supplies ( supplierID, partID, MSRP ) uses ( EmployeeID, partID, numPartsUsed, quality, sellCost ) works_on ( EmployeeID, RepairID, hoursWorked ) address(city, state, zip, street_name,street_num, addr_id) ===================================================================== brings ( customerID, deviceID ) contains ( deviceID, repairOrderID ) repairRequest/Device contains ( orderID, partID, boughtCost, quantity ) order/ReplacementParts creates ( employeeID, orderID ) Identifies_device (modelName, deviceID ) narrows_search (manufacturerID, modelName ) pays ( customerID, paymentID ) paid_with ( paymentID, repairOrderID ) supplies ( supplierID, partID, MSRP ) uses ( EmployeeID, partID, numPartsUsed, quality, sellCost ) works_on ( EmployeeID, RepairID, hoursWorked )