The list below shows a set of customers that a company has and their RFM scores. Answer the following questions using information from the list. a. Which of the customers should the company focus...

1. What process would you use to identify your choice of a first round athletic draft? 2. Is choosing athletes any different from hiring any other kind of employee? 3. Why do you think these...

Consider the data needs of the student-run newspaper in your university or high school. What are the data entities of this enterprise? List and define each entity. Then, develop an enterprise data...

Consider Figure 1-11, which depicts a hypothetical multitier database architecture. Identify potential duplications of data across all the databases listed on this figure. What problems might arise...

Interview a systems analyst or database analyst and ask questions about the typical composition of an information systems development team. Specifically, what role does a database analyst play in...

List five costs or risks associated with the database approach.

List the four types of cardinality constraints, and draw an example of each.

Give an example, other than those described in this chapter, of a weak entity type. Why is it necessary to indicate an identifying relationship?

Give an example of each of the following, other than those described in this chapter, and clearly explain why your example is this type of relationship and not of some other degree. a. Ternary...

State a rule that says when to extract an attribute from one entity type and place it in a linked entity type.

What are the special guidelines for naming relationships?

In addition to explaining what action is being taken, what else should a relationship definition explain?

Give four reasons why a business rules approach is advocated as a new paradigm for specifying information systems requirements.

Figure 2-27 represents a situation of students who attend and work in schools and who also belong to certain clubs that are located in different schools. Study this diagram carefully to try to...

State six general guidelines for naming data objects in a data model.

What are the benefits of enforcing the integrity constraints as part of the database design and implementation process (instead of doing it in application design)?

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

Consider the composite usage map in Figure 5-1. After a period of time, the assumptions for this usage map have changed, as follows: There is an average of 50 supplies (rather than 40) for each...

Consider Figure 4-38 and your answer to Problem and Exercise 4-48 in Chapter 4. Assume that the most important reports that the organization needs are as follows: A list of the current developer's...

List ProductID, ProductDescription, ProductFinish, and ProductStandardPrice for oak products with a ProductStandardPrice greater than $400 or cherry products with a StandardPrice less than $300. Show...

For each order, list the order ID, customer ID, order date, and most recent date among all orders. Show how you constructed this query using a Venn diagram.

This chapter discusses the data dictionary views for Oracle 12c. Research another RDBMS, such as Microsoft SQL Server, and report on its data dictionary facility and how it compares with Oracle.

Write the SQL command to find any tutors who have not submitted a report for July.

Where do you think student and tutor information such as name, address, phone, and e-mail should be kept? Write the necessary SQL commands to capture this information.

Which tutors, by name, are available to tutor? Write the SQL command.

Write an SQL command that will find any customers who have not placed orders.

List the names and number of employees supervised (label this value HeadCount) for each supervisor who supervises more than two employees.

The production manager at PVFC is concerned about support for purchased parts in products owned by customers. A simple analysis he wants done is to determine for each customer how many vendors are in...

Write an SQL query to list the order number and order quantity for all customer orders for which the order quantity is greater than the average order quantity of that product.

List the five major trends that necessitate data warehousing in many organizations today.

How can data capture processes be improved to improve data quality?

List five errors and inconsistencies that are commonly found in operational data.

Define each of the following terms: a. Hadoop b. MapReduce c. HDFS d. NoSQL e. Pig f. Data mining g. Online analytical processing h. Business intelligence

Identify six broad categories of implications of big data analytics and decision making.

What concerns would you have if you accept a job as a database administrator and discover that the database users are entering one common password to log on to the database each morning when they...

List four common problems of ineffective data administration.

Match the following terms to the appropriate definitions: _______ Hive a. knowledge discovery using a variety of statistical and computational techniques _______ Text mining b. analytics that...

What are the three functions of adaptive control?

