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 07 Jan 2018 My Price 10.00

design of physical relational database tables,

Hi Harrikelie,

I have submitted this homework twice. Please, reply back in MS word.  Otherwise, I can't open it. CREATING, POPULATING, AND QUERYING TABLES. I have attached Module 3CT(chapter 3- Relational Database Design), and Module 4,

Using your ERD from the Module 3 CT assignment, along with any design changes you wish to make, develop a spreadsheet of table specification metadata, in the format presented in Module 4, for the design of physical relational database tables, their columns, and necessary integrity constraints.

Then, based on your table specification metadata and using your selected RDBMS from Module 4 (i.e., SQL Server, Oracle, or MySQL) and DDL SQL (i.e. CREATE TABLE, DROP TABLE, and ALTER TABLE statements), develop an SQL script file to create the corresponding relational database tables.

Then, using an SQL script file of DML SQL INSERT statements, populate each table with two rows of data.

Finally, using an SQL script file of SQL SELECT statements, perform queries to display all data in each table.

Submit your Excel spreadsheet of table specification metadata. Submit the following outputs of your SQL script file processing, in this order and appropriately labeled, in a single Word file:

Your DDL SQL and results used to create your tables

Your DML SQL INSERT statements and results used to populate your tables

Your SQL SELECT statements and results showing the contents of each table

You must show all of your SQL as it executed in Management Studio or other development environments. This includes the results returned by your selected RDBMS.

Thank you, Harrikelie!  

Attachments:

Answers

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