musicmarkup.info In English DATABASE CONCEPTS 6TH EDITION KROENKE PDF

DATABASE CONCEPTS 6TH EDITION KROENKE PDF

Friday, July 5, 2019 admin Comments(0)

Details about Database Concepts (6th Edition) by Kroenke, David M., Auer, David Be the first to Database System Concepts 6th musicmarkup.info - musicmarkup.info . download database concepts 6th edition david m kroenke pdf - database concepts 6th edition david m kroenke. unframed world. download: database concepts 6th edition kroenke solutions - database concepts 6th edition kroenke solutions manual pdf download this great ebook and.


Author:PAMALA PERINI
Language:English, Spanish, Hindi
Country:Tuvalu
Genre:Environment
Pages:597
Published (Last):27.02.2016
ISBN:509-4-53901-275-5
ePub File Size:16.40 MB
PDF File Size:11.15 MB
Distribution:Free* [*Sign up for free]
Downloads:32034
Uploaded by: MARQUERITE

DATABASE CONCEPTS 6TH EDITION DAVID M KROENKE - In this site isn`t the same as a solution manual you download in a book store or download off the web. or download with email. MIS+Essentials+4th+Edition+by+David+Kroenke - Sat, 30 Mar GMT (PDF) Consumer Behavior Schiffman Kanuk 10th. Solution manual for Database Concepts 6th by David Kroenke Test Bank for Database Concepts 6th Edition David Kroenke, David Auer download answer key.

Skip to main content. Log In Sign Up. Yv4vdj Tt9pl9. Full file at https: Kroenke and David J. Publishing as Prentice Hall Page 2 of 35 Full file at https:

Show an example of this relation for two students, one of whom has three siblings and the other of whom has one sibling. Assume that each student has a single major. Page 17 of 35 Full file at https: Show the data changes necessary to add a second major for only the first student. Based on your answer to part B, show the data changes necessary to add a second major for the second student. Explain the differences in your answers to parts B and C. Comment on the desirability of this situation.

We had to add three rows in the first case—one major for each of the siblings of the student. This is nuts!

Gehl skid steer repair manual - Ebook List

Divide this relation into a set of well-formed relations. StudentNumber, Major Is every determinant a candidate key? Page 19 of 35 Full file at https: In a properly normalized relation, each row of the relation consists of a primary key value which is a determinant and attribute values which are all functionally dependent on the primary key. Thus, properly normalized relations store instances of functional dependencies, and only instances of functional dependencies.

So we can say that the purpose of relations is to store instances of functional dependencies. Figure shows data that Regional Labs collects about projects and the employees assigned to them. Assuming that all functional dependencies are apparent in this data, which of the following are true? Are all the nonkey attributes if any dependent on the primary key?

To give an employee a salary, we must first assign the employee to a project. If we change a Salary, we have to change it in multiple places and may create inconsistent data. Is ProjectID a determinant?

If so, based on which functional dependencies in part A? Is EmployeeName a determinant? Is EmployeeSalary a determinant? NO Actually, for the data in Figure , it is a determinant. However, the dataset is too small to validate this determinant, and logically EmployeeSalary is not a determinant! Does this relation contain a transitive dependency? If so, what is it?

Redesign the relation to eliminate modification anomalies. The following seems workable: Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.

Figure shows data that Garden Glory collects about properties and services. Using these data, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses. From the data it appears that there are many functional dependencies that could be defined.

Some examples are: Page 22 of 35 Full file at https: There is simply not enough data to reply on it. Logically, it seems that we need one ID column—a surrogate key will be required here. With regard to services, it would seem likely that a given service could be given to the same property, but on different dates. So, if we had a good determinant for property, then the last functional dependency would be true. So, the following seems workable: Given your assumptions in part A, comment on the appropriateness of the following designs: For example, PropertyName does not determine ServiceDate.

There may be more than one service on a given date. For example, PropertyName, ServiceDate does not determine Description since there may be more than one service at a property on a given date. For example, PropertyID, ServiceDate does not determine Description since there may be more than one service at a property on a given. Page 23 of 35 Full file at https: The question then becomes: Which one should we keep?

Finally the relationship is set up correctly. Now we can have many services even on the same date for one property. Suppose Garden Glory decides to add the following table: Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure ? If not, modify the design so that this data will work. State the assumptions implied by this design. Page 24 of 35 Full file at https: This also means that a service can be applied to multiple, but different, properties on the same date.

However, a property may not have the same service on the same date. All of this seems reasonable. Now we need to check with the users.

While James River Jewelry does sell typical jewelry downloadd form jewelry vendors, including such items as rings, necklaces, earrings, and watches, it specializes in hard-to-find Asian jewelry. It has a small but loyal clientele, and it wants to further increase customer loyalty by creating a frequent downloader program. In this program, after every 10 downloads, a customer will receive a credit equal to 50 percent of the sum of his or her 10 most recent downloads.

Figure D-1 shows data that James River Jewelry collects for its frequent downloader program. Page 25 of 35 Full file at https: Justify your assumptions on the basis of these sample data and also on the basis of what you know about retail sales.

From the data it would appear: For example, name is not a good determinant in a retail application; there may be many customers with the same name.

Another functional dependency is: For example, Name does not determine InvoiceNumber because one customer may have made more than one download. And why is InvoiceNumber the key for data about a customer? Page 26 of 35 Full file at https: Given a unique Email address, Email works as a key for customer data.

Unfortunately, Email does not determine InvoiceNumber and therefore is not a sufficient key. A unique ID column is a good idea, and works as a key for customer data. The design breaks up the themes and has a proper foreign key. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.

Figure shows data that Garden Glory collects about properties and services. Using these data, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses. From the data it appears that there are many functional dependencies that could be defined. Some examples are: Page 22 of 35 Full file at https: There is simply not enough data to reply on it.

Database concepts 6th edition kroenke

Logically, it seems that we need one ID column—a surrogate key will be required here. With regard to services, it would seem likely that a given service could be given to the same property, but on different dates.

So, if we had a good determinant for property, then the last functional dependency would be true. So, the following seems workable: Given your assumptions in part A, comment on the appropriateness of the following designs: For example, PropertyName does not determine ServiceDate.

There may be more than one service on a given date. For example, PropertyName, ServiceDate does not determine Description since there may be more than one service at a property on a given date. For example, PropertyID, ServiceDate does not determine Description since there may be more than one service at a property on a given. Page 23 of 35 Full file at https: The question then becomes: Which one should we keep?

Finally the relationship is set up correctly. Now we can have many services even on the same date for one property. Suppose Garden Glory decides to add the following table: Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure ?

If not, modify the design so that this data will work. State the assumptions implied by this design. Page 24 of 35 Full file at https: This also means that a service can be applied to multiple, but different, properties on the same date.

However, a property may not have the same service on the same date. All of this seems reasonable. Now we need to check with the users. While James River Jewelry does sell typical jewelry downloadd form jewelry vendors, including such items as rings, necklaces, earrings, and watches, it specializes in hard-to-find Asian jewelry. It has a small but loyal clientele, and it wants to further increase customer loyalty by creating a frequent downloader program. In this program, after every 10 downloads, a customer will receive a credit equal to 50 percent of the sum of his or her 10 most recent downloads.

Figure D-1 shows data that James River Jewelry collects for its frequent downloader program. Page 25 of 35 Full file at https: Justify your assumptions on the basis of these sample data and also on the basis of what you know about retail sales.

From the data it would appear: For example, name is not a good determinant in a retail application; there may be many customers with the same name.

Another functional dependency is: For example, Name does not determine InvoiceNumber because one customer may have made more than one download. And why is InvoiceNumber the key for data about a customer?

Page 26 of 35 Full file at https: Given a unique Email address, Email works as a key for customer data. Unfortunately, Email does not determine InvoiceNumber and therefore is not a sufficient key. A unique ID column is a good idea, and works as a key for customer data. The design breaks up the themes and has a proper foreign key. However, the use of Email as a primary key may be a problem if two customers share an Email address.

However, why was Phone moved? Modify what you consider to be the best design in part B to include a column called AwarddownloadAmount. Assume that returns will be recorded with invoices having a negative PreTaxAmount. The result is: Assume that the new table will hold data concerning the date and amount of an award that is given after a customer has downloadd 10 items.

Ensure that your new table has appropriate primary and foreign keys. The new table is: For example, the store sells antique dining room tables and new tablecloths. The antiques are downloadd from both individuals and wholesalers, and the new items are downloadd from distributors. The antiques are unique, although some multiple items, such as dining room chairs, may be available as a set sets are never broken. The new items are not unique, and an item may be reordered if it is out of stock.

New items are also available in various sizes and colors for example, a particular style of tablecloth may be available in several sizes and in a variety of colors. Page 28 of 35 Full file at https: Page 29 of 35 Full file at https: From the sample sales data it would appear: The one trustable functional dependency here is: For example, Item is not a good determinant in a retail application; there may be many Items with the same designator.

Database concepts 6th edition kroenke

The most trustworthy functional dependencies here are: There may be many customers with the same last name. Page 30 of 35 Full file at https: There may be many customers with the same last name and first name. Phone will be fairly unique, and combined with FirstName may overcome the problem of two people with the same phone number being in the customer list but not necessarily—what if three students are sharing an apartment, and two of them are Bill Smith and Bill Jones?

However, this will not determine the download information of download date, etc. There may be many customers with the same last name and first name, and some of them may make a download on the same date.

The only good thing about this is that it is starting to address the download information. If LastName, FirstName was unique, then customers would be limited to one download per day.

Same objections as above in 4, except that now customers would be limited to one of a particular item per day. For example, a customer could not download two antique chairs on the same day! Finally the customer and download data is effectively broken up, but there is no foreign key to link the two tables.

Show the data changes necessary to add a second major for only the first student. Based on your answer to part B, show the data changes necessary to add a second major for the second student.

Concepts 6th edition kroenke pdf database

Explain the differences in your answers to parts B and C. Comment on the desirability of this situation. We had to add three rows in the first case—one major for each of the siblings of the student.

This is nuts! Divide this relation into a set of well-formed relations. StudentNumber, Major Is every determinant a candidate key? Page 19 of 35 Full file at https: In a properly normalized relation, each row of the relation consists of a primary key value which is a determinant and attribute values which are all functionally dependent on the primary key.

Thus, properly normalized relations store instances of functional dependencies, and only instances of functional dependencies. So we can say that the purpose of relations is to store instances of functional dependencies. Figure shows data that Regional Labs collects about projects and the employees assigned to them.

Assuming that all functional dependencies are apparent in this data, which of the following are true? Are all the nonkey attributes if any dependent on the primary key? To give an employee a salary, we must first assign the employee to a project.

If we change a Salary, we have to change it in multiple places and may create inconsistent data. Is ProjectID a determinant? If so, based on which functional dependencies in part A?

Is EmployeeName a determinant? Is EmployeeSalary a determinant? NO Actually, for the data in Figure , it is a determinant. However, the dataset is too small to validate this determinant, and logically EmployeeSalary is not a determinant! Does this relation contain a transitive dependency? If so, what is it? Redesign the relation to eliminate modification anomalies.

Concepts pdf database kroenke 6th edition

The following seems workable: Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance.

Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.

6th edition pdf kroenke database concepts

Figure shows data that Garden Glory collects about properties and services. Using these data, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses.

From the data it appears that there are many functional dependencies that could be defined. Some examples are: Page 22 of 35 Full file at https: There is simply not enough data to reply on it. Logically, it seems that we need one ID column—a surrogate key will be required here.

With regard to services, it would seem likely that a given service could be given to the same property, but on different dates. So, if we had a good determinant for property, then the last functional dependency would be true. So, the following seems workable: Given your assumptions in part A, comment on the appropriateness of the following designs: For example, PropertyName does not determine ServiceDate.

There may be more than one service on a given date. For example, PropertyName, ServiceDate does not determine Description since there may be more than one service at a property on a given date.

For example, PropertyID, ServiceDate does not determine Description since there may be more than one service at a property on a given. Page 23 of 35 Full file at https: The question then becomes: Which one should we keep? Finally the relationship is set up correctly.

Now we can have many services even on the same date for one property. Suppose Garden Glory decides to add the following table: Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure ? If not, modify the design so that this data will work. State the assumptions implied by this design.

Page 24 of 35 Full file at https: This also means that a service can be applied to multiple, but different, properties on the same date. However, a property may not have the same service on the same date.

All of this seems reasonable. Now we need to check with the users. While James River Jewelry does sell typical jewelry downloadd form jewelry vendors, including such items as rings, necklaces, earrings, and watches, it specializes in hard-to-find Asian jewelry. It has a small but loyal clientele, and it wants to further increase customer loyalty by creating a frequent downloader program.

In this program, after every 10 downloads, a customer will receive a credit equal to 50 percent of the sum of his or her 10 most recent downloads. Figure D-1 shows data that James River Jewelry collects for its frequent downloader program. Page 25 of 35 Full file at https: Justify your assumptions on the basis of these sample data and also on the basis of what you know about retail sales.

From the data it would appear: For example, name is not a good determinant in a retail application; there may be many customers with the same name. Another functional dependency is: For example, Name does not determine InvoiceNumber because one customer may have made more than one download. And why is InvoiceNumber the key for data about a customer?

Page 26 of 35 Full file at https: Given a unique Email address, Email works as a key for customer data. Unfortunately, Email does not determine InvoiceNumber and therefore is not a sufficient key.

A unique ID column is a good idea, and works as a key for customer data. The design breaks up the themes and has a proper foreign key.

However, the use of Email as a primary key may be a problem if two customers share an Email address. However, why was Phone moved? Modify what you consider to be the best design in part B to include a column called AwarddownloadAmount.