Describe the concept of join dependency and describe how this concept relates to 5NF. Provide an example to illustrate your answer.

Create a local conceptual data model for the Branch user views of Dream Home documented in Appendix A. Compare your ER diagram with Figure 13.8 and justify any differences found.

Create and validate a local logical data model from the conceptual data model for the Easy Drive School of Motoring case study created in Exercise 15.18.

Present the relational schema mapped from the Parking Lot EER model shown in Figure 17.11 and described in Exercises 12.13 and 13.11.

Discuss how the log file (or journal) is a fundamental feature in any recovery mechanism. Explain what is meant by forward and backward recovery and describe how the log file is used in forward and...

One problem area with DDBMSs is that of distributed database design. Discuss the issues that have to be addressed with distributed database design. Discuss how these issues apply to the global system...

1. Consider the 5 components of an information system provided in Figure 1-1 in Chapter 1. Which of these components was the reason for the lack of success in the first round of ERP implementation at...

Name the five phases of the traditional systems development life cycle, and explain the purpose and deliverables of each phase.

What is the degree of a relationship? List the three types of relationship degrees described in the chapter and give an example of each.

Give an example (other than those described in this chapter) for each of the following, and justify your answer: a. Derived attribute b. Multivalued attribute c. Atomic attribute d. Composite...

Are associative entities also weak entities? Why or why not? If yes, is there anything special about their "weakness"?

Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help...

State four criteria for selecting identifiers for entities.

Why must some identifiers be composite rather than simple?

