You are required to build a database that keeps track of university instructors, the courses they teach and the textbooks they use. Given the requirements below, design a database using Oracle SQL Data Modeler.
1. An instructor has a unique id (an 8-digit number), a name composed of first and last names (strings with a maximum of 20 characters each), and belongs to a department identified by a department id (4-digit number) .An instructor has at least one phone number. A phone number is a string with a maximum of 10 characters.
2. A course has a unique code (string of 7 characters, eg: RGIS606), a title (string of up to 40 characters long eg: Database Management Systems) and a corresponding department. Instructors teach sections of courses. A section is identified by its number ( a 2-digit number, eg: 01) and the semester (6-digit number, eg: 202010) it is offered in. A section is related to the course by an identifying relationship.
3. A textbook is identified by its ISBN (a string of a maximum of 20 characters), has a publisher (string of 40 characters), and has one or more authors. The author’s name is composed of first and last names (a string of 20 characters each).
4. Each section is taught by exactly one instructor, but an instructor can teach more than one section.
Each textbook is used by at least one section.
Save the design as university_1.
if you can do this on SQL data modeler and post the link please

A Poisson process is a statistical model that describes the occurrence of rare events over time or space. It is commonly used to model the number of failures in commercial water pipes.

One of the advantages of using a Poisson process to model the number of failures in commercial water pipes is that it allows for the calculation of the probability of multiple failures occurring within a given time period. For example, if the failure rate is estimated to be 1 failure per 100 km of pipe per day, the probability of two failures occurring in a 24 hour period can be calculated.

In addition, the Poisson process can be used to determine the expected number of failures over a given time period. For example, if the failure rate is estimated to be 1 failure per 100 km of pipe per day, the expected number of failures over a 30-day period would be 30 failures.


In conclusion, the Poisson process is a useful statistical model for estimating the number of failures in commercial water pipes. It allows for the calculation of the probability of multiple failures occurring within a given time period, as well as the expected number of failures over a given time period. However, it is important to consider the assumptions of the model and to be aware of potential sources of variation in the rate of failures over time.

To know more about model visit:

https://brainly.com/question/32196451

#SPJ11

Answer: the stress is 384 pounds per square inch.

Step-by-step explanation:

Let S represent the stress in the material of the pipe.

Let P represent internal pressure of the pipe.

Let D represent internal diameter of the pipe.

Let T represent the thickness of the pipe.

The stress in the material of a pipe subject to internal pressure varies jointly with the internal pressure and the internal diameter of the pipe and inversely with the thickness of the pipe. Introducing a constant of proportionality, k, the expression becomes

S = kPD/T

The stress is 100 pounds per square inch when the diameter is 5 inches, the thickness is 0.75 inch, and the internal pressure is 25 pounds per square inch. It means that

100 = (k × 25 × 5)/0.75

125k = 100 × 0.75 = 75

k = 75/125 = 0.6

The equation representing the relationship becomes

S = 0.6PD/T

If the internal pressure is 40 pounds per square inch, the diameter is 8 inches and the thickness is 0.50 inch, then the stress would be

S = (0.6 × 40 × 8)/0.5

S = 384

3837 kip-ft / 7560 kip-ft = 1.97 for Mn / Mx. Member AB is regarded as suitable for LRFD because this ratio is bigger than 1.0.

The force that will cause a member to yield is typically between 1.3 and 1.4 times the member strength (the maximum load that the member will support). These load factors, whose size varies depending on the type of load, are used in the load combination formulae.

Kx = Effective length factor for x-axis bending

= Lx / rx

\(Lx = AC = √(13^2 + 25^2) = 28.8 ft\)

\(rx = √(Ix / A)\)

\(A = 28.5 in^2\)

\(Ix = 1630 in^4\)

\(rx = √(1630 / 28.5) = 9.07 in\)

Now we can calculate Kx:

