Line_units DECIMAL(9,2) DEFAULT 0.00 NOT NULL, * This script creates and loads data in order to create the Sale Company database*/Ĭus_areacode CHAR(3) DEFAULT '615' NOT NULL CHECK(cus_areacode IN ('615','713','931')),ĬONSTRAINT PRODUCT_V_CODE_FK FOREIGN KEY (v_code) REFERENCES vendor(v_code)) Ĭus_code INTEGER NOT NULL REFERENCES customer(cus_code),ĬONSTRAINT INVOICE_CUSTOMER_FK FOREIGN KEY (cus_code) REFERENCES customer (cus_code),ĬONSTRAINT INV_CK1 CHECK (inv_date > TO_DATE('','YYYY-MM-DD'))) * Database Systems, 9th Ed., Coronel/Morris/Rob */ The results should have the same column headings and be sorted by Num_Products_Supplied in highest to lowest values and then by Vendor.īelow is a sale company SQL script file for running in mySQL Write the query to produce the output listed below which shows by vendor the number of products supplied and the lowest and highest product price. (Hint: The Total_Purchases column is a calculated column.)Ģ. The results should have the same column headings, the Total_Purchases column listed to two decimal places and the data sorted by cus_lname and then by cus_fname. Write a query to produce the output listed below which shows the number of invoice lines and the overall total of the subtotals of all the invoice lines for each customer. Submit via the D2L drop box the final SQL script for all problems. Using MySQL SELECT commands answer the questions listed below within the sales_co schema. You may find an example ERD in the previous assignment. You may have already completed this as part of you last assignment so you may not need to do it again. Use the Sales_Company SQL script file to create the tables and load the data into a schema called sales_co. * Version 4.SOLVING THIS PROBLEM USING MYSQL WORKBENCH FOR WRITING CODE,please * - Delete option with permission configuration Server URL : API URL (Vehicle add page).Device Identifier : API Username (Check in vehicle add/view page).Use traccar client to send lat log to server.GPS Tracking Mobile APP (customized version, please contact over email : ) Mobile APP Once installed successfully, it get automatically redirected to login page.Fill Out the all fields are required for your database connections – MYSQL HOSTNAME, MYSQL USERNAME, MYSQL PASSWORD and MYSQL DATABASE NAME.First all files upload in your hosted path.User management with Dynamic Permission Options.Standalone URL for trip booking tracking.Delete option(Driver,Booking,Customer) with permission configuration.Please check demo clearly, I won’t accept any refund request This system gives a unique tracking url of trip and can able to share, the url to customer to keep tracking. Geofence help to track eye on inbound and outbound of particular marked location. Real time gps tracking and Geofence is available in the system, which help to track location. This system can able to manage vehicles and drivers, customers, keep a track of income and expenses and get detailed reports. Vehicle Management System with GPS Tracking is the complete Fleet Management System for managing vehicles.
0 Comments
Leave a Reply. |