Suppose the page table for the process currently executing on the processor looks like the following. All numbers are decimal, everything is numbered starting from zero, and all addresses are memory...

List and briefly define four techniques for thread scheduling.

List and briefly define three versions of load sharing.

An interactive system using round-robin scheduling and swapping tries to give guaranteed response to trivial requests as follows: After completing a round-robin cycle among all ready processes, the...

List and briefly define four classes of real-time scheduling algorithms.

What items of information about a task might be useful in real-time scheduling?

List and briefly define three techniques for performing I/O.

Consider the organization of a UNIX file as represented by the inode. Assume that there are 12 direct block pointers, and a singly, doubly, and triply indirect pointer in each inode. Further, assume...

The implementation of mutexes within the eCos kernel does not support recursive locks. If a thread has locked a mutex and then attempts to lock the mutex again, typically as a result of some...

Suggest pros and cons for fat client and thin client strategies.

Suppose you are a marketing assistant for a consumer electronics company and are in charge of setting up your companys booth at tradeshows. Weeks before the shows, you meet with the marketing...

Many companies have a conflict of interest with regard to third-party cookies. On the one hand, such cookies help generate revenue and pay for Internet content. On the other hand, trespassing on...

Suppose you are the director of student activities at your university. Recently, some students have charged that your department misallocates its resources. They claim the allocation is based on...

Credit reporting agencies are required to provide you with a free credit report each year. Most such reports do not include your credit score, but they do provide the details on which your credit...

True or False. 1. The lookup_value of a HLOOKUP function can be a continuous cell range. 2. In a VLOOKUP formula with a TRUE lookup type, the lookup table referenced must be in ascending order to...

What are the types of Solver reports? What information is described in an answer report? What is the difference between a binding status and a not binding status? What is slack?

What is the difference between a linear function and a nonlinear function?

What is an assignment problem?

What are the three required parameters of a Solver model and what do they represent?

Increase the length of the Warehouse field in the Part table to two characters. Change the warehouse number for warehouse 1 to 1a. Display all the data in the Part table.

For each of the following collections of relations, give the assumptions concerning the relationship between students, courses, and faculty members that are implied by the collection. In each...

1. Using the types of entities found in the Henry Books database (books, authors, and publishers), create an example of a table that is in first normal form but not in second normal form and an...

List the functional dependencies in the following table that concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified conditions. For a...

The information-level design method presented in this chapter contains steps that must be repeated for each user view. List the steps and briefly describe the kinds of activities that must take place...

Suppose a given user view contains information about employees and projects. Suppose further each employee has a unique EmployeeNum and each project has a unique ProjectNum. Explain how you would...

A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Use your own experience to determine any constraints you...

What is journaling? What two types of images does a DBMS output to its journal?

What is encryption? How does encryption relate to security?

Youve explained replication to management, and some managers ask you for examples of when replication could be useful to them. Describe two situations, other than the ones given in the text, when...

Create requirements and the ER diagram for a scenario with two entities (both with several attributes) involved in the following relationship: a. M relationship, where participation on the 1 side is...

Create two examples, one of a table that is a relation and one of a table that is not a relation.

Show the SQL command that will be issued when a user using the form shown in Figure 6.24 enters the value Pam in the Customer Name box and clicks the Search button. Also, show the result of executing...

Why is a data warehouse created as a separate data store?

What are the similarities and differences between the development of the initial and subsequent versions of the data warehouse?

Briefly describe the data warehouse deployment process.

Briefly describe ROLAP architecture.

What is the difference between the first load and a refresh load?

Consider uses for Pixel Sense at your university. How might Pixel Sense be used in architecture, chemistry, law, medicine, business, geography, political science, art, music, or any other discipline...

You will sometimes hear the expression, Emerging technology is constantly leveling the playing field, meaning that technology eliminates competitive advantages of existing companies and enables...

Name three record-based data models. Discuss the main differences between these data models.

Provide the equivalent domain relational calculus and relational algebra expressions for each of the tuple relational calculus expressions given in Exercise 4.10. (a) {H.hotelName | Hotel(H) H.city...

Create an INSTEAD OF database trigger that will allow data to be inserted into the following view: CREATE VIEW LondonHotelRoom AS SELECT h.hotelNo, hotelName, city, roomNo, type, price FROM Hotel h,...

Discuss what a user view represents in the context of a database system.

Consider whether it is appropriate to introduce the enhanced concepts of specialization/generalization, aggregation, and/or composition into the ER model for the case study described in Exercise...

Introduce specialization/generalization concepts into the ER model shown in Figure 13.11 and described in Exercise 12.13 to show the following: (a) The majority of parking spaces are under cover and...

Describe the concept of multi-valued dependency and describe how this concept relates to 4NF. Provide an example to illustrate your answer.

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

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

State four criteria for selecting identifiers for entities.

Why must some identifiers be composite rather than simple?

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.