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: 305 Weeks Ago, 1 Day 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 12 Jan 2018 My Price 10.00

(E-R diagram) and implementation (SQL queries)

Deliverables for Project Part 2:

Must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was previously submitted or appears on the Web, in a textbook, or otherwise made available via an external source.

  1. SQL Data Definition Language.
  • Create a base table. Write the SQL to create a table based on one of your entities. Be sure to identify the primary key as part of your SQL syntax
  • Create a view. Write the SQL to create a view on the base table
  • Show the base tables with data. Show a base table along with six rows containing data for three entities in your entity-relationship diagram. (Display each table in the form of an MS Word table.)

SQL Data Manipulation Language (insert, update, and delete).

  • Insert a row. Write a SQL query to insert a row into one of your base tables
  • Update a row. Write a SQL query to change a data value in the inserted row.
  • Delete a row. Write a SQL query to delete the row from your base table

SQL Data Manipulation Language for data retrieval. For 3.1 through 3.7, write the SQL query AND show the output using the data in your base tables.

  • Write a SQL query using a comparison operator (e.g., =, >, <)
  • Write a SQL query using the “AND” or “OR” operator
  • Write a SQL query using the “BETWEEN” or “LIKE” operator
  • Write a SQL query using a built-in function
  • Write a SQL query using the “GROUP BY” clause
  • Write a SQL join query using two or more base tables
  • Write a SQL subquery using two or more base tables

Part 1 or Project is attached, Project Description and Entity-Relationship Diagram

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Jan 2018 02:01 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)