Homework Due in Hours: SQL Normalization, ERD & Dependency Diagrams ERD

Very strong understanding of English is a must! Communications must happen today.

I am taking a database administration course focused on standard SQL databases. I need help because I don't understand exactly what my teacher is looking for and I'm totally out of time.

This homework is all about charting diagrams of weakly normalized databases, then normalizing them and re-charting them. Multiple styles are required including an ERD diagram in Crows Foot notation. I'm not clear on what the other styles are supposed to be or if a certain style is required for one or two of the questions, but you can suggest a style in screenshot format and I'll approve/disapprove the style.


The following is a highly detailed summary of ALL the homework problems. I didn't post exact text, but if you are the high bidder you will get the exact text. So, the homework is roughly this:

1. Given a 16-column table with 3 rows of data and also the plain English goals of the database:

- Draw dependency diagram(s).

- Label the dependency diagram with all transitive and/or partial dependencies. I've done this already but may have done this wrongly! I will send a screenshot.

- Redesign the table to 3NF normalized form.

- Redraw the diagram as a normalized database in 3NF normalized form.

- Write a relational schema reflecting the 3NF normalized form.

- Draw a Crows Food ERD reflecting the 3NF normalized form.

The database mostly just has to be split up because the columns are only remotely related and will be redesigned as new tables..

Send me all diagrams as screenshots!

2. Use the dependencies described below where the letters represent data columns to work the following problems:

A,B -> C,D,E,F,G

A -> D

E -> G

C -> B

Create a diagram in 2NF of the above chart.

Create a diagram as 3NF of the above chart.

Redesign the diagram as 3NF BUT NOT BCNF.

Redesign the diagram as 3NF AND BCNF.


A decent free diagram charting software, if you don't have one, is Dia. See [url removed, login to view]

I WILL SELECT THE FIRST QUALIFIED BIDDER due to time pressure, so be ready to start within an hour of your bid and finish within 6 hours. Please post a bid if you can do all of this!

Skills: Database Administration, SQL

See more: use diagrams, teacher f, my sql free software, my sql databases, my sql create database, looking for a english teacher, do your homework for you, do homework for you, create a table chart, teacher work hours, Sql Database administration, redraw work, normalization, gnome, get sql help, food label, erd, english homework, do my homework, do my homework about

About the Employer:
( 23 reviews ) Grafton, United States

Project ID: #6016267

Awarded to:


i have more then 4 years experiences in databases and developments.. i also teach databases and developer specially in oracle 10g, mysql and sql server databases..

$20 USD / hour
(2 Reviews)

6 freelancers are bidding on average $22/hour for this job


Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here More

$22 USD / hour
(15 Reviews)

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around databases and SQL de More

$26 USD / hour
(14 Reviews)

Hi, I have gone through your requirements.I am a DBA at CMM5 Level company since August 2009.I am working on MySql,SQL Server,SQL,Oracle database, I can do your job confidently. I am available now,I can finish your wo More

$21 USD / hour
(33 Reviews)

A proposal has not yet been provided

$22 USD / hour
(0 Reviews)

may I see the full text,please. . More

$22 USD / hour
(0 Reviews)