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: 313 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 30 Oct 2017 My Price 10.00

How many books are sole each month by the publisher?

I NEED A SQL DATABASE CREATED FOR BOOKSRUS

 

Database: You will use your entity-relationship diagram in IT330_MILESTONE2_DIAGRAM_DOMINIQUEGONCALVES (1).jpgthe creation of your database. .

 

Tables: Should have at  least four tables that will display the data that is important to the store owners. Identify the primary and foreign keys that are necessary to relate the tables.

 

Include screenshots that show the tables you created. 

 

B. Import Data: Use SQL statements to import the data into the tables you just created. You will come up with each of your data sets yourself. You should have at least five records for each table. Include screenshots that show the populated tables annotated with the SQL statements that you used.

 

C. Queries: After you have populated the tables, write queries to extract the data to answer the owner's questions. Include screenshots that show each query and the corresponding query results.  

 

Queries need to answer these questions

 

How many books are sole each month by the publisher?

Which authors are the biggest sellers of books in our stores?

What books are associated with each publisher?

What are the most popular products besides books that are sold in each store?

From what region s by zipcode do customers visit our store?

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 30 Oct 2017 01: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)