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, 2 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 > Engineering Posted 14 Oct 2017 My Price 10.00

I need help ASAP.I have some information but can anyone put into Access?

GARDEN GLORY PROJECT QUESTIONS

 

 

A.   Write CREATE TABLE statements for each of these tables.

 

 

B.   Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading updates and deletions, and justify those assumptions. (Hint: You can combine the SQL for your answers to Questions A and B.)

 

 

C.   Write SQL statements to insert the data into each of these tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in Figures 3-30, 3-31, 3-32, 3-33, and 3-34.

 

D.   Write SQL statements to list all columns for all tables.

 

 

Garden GloryProject Questions

If you have not already implemented the Garden Glory database shown in Chapter 3 in a DBMS product, create and populate the GG database now in the DBMS of your choice (or as assigned by your instructor).  (See Below)

A.           Create a user named GG-User with the password GG-User+password. Assign this user to database roles so that the user can read, insert, delete, and modify data.

 

B.           If you haven’t completed Exercise 7.50, do it now.

 

C.           Add a new folder to the DBC website named GG. Create a web page for Garden Glory in this folder—using the file name index.html. Link this page to the DBC web page.

 

D.           Create an appropriate ODBC data source for your database.

 

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 14 Oct 2017 12:10 PM 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)