Questions from Database Systems

Q: How do systems analysis and systems development fit into a discussion about

How do systems analysis and systems development fit into a discussion about information systems?

Q: What does the acronym SDLC mean, and what does an SDLC

What does the acronym SDLC mean, and what does an SDLC portray?

Q: What does the acronym DBLC mean, and what does a DBLC

What does the acronym DBLC mean, and what does a DBLC portray?

Q: Discuss the distinction between centralized and decentralized conceptual database design.

Discuss the distinction between centralized and decentralized conceptual database design.

Q: What is the minimal data rule in conceptual design? Why is

What is the minimal data rule in conceptual design? Why is it important?

Q: Discuss the distinction between top-down and bottom-up approaches

Discuss the distinction between top-down and bottom-up approaches to database design.

Q: What are business rules? Why are they important to a database

What are business rules? Why are they important to a database designer?

Q: Use a query to show the invoices and invoice totals as shown

Use a query to show the invoices and invoice totals as shown in Figure P7.34. (Hint: Group by the CUS_CODE.) FIGURE P7.34 Invoice Totals by Customer

Q: What is the data dictionary's function in database design?

What is the data dictionary's function in database design?

Q: Explain the following statement: a transaction is a logical unit of

Explain the following statement: a transaction is a logical unit of work.