What is the SQL command to list the total sales by month and product category, with subtotals by month and a grand total for all sales?

The following state transition table is a simplified model of process management, with the labels representing transitions between states of READY, RUN, BLOCKED, and NONRESIDENT. Give an example of...

Is busy waiting always less efficient (in terms of using processor time) than a blocking wait? Explain.

Table lists typical elements found in a process control block for an unthreaded OS. Of these, which should belong to a thread control block and which should belong to a process control block for a...

What is the difference among deadlock avoidance, detection, and prevention?

Show that the four conditions of deadlock apply to Figure. 2

A pipeline algorithm is implemented so that a stream of data elements of type T produced by a process P0 passes through a sequence of processes P1, P2, ., Pn - 1, which operates on the elements in...

For Figure, provide a narrative description of each of the six depicted paths, similar to the description of the paths of Figure 6.2 provided in Section 6.1. Progress of Q Release P and Q want A...

List and briefly define five different categories of synchronization granularity.

Suppose that your roommate, a political science major, asks you to help her purchase a new laptop computer. She wants to use the computer for email, Internet access, and note-taking in class. She...

Search the Internet for evidence that Microsoft Azure complies with ISO 27001. Summarize your findings.

YourFire, Inc., (the same YourFire we met at the end of Chapter 3, p. 75) is a small business owned by Curt and Julie Robards. Based in Brisbane, Australia, YourFire manufacturers and sells the...

Summarize what you have learned from this exercise about choosing a CRM product. Formulate your summary as an answer to a job interviewers question about the difficulties that organizations face when...

Suppose you need to terminate an employee who works in your department. Summarize security protections you must take. How would you behave differently if this termination were a friendly one?

1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a view named...

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent...

Describe the relationship between columns that can be null and entity subtypes. Under what circumstances would these columns lead to more than one entity subtype?

Describe the entity-relationship model. How are entities, relationships, and attributes represented in this model? What is a composite entity? Describe the approach to diagrams that uses a crows...

Occasionally, users at Premiere Products obtain incorrect results when they run queries that include built-in (aggregate, summary, or statistical) functions. The DBA told management that unrepeatable...

The DBA at Premiere Products wants you to investigate biometric identification techniques for potential use at the company for computer authentication purposes. Use books, articles, and/or the...

While users were updating the Premiere Products database, one of the transactions was interrupted. You need to explain to management what steps the DBMS will take to correct the database. Using the...

What is an executive dashboard?

Visit the Open Source Initiatives Web site at opensource.org. Summarize the mission of this non-profit corporation. Find the definition of open source on this site and summarize that definition in...

List specific features and benefits for each of the five applications you selected in question 1.

Which of the analysis options in this exercise will provide Mary the best value? If you owned Carbon Creek Gardens and you were going to implement just one of these applications, which would you...

To learn phishing fundamentals, visit www.microsoft.com/protect/fraud/phishing/symptoms.aspx. To see recent examples of phishing attacks, visit www.fraudwatchinternational.com/phishing-alerts/. a....

You are required to create a conceptual data model of the data requirements for a company that specializes in IT training. The Company has 30 instructors and can handle up to 100 trainees per...

Describe the types of update anomalies that may occur on a relation that has redundant data.

On completion of Exercise 14.14 examine the 3NF relations created to represent the attributes shown in the Well meadows Hospital form shown in Figure 14.18. Determine whether these relations are also...

Describe business situations in which an individuals or businesses behavior would be considered: (a) Illegal and unethical; (b) Legal but unethical; (c) Illegal but ethical.

For each of the following schedules, state whether the schedule is serializable, conflict-serializable, view-serializable, recoverable, and whether it avoids cascading aborts: (a) Read(T1, balx),...

Using the ER diagram from Exercise 24.15, produce a distributed database design for this system, and include: (a) A suitable fragmentation schema for the system; (b) In the case of primary horizontal...

List 10 potential benefits of the database approach over conventional file systems.

State three conditions that suggest the designer should model a relationship as an associative entity type.

Contrast the following terms: a. Stored attribute; derived attribute b. Simple attribute; composite attribute c. Entity type; relationship type d. Strong entity type; weak entity type e. Degree;...

Review your answer to Problem and Exercise 2-49; if necessary, change the names of the entities, attributes, and relationships to conform to the naming guidelines presented in this chapter. Then,...

The Is Married To relationship in Figure 2-12a would seem to have an obvious answer in Problem and Exercise 2-33dthat is, until time plays a role in modeling data. Draw a data model for the PERSON...

Explain how each of the following types of integrity constraints is enforced in the SQL CREATE TABLE commands: a. Entity integrity b. Referential integrity

Explain three conditions that suggest a surrogate key should be created for the primary key of a relation.

