Chapter 12 Lab

In: Computers and Technology

Submitted By mzamora13
Words 678
Pages 3
Exercises
In these exercises, you’ll use SQL Server Management Studio to create the MyGuitarShop database, to review the tables in the MyGuitarShop database, and to enter SQL statements and run them against this database.
Create the database
Start SQL Server Management Studio and open a connection using either Windows or SQL Server authentication.
Open the script file named CreateMyGuitarShop.sql
Execute the entire script by clicking the Execute button in the SQL Editor toolbar or by pressing F5. When you do, the Messages tab displays indicates whether the script executed successfully.
Review the database
In the Object Explorer window, expand the node for the database named MyGuitarShop so you can see all of the database objects it contains. If it isn’t displayed in the Object Explorer window, you may need to click on the Refresh button to display it.
View the data for the Categories and Products tables.
Navigate through the database objects and view the column definitions for at least the Categories and Products tables.

Questions 1. Write a SELECT statement that returns these column names and data from the Products table: ProductName The ProductName column ListPrice The ListPrice column DiscountPercent The DiscountPercent column DiscountAmount A column that’s calculated from the previous two columns DiscountPrice A column that’s calculated from the previous three columns
Sort the result set by discount price in descending sequence.
Write a SELECT statement that returns these columns from the Orders table:
OrderID The OrderID column
OrderDate The OrderDate column
ShipDate The ShipDate column
Return only the rows where the ShipDate column contains a null value.
Write a SELECT statement without a FROM clause that creates a row with these columns:
Price 100 (dollars)
TaxRate .07 (7 percent)
TaxAmount The price multiplied by the tax
Total The price plus tax
To…...

Similar Documents

Chapter 12 Solutions

...EXERCISE 12-1 (15–20 minutes) (a) 10, 13, 15, 16, 17, 19, 23 (b) 1. Long-term investments in the balance sheet. 2. Property, plant, and equipment in the balance sheet. 3. Research and development expense in the income statement. 4. Current asset (prepaid rent) in the balance sheet. 5. Property, plant, and equipment in the balance sheet. 6. Research and development expense in the income statement. 7. Charge as expense in the income statement. 8. Operating losses in the income statement. 9. Charge as expense in the income statement. 11. Not recorded; any costs related to creating goodwill incurred internally must be expensed. 12. Research and development expense in the income statement. 14. Research and development expense in the income statement. 18. Research and development expense in the income statement. 20. Research and development expense in the income statement. 21. Long-term investments, or other assets, in the balance sheet. 22. Expensed in the income statement. EXERCISE 12-4 (15–20 minutes) 1. Palmiero should report the patent at $900,000 (net of $600,000 accumulated amortization) on the balance sheet. The computation of accumulated amortization is as follows. Amortization for 2010 and 2011 ($1,500,000/10) X 2 | $300,000 | 2012 amortization: ($1,500,000 – $300,000) ÷ (6 – 2) | 300,000 | Accumulated amortization, 12/31/12 | $600,000 | 2. Palmiero should amortize the franchise over its......

Words: 781 - Pages: 4

Biology Lab Grade 12

...Hypothesis: As a group predict that aerobic exercise will consume more glucose because of oxidation phosphorylation which produces more ATP. Thus more reps will be done under this condition. Or in other words stage 1 of the lab will have more reps than stage 2 because there is more energy available. During aerobic respiration the continuous break down of sugar will allow more activity to be done versus anaerobic respiration which will just be able to use the energy it currently has, it will not be able to create more. Could you tell when muscles went into anaerobic resp . what evidence? There was a tight feeling in the muscles along with tension and cramping. The oxygen could not be delivered to the cells quick enough to undergo oxidative phosphorylation and instead underwent anaerobic respiration in which oxygen is not needed. During anaerobic respiration, lactic acid fermentation occurred which causes the formation of lactase build up in the working muscles. This causes pain, stiffness, and fatigue which explains the symptoms experienced in the experiment. Panting was also experienced which occurs as a result of the body paying back the oxygen debt that was lost while lifting.  When your muscles run out of oxygen, your muscle cells quickly try to produce ATP using lactic acid fermentation. The buildup of lactic acid causes a painful, burning sensation. Hot feeling after lifting. Explain using cellular respiration. Exercising increases the body’s heat......

