Turn the attached ERD into Oracle database tables with foreign key relationships. You will insert records into your database tables and run queries against the tables using Structured Query Language (SQL).

Using Oracle, practice writing and testing Data Definition Language (DDL) and Data Manipulation Language (DML) SQL statements. You may use Oracles 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.

CUSTOMER Customer ID Customer Name Customer Address (Street, City, State, Zip Code) Customer Telephone Has Location Time of Day LOCATION RATE Location ID Customer tt Rate class (FK) Location Address Location ID (Street, City, State, Zip Rate Per KWH Code) Is Charged Location Type