Match the following terms to the appropriate definitions: _________ View a. list of values _________ Referential b. description of a database _________ Integrity constraint c. view materialized as a...

In what clause of a SELECT statement is an IN operator used? What follows the IN operator? What other SQL operator can sometimes be used to perform the same operation as the IN operator? Under what...

What are SQL-92, SQL:1999, and SQL:2011? Briefly describe how SQL:2011 differs from SQD1999.

Explain what capabilities the new temporal features added to the SQL standard in SQL:2011.

Reread the case descriptions in Chapters 1 through 3 with an eye toward identifying the typical types of reports and displays the various stakeholders might want to retrieve from your database....

When is an outer join used instead of a natural join?

Explain the following statement regarding SQL: Any query that can be written using the subquery approach can also be written using the joining approach but not vice versa.

A food manufacturing company needs a data mart to summarize facts about orders to move goods. Some orders transfer goods internally, some are sales to customers, some are purchases from vendors, and...

What are the key components of a data governance program? How does data stewardship relate to data governance?

A plant produces three product lines: A, B, and C. There are 6 models within product line A, 4 models within B, and 8 within C. Average annual production quantities of each A model is 500 units, 700...

A DAC uses a reference voltage of 80 V and has 6-bit precision. In four successive sampling periods, each 1 second long, the binary data contained in the output register were 100000, 011111, 011101,...

A dc servomotor is used to drive one of the table axes of an NC milling machine. The motor is coupled directly to the lead screw for the axis, and the lead screw pitch = 5 mm. The optical encoder...

In the previous problem, suppose that the machine will be operated three shifts, or 6000 hr/yr, instead of 2000 hr/yr. Note the effect of increased machine utilization on the hourly rate compared to...

An automated storage/retrieval system for work-in-process has five aisles. The storage racks in each aisle are 10 m high and 50 m long. The S/R machine for each aisle travels at a horizontal speed of...

A single carousel storage system is located in a factory making small assemblies. It is 20 m long and 1.0 m wide. The pick and deposit time is 0.25 min. The speed at which the carousel operates is...

A storage system serving an electronics assembly plant has three storage carousels, each with its own manually operated pick and deposit station. The pick and deposit time is 0.30 min. Each carousel...

A roller conveyor moves tote pans in one direction at 150 ft/min between a load station and an unload station, a distance of 200 ft. With one worker, the time to load parts into a tote pan at the...

A machine shop has dedicated one CNC machining center to the production of two parts (A and B) used in the final assembly of the company's main product. The machining center is equipped with an...

A Geneva with six slots is used to operate the worktable of a dial-indexing machine. The slowest workstation on the dial-indexing machine has an operation time of 2.5 sec, so the table must be in a...

A plastic extrusion plant will be built to produce 30 million meters of plastic extrusions per year. The plant will run three 8hour shifts per day, 360 days per year. For planning purposes, the...

A partially automated production line has a mixture of three mechanized and three manual workstations. There are a total of six stations, and the ideal cycle time of 1.0 min, which includes a...

A garment manufacturer produces 22 different coat styles, and every year new coat styles are introduced and old styles are discarded. Whatever the style, the final inspection department checks each...

A semi automated flexible manufacturing cell is used to produce three products. The products are made by two automated processing stations followed by an assembly station. There is also a load/unload...

What are the Type I and Type II errors that can occur in inspection?

A digital camera maker produces three different models: (1) base model, (2) zoom model, and (3) zoom model with extra memory. Data for the three models are shown in the table below. The three models...

Two of the edges of a rectangular part are represented by two lines in the x-y plane on a CMM worktable, as illustrated in. It is desired to mathematically redefine the coordinate system so that the...

A stamping plant supplies sheet metal parts to a final assembly plant in the automotive industry. The following data are values representative of the parts made at the plant. Annual demand is 150,000...

What other actions could the University have taken to prevent the attack?

Why is it so important for you to protect yourself?

A precise optical signal source can control the output power level to within 1 percent [32]. A laser is controlled by an input current to yield the power output. A microprocessor controls the input...

In a chemical process control system, it is valuable to control the chemical composition of the product. To do so, a measurement of the composition can be obtained by using an infrared stream...

Many modern luxury automobiles have an auto park option. This feature will parallel park an automobile without driver intervention. Figure AP1.3 illustrates the parallel parking scenario. Using...

One of the most potentially beneficial applications of an automotive control system is the active control of the suspension system. One feedback control system uses a shock absorber consisting of a...

A two-transistor series voltage feedback amplifier is shown in Figure P2.24(a). This AC equivalent circuit neglects the bias resistors and the shunt capacitors. A block diagram representing the...