Assume that at Pine Valley Furniture, each product (described by product number, description, and cost) is composed of three components (described by component number, description, and unit of...

Describe how the following components of an E-R diagram are transformed into relations: a. Regular entity type b. Relationship (1:M) c. Relationship (M:N) d. Relationship (supertype/subtype) e....

Briefly describe four typical problems that often arise in merging relations and common techniques for addressing those problems.

Refer to Problem and Exercise 2-44 in Chapter 2, Part f. Redraw the ERD for your answer to this exercise using appropriate supertypes and subtypes. In Exercise 2-44 Part f You may see various...

Transform the relational schema developed in Problem and Exercise 4-37 into an EER diagram. State any assumptions that you have made.

Transform Figure 2-15a, attribute version, to 3NF relations. Transform Figure 2-15b, relationship version, to 3NF relations. Compare these two sets of 3NF relations with those in Figure 4-10. What...

Summarize six important properties of relations.

Describe two properties that each candidate key must satisfy.

Describe three types of anomalies that can arise in a table and the negative consequences of each.

Demonstrate each of the anomaly types with an example.

Explain why normalized relations may not comprise an efficient physical implementation structure.

List three common situations that suggest that relations be denormalized before database implementation.

List seven important criteria for selecting the best file organization.

What is the most important mechanism that database designers can use to impact database performance in specific use situations?

Say that you are interested in storing the numeric value 3,456,349.2334. What will be stored, with each of the following Oracle data types: a. NUMBER (ll) b. NUMBER (11,1) c. NUMBER (ll,-2) d. NUMBER...

Explain how physical database design has an important role in forming a foundation for regulatory compliance.

Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the on update restrict, on update cascade, and on update set null clauses differ from one...

Explain and provide at least one example of how to qualify the ownership of a table in SQL. What has to occur for one user to be allowed to use a table in a database owned by another user?

How is the order in which attributes appear in a result table changed? How are the column heading labels in a result table changed?

What is the evaluation order for the Boolean operators (AND, OR, NOT) in an SQL command? How can a query writer be sure that the operators will work in a specific, desired order?

Explain why SQL is called a set-oriented language.

What is an identity column? Explain the benefits of using the identity column capability in SQL.

What can be changed about a table definition, using the SQL command ALTER? Can you identify anything about a table definition that cannot be changed using the ALTER command?

Explain the difference between the WHERE and HAVING clause.

Describe a relational DBMS (RDBMS), its underlying data model, its data storage structures, and how data relationships are established.

Describe the components and structure of a typical SQL environment.

Define each of the following terms: a. Dynamic SQL b. Correlated subquery c. Embedded SQL d. Procedure e. Join f. Equijoin g. Self join h. Outer join i. Function j. Persistent Stored Modules (SQL/PSM)

Determine the relationships among the four relations in Figure 7-17. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain referential...

What are some of the purpose for which you would use correlated subqueries?

The head of marketing is interested in some opportunities for cross-selling of products. She thinks that the way to identify cross-selling opportunities is to know for each product how many other...

Rewrite the example shown in Figure 8-4 using Java.

Is a star schema a relational data model? Why or why not?

What is the meaning of the phrase "slowly changing dimension"?

List and briefly describe five steps in the data reconciliation process.

Any successful data governance program needs to address the people ("who"), ("how"), and technology ("what") aspects. Based on your reading of Chapter 10, provide some examples for each of these...

Contrast the following terms: a. Static extract; incremental extract b. Data scrubbing; data transformation c. Consolidation; federation d. ETL; master data management

Simplified Automobile Insurance Company would like to add a Claims dimension to its star schema (see Problem and Exercise 9-30). Attributes of Claim are ClaimID, ClaimDescription, and ClaimType....

Millennium College (see Problem and Exercise 9-28) now wants to include new data about course sections: the department offering the course, the academic unit to which the department reports, and the...

State at least seven commonly used data mining techniques.

Describe the core idea underlying in-memory database management systems.

Identify at least five categories of human activity that are affected by big data and analytics.

Using the MDIFF "ordered analytical function" in Teradata SQL (see the Functions and Operators manual), show the differences (label the difference CHANGE) in TOTAL (which you calculated in the...

What is the primary difference between key-value stores and document stores?

Suppose the part in the previous problem is made in very large quantities on a production line in which an automated work handling system is used to transfer parts between machines. Transfer time...

A factory produces cardboard boxes. The production sequence consists of three operations: (1) cutting, (2) indenting, and (3) printing. There are three machines in the factory, one for each...

Describe the differences in orientation capabilities and work volumes for a :TR and a :RT wrist assembly. Use sketches as needed.

An emergency stop system is to be designed for a certain automatic production machine. A single "start" button is used to turn on the power to the machine at the beginning of the day. In addition,...

There are nine machines in the automatic lathe section of a certain machine shop. The setup time on an automatic lathe averages 6 hours. The average batch size for parts processed through the section...

In the previous problem, suppose that a double gripper is used instead of a single gripper as indicated in that problem. The activities in the cycle would be changed as follows: Steps 1, 4, and 5 are...

Since the robot's portion of the work cycle requires much less time than the machine tool in Problem 8.6, the possibility of installing a cell with two machines is being considered. The robot would...

What are the five material handling functions that must be provided in a manufacturing system?

What is a pallet fixture in work transport in a manufacturing system?

A unit load AS/RS for work-in-process storage in a factory must be designed to store 2000 pallet loads, with an allowance of no less than 20% additional storage compartments for peak periods and...

A rotary worktable is driven by a Geneva mechanism with five slots. The driver rotates at 48 rev/min. Determine (a) The cycle time, (b) Available process time, and (c) Indexing time each cycle.

A ten-station rotary indexing machine performs nine machining operations at nine workstations, and the tenth station is used for loading and unloading parts. The longest process time on the line is...

An industrial robot will service n production machines in a machine cluster. Each production machine is identical and has an automatic processing time Tm = 130 sec. The robot servicing and...

A new forging plant must supply parts to the automotive industry. Because forging is a hot operation, the plant will operate 24 hr per day, five days per week, 50 weeks per year. Total output from...

Solve the previous problem except that the Geneva has eight slots. Previous problem A Geneva with six slots is used to operate the worktable of a dial-indexing machine. The slowest workstation on the...

A 16-station transfer line can be divided into two stages by installing a storage buffer between stations 8 and 9. The probability of failure at any station is 0.01. The ideal cycle time is 1.0 min...

Cost elements associated with the operation of the ten-station transfer line in Problem 16.4 are as follows: raw work part cost = $0.55/pc, line operating cost = $42.00/hr, and cost of disposable...

What is the difference between a hierarchical structure and a chain-type structure in a classification and coding scheme?

Develop the form code (first five digits) in the Opitz System for the part illustrated in Figure P18.3.

A six-station automatic assembly machine has an ideal cycle time of 6 sec. At stations 2 through 6, parts feeders deliver components to be assembled to a base part that is added at the first station....

Apply the rank order clustering technique to the part-machine incidence matrix in the following table to identify logical part families and machine groups. Parts are identified by letters, and...

The upper and lower control limits for a p chart are: LCL = 0 and UCL = 0.20. The center line of the p chart is at 0.10. Determine the sample size n that is compatible with this control chart.

A supplier of parts to an assembly plant in the household appliance industry is required to make deliveries on a just-in-time basis (daily). For one of the parts that must be delivered, the daily...

Compare the two types of network architectures.

1. Discuss the reasons why end-user-developed information systems can be of poor quality. 2. What can be done to improve this situation?

Describe a request for proposal (RFP)?

An autofocus camera will adjust the distance of the lens from the film by using a beam of infrared or ultrasound to determine the distance to the subject [42]. Sketch a block diagram of this...

The potential of employing two or more helicopters for transporting payloads that are too heavy for a single helicopter is a well-addressed issue in the civil and military rotorcraft design arenas...

Determine the transfer function V0(s)/V(s) for the op-amp circuit shown in Figure E2.28 [1]. Let R1 = 167 kΩ, R2 = 240 kΩ, R3 = 1 kΩ, R4 = 100 kΩ, and...

Obtain a signal-flow graph to represent the following set of algebraic equations where x1 and x2 are to be considered the dependent variables and 6 and 11 are the inputs: x1 + 1.5x2 = 6, 2x1 + 4x2 =...

A mechanical system is shown in Figure P2.17, which is subjected to a known displacement x3(t) with respect to the reference, (a) Determine the two independent equations of motion. (b) Obtain the...

We want to accurately position a table for a machine as shown in Figure CDP2.1. A traction-drive motor with a capstan roller possesses several desirable characteristics compared to the more popular...

An operational amplifier circuit that can serve as a filter circuit is shown in Figure DP2.4. Determine the transfer function of the circuit, assuming an ideal op-amp. Find v0(t) when the input is...

A system is represented by a block diagram as shown in Figure E3.5. Write the state equations in the form of Equations (3.16) and (3.17). FIGURE E3.5 Block diagram.

Determine a state variable model for the circuit shown in Figure P3.22. The state variables are x1 = i, x2 = v1, and x3 = v2. The output variable is v0(t). 12 Output FIGURE P3.22 RLC circuit.

The transfer function of a system is Sketch the block diagram and obtain a state variable model. Y(s) 2s 10 R(s) 4s26s 10 T(s)-

A speed control system using fluid flow components is to be designed. The system is a pure fluid control system because it does not have any moving mechanical parts. The fluid may be a gas or a...

Figure P4.16 shows the model of a two-tank system containing a heated liquid, where T0 is the temperature of the fluid flowing into the first tank and T2 is the temperature of the liquid flowing out...

An armature-controlled DC motor with tachometer feedback is shown in Figure AP4.4. Assume that Km = 10, J = l, and R = 1. (a) Determine the required gain, K, to restrict the steady-state error to a...

Consider the feedback system in Figure CP4.4. Suppose that the controller is Gc(s) = K = 10. Figure CP4.4 Unity feedback system with controller gain K. (a) Develop an m-file to compute the...

Consider the closed-loop control system shown in Figure CP4.5. Develop an m-file script to assist in the search for a value of k so that the percent overshoot to a unit step input is greater than 1%,...

Consider the block diagram shown in Figure E5.6 [16]. (a) Calculate the steady-state error for a ramp input. (b) Select a value of K that will result in zero overshoot to a step input. Provide the...

Consider the closed-loop system in Figure P5.22, where (a) If Ñ = 2.43, determine the value of K such that the steady-state error of the closed-loop system response to a unit step input, R(s)...