Words: 1168 - Pages: 5

Linux Chapter 12 and 13

...Review Questions 2. B 4. B 6. A, C 8. B, C 10. A 12. B 14. True 16. D 18. A 20. A, C, D Hands On Projects 12-1 1. OK 2. OK 3. Just one device, eth0 for the Ethernet. Just one driver for that device. 4. Most likely when the system was first installed. OK 5. OK 6. OK 7. 8. OK 9. OK 10. The old one as the script has not been read since it was modified. OK 11. OK 12. The new one as the modified script was read at boot.Yes 13. OK 14. OK 15. The modified configuration. 16. OK 12-2 1. OK 2. 3. No DNS servers have been setup. 4. Files then dns. 5. an entry for: 127.0.0.1 server1 localhost.localdomain localhost 6. Yes 7. Yes 8. Yes it was resolved, but not available to contact. 9. Yes it was resolved, but not available to contact. 10. OK 12-3 1. OK 2. 204.152.189.116, yes, zeus-pub.kernel.org. 3. nslookup lists the IP of your DNS server. 4. Detailed query information and statistics. 5. OK 12-4 1. OK 2. 10.0.2.2 3. OK 4. Yes it will interfere with the default gateway. 5. 30 6. No, and at least 1. 7. Ok Discovery Assignments 1. Subnet mask = 255.240.0.0 Hosts per network = 220-2 First five ranges are: 100.0.0.1–100.15.255.254 100.16.0.1–100.31.255.254 100.32.0.1–100.47.255.254 100.48.0.1–100.63.255.254 100.64.0.1–100.79.255.254 2. The cat command is run on the remote system; to......

Words: 926 - Pages: 4

Chapter 12 Supply Chain

...ANSWER KEY Homework Chapter 12 – Managing Production Multiple Choice: 1. D 2. C 3. C 4. B 5. D 6. C | 7. D 8. C 9. B 10. D 11. D | Essay – Chapter 12/12S 1. What is MRP Nervousnes?.Can this condition affect DRP system as well?. Answer: MRP nervousness refers to the observation that any change, even a small one, in the requirements for items at the top of the bill can have drastic effects on items further down the bill. As you fall short of parts at the top, you cannot create more parts as you go down the bill, and at the bottom you have massive amounts of shortages. MRP nervousness can affect DRP systems as well because they use MRP-style logic to feed accurate demand information into the master schedule. 2. What are the benefit of having formal Master Scheduling Process?. What happen to the firm that don’t follow some of basic rules of master scheduling?. Answer: It is good to have a formal master scheduling process because it ensures uniformity in the calculation and results, no matter who does the scheduling. If firms do not follow some of the basic rules of scheduling there would be a disconnect between the supply chain, sales, marketing, and finance and that almost ensures that there will be chaos among these units. 3. What is the different between information flow and information system? Do information system always have to be computerized? Why? Answer: An information flow focuses on “what” information is......

Words: 308 - Pages: 2

Mfrs Chapter 12

...Chapter 12 1(a) Tagline Statement of Cash Flows For the year ended 31 December x5 | RM’000 | | RM’000 | Cash from operating activities: | | | | Profit before taxation | | | 50 | Adjustments fro: | | | | Depreciation | | | 2,200 | Profit on disposal of PPE (12,000-7,400) | | | (4,600) | Release of government grant | | | (250) | Increase in insurance claim receivable | | | (300) | Interest expense | | | 260 | Investment income | | | (40) | Cash generated from operations | | | (2,680) | Increase in inventories | | | (700) | Increase in trade receivables | | | (500) | Increase in trade payables | | | 1,100 | | | | (2,780) | Interest paid | | | (260) | Income taxes paid | | | (1,350) | Net cash flow from operating activities | | | (4,390) | | | | | Cash flows from investing activities: | | | | Purchase of plant | (2,900) | | | Proceeds from the disposal of plant | 12,000 | | | Proceeds from government grant | 950 | | | Investment income | 40 | | 10,090 | Net cash inflow......

