SECTION A. (50 points): DATA DEFINITION LANGUAGE COMMANDS Write the SQL commands needed to implement a database in Oracle for the design given below. PRODUCT VENDOR Key PID PK VID Name CompanyName QOH Phone 1. Be sure to include all the necessary constraints. 2. NOTE/HINT: Use a composite primary key for any associative entities needed. 3. Add test data necessary to demonstrate that the relationships are implemented properly. 4. Write a query to show how the relationships in the design work (simple select * queries are not sufficient, use a JOIN). 5. Write the command to add the attribute "price" (and any other relevant attributes) where it/they belong(s). 6. Write the command to add the values for the new attributes. 7. Write a query to show that the attribute and values have been added properly