Kx = Lx / rx = (28.8 ft) / (9.07 in / 12 in/ft) = 11.5

\(Mx = (1.2D + 1.6L) * (Lx / Kx)\)

\(= (1.2 * 204 kips + 1.6 * 408 kips) * (28.8 ft / 11.5)\)

= 3837 kip-ft

\(Mn = Fy * Zx\)

\(Zx = 168 in^3\)

\(Mn = Fy * Zx = 50 ksi * 168 in^3 = 8400 kip-ft\)

The LRFD design strength of member AB is then:

\(φMn = 0.9 * Mn = 0.9 * 8400 kip-ft = 7560 kip-ft\)

\(φMn / Mx = 7560 kip-ft / 3837 kip-ft = 1.97\)

To know more about LRFD visit:-

https://brainly.com/question/13507657

#SPJ1

Answer:

10.5

Explanation:

Convert to an equation for example P%* X=Y

P is 7.5% X is 140, so the equation Is 7.5 percent * 14= Y

convert 7.5% Into a decimal by removing the percent sign and deviding by 7.5/100= 0.075

Substitute 0.075 for 7.5% in the equation: 7.5%*140=Y becomes 0.075*140= 10.5

Answer: A, B, C or D

Explanation: its either those

Answer:

\(F=710KHZ\)

Explanation:

From the question we are told that:

Frequency selectivity ratio \(R=10\)

AM range 750 kHz to 2600 kHz

Therefore Bandwidth is

 \(B=2100-680\)

 \(B=1420KHZ\)

Generally the equation for The intermediate frequency is mathematically given by

Intermediate frequency=\frac{Bandwidth}{2}

 \(F=\frac{B}{2}\)

 \(F=\frac{1420}{2}\)

 \(F=710KHZ\)

Answer:

im pretty sure its answer D

Explanation:

The condenser is normally inspected when the high-side pressures are too high in a refrigerator etc.

This is defined as a device which reduces a gas or vapour to a liquid and is normally inspected when the high-side pressures are too high.

When this occurs , it therefore means the system is not cooling well which could damage other parts.

Read more about Condenser here https://brainly.com/question/15049508

#SPJ1

Answer:

If prescription lenses are required, they must be covered by protective goggles or the lenses and frames must be ANSI approved.

Explanation:

this includes side shields for angular protection.  Goggles and safety glasses are primary protectors. Goggles fit around the area of the face near the eye. hope this helps you :)

The performance that is required of a multiengine airplane with the critical engine inoperative, while carrying passengers for hire in ifr weather conditions is at least 50 feet a minute when operating at the MEAs of the route to be flown or 5,000 feet MSL, whichever is higher

Regulations for multi-engine airplanes with a disabled critical engine in IFR conditions while carrying paying passengers are dictated by aviation authorities.

Regulations may differ by country, so it is good to consult the appropriate authority for accurate information. However, common aviation practices dictate guidelines for multi-engine airplanes operating in these conditions.

Learn more about multiengine  from

https://brainly.com/question/31059494

#SPJ1

Economic activities can occur during and between different stages of various processes.

Here are some examples:

Production Stage: During the production stage, economic activities can include the purchase of raw materials, labor costs, and the use of machinery and equipment.

Distribution Stage: During the distribution stage, economic activities can include transportation costs, warehousing costs, and marketing costs.

Consumption Stage: During the consumption stage, economic activities can include the purchase of goods and services by consumers.

Recycling Stage: During the recycling stage, economic activities can include the collection and processing of waste materials, the production of recycled materials, and the sale of these materials to manufacturers.

Innovation Stage: Economic activities during the innovation stage can include research and development expenses, patents, and intellectual property rights.

Service Stage: During the service stage, economic activities can include the provision of services to customers, such as consulting, repair, and maintenance services.

Investment Stage: During the investment stage, economic activities can include the purchase of securities, property, and other assets.

