Consider as shown below, and suppose that authors could also appear as top level elements. What change would have to be done to the relational schema? similar PCDATA declarations for year,...
Write a query in XQuery on the XML representation as shown below to find the total balance, across all accounts, at each branch. A-101 Downtown 500 A-102 Perryridge 400 A-201 Brighton 900 Johnson...
Are reflex actions (such as moving your hand away from a hot stove) rational? Are they intelligent?
For each of the following agents, develop a PEAS description of the task environment: a. Robot soccer player, b. Internet book-shopping agent; c. Autonomous Mars rover; d. Mathematicians...
The vacuum environments in the preceding exercises have all been deterministic. Discuss possible agent programs for each of the following stochastic versions: a. Murphys Law twenty-five percent of...
Show that the 8-puizle states are divided into two disjoint sets, such that no state in one set can be transformed into a state in the other set by any number of moves. Devise a procedure that will...
Does a finite state space always lead to a finite search tree? How about a finite state space that is a tree? Can you be more precise about what types of state spaces always lead to finite search...
The heuristic path algorithm is a best-first search in which the objective function is f(n) = (2 w) g(n) + wh(n). For what values of w is this algorithm guaranteed o be optimal? (You may assume that...
Prove each of the following statements: a. Breadth-first search is a special case of uniform-cost search. b. Breadth-first search, depth-first search, and uniform-cost search are special cases of...
Consider the following logic puzzle: In five houses, each with a different color, live 5 persons of different nationalities, each of whom prefer a different brand of cigarette, a different drink, and...
This exercise looks into the relationship between clauses and implication sentences. a. Show that the clause (P1 V . . . V Pm VQ) iS logically equivalent to the implication sentence (P1 . . . Pm)...
Prove the following assertions about planning graphs: a. A literal that does not appear in the final level of the graph cannot he achieved. b. The level cost of a literal in a serial graph is no...
List and briefly describe the characteristics that an analyst examines when choosing or defining the deployment environment.
Develop a use case diagram for the university library system. Part a. Based on the following descriptions; list the use cases and actors. Patrons have access to the library information to search for...
To review your skills in developing a class diagram, develop a domain model class diagram, including associations and multiplicities, based on the following narrative. A clinic with three dentists...
Given the following list of classes and relationships for the previous car insurance system, list the preconditions and the post conditions for the Add a new vehicle to an existing policy use case....
The right side of Figure shows a system that simulates the manufacture of computer chips. The equations in the simulation system are based on statistical probabilities of failures in the...
How does the use of the Internet, intranets, and extranets by companies today support their business processes and activities?
Small businesses have been slower to integrate information technology into their operations than larger companies. Break into small groups with your classmates to discuss the reasons for this state...
How could a business use information technology to increase switching costs and lock in its customers and suppliers? Use business examples to support your answers.
How could a business use Internet technologies to form a virtual company or become an agile competitor?
What is the business value driving so many companies to install and extend intranets rapidly throughout their organizations?
Refer to the Real World Case on telepresence in the chapter. What seems to be the difference between videoconferencing and telepresence? Given the discussion on the latter in the case, does...
What are the most important HR applications a company should offer to its employees via a Web-based system? Why?
How could sales force automation affect salesperson productivity, marketing management, and competitive advantage?
How do you think the possession or access to certain information shapes the political dynamics of organizations? Do you believe companies should be open about widespread access to information, or...
What are several business decisions that you will have to make as a manager that have both ethical and IT dimensions? Give examples to illustrate your answer.
Remote Point of Sales in Mexico Melissa and Rook Nelson, co-owners of Skydive Chicago, shut down their northern operations in mid- December each year. With heavy cloud cover and frigid temperatures,...
Refer to the Real World Case on the globalization challenges faced by CIOs in the chapter. All those mentioned are CIOs from headquarters who went abroad, but there is no mention of CIOs from...
What are the six general skills all project team members should have?
What are the major roles on a project team?
Describe the principal steps in the planning phase. What are the major deliverables?
Describe the principal steps in the design phase. What are the major deliverables?
Describe the principal steps in the implementation phase. What are the major deliverables?
Describe the four steps of business process management. Why do companies adopt BPM as a management strategy?
What is the purpose of an approval committee? Who is usually on this committee?
Social Engineering An employee who needs permission to access an electronic workspace, database, or other information systems resource typically fills in a request form and obtains approval from the...
Describe a "risky" project in terms of technical feasibility. Describe a project that would not be considered risky.
Select a computer-aided software engineering (CASE) tooleither one that you will use for class, a program that you own, or a tool that you can examine over the Web. Create a list of the capabilities...
Some companies hire consulting firms to develop the initial project plans and manage the project, but use their own analysts and programmers to develop the system. Why do you think some companies do...
Pretend that your instructor has asked you and two friends to create a Web page to describe the course to potential students and provide current class information (e.g., syllabus, assignments,...
In April 1999, one of Capital Blue Cross' health-care insurance plans had been in the field for three years, but hadn't performed as well as expected. The ratio of premiums to claims payments wasn't...
Suppose that you are an analyst for the ABC Company, a large consulting firm with offices around the world. The company wants to build a new knowledge management system that can identify and track...
Pretend that the career services office at your university wants to develop a system that collects student rsums and makes them available to students and recruiters over the Web. Students should be...
Why is document analysis useful? What insights into the organization can it provide?
What role does iteration play in developing use cases?
Several years ago, a well-known national real estate company built a computer-based system to help its real estate agents sell houses more quickly. The system, which worked in many ways like an early...
Explain the process of balancing a set of DFDs.
What is meant by a DFD semantic error? Provide an example.
Create a set of use cases for a university library borrowing system. (Do not worry about catalogue searching, etc.) The system will record the books owned by the library and will record who has...
Locate the independent entities on Figure. How do you know which of the entities are independent? Locate the nonidentifying relationships. How did you find them? Can you create a rule that describes...
Locate the dependent entities on Figure. Locate the identifying relationships. How did you find them? Can you create a rule that describes the association between dependent entities and...
Describe the three primary strategies that are available to obtain a new system.
What information is typically conveyed in an RFP?
Develop a hardware and software specification for the university course registration system described in Your Turn 8-1.
Explain the difference between concurrent multilingual systems and discrete multilingual systems.
What is white space, and why is it important?
Under what circumstances should densities be low? high?
What are use scenarios, and why are they important?
What is an interface structure diagram (ISD), and why is it used?
Compare and contrast the three types of interface design prototypes.
Describe three basic principles of navigation design.
Describe four types of navigation controls.
Why are menus the most commonly used navigation control?
Under what circumstances would you use a dropdown menu versus a tab menu?
Explain three principles in the design of outputs.
Describe the primary components of the interface standards for a Web site that sells some retail products (metaphors, objects, actions, icons, and templates).
What is the difference between a transaction structure and a transform structure? Can a module be a part of both types of structures? Why or why not?
List the seven types of cohesion. Why do the various types of cohesion range from good to bad? Give an example of good coupling and an example of bad coupling.
What are the five types of coupling? Give an example of good coupling and an example of bad coupling.
Create a structure chart based on the data flow diagrams (DFDs) that you created for the following exercises in Chapter 5: Question D Question E Question F Question G Question H
Develop the combination of conversion strategy dimensions that produces the least risk; the most risk. Develop the combination of conversion strategy dimensions that produces the least cost; the...
Why do people resist change? Explain the basic model for understanding why people accept or resist change.
Suppose that you are the project leader for the scenario described in Exercise J. Develop a migration plan (including both conversion and change management) for the independent travel agencies who...
You have been working with the system for the campus housing service that helps students find apartments. One of the dynamic classes in this system likely is the apartment class. Draw a behavioral...
Consider a system that is used to run a small clothing store. Its main functionality is maintaining inventory of stock, selling items to customers, and producing sales reports for management. List...
Create a use case diagram that would illustrate the use cases for the following online university registration system: The system should enable the staff members of each academic department to...
What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the filestructure? PROJECT CODE PROJECT MANAGER MANAGER PHONE 21-52 25-2D...
If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the filestructure? PROJECT CODE PROJECT MANAGER MANAGER PHONE 21-52...
Create the relational diagram for the database shown in Figure.
What is the difference between a database and a table?
Describe the type(s) of relationship(s) between EMPLOYEE and STORE.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. Discuss.
Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. Discuss in detail.
For each table, identify a superkey and a secondary key.
Draw the relational diagram for the design you revised in problem 27. (After you have had a chance to revise the design, your instructor will show you the results of the design change, using a copy...
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write none in the space provided. Discuss.
Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters...
How would you (graphically) identify each of the following ERM components in a Crows Foot model? a. An entity b. The cardinality (0, N) c. A weak relationship d. A strong relationship
What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer.
What is the difference between partial completeness and total completeness?
What is a surrogate key, and when should you use one?
Explain the difference between an ORDER BY clause and a GROUP BY clause.
Write the SQL code to create a copy of EMP_1, naming the copy EMP_2. Then write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to its structure. The EMP_PCT is the bonus percentage to...
To keep track of office furniture, computers, printers, and so on, the FOUNDIT Company uses the table structure shown in Table P6.5. a. Given that information, write the relational schema and draw...
Should you create an index? If so, what would the index column(s) be, and why should you create that index?
Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee...
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...