The script should perform the following tasks

 

• CREATE Two SQL CREATE VIEW Statements.  One of the CREATE VIEW Statements must use two joined tables.
• Use the two created VIEWS in two different SELECT Statements.  One created VIEW per SELECT Statement.
• Use the SHOW FULL TABLES Statement to list the stored VIEWS in the Database
  
   

Upload the following 
 

1. SQL Script to create the two VIEWS for the Food Truck Company Database.
2. SQL SCRIPT containing statements to  CREATE the DATABASE and TABLES for the Food Truck Company Database.
3. SQL SCRIPT containing statements to load the sample data using INSERT INTO Statements.
4. SELECT Statement commands to execute  the VIEWS
5. SQL Statement to list the VIEWS
6. All components should be combined into a single SQL Text File

Transcribed Image Text:

11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 ATTRUBUTE NAME name phone email ATTRUBUTE NAME price name productNo reorder level quantity on hand ATTRIBUTE NAME name Id ATTRIBUTE NAME transactionNo date time details of trans costName TABLE: Customer ATTRIBUTE DESCRIPTION Contains the name of the customer Contains the phone of the customer contain the email of the customer TABLE: Products ATTRIBUTE DESCRIPTION contains price of the product Contains the name of the employee product number associated with food number of reorders number of quantity TABLE: Vendors ATTRIBUTE DESCRIPTION Name of the vendor Cell Phone Number of the Delivery Person TABLE: Sales and services ATTRIBUTE DESCRIPTION Transaction Number of the order Date of the Orders Time of the Orders Data Dictionary For Food Truck Company Database contains details of transaction contains the name of the costumer Domain all values >=0 and <10 all values Domain <1000 and >0 all values <100 and >0 <100 and >0 >1000 and >0 Domain any value >=0 and >10 Domain all values valid date valid date all values all values Range String Integer String Range Integer String Integer Integer Integer Range String Integer Range Integer Date Time String String PK No No Yes PK No No Yes No No PK No Yes PK Yes No No No No FK No No No FK No No No No No FK No No FK No No No No No Null No No No Null No No No No No Null No No Null No No No No No 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 ATTRUBUTE NAME name phone email ATTRUBUTE NAME price name productNo reorder level quantity on hand ATTRIBUTE NAME name Id ATTRIBUTE NAME transactionNo date time details of trans costName TABLE: Customer ATTRIBUTE DESCRIPTION Contains the name of the customer Contains the phone of the customer contain the email of the customer TABLE: Products ATTRIBUTE DESCRIPTION contains price of the product Contains the name of the employee product number associated with food number of reorders number of quantity TABLE: Vendors ATTRIBUTE DESCRIPTION Name of the vendor Cell Phone Number of the Delivery Person TABLE: Sales and services ATTRIBUTE DESCRIPTION Transaction Number of the order Date of the Orders Time of the Orders Data Dictionary For Food Truck Company Database contains details of transaction contains the name of the costumer Domain all values >=0 and <10 all values Domain <1000 and >0 all values <100 and >0 <100 and >0 >1000 and >0 Domain any value >=0 and >10 Domain all values valid date valid date all values all values Range String Integer String Range Integer String Integer Integer Integer Range String Integer Range Integer Date Time String String PK No No Yes PK No No Yes No No PK No Yes PK Yes No No No No FK No No No FK No No No No No FK No No FK No No No No No Null No No No Null No No No No No Null No No Null No No No No No 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 ATTRUBUTE NAME name phone email ATTRUBUTE NAME price name productNo reorder level quantity on hand ATTRIBUTE NAME name Id ATTRIBUTE NAME transactionNo date time details of trans costName TABLE: Customer ATTRIBUTE DESCRIPTION Contains the name of the customer Contains the phone of the customer contain the email of the customer TABLE: Products ATTRIBUTE DESCRIPTION contains price of the product Contains the name of the employee product number associated with food number of reorders number of quantity TABLE: Vendors ATTRIBUTE DESCRIPTION Name of the vendor Cell Phone Number of the Delivery Person TABLE: Sales and services ATTRIBUTE DESCRIPTION Transaction Number of the order Date of the Orders Time of the Orders Data Dictionary For Food Truck Company Database contains details of transaction contains the name of the costumer Domain all values >=0 and <10 all values Domain <1000 and >0 all values <100 and >0 <100 and >0 >1000 and >0 Domain any value >=0 and >10 Domain all values valid date valid date all values all values Range String Integer String Range Integer String Integer Integer Integer Range String Integer Range Integer Date Time String String PK No No Yes PK No No Yes No No PK No Yes PK Yes No No No No FK No No No FK No No No No No FK No No FK No No No No No Null No No No Null No No No No No Null No No Null No No No No No