Discuss problem analysis as an analysis strategy. What are the strengths and limitations of this technique?
Compare and contrast duration analysis and activity based costing. What role do these activities play as analysis strategies?
How can informal benchmarking contribute to requirements determination?
One of the most common mistakes made by new analysts is to confuse functional and nonfunctional requirements. Pretend that you received the following list of requirements for a sales system:...
Discuss how the analyst knows how to stop decomposing the process model into more and more levels of detail.
Why would one use a decision tree and/or decision table in a process description?
How can you make a DFD easier to understand?
Describe the three-step process of creating an intersection entity.
What is a CRUD matrix? How does it relate to process models and data models?
A large direct health and insurance medical provider needed an enterprise information management (EIM) system to enable enterprise wide information management and to support the effective use of data...
Suppose that your university were interested in creating a new course registration system that could support Web-based registration. QUESTION: What should the university consider when determining...
Distinguish between a traditional ASP and a provider of software as a service. What are the pros and CMS of each solution approach?
Think about the course registration system in your university. First, develop a set of nonfunctional requirements as if the system were to be developed today. Consider the operational requirements,...
What is meant by the term scalable? What is its importance in architecture selection?
Explain the term Virtualization.
Describe cloud computing and how it is impacting architecture choices.
What is meant by system value? Explain how various systems can have a different value to the organization.
What is the purpose of the hardware and software specification?
What do you think are the most important security issues for a system?
Pretend that you have been charged with the task of redesigning the interface for the ATM at your local bank. Develop an interface standard that includes metaphors, objects, actions, icons, and a...
Design a navigation system for a form into which users must enter information about customers, products, and orders. For all three information categories, users will want to change, delete, find one...
Why is content awareness important?
How can different parts of the interface be consistent?
Why are interface standards important?
How can you prevent mistakes?
Describe five types of messages.
What is context-sensitive help? Does your word processor have context-sensitive help?
Explain three principles in the design of inputs.
Why is capturing data at the source important?
Why is input validation important?
When would you use electronic reports rather than paper reports, and vice versa?
What do you think are three common mistakes that novice analysts make in interface design?
How would you improve the form inFigure? EMPLOYEE PERSONNEL REPORI UNIVIRSITY (W GEORGIA DOCURENT MO r DEPARTMENT PHONE | LEGE OR DIVISION D (C) DRRENT CP, PREVIOS DATE SOC.SEC H STREET OR ROUTE No....
Ask Jeeves (www.askjeeves.com) is an Internet search engine that uses natural language. Experiment with it and compare it with search engines that use key words.
What does a data couple depict on a structure chart? A control couple?
It is preferable for a control couple to flow in one particular direction on the structure chart. Which direction is preferred, and why?
What is meant by the characteristic of module cohesion? What is its role in structure chart quality?
Identify the kinds of coupling that are represented in the followingsituations: Customer Customer Customer Record Address City, State. ZIP Record PRINT MAILING LIST PRINT MAILING LIST PRINT MAILING...
Create a program specification for module 1.1.3.1 on the structure chart inFigure. 10 DF D Dagam Pronote Tunen Soarch and Fom tavel 13.1 12.3 From Use Cases and 1232 11.3 Soloct Tune Gathar into
Create a program specification for module 1.2.3.4 on the structure chart in Figure. romote 1.2.1 Fron Use Cases and 1232 1.233 123 Gathor 1132 Solact Tuns
Create pseudocode for the program specification that you wrote in Exercise K.
Create pseudocode for the program specification that you wrote in Exercise L.
In Chapter 6, you were asked to create a logical entity relationship diagram (ERD) for a charter company that owns boats that are used to charter trips to the islands ("Your Turn 6-8"). The company...
A Virginia-based mail-order company sends out approximately 25 million catalogs each year, using a customer table with 10 million names. Although the primary key of the customer table is customer...
Visit a commercial Web site (e.g., CDnow, Amazon. com). If files were being used to store the data supporting the application, what types of files would be needed? What data would they contain?
Draw a physical process model (just the processes and data stores) for the following CRUDmatrix: Register Schedule Create Create Student Studen Transcript Bill Student Student Data Store Course Data...
My first programming job in 1977 was to convert a set of application systems from one version of COBOL to another version of COBOL for the government of Prince Edward Island. The testing approach was...
What do you think are three common mistakes made by novice systems analysts during programming and testing?
Create several guidelines for developing good documentation.
What are the three major elements of management policies that must be considered when implementing a new system?
Prepare a plan to motivate the adoption of the system described in Exercise E.
The use case diagram for the Digital Music Download system does not include special use case relationships (e.g., extends or includes) or specialized actors. See whether you can come up with one...
Describe how the object approach supports the program design concepts of cohesion and coupling that were presented in Chapter 10.
How can you employ the use case report to develop a use case diagram?
Give two examples of the extends associations on a use case diagram. Give two examples for the includes association.
How is a class diagram different from an ERD?
What are the two kinds of labels that a class diagram can have for each association? When is each kind of label used?
Consider the video store described in question I. Draw a behavioral state machine diagram that describes the various states that a video goes through from the time it is placed on the shelf through...
You have an interview for an IT position with NewTech, a large telecommunications company, and you want to learn more about the firm and its organizational structure. To prepare for the interview,...
How many records does the file contain? How many fields are there perrecord? PROJECT CODE PROJECT MANAGER MANAGER PHONE 21-52 25-2D 25-5A 25-9T 27-40 29-2D 31-7P MANAGER ADDRES 3334 Lee Rd.,...
Write the business rule(s) that governs the relationship between AGENT and CUSTOMER.
Write the business rules that are reflected in the ERD shown in Figure (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember...
What data redundancies do you detect? How could those redundancies lead toanomalies? PROJECT CODE PROJECT MANAGER MANAGER PHONE 21-52 25-2D 25-5A 25-9T 27-40 29-2D 31-7P MANAGER ADDRES 3334 Lee Rd.,...
Looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would yourecommend? PROJ NUM PROJ NAME EMP NUMP NAME JBCODEOB CHO HOUR [PROJ HOURS EMP PHONE 1 Hurricane 1 Hurricane 1...
Identify the various data sources in the file you examined in Problem5. PROJ NUM PROJ NAME EMP NUMP NAME JBCODEOB CHO HOUR [PROJ HOURS EMP PHONE 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3...
Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown inFigure? PROJ NUM PROJ NAME EMP NUMP NAME JBCODEOB CHO HOUR [PROJ...
Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate the difference between a natural join, an equijoin, and an outer join. Table name: STUDENT Database name: Ch03_CollegeQue STU...
Create the basic ERD for the database shown in Figure.
Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.11. BOOTH_PRODUCT BOOTH_PRICE Energy Drink......... 2
For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided.
Create the ERD to show the relationship between EMPLOYEE and JOB.
Identify the TRUCK tables candidate key(s).
For each table, where possible, identify: a. The primary key b. A superkey c. A candidate key d. The foreign key(s) e. A secondary key
Create the ERD. (Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT. Similarly, you will discover that a...
Modify the ERD you created in Problem 25 to eliminate the problems created by the use of synonyms.
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...
Describe the type(s) of relationship(s) between STORE and REGION.
Create the table that would result from applying a DIFFERENCE relational operator of your result from problem 29 to your result from problem 30.
Given the business rule an employee may have many degrees, discuss its effect on attributes, entities, and relationships.
Suppose you are working within the framework of the conceptual model in Figure Q4.5. a. Write the business rules that are reflected in it. b. Identify all of the cardinalities. CUSTOMER CAR kowns...
Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?
What is a derived attribute? Give an example.
Discuss two ways in which the 1:M relationship between COURSE and CLASS can be implemented.
What three (often conflicting) database requirements must be addressed in database design?
Briefly, but precisely, explain the difference between single-valued attributes and simple attributes. Give an example of each.
Write the ten cardinalities that are appropriate for this ERD.
What is a strong (or identifying) relationship, and how is it depicted in a Crows Foot ERD?
What is a composite entity, and when is it used?
How is a composite entity represented in an ERD, and what is its function? Illustrate the Crows Foot model.
Describe precisely the composition of the DEPENDENT weak entitys primary key. Use proper terminology in your answer.
What is a specialization hierarchy?
What is an overlapping subtype? Give an example.
According to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why or why not?
What primary key characteristics are considered desirable? Explain why each characteristic is considered desirable.
Under what circumstances are composite primary keys appropriate?
When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be mandatory or optional?
What is the most common design trap, and how does it occur?
What kinds of data would you store in an entity subtype?
List all of the attributes of a movie.
Tiny College wants to keep track of the history of all administrative appointments (date of appointment and date of termination). The Tiny College chancellor may want to know how many deans worked in...