A continuous voltage signal is to be converted into its digital counterpart using an analog-to-digital converter. The maximum voltage range is (30 V. The ADC has a 12-bit capacity. Determine (a)...

A cast iron work piece is to be face milled on an NC machine using cemented carbide inserts. The cutter has 16 teeth and is 120 mm in diameter. Cutting speed = 200 m/min and feed = 0.005 mm/tooth....

An end milling operation is performed on an NC machining center. The total length of travel is 625 mm along a straight line path to cut a particular work piece. Cutting speed = 2.0 m/s and chip load...

A turning operation is to be performed on an NC lathe. Cutting speed = 2.5 m/s, feed = 0.2 mm/rev, and depth = 4.0 mm. Work piece diameter = 100 mm and its length = 400 mm. Determine (a) Rotational...

The XYZ Company is planning to introduce a new product line and will build a new factory to produce the parts and assembly the final products for the product line. The new product line will include...

What is forward sensing in AGVS terminology?

What is the unit load principle?

Suppose the warehouse in the preceding problem were organized according to a class-based dedicated storage strategy based on activity level of the pallet loads in storage, so that aisles 1 and 2...

A closed loop overhead conveyor must be designed to deliver parts from one load station to one unload station. The specified flow rate of parts that must be delivered between the two stations is 300...

A planned fleet of forklift trucks has an average travel distance per delivery = 500 ft loaded and an average empty travel distance = 350 ft. The fleet must make a total of 60 deliveries per hour....

The arc-on time is a measure of efficiency in an arc welding operation. As indicated in our discussion of arc welding in Section 8.5.2, typical arc-on times in manual welding range between 20% and...

Name and briefly describe four of the six measures used to assess the performance of a storage system?

In the manual operation of a sheet metal stamping press, a two button safety interlock system is often used to prevent the operator from inadvertently actuating the press while his hand is in the...

An industrial robot performs a machine loading and unloading operation. A PLC is used as the robot cell controller. The cell operates as follows: (1) a human worker places a work part into a nest,...

A flexible manufacturing system is being planned. It has a ladder layout as pictured in Figure P10.1 and uses a rail guided vehicle system to move parts between stations in the layout. All work parts...

An automated guided vehicle system is being proposed to deliver parts between 40 workstations in a factory. Loads must be moved from each station about once every hour; thus, the delivery rate = 40...

An AGVS will be implemented to deliver loads between four workstations: A, B, C, and D. The hourly flow rates (loads/hr) and distances (m) within the system are given in the table below (travel...

What are the five factors that can be used to distinguish manufacturing systems in the classification scheme proposed in the chapter?

What are the additional three enablers that are required for unattended operation of a mixed-model automated production cell?

A 20station transfer line presently operates with a line efficiency E = 1/3. The ideal cycle time = 1.0 min. The repair distribution is geometric with an average downtime per occurrence = 8 min, and...

What are the two aspects of quality in a manufactured product? List some of the product characteristics in each category.

A robotic assembly cell uses an industrial robot to perform a series of assembly operations. The base part and parts 2 and 3 are delivered by vibratory bowl feeders that use selectors to insure that...

Reconsider Problem 17.17 except that both the current line and the proposed line will have storage buffers before and after the manual stations. The storage buffers will be of sufficient capacity to...

What is the measure step in DMAIC?

What is a robust design in Taguchi's quality engineering?

A synchronous assembly machine has 8 stations and must produce at an average rate of 400 completed assemblies per hour. Average downtime per jam is 2.5 min. When a breakdown occurs, all subsystems...

A flexible manufacturing system is used to produce three products. The FMS consists of a load/unload station, two automated processing stations, an inspection station, and an automated conveyor...

What is meant by the term process capability?

For each of the three control charts, identify whether or not there is evidence that the process depicted is out of control.

In Problem 19.18, determine (a) The utilizations of each station in the system for the specified production requirements, and (b) What is the maximum possible production rate of the system if the...

A FMS consists of three stations plus a load/unload station. Station 1 loads and unloads parts using two servers (material handling workers). Station 2 performs horizontal milling operations with two...

What are the six phases of the general design process?

What is enterprise resource planning (ERP)?

What is the difference between independent demand and dependent demand?

Material requirements are to be planned for component C2 given the master schedule for P1 and P2, and the product structures in. Assembly lead time for products and subassemblies (P and S levels) is...

The inspection department in an automobile final assembly plant checks cars coming off the line against 85 features that are considered critical-to-quality characteristics for customer satisfaction....

A batch of large castings is processed through a machine shop. The batch size is 20. Each raw casting costs $175. There are 22 machining operations performed on each casting at an average operation...

Demand for a certain product is 25,000 units/yr. Unit cost is $10.00. Holding cost rate is 30%/yr. Changeover (setup) time between products is 10.0 hr, and downtime cost during changeover is $150/hr....

A part is produced in batches size of 3000 pieces. Annual demand is 60,000 pieces, and piece cost is $5.00. Setup time to run a batch is 3.0 hr, cost of downtime on the affected equipment is figured...

A variety of assembled products are made in batches on a batch model assembly line. Every time a different product is produced, the line must be changed over which causes lost production time. The...

Annual demand for a part is 500 units. The part is currently produced in batches. It takes 2.0 hours to set up the production machine for this part, and the downtime during setup costs $125/hr....

Apply Porter's value chain model to Costco (www.costco.com). What is Costco's competitive strategy? Who are Costco's major competitors? Describe Costco's business model. Describe the tasks that...

Compare and contrast Google Sites (www.google.com/sites) and Microsoft Office Live (www.liveoffice.com). Which site would you use to create your own Web site? Explain your choice.

Identify some benefits and limitations of e-commerce.

Discuss the benefits of telemetry in health care for the elderly.

How would you describe Web 2.0 to someone who has not taken a course in information systems?

Discuss each of the seven development methods in this section with regard to the four business decisions that organizations must make?

What is the difference between systems analysis and systems design?

Describe the alternate methods that can be used for systems development, other than the SDLC?

A large, braced robot arm for welding large structures is shown in Figure DP1.4. Sketch the block diagram of a closed-loop feedback control system for accurately controlling the location of the weld...

The rotational velocity Ï of the satellite shown in Figure E2.22 is adjusted by changing the length of the beam L. The transfer function between Ï(s) and the incremental change in beam...

A voltage follower (buffer amplifier) is shown in Figure P2.19. Show that T = v0/vin = 1. Assume an ideal op-amp. FIGURE P2.19 A butter amplifier

The measurement or sensor element in a feedback system is important to the accuracy of the system [6]. The dynamic response of the sensor is important. Most sensor elements possess a transfer...

A system is represented by Figure P2.36. (a) Determine the partial fraction expansion and y(t) for a ramp input, r(t) = t, t > 0. (b) Obtain a plot of y(t) for part (a), and find y(t) for t = 1.0 s....

A two-mass system is shown in Figure P2.37 with an input force u(t). When m1 = m2 = 1 and K1 = K2 = 1, find the set of differential equations describing the system. .t ely K, FIGURE P2.37 Two-mass...

An ideal set of gears is connected to a solid cylinder load as shown in Figure P2.44. The inertia of the motor shaft and gear G2 is Jm. Determine (a) The inertia of the load JL and (b) The torque T...

The circuit shown in Figure P2.48 is called a lead-lag filter. (a) Find the transfer function V2(s)/V1(s). Assume an ideal op-amp. (b) Determine V2(s)/V1(s) when R1 = 100 kΩ, R2 = 200...

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 b01

For the three-cart system illustrated in Figure AP2.5, obtain the equations of motion. The system has three inputs u1, u2, and u3 and three outputs x1, x2, and x3. Obtain three second-order ordinary...

Consider the cable reel control system given in Figure AP2.8. Find the value of A and K such that the percent overshoot is P.O. ¤ 10% and a desired velocity of 50 m/s in the steady state is...

A control system is shown in Figure DP2.1. The transfer functions G2(s) and H2(s) are fixed. Determine the transfer functions G1(s) and H1(s) so that the closed-loop transfer function Y(s)/R(s) is...

Consider the clock shown in Figure DP2.5. The pendulum rod of length L supports a pendulum disk. Assume that the pendulum rod is a mass less rigid thin rod and the pendulum disc has mass m. Design...