Using Oracle, practice writing and testing Data Definition Language (DDL) and Data Manipulation Language (DML) SQL statements. You may use Oracle’s SQL Plus, SQL Developer, or Oracle Data Modeler tools. Create tables to fulfill the requirements of the ERD below. Populate the newly created tables with three records of data and write database queries with the following requirements:

Scenario 2 Bute Electric - continued

A query (or queries) that lists all of the records in all of the tables.

A query that lists each customer by name with location addresses.

A query that lists the location type and the rates by time of day.

 

Transcribed Image Text:

CUSTOMER Customer ID Customer Name Customer Address (Street, City, State, Zip Code) Customer Telephone Has Location LOCATION Location ID Customer ID (FK) Location Address (Street, City, State, Zip Code) Location Type HH Time of Day Is Charged RATE Rate Class Location ID (FK) RatePerKWH CUSTOMER Customer ID Customer Name Customer Address (Street, City, State, Zip Code) Customer Telephone Has Location LOCATION Location ID Customer ID (FK) Location Address (Street, City, State, Zip Code) Location Type HH Time of Day Is Charged RATE Rate Class Location ID (FK) RatePerKWH

Answer rating: 100% (QA)

Answer Here are SQL statements to create tables based on the scenario Create the Customers table CREATE TABLE Customers CustomerID INT PRIMARY KEY Nam... View the full answer