Questions from Database Systems


Q: What are some basic database functions that a spreadsheet cannot perform?

What are some basic database functions that a spreadsheet cannot perform?

See Answer

Q: What common problems do a collection of spreadsheets created by end users

What common problems do a collection of spreadsheets created by end users share with the typical file system?

See Answer

Q: Explain the significance of the loss of direct, hands-on

Explain the significance of the loss of direct, hands-on access to business data that users experienced with the advent of computerized data repositories.

See Answer

Q: Explain why the cost of ownership may be lower with a cloud

Explain why the cost of ownership may be lower with a cloud database than with a traditional, company database.

See Answer

Q: Suppose that you have the ERM shown in Figure Q3.18

Suppose that you have the ERM shown in Figure Q3.18. How would you convert this model into an ERM that displays only 1:M relationships? (Make sure that you draw the revised ERM.)

See Answer

Q: Consider the scenario described by the statement “A customer can make

Consider the scenario described by the statement “A customer can make many payments, but each payment is made by only one customer” as the basis for an entity relationship diagram (ERD) representation...

See Answer

Q: What are homonyms and synonyms, and why should they be avoided

What are homonyms and synonyms, and why should they be avoided in database design?

See Answer

Q: How would you implement a l:M relationship in a database

How would you implement a l:M relationship in a database composed of two tables? Give an example.

See Answer

Q: Identify and describe the components of the table shown in Figure Q3

Identify and describe the components of the table shown in Figure Q3.21, using correct terminology. Use your knowledge of naming conventions to identify the table’s probable foreign key(s).

See Answer

Q: Identify the primary keys. Data from FIGURE Q3.

Identify the primary keys. Data from FIGURE Q3.18 The Ch03_Theater Database Tables:

See Answer