Words: 1211 - Pages: 5

Netw Lab 12

...Lab 12.1 1. The type of events are system log, application log, and security log. Errors will happen same as warning and information. 2. Applications and Services Logs vary. They include separate logs about the programs that run on your computer, as well as more detailed logs that pertain to specific Windows services. 3. Custom Views, it’s easier to call up a commonly used filter. You can easily remove old events and then show recurring events. 4. Yes you can 5. Edit custom view Lab 12.2 1. This process is of assigning alphabetical identifiers to physical or logical disk drives or partitions. 2. You would have to use start up repair. You would need to take ownership for this to work. 3. The System Volume Information folder (SVI) contains windows system restore files. If you do not have any important data on that drive, you could format and reclaim the space. 4. Driver Restore backs up your existing drivers and settings to create a restore point so that if you run into a similar issue in the future, the user would have an easy solution prepared. 5. When the user restores the system Lab 12.3 1. Disable Service helps you to disable services running in the background such as "push service”,” upload service" or "pull ad service" and so on. This would help keep out the viruses etc. 2. No 3. System Configuration is an advanced tool that can help identify problems that might prevent Windows from starting correctly. You can......

Words: 335 - Pages: 2

Week 12 Lab 1

...Unit 7 Lab – Relate Windows Encryption and Hashing to Confidentiality & Integrity 1. Which Key do you provide anyone you want to encrypt messages with private or public keys or both? Public The key is always provided as part of the handshake in order to encryption to take place. 2. What does GPG allow you to do once it is installed? GPG allows you to encrypt your hard drives content in order to secure it. 3. Name 2 different types of encryption supported by GPG for your key? The MD5 and Sha1 type of hashing encryption are supported by GPG. 4. What happens when you sign and trust a new key on your keychain? A new key is created to include the private and public key based on how the new key was created. 5. If a user sends you a public key will he be able to decrypt your encrypted messages once you import and sign his key? Both parties need to have each other’s private keys in order to be able to encrypt and decrypt all messages that are exchange among themselves. 6. What are the similarities between an MD5 hash and a fingerprint? They both insert a fingerprint to the data. 7. How would you encrypt a webserver and the pages it serves up? I would set the web server to redirect its web traffic to SSL hence encrypting all conversations between server and host in relation to the web traffic. 8. Why is hashing all database inputs not considered encryption of a database? What value does hashing database entries from server to client? Hashing......

Words: 442 - Pages: 2

Chapter 12 Cis 345

...Chapter 12 – Network Management Lab In this Lab you will use the Event Viewer application to explore the event log on a computer running the Windows operating system. You can find the Event Viewer as follows: Click Start, click Control Panel, and then click System and Security; under Administrative Tools click the Event Viewer. For this exercise, you need a computer running Windows. Ideally, it should be a computer that has been used for a while, so that the event log contains several entries. It need not be connected to a network. However, you must be logged on to the computer as a user with administrator-equivalent privileges. 1. Click Start, then click Control Panel. The Control Panel window appears. 2. In the Control Panel window, click System and Security. The System and Security window appears. 3. If the entire list of options doesn’t appear, scroll to the bottom of the window and click View event logs under the Administrative Tools heading. 4. A User Account Control window appears, requesting your permission to continue. Click Continue. 1. The Event Viewer window appears, with three columns of panes. The center pane lists a summary of administrative events. Notice that events are classified into the following types: Critical, Error, Warning, Information, Audit Success, and Audit Failure. The number of events that have been logged in each category are listed to the right of the classification entry. ......

Words: 1193 - Pages: 5

Chapter 12