Obtain the transfer function of the differentiating circuit shown in Figure P2.7. V.ts FIGURE P2.7 A differentiating circuit

Determine the transfer function X1(s)/F(s) for the coupled spring-mass system of Problem P2.3. Sketch the s-plane pole-zero diagram for low damping when M = l, b/k = l, and Discuss. b01

There has been considerable engineering effort directed at finding ways to perform manipulative operations in space-for example, assembling a space station and acquiring target satellites. To perform...

The control of an autonomous vehicle motion from one point to another point depends on accurate control of the position of the vehicle [16]. The control of the autonomous vehicle position Y(s) is...

The Mile-High Bungi Jumping Company wants you to design a bungi jumping system (i.e., a cord) so that the jumper cannot hit the ground when his or her mass is less than 100 kg, but greater than 50...

A deburring robot can be used to smooth off machined parts by following a preplanned path (input command signal). In practice, errors occur due to robot inaccuracy, machining errors, large...

The capstan drive system of problem CDP5.1 uses the amplifier as the controller. Determine the maximum value of the gain Ka before the system becomes unstable.

The elevator in Yokohama's 70-story Landmark Tower operates at a peak speed of 45 km/hr. To reach such a speed without inducing discomfort in passengers, the elevator accelerates for longer periods,...

Arc welding is one of the most important areas of application for industrial robots [11]. In most manufacturing welding situations, uncertainties in dimensions of the part, geometry of the joint, and...

A unity feedback system has a loop transfer function (a) Determine the angle of departure of the root locus at the complex poles. (b) Sketch the root locus. (c) Determine the gain K when the roots...

A tape recorder has a speed control system so that H(s) = 1 with negative feedback and L(s) = Gc(s)G(s) = K / s(s + 2)(s2 + 4s + 5). (a) Sketch a root locus for K, and show that the dominant roots...

A unity feedback system has a loop transfer function Sketch the root locus. Determine the gain K when the complex roots of the characteristic equation have a ζ approximately equal to...

A unity feedback system has a loop transfer function Sketch the root locus for 0 ¤ a l(s)-G,(s)G (s) = 4(s2 + 1) ss + a) L(s)-G(s)G(s) =

Consider a unity feedback system with L(s) = Gc(s)G(s) = K(s + 1) / s2 + 4s + 5 (a) Find the angle of departure of the root locus from the complex poles. (b) Find the entry point for the root locus...

A unity feedback system has a loop transfer function (a) Draw the root locus as z varies from 0 to 100. (b) Using the root locus, estimate the percent overshoot and settling time (with a 2%...

An RLC network is shown in Figure P7.30. The nominal values (normalized) of the network elements are L - C = 1 and R = 2.5. Show that the root sensitivity of the two roots of the input impedance Z(s)...

Consider the feedback control system in Figure E8.11. Sketch the Bode plot of G(s) and determine the crossover frequency, that is the frequency when 20 1og10|G(j)| = 0dB. Figure E8.11 Unity feedback...

A robotic arm has a joint-control loop transfer function Show that the frequency equals 28.3 rad/s when the phase angle of L(jÏ) is -180°. Find the magnitude of L(jÏ) at that frequency....

Consider a unity feedback system with the loop transfer function (a) Plot the Bode diagram, (b) Find the gain margin and the phase margin. 10 0.4s) 2s)(10.24s 0.04s2) G(s)G(s)-

A unity feedback system has a loop transfer function (a) Using a Bode diagram for K = 10, determine the system phase margin, (b) Select a gain K so that the phase margin is at least 60°. L(s) =...

Consider a unity feedback system with the loop transfer function (a) For K = 4, show that the gain margin is 3.5 dB. (b) If we wish to achieve a gain margin equal to 16 dB, determine the value of the...

The block diagram of a feedback control system is shown in Figure P8.12(a).The transfer functions of the blocks are represented by the frequency response curves shown in Figure P8.12(b).

The non unity feedback control system shown in Figure E10.18 has the transfer functions Design a compensator Gt.(s) and prefilter Gp(s) so that the closed-loop system is stable and meets the...

The design of a lunar excursion module (LEM) is an interesting control problem. The attitude control system for the lunar vehicle is shown in Figure PI 0.1. The vehicle damping is negligible, and the...

A unity feedback control system for a robot submarine has a plant with a third-order transfer function [20]: We want the overshoot to be approximately 7.5% for a step input and the settling time...

An engineering design team is attempting to control a process shown in Figure PI0.27. The system has a controller Gc(s), but the design team is unable to select Gc(s) appropriately. It is agreed that...

A process has the transfer function y = [0 l]x + [0]. Determine the state variable feedback gains t achieve a settling time (with a 2% criterion) of 1 second and an overshoot of about 10%. Also...