In Progress

database project

1. Your final submission should include:

a. Project description or proposal

b. A complete E-R diagram

c. A complete Schema diagram

d. Sample SQL statements used to manage the database, including creating tables, inserting records, updating records, deleting records, and retrieving records with various SQL queries. Please suggest different scenarios where the following keywords may be used in SQL queries: IN, EXISTS, NOT EXISTS, NOT EXISTS with EXCEPT, ALL, SOME, UNIQUE, UNION, EXCEPT, INTERSECT, NATURAL JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN and etc. For each keyword in the preceding list, create at least one query.

2. Create the database in SQL Fiddle or another database system you prefer. Run all the SQL statements you created and show the execution results in the final submission. You can do screenshot of your execution which can be added into the same file of your submission.

Caveats: 1. You are free to propose your own project, but make sure the project your propose is not too complex to serve as a term project in this course.

2. Your submission should only contain one file in pdf or Word.

3. You are free to discuss the project with your friends, but don’t submit the same work. No plagiarism is tolerated. Duplication detection will be applied to all submissions.

Skills: Database Administration, Database Development, Database Programming

See more: sample proposal for a project, sample of the project proposal, sample of proposal of project, sample of proposal for project work, sample of project work proposal, sample of project proposal, proposal sample for project, proposal project sample, proposal of project sample, proposal for project sample, project work proposal sample, project sample proposal, make project proposal, creating a proposal for a project, creating a project proposal, a sample proposal for a project, create access project database 2010, create sports results database, create sport results database, create project database application netbeans , create setup installshield web project database, java exe project database, project database hotel, real estate project database, php mysql simple project database

About the Employer:
( 2 reviews ) Kansas City, United States

Project ID: #10385728

Awarded to:

rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time

$30 USD in 1 day
(11 Reviews)
3.6

19 freelancers are bidding on average $53 for this job

scorpioangry55

You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.

$100 USD in 3 days
(9 Reviews)
4.3
acronymsolutions

Hi , I am 16+ years experienced Database Programmer at CMMI-5 level company. We are working on : RDBMS :Oracle,MySQL,DB2, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assist More

$100 USD in 3 days
(28 Reviews)
4.9
vw7209238vw

I have similar case about plane, airports. etc........................................................................................................................

$30 USD in 2 days
(9 Reviews)
4.1
shahzaib121

Hi Dear I have a lot of experience in Business Intelligence & Data Mining, DataBases +Data Warehous.I am DataBases + Warehouse certified from Oracle. I have done many work in Requirements analysis , Data Staging, More

$100 USD in 3 days
(7 Reviews)
3.6
ashupathania

I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynam More

$30 USD in 1 day
(11 Reviews)
3.8
ref2

Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. You should choos More

$66 USD in 2 days
(4 Reviews)
2.7
ElanceCoder

Hi, I have done similar database assignments previously as having expert team for data base development as well. please contact. thanks

$155 USD in 3 days
(1 Review)
2.8
$45 USD in 0 days
(4 Reviews)
2.6
$25 USD in 1 day
(2 Reviews)
2.1
ajoaosilva

Hi I have over 20 years of experience with SQL, Microsoft SQL Server (since version 6.5 in 1996) and Microsoft Access (since version 2.0 in 1993) so, these database systems don't have many secrets to me. Also, i'm u More

$50 USD in 10 days
(2 Reviews)
1.8
ENRICOJ

HI, I WOULD LIKE TO ASSIST AS I HAVE EXTENSIVE DATABASE DESIGN ,ER AND [url removed, login to view] FEEL FREE TO APPROACH ME FOR FURTHER ASSISTANCE. KIND REGARDS ENRICO

$25 USD in 1 day
(3 Reviews)
1.7
DaraCodes

Let's talk

$30 USD in 1 day
(1 Review)
1.0
ankita0389

A proposal has not yet been provided

$88 USD in 3 days
(2 Reviews)
1.3
$30 USD in 1 day
(1 Review)
0.4
vijayashanthij

Hi, I am a Sr Software engineer who works on SQL Server(TSQL) Development. I should complete your project smoothly as I have got experience on the same technology. Thank You, VjShanthi

$25 USD in 2 days
(0 Reviews)
0.0
assignmentntutor

Hi, we are experts in student assignments, we create assignments that looks realitic and make students score better. Regards, Ajay

$66 USD in 3 days
(0 Reviews)
0.0
anupkumarmishra

A proposal has not yet been provided

$40 USD in 3 days
(0 Reviews)
0.0
hemamalinib

Hello I am Hema, having 10 years experience in software development. Worked on various database projects on Oracle and MS SQL Server. I am passionate working on database programming especially Oracle. I am a very qu More

$35 USD in 3 days
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0
WeirdMix

hello!!! I suppose it's your final project!!! Please contact me to chat about details.. when do you need this to be deliver?? greetings

$35 USD in 3 days
(1 Review)
0.0