Questions from Database Systems

Q: Extend the E-R diagram of Exercise 6.3 to

Extend the E-R diagram of Exercise 6.3 to track the same information for all teams in a league.

Q: List two features developed in the 2000s and that help database systems

List two features developed in the 2000s and that help database systems handle data-analytics workloads.

Q: Explain the difference between a weak and a strong entity set.

Explain the difference between a weak and a strong entity set.

Q: Consider two entity sets A and B that both have the attribute

Consider two entity sets A and B that both have the attribute X (among others whose names are not relevant to this question). a. If the two X s are completely unrelated, how should the design be impro...

Q: We can convert any weak entity set to a strong entity set

We can convert any weak entity set to a strong entity set by simply adding appropriate attributes. Why, then, do we have weak entity sets?

Q: Construct appropriate relation schemas for each of the E-R diagrams

Construct appropriate relation schemas for each of the E-R diagrams in: a. Exercise 6.1. b. Exercise 6.2. c. Exercise 6.3. d. Exercise 6.15.

Q: Consider the E-R diagram in Figure 6.30,

Consider the E-R diagram in Figure 6.30, which models an online bookstore. a. Suppose the bookstore adds Blu-ray discs and downloadable video to its collection. The same item may be present in one or...

Q: Design a database for an automobile company to provide to its dealers

Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is ide...

Q: Give a lossless decomposition into BCNF of schema R of Exercise 7

Give a lossless decomposition into BCNF of schema R of Exercise 7.1.

Q: Write a servlet and associated HTML code for the following simple application

Write a servlet and associated HTML code for the following simple application: A user is allowed to submit a form containing a number, say n, and should get a response saying how many times the value...