Em Andamento

SQL DDL and SQL DML table design

Project 2 - SQL DDL and SQL DML (Part 1 of 2)

In this project you will conclude the _logical_ design of the Mom and Pop Johnson Video Store database you designed in Project 1, perform the _physical_ design and implementation using SQL Data Definition Language (DDL) and proceed with _populating_ the Mom and Pop Johnson Video Store database via Data Manipulation Language (DML) SQL commands. As described in Module 4, these are the next steps in implementation of the database that you designed via E/R Diagramming in Project 1 (_logical_ design).

In addition, some basic single-table and multi-table data retrievals against your database will be performed.

Your design work and SQL must be submitted through the Submit Assignments WebTycho facility. **Include both the SQL used, and the Oracle 9i or 8i responses immediately after each SQL statement in a single listing. ** Do not provide separate SQL and response listings. You may use any SQL*Plus available to you as long as it interfaces to Oracle9i or 8i. You should use a hierarchy of SQL scripts to perform this project (review SQL scripts in Module 4). Allow _sufficient_ _time_ to complete the project fully by following _all_ directions.

_The assignment_: plz open the zip file..

Habilidades: Administração de Bancos de Dados, Engenharia, Microsoft Access, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: sql to oracle, project mom, pop commands, open-table, johnson and johnson, design mom, design definition, definition of design, sql r, sql in r, r sql, oracle sql with, sql data, sql commands, sql and c, johnson, video store database project sql video, project using sql, database table design, mom pop johnson, multi statement sql, basic engineering design project, table video, mom pop johnson video store, project table design

Acerca do Empregador:
( 7 comentários ) United States

ID do Projeto: #2957204

Premiar a:

ekam

See private message.

$21.25 USD em 2 dias
(107 Avaliações)
5.7

5 freelancers estão ofertando em média $19 para este trabalho

teamvw

See private message.

$21.25 USD in 2 dias
(36 Comentários)
3.8
oradevvw

See private message.

$21.25 USD in 2 dias
(7 Comentários)
2.2
shyamvaranvw

See private message.

$20.4 USD in 2 dias
(0 Comentários)
0.0
Eureka

See private message.

$8.5 USD in 2 dias
(0 Comentários)
0.0