Overall, economic activities occur throughout various stages of a process, from the production of goods and services to their consumption and beyond.

Learn more about economic activities on

https://brainly.com/question/14545466

#SPJ1

Answer:

A solenoid switch is an electrical switch that is often used where a high current circuit, such as a starter motor circuit, is brought into operation by a low current switch. When the key switch is turned to Start and the gearshift is in neutral, the circuit between the battery and the solenoid switch is complete

Explanation:

brainliest?

The function of the solenoid switch is better understood by the fact that it mediates the high current which is flowing in the circuit into an appropriate current that is easily required by any electrical device.

A solenoid switch may be defined as a type of electrical switch that is significantly utilized in a place where there is a high current flowing in the circuit. This high current is effectively brought into a functional low current switch.

According to the context of this question, a solenoid switch is placed between your vehicle's ignition module and the engine in order to regulate the high current into the functional one. This type of switch is also used in a motor circuit for the same function.

Therefore, the function of the solenoid switch is well described above.

To learn more about Solenoid switches, refer to the link:

https://brainly.com/question/15007247

#SPJ2

To declare and initialize an array of ints named myVals with 4 elements each initialized to 10 in a single statement, you can use the following code:

int[] myVals = {10, 10, 10, 10};

This creates an array of integers with 4 elements and initializes each element to the value of 10.

The curly braces ({}) denote the initialization of the array elements, and the commas separate the values of each element. By using this syntax, you don't need to specify the size of the array explicitly, as the number of elements is inferred from the number of values in the initialization list.

Learn more about array: https://brainly.com/question/26104158

#SPJ11

Answer:

1. Be sure to use the correct type and size of screwdriver on every kind of screw to avoid injury to yourself or damage to equipment.

2. It is also unsafe to carry screwdrivers in pockets or to use them around moving machinery.

3. Screwdrivers are not safe to use as hammers or chisels or for prying.

Explanation:

The work needed for the compression of an ideal gas in a single reversible and adiabatic compressor can be expressed in terms of the mass flow rate, initial pressure (P1), final pressure (P2), and initial temperature (T1).

a. When compressing an ideal gas in a single reversible and adiabatic compressor, the work required can be calculated using the equation: W = (m_dot * R * T1) * ln(P2/P1), where W is the work, m_dot is the mass flow rate, R is the gas constant, T1 is the initial temperature, and ln represents the natural logarithm. This expression takes into account the change in pressure and temperature during the compression process.

b. In a two-stage compression process, the work needed can be minimized by selecting an intermediate pressure (P*) between P1 and P2. The value of P* should be determined such that the compression process is done with minimum work. By optimizing the pressure ratio between the stages, the work required for each compression can be reduced. To calculate the specific value of P*, detailed calculations involving thermodynamic relationships and optimization techniques are required.

In summary, the work needed for compressing an ideal gas depends on factors such as the mass flow rate, initial and final pressures, and initial temperature. In a two-stage compression process, selecting the intermediate pressure (P*) carefully can help minimize the work required. Precise calculations and analysis are necessary to determine the specific value of P*.

Learn more about an ideal gas  

brainly.com/question/13463215

#SPJ11

False.

The voltage through a resistor with current i(t) in the s-domain is simply Ri(s), where R is the resistance value of the resistor. In the s-domain, the relationship between voltage and current through a resistor can be expressed using Ohm's law as V(s) = I(s)R.

Therefore, the voltage across a resistor in the s-domain is proportional to the current through it, with the proportionality constant being the resistance value. It's important to note that this relationship only holds true for resistive elements in linear circuits. Non-linear circuit elements such as diodes and transistors have much more complex voltage-current relationships that cannot be described using a simple linear equation.

To know more about diodes visit:

https://brainly.com/question/32612539

#SPJ11

The direction of motion of a screw dislocation's line is perpendicular to the applied shear stress.

