1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

SQL ANSI Help

Discussion in 'Databases' started by Lorena Da Silva Pereira, Dec 5, 2019.

  1. #1
    LOCAR car rental company wants to keep track of its affiliates and their available vehicles.
    A branch has several vehicles. A vehicle can be linked to only one branch. We also know that a vehicle is produced by a manufacturer, which in turn produces several vehicles. Entries must consist of the following attributes:



    Branch: code, name, address (street, number, neighborhood, city, state, zip code) and telephone numbers.
    Vehicle: plate, year, model, fuel type, chassis and color.
    Manufacturer: code and name.
    Based on this information, develop the Conceptual and Logical Models using the Case BR Model tool and implement your MySQL project with SQL language DDL commands.

    Develop instructions for including at least 5 (five) records for Manufacturer, Vehicle and Branch;
    Develop a color change instruction for a vehicle;
    Develop an instruction to select all white and Fiat brand vehicles, which displays all fields sorting descending by vehicle year;
    Develop an instruction for…