...Chapter 12 Intangible Assets Lack physical substance (patents, copyrights, franchises, licenses, trademarks, trade names, goodwill) They are NOT financial instruments (A/R, notes and bonds receivable,….ect.) Valuation: Record at cost (everything necessary to make asset ready for intended use). For internally-generated intangibles, only direct costs are capitalized (e.g., legal costs for patent). If insignificant cost, then usually expensed. Amortization:* Limited-life intangibles—over useful life. Amortizable base equals cost minus residual value. Indefinite-life intangibles—do NOT amortize. * Usually decrease the value of the asset directly, can use a contra-account: Accum. Amort. “Types” of Intangible Assets Legal Amortization life Period Market-related: Trademark Indefinate, Company name renewable Not amortized Customer-related: Customer lists None Lesser of useful or economic life. Artistic-related: Copyrights Life of creator Lesser of useful or plus 70 years economic life. Contract-related: Franchises Length of Length of Licences contract or contract or Permits indefinite not amortized Technology-related: Patents 20 years Less of useful or legal life. Goodwill: None Not amortized Recording Goodwill Duncun Corp. purchased the Fran Company for $300,000 on December 31, 2003. The balance sheet of Fran......

Words: 1637 - Pages: 7

Bsop 330 Week 4 Lab Assignments Chapter 12, Problems 12.1, 12.5, 12.9, 12.15

...BSOP 330 Week 4 Lab Assignments Chapter 12, problems 12.1, 12.5, 12.9, 12.15 Purchase here http://chosecourses.com/BSOP%20330/bsop-330-week-4-lab-assignments-chapter-12-problems-121-125-129-1215 Product Description Chapter 12, problems 12.1 L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company’s manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? Chapter 12, problems 12.5 William Beville’s computer training school, in Richmond, stocks workbooks with the following characteristics: Demand ,500 units/year Ordering cost S = $25/order Holding cost H = $4/unit/year a) Calculate the EOQ for the workbooks. b) What are the annual holding costs for the workbooks? c) What are the annual ordering costs? Chapter 12, problems 12.9 Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,000 units. Southeastern estimates its annual holding cost for this item to be $25 per unit. The cost to place and process an order from the supplier is $75. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) Find the economic order quantity. b) Find the annual holding costs. c) Find the annual ordering costs. d) What is the......

Words: 1545 - Pages: 7

Bsop 330 Week 4 Lab Assignments Chapter 12, Problems 12.1, 12.5, 12.9, 12.15

...Week 4 Lab Assignments Chapter 12, problems 12.1, 12.5, 12.9, 12.15 Purchase here devrycourse.com/bsop-330-week-4-lab-assignments-chapter-12-problems-121-125-129-1215 Product Description Chapter 12, problems 12.1 L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company’s manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? Chapter 12, problems 12.5 William Beville’s computer training school, in Richmond, stocks workbooks with the following characteristics: Demand ,500 units/year Ordering cost S = $25/order Holding cost H = $4/unit/year a) Calculate the EOQ for the workbooks. b) What are the annual holding costs for the workbooks? c) What are the annual ordering costs? Chapter 12, problems 12.9 Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,000 units. Southeastern estimates its annual holding cost for this item to be $25 per unit. The cost to place and process an order from the supplier is $75. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) Find the economic order quantity. b) Find the annual holding costs. c) Find the annual ordering costs. d) What is the reorder point? Chapter 12,......

Words: 384 - Pages: 2

Bsop 330 Week 4 Lab Assignments Chapter 12, Problems 12.1, 12.5, 12.9, 12.15

...Week 4 Lab Assignments Chapter 12, problems 12.1, 12.5, 12.9, 12.15 Purchase here devrycourse.com/bsop-330-week-4-lab-assignments-chapter-12-problems-121-125-129-1215 Product Description Chapter 12, problems 12.1 L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company’s manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? Chapter 12, problems 12.5 William Beville’s computer training school, in Richmond, stocks workbooks with the following characteristics: Demand ,500 units/year Ordering cost S = $25/order Holding cost H = $4/unit/year a) Calculate the EOQ for the workbooks. b) What are the annual holding costs for the workbooks? c) What are the annual ordering costs? Chapter 12, problems 12.9 Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,000 units. Southeastern estimates its annual holding cost for this item to be $25 per unit. The cost to place and process an order from the supplier is $75. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) Find the economic order quantity. b) Find the annual holding costs. c) Find the annual ordering costs. d) What is the reorder point? Chapter 12,......

Words: 384 - Pages: 2

Bsop 330 Week 4 Lab Assignments Chapter 12, Problems 12.1, 12.5, 12.9, 12.15

