A process contains eight virtual pages on disk and is assigned a fixed allocation of four page frames in main memory. The following page trace occurs: a. Show the successive pages residing in the...

A 32-bit computer has two selector channels and one multiplexor channel. Each selector channel supports two magnetic disk and two magnetic tape units. The multiplexor channel has two line printers,...

Consider a 4-drive, 200 GB-per-drive RAID array. What is the available data storage capacity for each of the RAID levels, 0, 1, 3, 4, 5, and 6?

Until June 2012, PixelSense was called Surface. At that time, Microsoft repurposed the name to use on its tablet devices. Surface was changed to PixelSense. What conclusions do you draw from these...

Summarize the benefits of third-party cookies to consumers.

What does it mean to qualify a field name? How would you qualify the Street field in the Customer table?

Using data from the Premiere Products database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are...

Write a program that stores names and telephone numbers in a database. Write another program that stores names and addresses in a database. Modify the programs to use external, conceptual, and...

Discuss the differences between DDL and DML? What operations would you typically expect to be available in each language?

Consider your business school or other academic unit as a business enterprise. a. Define several major data entity types and draw a preliminary enterprise data model (similar in notation to Figure...

Answer the following questions concerning Figures 1-17 and 1-18: Figures 1-17 Figures 1-18 a. What will be the field size for the ProductLineName field in the Product table? Why? b. In Figure 1-18,...

Why is it recommended that every ternary relationship be converted into an associative entity?

Explain where you can find business rules in an organization.

Match the following terms and definitions: _________ Supertype. a. subset of supertype _________ Entity cluster b. entity belongs to two subtypes _________ Subtype. c. subtype gets supertype...

For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies (other than...

Based on the EER diagram constructed for Problem and Exercise 3-34, develop a sample definition for each entity type, attribute, and relationship in the diagram. Consultant There are two types of...

Map the EER diagram you developed in Chapter 3, 3-44 to a relational schema using the techniques described in this chapter. Be sure to appropriately identify the primary and foreign keys as well as...

Indexing can clearly be very beneficial. Why should you not create an index for every column of every table of your database?

Suppose you are designing a default value for the age field in a student record at your university. What possible values would you consider, and why? How might the default vary by other...

Write SQL queries to answer the following questions: a. How many students are enrolled in Section 2714 in the first semester of 2015? b. Which faculty members have qualified to teach a course since...

What is the average Read score for all students? What are the minimum and maximum Read scores? Based on the relations shown in Figure 6-12. The database tracks an adult literacy program. Tutors...

List the IDs of the tutors who are currently tutoring more than one student. Based on the relations shown in Figure 6-12. The database tracks an adult literacy program. Tutors complete a...

What are the TutorlDs for tutors who have not yet tutored anyone? Based on the relations shown in Figure 6-12. The database tracks an adult literacy program. Tutors complete a certification class...

Match the following terms to the appropriate definition: _________ Equijoina. Undoes changes to a table _________ Natural join..b. user-define data type _________ Outer join.c. SQL.: 1999 extension...

Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113?

Which tutor needs to be reminded to turn in reports? Write the SQL command. Show how you constructed this query using a Venn or other type of diagram.

Write an SQL command to display each item ordered for order number 1, its standard price, and the total price for each item ordered.

Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.

Indicate whether data administration or database administration is typically responsible for each of the following functions: a. Managing the data repository b. Installing and upgrading the DBMS c....

For each of the situations described below, select the type of analytics that would address the specific organizational need and justify your selection. a. A mid-sized bank would like to provide as...

What is the difference between an analog sensor and a discrete sensor?

Nearly all actuators can be classified into one of three categories, according to type of drive power. Name the three categories.

A voltage of 24 V is applied to a DC servomotor whose torque constant = 0.115 N-m/A and voltage constant = 0.097 V/(rad/sec). Armature resistance = 1.9 ohms. The motor is directly coupled to a blower...

The ABC Company is planning a new product line and will build a new plant to manufacture the parts for a new product line. The product line will include 50 different models. Annual production of each...

What is the difference between powered lead through and manual lead through in robot programming?

A robot performs a loading and unloading operation for a machine tool. The work cycle consists of the following sequence of activities: The activities are performed sequentially as listed. Every 30...

Identify the three application areas of automated storage/retrieval systems.

In Example 10.2 in the text, suppose that the vehicles operate according to the following scheduling rules: (1) vehicles delivering raw work parts from station 1 to stations 2, 3, and 4 must return...

What is the difference between fixed routing and variable routing in manufacturing systems consisting of multiple workstations?

An AS/RS with one aisle is 300 ft long and 60 ft high. The S/R machine has a maximum speed of 300 ft/min in the horizontal direction. It accelerates from zero to 300 ft/min in a distance of 15 ft. On...

A plastic injection molding plant will be built to produce 6 million molded parts per year. The plant will run three 8hour shifts per day, five days per week, 50 weeks per year. For planning...

What is the difference between a unitized production line and a link line?

A worker is currently responsible for tending two machines in a machine cluster. The service time per machine is 0.35 min and the time to walk between machines is 0.15 min. The machine automatic...

A factory production department consists of a large number of work cells. Each cell consists of one human worker performing electronics assembly tasks. The cells are organized into sections within...

The uptime efficiency of a 20 station automated production line is only 40%. The ideal cycle time is 48 sec, and the average downtime per line stop occurrence is 3.0 min. Assume the frequency of...

An eight-station rotary indexing machine performs the machining operations shown in the accompanying table, together with processing times and breakdown frequencies for each station. The transfer...

An automated assembly machine has four workstations. The first station presents the base part, and the other three stations add parts to the base. The ideal cycle time for the machine is 3 sec, and...

What is the difference between the primary and secondary handling systems that are common in flexible manufacturing systems?

A GT machine cell contains three machines. Machine 1 feeds machine 2 which is the key machine in the cell. Machine 2 feeds machine 3. The cell is set up to produce a family of five parts (A, B, C, D,...

A producer of cell phones checks each phone prior to packaging, using seven critical-to-quality (CTQ) characteristics that are deemed important to customers. Last year, out of 205,438 phones produced...

Annual demand for a madetostock product is 60,000 units. Each unit costs $8.00 and the annual holding cost rate is 24%. Setup time to change over equipment for this product is 6 hr, and the downtime...

The monthly demand for a part produced for an automotive final assembly plant is 16,000 units. There are 20 working days in February and the effective operating time of the plant is 900 min per day...

Compare Porter's three generic strategies.

1. Draw a diagram of the supply chain for a fish fillet from the ocean to the restaurant table in Japan. Then include the flow of information into the picture. Describe where IT is used to enable the...

An injection-molding machine used to produce 25 different plastic molded parts in a typical year. Annual demand for a typical part is 20,000 units. Each part is made out of a different plastic (the...

Describe Porter's value chain model. Differentiate between Porter's competitive forces model and his value chain model.

Unmanned aerial vehicles (UAVs) are being developed to operate in the air autonomously for long periods of time. By autonomous, we mean that there is no interaction with human ground controllers....

The position control system for a spacecraft platform is governed by the following equations: d2p / dt2 + 2dp / dt + 4p = v1 = r - p d/dt = 0.6v2 v2 = 7v1 The variables involved are as follows: r(t)...

Find the transfer function Y(s)/Td(s) for the system shown in Figure E2.27. T4LS) G,(s) RIs H(s) FIGURE E2.27 System with disturbance.

A four-wheel antilock automobile braking system uses electronic feedback to control automatically the brake force on each wheel [15]. A block diagram model of a brake control system is shown in...

Determine the transfer function Y1(s)/F(s) for the vibration absorber system of Problem P2.2. Determine the necessary parameters M2 and k12 so that the mass M1 does not vibrate in the steady state...

Consider the block diagram in Figure CP2.10. Create an m-file to complete the following tasks: (a) Compute the step response of the closed-loop system (that is, R(s) = 1/s and Td(s) = 0) and plot the...

Determine the state variable matrix equation for the circuit shown in Figure P3.6. Let x1 = v1, x2 = v2, and x3 = i. 4 kn 2 nH kn Oi FIGURE P3.6 RLC circuit.

An automatic depth-control system for a robot submarine is shown in Figure P3.7.The depth is measured by a pressure transducer. The gain of the stern plane actuator is K = 1 when the vertical...

In Figure E4.12, consider the closed-loop system with measurement noise N(s), where In the following analysis, the tracking error is defined to be E(s) = R(s) - Y(s): (a) Compute the transfer...

Two feedback systems are shown in Figures P4.12(a) and (b). (a) Evaluate the closed-loop transfer functions T1 and T2 for each system. (b) Compare the sensitivities of the two systems with respect to...

A closed-loop system is used in a high-speed steel rolling mill to control the accuracy of the steel strip thickness. The transfer function for the process shown in Figure E4.13 can be represented as...

Consider the unity feedback system shown in Figure E4.14. The system has two parameters, the controller gain K and the constant K1 in the process. (a) Calculate the sensitivity of the closed-loop...

A robotic arm and camera could be used to pick fruit, as shown in Figure E4.3(a). The camera is used to close the feedback loop to a microcomputer, which controls the arm [8, 9]. The transfer...

A magnetic disk drive requires a motor to position a read/write head over tracks of data on a spinning disk, as shown in Figure E4.4. The motor and head may be represented by the transfer function...

A system has a characteristic equation s3 + Ks2 + (1 + K)s + 6 = 0. Determine the range of K for a stable system.

A feedback system with negative unity feedback has a loop transfer function (a) Determine the closed-loop transfer function T(s) = Y(s)/R(s). (b) Find the time response, y(t), for a step input r(t) =...

A space telescope is to be launched to carry out astronomical experiments [8]. The pointing control system is desired to achieve 0.01 minute of arc and track solar objects with apparent motion up to...

The control of the spark ignition of an automotive engine requires constant performance over a wide range of parameters [15]. The control system is shown in Figure DP6.1, with a controller gain K to...

A "paper-pilot" model is sometimes utilized in aircraft control design and analysis to represent the pilot in the loop. A block diagram of an aircraft with a pilot "in the loop" is shown in Figure...

Control systems for maintaining constant tension on strip steel in a hot strip finishing mill are called "loopers." A typical system is shown in Figure P7.16. The looper is an arm 2 to 3 feet long...

The feedback system shown in Figure AP7.13 has two unknown parameters K1 and K2. The process transfer function is unstable. Sketch the root locus for 0 ¤ K1, K2 Figure AP7.13 An unstable plant...

An attitude control system for a satellite vehicle within the earth's atmosphere is shown in Figure P7.6. The transfer functions of the system are and (a) Draw the root locus of the system as K...

A compact disc player for portable use requires a good rejection of disturbances and an accurate position of the optical reader sensor. The position control system uses unity feedback and a loop...

Determine the transfer function of the op-amp circuit shown in Figure P8.26. Assume an ideal op-amp. Plot the frequency response when R1 = 9k . R2 = 1 k, and C = μF

A rover vehicle designed for use on other planets and moons is shown in Figure DP7.12(a) [21]. The block diagram of the steering control is shown in Figure DP7.12(b), where (a) When Gc(s) = K, sketch...

Consider the feedback system shown in Figure DP7.14. The process transfer function is marginally stable. The controller is the proportional-derivative (PD) controller Gc(s) = KP + KDs. (a) Determine...

A unity feedback control system has a loop transfer Function Determine the phase margin, the crossover frequency, and the gain margin when K - 1300. L(s) = Gc(s)G(s) S(S + 2)(s + 50)

An integrated CMOS digital circuit can be represented by the Bode diagram shown in Figure E9.5. (a) Find the gain and phase margins of the circuit. (b) Estimate how much we would need to reduce the...

A DC motor controller used extensively in automobiles is shown in Figure P8.19(a). The measured plot of Q(s)/I(s) is shown in Figure P8.19(b). Determine the transfer function of Q(s)/I(s). FIGURE...

A unity feedback system has a loop transfer function where K = 1 / 2and T = 1. The polar plot for Gc(jÏ)G(jaÏ) is shown in Figure E9.24. Determine whether the system is stable by using the...

The possibility of overcoming wheel friction, wear, and vibration by contactless suspension for passenger-carrying mass-transit vehicles is being investigated throughout the world. One design uses a...

Consider the block diagram model. Write the corresponding state variable model in the form y = Cx + Dµ.

The heading control of the traditional bi-wing aircraft, is represented by the block diagram. (a) Determine the minimum value of the gain K when Gc{s) = K, so that the steady-state effect of a unit...

A 255-GB disk has 65,536 cylinders with 255 sectors per track and 512 bytes per sector. How many platters and heads does this disk have? Assuming an average cylinder seek time of 11 ms, average...

For each of the following system calls, give a condition that causes it to fail: fork, exec, and unlink.

Give an example of a deadlock taken from politics.

Which constructs in a Presentation-Layer ER diagram cannot be directly mapped to a logical schema? What is required to represent these constructs in a Design-Specific ER diagram?

Consider the Presentation Layer ER diagram. a. Identify the base and weak entity types. What is (are) the unique identifier(s) of each entity type? Which unique identifiers are composite attributes?...

What is the difference between an exclusive arc and an inclusive arc?

Consider the following Presentation Layer ER diagram. a. Identify all entity types that at one time or another function as a superclass. b. List the superclass entity type and subclass entity type(s)...

This exercise refers to the relations R1 and R2 given below. Show the relations created as a result of the following relational algebra operations Relation R1 Rl.a R1.b R1.c 30 a 20 45 b 32 75 a 24...

Identify the set of functional dependencies in the relation instance CAR shown below. Does this constitute the minimal cover for the set of functional dependencies present in CAR? If it is not a...

While browsing at Billy Bob's computer store, you overhear a customer asking Billy Bob what is the fastest computer in the store that he can buy. Billy Bob replies, "You're looking at our...

Consider a relational schema with three relation schemas: DRIVER (Dr_license_no, Dr_name, Dr_city, Dr_state), TICKET_TYPE (Ttp_offense, Ttp_fine) and TICKET (Tic_ticket_no, Tic_ticket_date,...