Blog

Which of the following SQL statements changes the type of an attribute from integer to date? Figure 2. Relational database movie

For each dog with breed Yorkie, list dog name and age.   

Find the name and breed of the dog that is owned by a customer (owner) with id 489

Find a zip code with largest number of clients (that is, owners).

Which of the following best describes a weak entity set in an ER model?

In the Relational model, data is represented as:

Identify attributes for each category, where attributes are from the ER diagram illustrated in Figure 2. Figure 2. ER diagram for a spa salon. 

Identify complex attributes in the entity set illustrated in Figure 2. Figure 2. Entity set agent.  

Find an error in the reduction from ER to relational diagram illustrated in Figure 3. (a) ER diagram                                                                                                                               (b) Relational diagram Figure 3. ER and associated relational diagram.

In the BCNF decomposition algorithm, suppose you use a functional dependency to decompose a relation schema into and . What primary and foreign-key constraint do you expect to hold on the decomposed relations?