...BSOP 330 Week 4 Lab Assignments Chapter 12, problems 12.1, 12.5, 12.9, 12.15 To Buy This material Click below link http://www.uoptutors.com/bsop-330-devry/bsop-330-week-4-lab-assignments-chapter-12-problems-12.1-12.5-12.9-12.15 Chapter 12, problems 12.1 L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company’s manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? Chapter 12, problems 12.5 William Beville’s computer training school, in Richmond, stocks workbooks with the following characteristics: Demand ,500 units/year Ordering cost S = $25/order Holding cost H = $4/unit/year a) Calculate the EOQ for the workbooks. b) What are the annual holding costs for the workbooks? c) What are the annual ordering costs?   Chapter 12, problems 12.9 Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,000 units. Southeastern estimates its annual holding cost for this item to be $25 per unit. The cost to place and process an order from the supplier is $75. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) Find the economic order quantity. b) Find the annual holding costs. c) Find the annual ordering costs. d) What...

Words: 403 - Pages: 2

Chapter 12

...TUGAS RESUME CHAPTER 12, 14 DAN 15 MATA KULIAH MANAJEMEN SUMBER DAYA MANUSIA (KELAS H) KELOMPOK 9 Nama Anggota : Auliana Maharani Puteri / 041411231251 Rila Nickytha Dewi / 041411231252 Fakhrur Rizal / 041411231253 Eva Amelia Rasidahwati / 041411233001 Amira Nadia Sawitri / 041411233004 Anggy Haristya Octari / 041411233015 Aza Rosmala / 041411233032 Kurnia Pramadhani / 041411233038 JURUSAN MANAJEMEN FAKULTAS EKONOMI DAN BISNIS UNIVERSITAS AIRLANGGA 2015 CHAPTER 12 THE ORGANIZATIONAL REWARD SYSTEM DEFINING SYSTEM sistem reward organisasi terdiri dari jenis hadiah yang akan ditawarkan dan distribusi mereka. Imbalan organisasi mencakup semua jenis hadiah, baik intrinsik dan ekstrinsik, yang diterima sebagai hasil kerja oleh organisasi. Imbalan intrinsik yang internal untuk individu dan biasanya berasal dari keterlibatan dalam kegiatan atau tugas-tugas tertentu. Kepuasan kerja dan perasaan. Imbalan ekstrinsik secara langsung dikontrol dan didistribusikan oleh organisasi dan lebih nyata tha reward intrinsik. membayar dan manfaat rawat inap. RELATING REWARDS TO PERFORMANCE Pertimbangan untuk menentukan reward yang akan diberikan, jumlah prasyarat yang diinginkan telah diidentifikasi dan berlaku umum: * Kepercayaan dalam manajemen * Tidak adanya kendala kinerja * Supervisor terlatih dan manajer * Sistem pengukuran yang baik * Kemampuan untuk membayar * Clear perbedaan antara biaya hidup, senioritas, dan......

Words: 1988 - Pages: 8

Lab 12

...improvements to their infrastructure over the last few years. Its expansion is thousands of websites vulnerable to SQL Injections. Malicious code writers have exploited these vulnerabilities to distribute malware so quick that the government cannot contain such a large quantity. 3. What does it mean to have a policy of nondisclosure in an organization? It is a contract where the parties agree not to disclose information covered by the agreement. It outlines confidential material, knowledge, or information that the parties wish to share with one another for certain purposes, but wish to restrict access to or by third parties 4. What trends were tracked when it came to malicious code in 2009 by the Symantec Report researched during this lab? DoS attacks are always common, however targeted attacks using advanced persistent threats (SPT) that occurred in 2009 made headlines. 5. What is phishing? Describe what a typical phishing attack attempts to accomplish. Is a way of attempting to acquire information such as usernames, passwords, and credit card details by masquerading as a trustworthy entity in an electronic communication. 6. What is the Zero Day Initiative? Do you think this is valuable, and would you participate if you were the managing partner in a large firm? The Zero Day Initiative (ZDI), founded by TippingPoint, is a program for rewarding security researchers for responsibly disclosing vulnerabilities. Not participating in such a program is......

Words: 411 - Pages: 2