Consider the following relation (table).
STUDENT (StudentNumber, StudentName, SiblingName, Major)
Assume that the values of SiblingName are the names of all of a given students brothers and
sisters; also assume that students can have m
1. Describe three modification problems that are likely to occur when using this list.
Three modification problems that are likely to occur are as follows:
a. If you want to delete a pet (for example), you would end up deleting the own
1. List and give an example of the three types of binary relationships (1:1, 1:N, N:M) other
than the ones used in this book. Draw an IE Crows Foot E-R diagram for each .
One-to-One Relationship [1:1]- COMPUTER-ASSIGNMENT:
1. Write a SQL CREATE TABLE statement to create the PET_OWNER table. Justify your
choices of column properties. Write SQL Statements to insert the data in Figure 3-15 into the
I figured integers was the best way for it
1. Write a SQL statement to display the PetID, PetBreed, and PetType for all pets having a
four-character PetName starting with K.
SELECT PET.PetID, PET.PetBreed, PET.PetType
WHERE (PET.[PetName] Like 'K_');
2. Write a SQL sta