Basic SQL/Database


The assignment:

Create a script like the [url removed, login to view] file to create your tables and populate the tables. You may find it more convenient to break this up into a creation script to create the tables and a population script to fill the tables with data. The population script requirements will be described more in the 2nd item.

Based on what you determined from your earlier assignments, generate the design accordingly. You do not need to follow either the ER or the Normalization assignment 100%, but you should justify your choices if the two assignments were not the same or if you chose yet another way to implement some desired property.

Insert data -- insert records for each table. Considering the queries below, make sure to enter enough data to check if your queries are correct. Your data should be from the website when available, but in some cases (like customers or orders), you may need to make up data.

For any query where you need to return a result based on only records satisfying some condition, make sure you include both records that satisfy the condition and records that do not satisfy the condition. If the query is an aggregate query, insert different values for the approriate attribute(s) to check if the result is correct.

QUERIES -- one basic, one using aggregate operations, one using at least one subqueries (either nested or set operation). The queries should be in a separate file to make it easier to execute them separately from the creation/population statements.

Required files are attached. The tables do not have to exactly follow the tables provided but it should be similar and be based on the products on

Habilidades: Administração de Bancos de Dados, MySQL, PHP, Arquitetura de software, SQL

Veja mais: sql database website design, sql database website, query creation, normalization, mysql to sql, database population, mysql populate table, sql different, nested sql, sql nested query, sql operation, php nested, check table mysql script, nested query sql, populate database, insert sql, populate table using, nested query, queries sql, check attribute, Create sql database, create tables using sql script, sql script data set, create website sql database, execute sql script

Acerca do Empregador:
( 42 comentários ) Hayward, United States

ID do Projeto: #5125745

Concedido a:


Will use the same Tables (given in your ER and Normalization docs) to write Create Table, Insert Data and given queries. Will deliver within 2 days. You need to confirm what database to use? MySql? or some other. Thank Mais

$83 USD em 2 dias
(59 Comentários)

6 freelancers estão ofertando em média $148 para esse trabalho


We intend to work on this project. Can we discuss details? Rehards, Nuprogramer

$368 USD in 10 dias
(34 Comentários)

Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,

$59 USD em 1 dia
(45 Comentários)

I could help you. . .

$155 USD in 10 dias
(3 Comentários)

I m Asad from Pakistan. I m currently in the final year of software engineering. Have worked on sql server ,need some little more details, wont disappoint you :)

$55 USD in 2 dias
(0 Comentários)

I have both the knowledge and experience regarding databases. Both studying, teaching and working on real life projects for years.

$166 USD in 5 dias
(0 Comentários)