(5) What would be the domain of the attribute County_name in the state of Texas?

QUESTION: What would be the domain of the attribute County_name in the state of Texas?   [signinlocker] SOLUTION The domain of the attribute County_name would be the set of all county names in the state of Texas. [/signinlocker]
Continue reading »

(23) Write a short essay (one or two pages) summarizing the content of the Harvard Business Review article on databases citied in Figure 1.4?

QUESTION: Write a short essay (one or two pages) summarizing the content of the Harvard Business Review article on databases citied in Figure 1.4?   [signinlocker] SOLUTION Figure 1.4 no longer contains a reference to the article from which it has been adapted. Its source...
Continue reading »

(18) Write a short essay (one or two pages) about data warehousing using information available from Internet sources?

Question: Write a short essay (one or two pages) about data warehousing using information available from Internet sources?   [signinlocker] SOLUTION A possible Internet source is: http://en.wikipedia.org/wiki/Data_warehouse [/signinlocker]
Continue reading »

(17) Write a short essay (one or two pages) about distributed databases using information available from Internet sources?

QUESTION: Write a short essay (one or two pages) about distributed databases using information available from Internet sources?   [signinlocker] SOLUTION A possible Internet source is: http://en.wikipedia.org/wiki/Distributed_database [/signinlocker]
Continue reading »

(16) Since ANSI and ISO have adopted SQL as the standard language for database access, explore via the Internet the history and features of SQL and its appropriateness for database access. Write a summary of your findings?

QUESTION: Since ANSI and ISO have adopted SQL as the standard language for database access, explore via the Internet the history and features of SQL and its appropriateness for database access. Write a summary of your findings?   [signinlocker] SOLUTION Some examples of Internet sources...
Continue reading »

(14) What is the difference between logical and physical data independence? Why is the distinction between the two important?

Question: What is the difference between logical and physical data independence? Why is the distinction between the two important?   [signinlocker] SOLUTION Logical data independence occurs when user views are immune to logical design changes in the conceptual schema. [/signinlocker]
Continue reading »

(13) Define data independence?

QUESTION: Define data independence?   [signinlocker] SOLUTION Data independence occurs as a result of the conceptual schema insulating user views (i.e., the external schema) from changes in the physical storage structure of the data in the internal schema. This is also known as physical data...
Continue reading »

(5) Identify a common task in a payroll system for which sequential access is more appropriate than direct access, and explain why this is so?

QUESTION: Identify a common task in a payroll system for which sequential access is more appropriate than direct access, and explain why this is so?   [signinlocker] SOLUTION Printing monthly (weekly, bi-weekly) payroll checks is the classic example since typically, virtually every employee receives a...
Continue reading »