In a screw dislocation, the atoms are displaced along a helical path around the dislocation line, resembling a screw thread. When an external shear stress is applied, it acts parallel to the dislocation line.

Due to the Burgers vector, which represents the magnitude and direction of the lattice distortion caused by the dislocation, the atoms move along the helical path in a direction perpendicular to the applied shear stress.

This motion allows the screw dislocation to propagate and contribute to plastic deformation in crystalline materials.

Learn more about screw dislocation here

https://brainly.com/question/32163867

#SPJ4

To reduce the moisture content of the batch of food product from 150% on a dry basis to 20% on a wet basis, we need to remove 1.225 times the weight of the original batch in water.

To solve this problem, we can use the concept of moisture content on a dry basis and moisture content on a wet basis.

Let's first convert the given moisture content of 150% on a dry basis to moisture content on a wet basis:

Moisture content on a wet basis = (Weight of water / Total weight of the product) x 100%

150% = (Weight of water / (Weight of dry solids + Weight of water)) x 100%

Solving for the weight of water, we get:

Weight of water = 1.5 x Weight of dry solids

Next, we need to find the weight of dry solids in the original batch of food product. Since the batch is 5% of the total product weight, we can assume that the total weight of the product is 100 / 5 = 20 times the weight of the batch. Therefore, the weight of dry solids in the original batch is:

Weight of dry solids = 0.95 x Total weight of the product

Now, we can calculate the weight of water in the original batch of food product:

Weight of water = 1.5 x (0.95 x Total weight of the product) = 1.425 x Total weight of the product

To reduce the moisture content to 20% on a wet basis, we need to remove some amount of water from the product. Let's assume that the final weight of the product remains the same as the original weight. Then, we can write:

Weight of water in the final product = 0.2 x Final weight of the product

The amount of water that needs to be removed from the original batch to achieve the desired moisture content can be calculated as:

Amount of water to be removed = Weight of water in the original batch - Weight of water in the final product

= 1.425 x Total weight of the product - 0.2 x Total weight of the product

= 1.225 x Total weight of the product

Learn more about moisture here https://brainly.com/question/13724830

#SPJ4

Answer:

See explaination

Explanation:

please kindly see attachment for the step by step solution of the given problem

GivenDataRadius of the spoked wheel, r = 705 mmCord speed at point P, v = 2.0 m/sVelocity of point E = VeWe know that linear velocity (v) = angular velocity (ω) × radius (r)We can find the angular velocity using the formula:ω = v / rω = 2 / 0.705= 2.84 rad/s

We know that the velocity of point A is perpendicular to the incline and the velocity of point E is parallel to the incline.As no slipping occurs, the velocity of point B is zero.The velocity of point E is given byVe = ω × r = 2.84 × 0.705 = 2.00 m/sLet VA be the velocity of point A. Then we can write:VA / Ve = AB / AEBut AB = 2r and AE = r + hSo we haveVA / 2 = AB / (r + h)VA / 2 = 2r / (r + h)VA = 4r / (r + h)Substitute the values to obtainVA = 4 × 705 / (705 + 300) = 2.22 m/sTherefore, the velocities of points A and B are VA = 2.22 m/s and VB = 0 m/s respectively.Note that the solution has a word count of 159 words.

To know more about velocity visit:

https://brainly.com/question/30559316

#SPJ11

According to the information, the velocity of point A is v = 1.0 m/s and the velocity of point B is v = 2.0 m/s.

Fist we have to consider that since no slipping occurs, the linear velocity of any point on the wheel must be equal to the tangential velocity of the cord. At point P, the cord speed is given as v = 2.0 m/s.

Now, to determine the velocities of points A and B, we need to consider the relationship between linear velocity, angular velocity, and radius. The linear velocity of a point on the wheel is equal to the product of the angular velocity and the radius of the wheel.

Additionally, the radius of the wheel is given as r = 705 mm, which is equivalent to 0.705 m, we can calculate the angular velocity (ω) of the wheel by dividing the linear velocity of point P (v) by the radius (r).

