New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Database Concepts 6th Edition David M Kroenke, David J Auer - Solutions
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 insertion anomaly, a modification anomaly, and a deletion anomaly. Apply the normalization process
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 insertion anomaly, a modification anomaly, and a deletion anomaly. Apply the normalization process
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 insertion anomaly, a modification anomaly, and a deletion anomaly. Apply the normalization process
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 insertion anomaly, a modification anomaly, and a deletion anomaly. Apply the normalization process
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 question 5.37 more correct?Assume that ProjectNumber determines ProjectName and explain why this
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 ProjectName and explain why this relation is not normalized. Demonstrate an insertion anomaly, a modification
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 all columns from the parent and child tables. Explain the difference between these two SQL
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 E-R diagram.AppendixLO1
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 second entity. Also, describe a method for obtaining the chil- dren for the second entity, given 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
Show how to represent the N:M relationship in your answer to question 5.9. Use an IE Crow's Foot E-R diagram.AppendixLO1
Give examples of binary 1:N relationships, other than those in this text, for (a) an optional-to-optional relationship, (b) an optional-to-mandatory relationship, (c) a mandatory-to-optional relationship, and (d) a mandatory-to-mandatory relation- ship. Illustrate your answer by using IE Crow's
For a 1:N relationship, explain why you must place the key of the parent table in the child table rather than place the key of the child table in the parent table.AppendixLO1
For your answer to question 5.15, code an SQL statement that creates a table that has all data from both tables.AppendixLO1
For your answer to question 5.15, describe a method for obtaining data for all the children, given the key of the parent. Describe a method for obtaining data for the parent, given a key of the child.AppendixLO1
Show how to represent the 1:N relationship in your answer to question 5.9. Use an IE Crow's Foot E-R diagram.AppendixLO1
Define the terms parent and child as they apply to tables in a database design and give an example of each.AppendixLO1
Code SQL statements to create a join that has all data about both tables from your work for question 5.11.AppendixLO1
For your answers to question 5.11, describe a method for obtaining data about one of the entities, given the key of the other. Describe a method for obtaining data about the second entity, given the key of the first. Describe methods for both of your alternatives in question 5.11.AppendixLO1
Show two different ways to represent the 1:1 relationship in your answer to question 5.9. Use IE Crow's Foot E-R diagrams.AppendixLO1
Define the term foreign key and give an example.AppendixLO1
List the three types of binary relationships and give an example of each. Do not use the examples given in this text.AppendixLO1
Explain how supertype and subtype entities are transformed into tables.AppendixLO1
Explain how the representation of weak entities differs from the representation of strong entities.AppendixLO1
Explain the problems that unnormalized tables have for insert, update, and delete actions.AppendixLO1
When is denormalization justified?AppendixLO1
What is denormalization?AppendixLO1
Why is it necessary to apply the normalization process to the tables created accord- ing to your answer to question 5.1?AppendixLO1
Explain how attributes are transformed into columns. What column properties do you take into account when making the transformations?AppendixLO1
Explain how entities are transformed into tables.AppendixLO1
Using the SQL DBMS of your choice, complete steps A through E in exercise AW.3.3, but exclude step F.The following exercises are intended for use with a DBMS other than Microsoft Access.If you are using Microsoft Access, see the equivalent questions in the “Access Workbench Exercises” that
Using the SQL DBMS of your choice, create and run queries to answer the questions in exercise AW.3.1.The following exercises are intended for use with a DBMS other than Microsoft Access.If you are using Microsoft Access, see the equivalent questions in the “Access Workbench Exercises” that
If you haven't done so, create the WPC database, tables, and relationships described in this chapter, using the SQL DBMS of your choice. Be sure to populate the tables with the data shown in Figure 3-2.The following exercises are intended for use with a DBMS other than Microsoft Access.If you are
Write an ALTER TABLE statement to add a CHECK constraint to the ENROLLMENT table to ensure that the value of FullFeePaid is either Yes or No.The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. where:
Write a set of SQL statements (Hint: Use the SQL ALTER TABLE command.) to add a FullFeePaid column to ENROLLMENT and populate the column, assum- ing that the column is NOT NULL. The only possible values for this column are Yes and No. (Compare COURSE.Fee to ENROLLMENT.Amount Paid to deter- mine
Write a set of SQL statements (Hint: Use the SQL ALTER TABLE command.) to add a FullFeePaid column to ENROLLMENT and populate the column, assum- ing that the column is NULL. The only possible values for this column are Yes and No. (Compare COURSE.Fee to ENROLLMENT.Amount Paid to determine data
Modify your query to include all students, regardless of whether they registered in Adv. Pastels, starting October 1, 2013. Include, in this order, Customer LastName, CustomerFirstName, Phone, Course, CourseDate, Fee, and Amount Paid.The following is a set of tables for the Art Course database
Write and run an SQL query to list all students registered in Adv. Pastels starting on October 1, 2013. Include in this order, Course, CourseDate, Customer Last Name, Customer FirstName, Phone, Fee, and AmountPaid. Use a join.The following is a set of tables for the Art Course database shown in
Write and run an SQL query to list all students registered in Adv. Pastels start- ing on October 1, 2013. Include, in this order, Course, CourseDate, Fee, CustomerLastName, Customer FirstName, and Phone.The following is a set of tables for the Art Course database shown in Figure 1-10. For the data
Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, Customer Last Name, Customer FirstName, Phone, CourseNumber, and Amount Paid.The following is a set of tables for the Art Course database shown in Figure 1-10. For the data
Write and run an SQL query to list all occurrences of Adv. Pastels. Include all asso- ciated data for each occurrence of the class.The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. where: CUSTOMER
Populate the tables with data.The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. where: CUSTOMER (CustomerNumber, Customer LastName. CustomerFirstName. Phone) COURSE (CourseNumber. Course, CourseDate.
Write and run the SQL statements necessary to create the tables and their referen- tial integrity constraints.The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. where: CUSTOMER (CustomerNumber,
Write an SQL statement to drop the PetWeight column you added to the PET table in either question 3.47 or 3.49.AppendixLO1
Write an SQL statement to add a CHECK constraint to the PET table so that the weight data recorded in the PetWeight column you added to the table in either question 3.47 or 3.49 is less than 250.AppendixLO1
Write SQL statements to add a PetWeight column like the one in PET3 to the PET table, given that this column is NOT NULL. Again, assume that PetWeight is Numeric(4,1). Use the Pet Weight data from the PET 3 table as shown in Figure 3-19.AppendixLO1
Write SQL statements to insert data into the PetWeight column you created in ques- tion 3.47. Use the PetWeight data from the PET 3 table as shown in Figure 3-19.AppendixLO1
Write an SQL statement to add a Pet Weight column like the one in PET 3 to the PET table, given that this column is NULL. Again, assume that PetWeight is Numeric(4,1).AppendixLO1
Write an SQL statement to delete all rows of pets of type Anteater. What will happen if you forget to code the WHERE clause in this statement?AppendixLO1
Explain what will happen if you leave the WHERE clause off your answer to question 3.44.AppendixLO1
Write an SQL statement to change the value of Std. Poodle in BreedName of PET 3 to Poodle, Std.AppendixLO1
Write an SQL statement to add three new rows to the PET OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Assume, however, that you have only LastName, FirstName, and Phone and that therefore Email is NULL. Use the last three lines of the data
Write an SQL statement to add three new rows to the PET OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Use the first three lines of the data provided in Figure 3-21.AppendixLO1
Answer part (4) of question 3.37, but use joins.AppendixLO1
Answer question 3.36 but use a join.AppendixLO1
Answer question 3.35 but use a join.AppendixLO1
Write SQL statements to (1) create the BREED table, (2) insert the data in Figure 3-20 into the BREED table, (3) alter the PET 3 table so that PetBreed is a foreign key referencing BreedName in BREED, and (4) to display the last name, first name, and email of any owner of a pet that has an
Write an SQL statement to display the last name, first name, and email of any owners of cats with the name Teddy. Use a subquery. The following table schema for the BREED table shows a new table to be added to the pet database: BREED (BreedName. Min Weight, MaxWeight, AverageLife Expectancy) Assume
Write an SQL statement to display the last name, first name, and email of any owners of cats. Use a subquery.AppendixLO1
Answer question 3.32 but consider only breeds for which five or more pets are included in the database.AppendixLO1
Write an SQL statement to group the data by PetBreed and display the average weight per breed.AppendixLO1
Write an SQL statement to display the minimum, maximum, and average weight of dogs.AppendixLO1
Write the required SQL statements to create the PET 3 table. Assume that PetWeight is Numeric(4,1).AppendixLO1
Write an SQL statement to count the number of distinct breeds. The following table schema for the PET 3 table is another alternate version of the PET table: PET 3 (PerID, PetName, Pet Type, Pet Breed, Pet DOB, Pet Weight, OwnerID) Data for PET 3 is shown in Figure 3-19. Except as specifically noted
Showing 2500 - 2600
of 3225
First
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Step by Step Answers
Get 50% OFF
Claim Now
