please answer everything
type everything and please provide images of input and ouput
- Please Answer Everything Type Everything And Please Provide Images Of Input And Ouput 1 (95.2 KiB) Viewed 92 times
- Please Answer Everything Type Everything And Please Provide Images Of Input And Ouput 2 (95.2 KiB) Viewed 92 times
- Please Answer Everything Type Everything And Please Provide Images Of Input And Ouput 3 (83.62 KiB) Viewed 92 times
CREATING VIEWS la. Create a LISTINGS table within your database. Print the CREATE TABLE
statement. The table will contain listings for cars. Each row will have the name of a car, the color of the car, and the number of cars on hand with that color. A car can have any number of colors; a color can have any number of cars. Set up a validation rule (constraint) saying the number of cars on hand must be between 0 and 20. (What is the primary key?) b. Enter at least 25 rows. c. Print the entire table ordered by car name, then color (desc). 2a. Create a CARS table (give the CREATE TABLE
statement you use) for information about cars. The table will contain the name of a car, the year, the manufacturer, the dealer's cost, and the selling price. Assume that car names are unique; the year must be between 2001 and 2010, the selling price and the dealer's cost must both be between 10,000 and 100,000; the selling price must be at least 500 more than the dealer's cost. (PK?) b. Enter at least 10 cars into this table. Be sure that every car in LISTINGS appears in this table, plus at least 3 new ones. Have at least one manufacturer with just one car, at least 3 with 3 cars. c. Print the CARS table, ordered by car name. d. Print the car names in CARS but not LISTINGS. e. Print the car names in LISTINGS but not CARS. 3. For each table, for each of the (non-PK) constraint rules that you set up, enter a value for that field which violates the rule. Print the value that you entered, together with the error message that was printed. 4. For a-c, give the CREATE VIEW
statement and print the view. a. Create a view consisting of the rows from the LISTINGS table for cars which are black, b. Create a second view consisting of the rows from CARS for cars manufactured by Toyota. c. Create a third view consisting of rows for cars whose number on hand is at least 10
5. Each part below should result in least two rows. a. Without using the views, find all cases in which a car manufactured by Toyota is black and the number of cars on hand is at least 10. For each row, give all relevant information. b. Do the same for cars manufactured by Toyota which are not black and the number is at least 10. c. Do the same for cars manufactured by Toyota which are not black and the number is less than 10. d-f. Repeat steps a, b, and c, but this time use the views from step 6 whenever possible (if at all possible, use only the views, and do not use the base tables). 6a. For each car, compute the profit (selling price minus dealer cost). Print the car's name, manufacturer, selling price, dealer cost, and profit. Order by manufacturer. b. Find which car has the highest selling price, which car has the highest dealer cost, and which car has the highest profit. For each part, print the car name and manufacturer, plus the relevant number. Print under a good heading. (Make sure that no one car appears in more than one part of this
question.) c. Repeat part b for each manufacturer. (Now repeats are ok.) That is, for each manufacturer, find the car with highest,..