User Account

All Pages

Display information about all columns in customers table

Assignment Help Database Management System
Reference no: EM131299881

Database Security and Auditing Lab

This lab requires MS SQL Server and Oracle.

The requirement of the lab is listed as deliverables. The deliverable is abbreviated as "D" in this manual.

Deliverable 1-7 can be completed using either Oracle or MS SQL Server.

D1. Create table Product - include SQL script and screen shot in the lab report.

ProductID (primary key)

ProductName

ListPrice

Category

int, not null

Not null, length 50

$

int, not null

D2. Add values to table Product - include SQL script in the lab report. If you received errors, explain why and show how you corrected those errors

ProductID

Name

ListPrice

Category

D3. Update the name of a product whose ID is 299 to "Small Chest" - include SQL script and screen shot of successful execution in the lab report

D4. Select all unique categories from product table. - include SQL script and screenshot of successful execution in the lab report.

D5. Delete all products in category 12 - include SQL script and screenshot of successful execution in the lab report.

D6. Create view Product_Category11 that will include only products from category 11 - include SQL script and screenshot of successful execution in the lab report.

D7. Display all products from Category 11 - include SQL script and screenshot of successful execution in the lab report.

Deliverable 8 & 9 should be completed using Oracle

D8. ORACLE: Display List of all tables in Database (hint use DBA_TABLES) - include SQL script in the lab report.

D9. Display information about all columns in Customers table. (hint use OE schema and DESC) - - include SQL script in the lab report.

Deliverable 10 & 11 should be completed using MS SQL

D10. Display List of all tables in AdventureWorks database (hint use INFORMATION_SCHEMA system view) - - include SQL script in the lab report.

D11. Display information about all columns in Production.Product table (hint use INFORMATION_SCHEMA system view) - include SQL script in the lab report.

Reference no: EM131299881

Questions Cloud

Complete comprehensive analytical response to project : Your firm, Nurse International has identified investments for your hospital in long term, fixed income bonds. Your boss is expecting you to complete a comprehensive, analytical, response to this project.
What information does a prospectus provide : Closed-End Fund Quotations. Where can an investor find price quotations for closed-end and open-end funds? What information will be provided in a quotation for open-end funds? What information will be provided in a quotation for closed-end funds?
What are the values expressed in lincoln : What are the values expressed in Lincoln's "Second Inaugural Address"? How do the passages from the text try to persuade you to accept these values
Perform dissertation research : Describe which of the 3 approaches you would use to perform your dissertation research, and why. What instruments do you intend to use to support your selected research method?
Display information about all columns in customers table : Display information about all columns in Customers table. (hint use OE schema and DESC) - - include SQL script in the lab report. Deliverable 10 & 11 should be completed using MS SQL.
Explain how lipper indexes are used : Diversification. Discuss diversification among mutual funds. Describe some strategies that make diversification more effective. What is a mutual fund supermarket?
Propose a strategy for the client to receive similar amounts : Create a tax plan for the future redemption of the client's stock owned in the construction company that will not be taxed according to Section 301 of the IRC.
Calculate the value of the buffelhead american put : Would you ever want to exercise an American put early?- Calculate the value of the Buffelhead American put.- Calculate the value of the put if it had been European-style.
Discuss catering for eal/d students language : Discuss Catering for EAL/D Students' Language Needs in Prep Class: Classroom Teachers Perspectives and Practices

Reviews

Write a Review

Database Management System Questions & Answers

  Create a new excel workbook and save it

You are a regional manager for Home Station, a national chain of home renovation stores. Create a new Excel workbook and save it as Home Station-Austin.xlsx

  Design the network requirements for the xyz company

You must design the network requirements for the XYZ company. As the network consultant you will be required to develop a plan for the company network, including all costs.

  Draw e-r diagram with cardinalities of store revenue cycle

Marge's Crafts sells work by local artists at her small store in Burnsville. Customers pay for their purchases at the time sale. Commercial customers, purchasing over 10 items, may pay in installments.

  Draw an ER diagram for your proposed database

Describe the situation. Your description should be brief and relatively informal. If there are any unique or particularly difficult aspects of your proposed application

  A data distribution strategy for this retail store chain

Would you recommend a distributed database, a centralized database, or a set of decentralized databases for this retail store chain? Justify your answer.

  Discuss concept of an index and how they improve performance

Discuss the concept of an index and explain how they improve performance. The goal of a quality physical design is to improve performance while disrupting the logical design as little as possible.

  How many different orders are possible

How many different orders are possible if a customer can order at most one hamburger, one fish sandwich, and one beverage but can order less?

  Convert database tables to the first normal form

Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form

  Prepare a database design specification

Understand and interpret a set of business rules for a database and create an Enhanced Entity Relationship Diagram that models the requirements accurately

  Construct a use-case diagram

Construct (i) a use-case diagram (ii) a class diagram (iii) System Sequence Diagram (iv) detailed Sequence Diagram or diagrams as appropriate and (v) a state chart for a car object/class according this scenario. Include appropriate properties for ..

  Create an erd from a business problem

List all the business rules for the ABS ( Business rules are important because they define the conditions that the database must meet. For example, every Order must be associated with a valid Product.This prevents invalid Orders being entered into..

  Create microsoft access database for doc-n-the-box pharmacy

Create a Microsoft Access database for the Doc-n-the-Box pharmacy. Create the table(s), field(s), data type(s), primary key(s), etc. for the database

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd