Statement needed to add cases to categories in the database

Assignment Help Operation Management

Reference no: EM132295207

1. The Guitar Shop is going to start carrying cases as part of their inventory. Write the statement needed to add Cases to the categories in the database. Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column.

2. During a meeting, it was decided that instead of Manuals, the Guitar Shop would start using the term Teaching Materials for these items. Write the statement that will update the name of the category Manuals to Teaching Materials. To be sure you are updating the right row, use the CategoryID in your statement.

3. Some new items have come into the Guitar Shop and need to be added to the database. Write the statement that will add this product: ProductID: The next automatically generated ID ?CategoryID: 4?ProductCode: dgx_680?ProductName: Yamaha DGX 680 102-Key Digital Piano?Description: Long description to come.?ListPrice: 799.99?DiscountPercent: 0?DateAdded: Today’s date/time.

4. It was later determined that the new product dgx_680 would have a discount percentage of 30%. Write the statement that will update the product in the database.

5. A new customer needs to be added to the database so that their orders can be tracked. Add the following customer to the Guitar Shop’s list: EmailAddress: [email protected]?Password: (empty string)?FirstName: John?LastName: Snyder

Reference no: EM132295207

Questions Cloud

Hypothesis testing is basis of inferential statistics : Hypothesis testing is basis of inferential statistics. Statisticians are always coming up with new tests and testing new characteristics of population parameter

Officer bill approaches you as his supervisor in confidence : Officer Bill approaches you as his supervisor in confidence. Bill has been the range officer for nearly 15 years.

Concept of granular projection of revenue : Explain the concept of granular projection of revenue.

Sergeant gervasio comes to you in confidence : Sergeant Gervasio comes to you in confidence. He has discovered that Sergeant Benes makes $7000 a year more than he does.

Statement needed to add cases to categories in the database : The Guitar Shop is going to start carrying cases as part of their inventory. Write the statement needed to add Cases to the categories in the database.

Consequence make the landlord conduct unethical : When Dog House Investments, Inc. was not reimbursed it caused severe financial duress. Does this consequence make the landlord’s conduct unethical?

The demographic segment of the macroenvironment : Identify the various generational cohorts within the demographic segment of the macroenvironment?

Who needs to be involved in setting quality standards : Who needs to be involved in setting quality standards?

What is true about the employment at-will doctrine : What is TRUE about the employment at-will doctrine? Pursuant to Aristotle's Doctrine of the Mean, a modern business corporation should be socially responsible.

User Account

All Pages