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.

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...

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...

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 table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.11. BOOTH_PRODUCT BOOTH_PRICE Energy Drink......... 2

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.

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...

When is a table in 2NF?

What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?

When is a table in BCNF?

Define and discuss the concept of transitive dependency.

In a SELECT query, what is the difference between a WHERE clause and a HAVING clause?

Explain why the following command would create an error, and what changes could be made to fix the error. SELECT V_CODE, SUM(P_QOH) FROM PRODUCT;

In Chapter 4, you saw the creation of the Tiny College database design. That design reflected such business rules as a professor may advise many students and a professor may chair one department....

The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRCs aircraft. Produce a data model segment that reflects the following business rules:...

Write the SQL code to generate the total hours worked and the total charges made by all employees. The results are shown in Figure. SumOfSumOIASSIGN HOURS SumOfSumOfASSIGN CHARGE 90.6 7612.64

Write a query to display a brand name and the number of products of that brand that are in the database. Sort the output by the brandname. BINDER PRIME BUSTERS FORESTERS BEST HOME COMFORT LE MODE...

What is a CROSS JOIN? Give an example of its syntax.

What three join types are included in the OUTER JOIN classification?

What is a subquery, and what are its basic characteristics?

What is a correlated subquery? Give an example.

Explain the difference between a regular subquery and a correlated subquery.

What is the difference between UNION and UNION ALL? Write the syntax for each.

What is a trigger, and what is its purpose? Give an example.

What is a stored procedure, and why is it particularly useful? Give an example.

Create a trigger named trg_pic_hours that will automatically update the PILOT table when a new CREW row is added and the CREW table uses a pilot CREW_JOB entry. Use the CHARTER tables...

Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname....

Starting with a consistent database state, trace the activities that are required to execute a set of transactions to produce an updated consistent database state.

Write a query to display the employee number, first name, last name, and largest salary amount for each employee in department 200. Sort the output by largest salary in descendingorder. EMP NUM EMP...

Using Table as an example, create two alternative access plans.

Multiple requests accessing multiple remote databases, Figure D12.3 Multiple requests, Multiple RemoteDBMSes REQUEST REQUESIT REQUEST DONAS REQUESI DBMS REQUESIT

What is data analytics? Briefly explain explanatory and predictive analytics.

Describe and contrast the focus of data mining and predictive analytics. Give some examples.

What is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total for all sales?

What is the SQL command to list the number of product sales (number of rows) and total sales by month and product category with subtotals by month and product category and a grand total for all sales?

What is the SQL command to list the number of product sales (number of rows) and total sales by month, product category and product, with subtotals by month and product category and a grand total for...

Why and how are new technological advances in computers and databases changing the DBA's role?

Consider a memory system with the following parameters: Tc = 100 ns Cc = 0.01 cents > bit Tm = 1,200 ns Cm = 0.001 cents > bit a. What is the cost of 1 MByte of main memory? b. What is the cost of 1...

A computer consists of a CPU and an I/O device D connected to main memory M via a shared bus with a data bus width of one word. The CPU can execute a maximum of 106 instructions per second. An...

The program execution of Figure is described in the text using six steps. Expand this description to show the use of the MAR and MBR. Fetch stage Execute stage CPU registers Memory CPU registers emo...

What are three objectives of an OS design?

A multiprocessor with eight processors has 20 attached tape drives. There is a large number of jobs submitted to the system that each require a maximum of four tape drives to complete execution....

List four characteristics of a suspended process.

Consider an environment in which there is a one-to-one mapping between user-level threads and kernel-level threads that allows one or more threads within a process to issue blocking system calls...

The Solaris documentation states that a ULT may yield to another thread of the same priority. Isnt it possible that there will be a run able thread of higher priority and that therefore the yield...

When a special machine instruction is used to provide mutual exclusion in the fashion of Figure 5.2, there is no control over how long a process must wait before being granted access to its critical...

In the commentary on Figure 5.9 and Table 5.4, it was stated that it would not do simply to move the conditional statement inside the critical section (controlled by s) of the consumer because this...

Consider a system consisting of four processes and a single resource. The current state of the claim and allocation matrices is: What is the minimum number of units of the resource needed to be...

Consider the following program which provides a software approach to mutual exclusion: Integer array control [1: N]; integer k Where 1 k N, and each element of control is either 0, 1, Or 2. All...

Consider the following definition of semaphores: void semWait(s) { if (s.count > 0) { s.count--; } else { place this process in s.queue; block; } } void semSignal (s) { if (there is at least one...

Consider a sharable resource with the following characteristics: (1) As long as there are fewer than three processes using the resource, new processes can start using it right away. (2) Once there...

The two variables a and b have initial values of 1 and 2, respectively. The following code is for a Linux system: What possible errors are avoided by the use of the memory barriers? Thread 1 Thread 2...

What are the three conditions that must be present for deadlock to be possible?

List two ways in which the no-preemption condition can be prevented.

Section 2.3, we listed five objectives of memory management, and in Section 7.1, we listed five requirements. Argue that each list encompasses all of the concerns addressed in the other.

To implement the various placement algorithms discussed for dynamic partitioning (Section 7.2), a list of the free blocks of memory must be kept. For each of the three methods discussed (best-fit,...

Another placement algorithm for dynamic partitioning is referred to as worst-fit. In this case, the largest free block of memory is used for bringing in a process. a. Discuss the pros and cons of...

Consider the following ways of handling deadlock: (1) Bankers algorithm, (2) Detect deadlock and kill thread, releasing all resources, (3) Reserve all resources in advance, (4) Restart thread and...

Suppose that there are two types of philosophers. One type always picks up his left fork first (a lefty), and the other type always picks up his right fork first (a righty). The behavior of a lefty...

It was stated that deadlock cannot occur for the situation reflected in Figure. Justify that statement. Progress of Q Release 4 P and Q want A Release Required P and Q want B Get A Required Get B 6...