Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

1:

utility for which I work uses circuit breakers to interrupt the energy that flows through a circuit. They are large pieces of equipment that reside in a substation. As practice, you are to design a circuit breaker database. Within this database, a manufacturer can have many different models. My company can have many circuit breakers for a particular model. A circuit breaker can be tested multiple times. In addition, it is common to document text about the circuit breaker. The following are the attributes that have been identified from the data flow diagram: Manufacturer Manufacturer_name Model Gallons_of_oil Weight Serial_number Location Amps Kva_rating Text_line_number Text Test_date Test_result     Create an entity relationship ...