Questions and Answers of Database Management Systems

Write an SQL statement to display the OwnerLastName, OwnerFirstName, PetName, Pet Type, PetBreed, and AverageLifeExpectancy for pets with a known PetBreed.AppendixLO1 FIGURE & BREED Data BreedName
Answer question 3.33 but do not consider any pet having the PetBreed value of Unknown.AppendixLO1 FIGURE 3-19 PET 3 Data PetID PetName PetType PetBreed PetDOB Pet Weight OwnerID King Dog Std. Poodle
Is PET or PET 2 a better design? Explain your rationale.AppendixLO1 FIGURE 3-17 PET OWNER Data OwnerLastName OwnerID OwnerFirstName Owner Phone 1 Downs Marsha 555-537-8765 2 James Richard
Develop a data model of a genealogical diagram. Model all parents, including stepparents. Use the IE Crow's Foot E-R model for your E-R diagrams.AppendixLO1
Develop a data model of a genealogical diagram. Model only biological parents; do not model stepparents. Use the IE Crow's Foot E-R model for your E-R diagrams.AppendixLO1
Using recursive relationships, as appropriate, develop a data model of the boxcars on a railway train. Use the IE Crow's Foot E-R model for your E-R diagrams.AppendixLO1
Extend your work for question 4.28 to include supplies that Heather uses on a pro- ject. Assume that she wants to track the description, price, and amount used of each supply. Supplies are used on
Suppose that Heather Sweeney wants to include records of her consulting ser- vices in her database. Extend the data model in Figure 4-20(c) to include CONSULTING PROJECT and DAILY PROJECT HOURS
Summarize one technique for evaluating a data model and explain how that technique could be used to evaluate the data model in Figure 4-20(c).AppendixLO1
Describe why it is important to validate a data model.AppendixLO1
Give an example of a business rule for your work for question 4.17.AppendixLO1
Give an example of a recursive relationship other than the one shown in this chapter. Draw an IE Crow's Foot E-R diagram for your example.AppendixLO1
What is an inclusive subtype relationship? Give an example other than one shown in this chapter. Draw an IE Crow's Foot E-R diagram for your example.AppendixLO1
What is an exclusive subtype relationship? Give an example other than one shown in this book. Draw an IE Crow's Foot E-R diagram for your example.AppendixLO1
Define the terms supertype, subtype, and discriminator.AppendixLO1
Explain the ambiguity in the definition of the term weak entity. Explain how this book interprets this term.AppendixLO1
Define the term weak entity and give an example other than one used in this text. Draw an IE Crow's Foot E-R diagram for your example.AppendixLO1
Define the term ID-dependent entity and give an example other than one used in this text. Draw an IE Crow's Foot E-R diagram for your example.AppendixLO1
Draw an IE Crow's Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE and the 1:N relationship between them. Assume that a DEPARTMENT does not need to have an EMPLOYEE, but that every EMPLOYEE
Define the terms maximum cardinality and minimum cardinality.AppendixLO1
List and give an example of the three types of binary relationships other than the ones used in this book. Draw both a traditional E-R diagram and an IE Crow's Foot E-R diagram for each.AppendixLO1
Define the term degree of relationship. Give an example, other than one used in this text, of a relationship greater than degree two.AppendixLO1
Explain the difference between a relationship class and a relationship instance.AppendixLO1
Define the term relationship and give an example other than those used in this book.AppendixLO1
Define the term composite identifier and give an example other than those used in this book.AppendixLO1
Define the term identifier and indicate which attribute defined in your answer to question 4.9 identifies the entity.AppendixLO1
Define the term attribute and give examples for the entity you described in question 4.7.AppendixLO1
Explain the difference between an entity class and an entity instance.AppendixLO1
Define the term entity and give an example other than those used in this book.AppendixLO1
Give an example of a business rule that would need to be documented in a database development project.AppendixLO1
Give an example of a data constraint.AppendixLO1
What is a use case, and what is its purpose?AppendixLO1
What is a prototype, and what is its purpose?AppendixLO1
What is a data model, and what is its purpose?AppendixLO1
Name the three stages in the process of developing database systems. Summarize the tasks in each.AppendixLO1
The text states that you can argue that "the only reason for having relations is to store instances of functional dependencies." Explain, in your own words, what this means.AppendixLO1
Alter question 2.40 to allow students to have multiple majors. In this case, the relational structure is: STUDENT (Student Number, StudentName, SiblingName, Major) A. Show an example of this relation
Consider the following relation: STUDENT(Student Number. Student Name, SiblingName, Major) Assume that the values of SiblingName are the names of all of a given student's brothers and sisters; also
Apply the normalization process to the Veterinary Office List-Version Two relation shown in Figure 1-31 (see page 52) to develop a set of normalized relations. Show the results of each of the steps
Apply the normalization process to the Veterinary Office List-Version One relation shown in Figure 1-30 (see page 52) to develop a set of normalized relations. Show the results of each of the steps
Explain a modification problem that occurs when changing data in the relation in question 2.35 and a second modification problem that occurs when deleting data in this relation.AppendixLO1
Using the assumptions you stated in your answer to question 2.35, what are the determinants of this relation? What attribute(s) can be the primary key of this relation?AppendixLO1
Examine the data in the Veterinary Office List-Version Two in Figure 1-31 (see page 52) and state assumptions about functional dependencies in that table.AppendixLO1
Describe a modification problem that occurs when changing data in the relation in question 2.32 and a second modification problem that occurs when deleting data in this relation.AppendixLO1
Using the assumptions you stated in your answer to question 2.32, what are the determinants of this relation? What attribute(s) can be the primary key of this relation?AppendixLO1
Examine the data in the Veterinary Office List-Version One in Figure 1-30 (see page 52) and state assumptions about functional dependencies in that table. What is the danger of making such
In your own words, describe the nature and purpose of the normalization process.AppendixLO1
How does your answer to question 2.29 change if you allow a relation to have dupli- cate data?AppendixLO1
If you assume that a relation has no duplicate data, how do you know there is always at least one primary key?AppendixLO1
Define the term primary key in terms of functional dependencies.AppendixLO1
Explain the differences in your answers to questions 2.25 and 2.26.AppendixLO1
Explain the meaning of the following expression: (D. E) F Given this expression, tell if it is also true that: DF and: ET AppendixLO1
Explain the meaning of the following expression: A (B. C) Given this expression, tell if it is also true that: and: AC AppendixLO1
In the following equation, name the functional dependency and identify the determinant(s): Area Length x Width =AppendixLO1
Define the terms functional dependency and determinant, using an example not from this book.AppendixLO1
Give an example of a null value (other than one from this chapter) and explain each of the three possible interpretations for that value.AppendixLO1
Explain three possible interpretations of a null value.AppendixLO1
Define the term referential integrity constraint and give an example of one.AppendixLO1
Explain how primary keys and foreign keys are denoted in this book.AppendixLO1
Explain the term foreign key and give an example.AppendixLO1
Why are the values of surrogate keys normally hidden from users on forms, queries, and reports?AppendixLO1
How do surrogate keys obtain their values?AppendixLO1
What is a surrogate key, and under what circumstances would you use one?AppendixLO1
Describe four uses of a primary key.AppendixLO1
Explain the difference between a primary key and a candidate key.AppendixLO1
Give an example of a relation with a unique composite key.AppendixLO1
Define the term nonunique key and give an example.AppendixLO1
Define the term unique key and give an example.AppendixLO1
Under what circumstances can a relation have duplicate rows?AppendixLO1
Explain the use of the terms relation, tuple, and attribute.AppendixLO1
Explain the use of the terms file, record, and field.AppendixLO1
Under what circumstances can an attribute of a relation be of variable length?AppendixLO1
Give an example of a table that is not a relation (other than one from this chapter).AppendixLO1
Give an example of a relation (other than one from this chapter).AppendixLO1
List the characteristics a table must have to be considered a relation.AppendixLO1
Define the term entity and give an example of an entity (other than the one from this chapter).AppendixLO1
Why is the relational model important?AppendixLO1
What is the purpose of database administration?AppendixLO1
Create a relational database design for the data model you developed for question 4.32.Assume that ProjectNumber determines ProjectName and explain why this relation is not normalized. Demonstrate an
Create a relational database design for the data model you developed for question 4.31.Assume that ProjectNumber determines ProjectName and explain why this relation is not normalized. Demonstrate an
Create a relational database design for the data model you developed for question 4.30.Assume that ProjectNumber determines ProjectName and explain why this relation is not normalized. Demonstrate an
Create a relational database design for the data model you developed for question 4.29.Assume that ProjectNumber determines ProjectName and explain why this relation is not normalized. Demonstrate an
Explain the difference between the two ASSIGNMENT tables in questions 5.36 and 5.37. Under what circumstances is the table in question 5.36 more correct? Under what circumstances is the table in
Consider the following relation that holds data about employee assignments: ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName. Hours Woul.AppendixLO1
Consider the following table, which holds data about employee project assignments: ASSIGNMENT (EmployeeNumber. ProjectNumber, ProjectName, Hours Worked) Assume that ProjectNumber determines
Code an SQL statement that creates a table with all columns from the parent and child tables in your answer to question 5.34. Code an SQL statement using a left outer join that creates a table with
Show how to represent the M:N recursive relationship in your answer to question 5.29. How does this differ from the representation of M:N nonrecursive relationships?AppendixLO1
Code an SQL statement that creates a table with all columns from the parent and child tables in your answer to question 5.32.AppendixLO1
Show how to represent a 1:N recursive relationship in your answer to question 5.29. How does this differ from the representation of 1:N nonrecursive relationships?AppendixLO1
Code an SQL statement that creates a table with all columns from the parent and child tables in your answer to question 5.30.AppendixLO1
Show how to represent the 1:1 recursive relationship in your answer to question 5.29. How does this differ from the representation of 1:1 nonrecursive relationships?AppendixLO1
Define the three types of recursive binary relationships and give an example of each, other than the ones shown in this text.AppendixLO1
Give an example of a supertype-subtype relationship, other than one shown in this text. Illustrate your answer using an IE Crow's Foot E-R diagram.AppendixLO1
Give an example of a 1:N relationship with an ID-dependent weak entity, other than one shown in this text. Illustrate your answer using an IE Crow's Foot E-R diagram.AppendixLO1
What is an associative entity? What is an association relationship? Give an example of an association relationship other than one shown in this text. Illustrate your answer using an IE Crow's Foot
Why is it not possible to represent N:M relationships with the same strategy used to represent 1:N relationships?AppendixLO1
For your answer to question 5.20, code an SQL statement that creates a relation that has all data from all tables.AppendixLO1
For your answers to questions 5.20, 5.21, and 5.22, describe a method for obtaining the children for one of the entities in the original data model, given the primary key of the table based on the
Explain how the terms parent table and child table relate to the tables in your answer to question 5.20.AppendixLO1
Explain the meaning of the term intersection table.AppendixLO1

Showing 1 - 100 of 779