SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 21 Nov 2017 My Price 10.00

CustLastName VARCHAR2(30) CONSTRAINT CustLastNameRequired

Chapter 14

 

Problem 5

 

Compare and contrast the software licenses for MySQL and another open source DBMS product.

 

 Problem 9

Write named CHECK constraints for the following integrity rules. Modify the CREATE TABLE

statement to add the named CHECK constraints.

 

CREATE TABLE Customer

( CustNo CHAR(8),

CustFirstNameVARCHAR2(20) CONSTRAINT CustFirstNameRequired

NOT NULL,CustLastName VARCHAR2(30) CONSTRAINT CustLastNameRequired

NOT NULL,

CustStreet VARCHAR2(50),

CustCity VARCHAR2(30),

CustStateCHAR(2),

CustZipCHAR(10),

CustBalDECIMAL(12,2) DEFAULT 0,

CONSTRAINT PKCustomer PRIMARY KEY (CustNo) )

• Customer balance is greater than or equal to 0.

• Customer state is one of CO, CA, WA, AZ, UT, NV, ID, or OR.

 

Problem 11

 

In this problem, you should create a view, several roles, and then grant specific kinds of access .

of the view to the roles.

• Create a view of the Supplier table in the extended Order Entry Database introduced in the

problems section of Chapter 10. The view should include all columns of the Supplier table for

suppliers of printer products (Product. ProdNamecolumn containing the word "Printer"). Your

view should be named "PrinterSupplierView."

• Define three roles: PrinterProductEmp, PrinterProductMgr, and StoreMgr.

• Grant the following privileges of PrinterSupplierView to PrinterProductEmp: retrieval of all

columns except supplier discount.

• Grant the following privileges of PrinterSupplierView to PrinterProductMgr: retrieval and

modification of all columns of PrinterSupplierView except supplier discount.

• Grant the following privileges of PrinterSupplierView to StoreMgr: retrieval for all columns,

insert, delete, and modification of supplier discount.

 

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 21 Nov 2017 11:11 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)