Now, we can calculate the velocities of points A and B using the angular velocity and their respective radii.

Velocity of point A:

Velocity of point B:

Since the radius of point A (r_A) is 0.705 m, the velocity of point A is:

Since the radius of point B (r_B) is twice the radius of point A, i.e., 2 * 0.705 m = 1.41 m, the velocity of point B is:

According to the above, the velocity of point A is v_A = 2.0 m/s and the velocity of point B is v_B = 4.0 m/s.

Learn more about velocity in: https://brainly.com/question/30559316
#SPJ4

Answer:

do u speak english

Explanation:

Answer:

  Av = -800

Explanation:

The gain to the output of the first op-amp is ...

  A1 = -R2/R1 = -1000/10 = -100

The gain of the voltage divider R3/R4 is ...

  A2 = R4/(R3+R4) = 10/(10+10) = 1/2

The gain of the second op-amp circuit from the positive terminal to the output is ...

  A3 = 1+ R5/R6 = 1 + 150/10 = 16

Then the total circuit gain is ...

  Av = A1×A2×A3 = (-100)(1/2)(16)

  Av = -800

_____

Additional comment

In the above, we have assumed ideal op-amps, with infinite gain and infinite input impedance. The resistor values used in the calculations are all Kohms, so we can avoid writing unnecessary zeros.

Answer:

There are six conditions

1. Poles should contain some residual flux.

2. Field and armature winding must be correctly connected so that initial mmm adds residual flux.

3. Resistance of field winding must be less than critical resistance.

4. Speed of prime mover of generator must be above critical speed.

5. Generator must be on load.

6. Brushes must have proper contact with commutators.

Explanation:

The thermal energy when the spark-ignition engine operates on an Otto cycle with a compression ratio of 9 and temperature limits of 30°C and 1000oC is 58%.

From the information given, we are told that spark-ignition engine operates on an Otto cycle with a compression ratio of 9 and temperature limits of 30°C and 1000oC.

The thermal energy will be:

= 1 - 1/(1.4 - 1)

= 0.58

= 58%

Also, the mass flux of air will be illustrated below:

T2 = 729.70k

W = 224.60kj

Therefore, the mass flux will be:

= 500/224.60

= 2.226kg/s

In conclusion, the the mass flux will be 2.226kg/s.

Learn more about engine on:

brainly.com/question/25870707

#SPJ1

On a ladder diagram, all wires that connect to a common point are assigned the same number. Let's understand what a ladder diagram is before we move on to the answer. Ladder diagrams are a type of electrical diagram that is widely used in industrial automation processes.

They are often used to represent complex control systems for machinery or other industrial equipment, as well as simple circuits for controlling lights or other small loads.A ladder diagram consists of two vertical lines representing the power rails or conductors that carry electrical power to the devices being controlled. Horizontal lines are used to connect the various devices or components in the system.

These horizontal lines are often called rungs.Each device or component in the system is represented by a symbol on the ladder diagram. The symbols used in ladder diagrams can vary depending on the type of device or component being represented. Some common symbols include switches, relays, motor starters, timers, and sensors.In a ladder diagram, all wires that connect to a common point are assigned the same number.

This is done to simplify the wiring and make it easier to troubleshoot problems if they occur. By assigning the same number to all wires that connect to a common point, it is easy to trace the wiring and determine which devices or components are connected together. Therefore, the correct option is A) the same number.

To know more about understand visit :

https://brainly.com/question/24388166

#SPJ11

Based on the information, both technician A and technician B are correct.

From the information given, Technician A says that mechanical shifting controls can wear out over time.

Technician B says that vacuum control rubber diaphragms can deteriorate over time.

In this case, both technicians are correct as the information depicted is true.

Learn more about technicians on:

brainly.com/question/1548867

#SPJ12