How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Steve Herrod Your Own Question

Steve Herrod
Steve Herrod, Master's Degree
Category: Writing Homework
Satisfied Customers: 690
Experience:  Masters in Literature and a Bachelors Degree in French with Management
65126503
Type Your Writing Homework Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

In you word document, submit a 2 - 3-paragraph problem statement

Customer Question

In you word document, submit a 2 - 3-paragraph problem statement describing the need for the database you are creating. The statement should overview the current environment, what your database will do, and how the environment will be better after they start using your database. This should be a unique problem, we do not want you to reinvent the wheel. For example, there are countless sales, marketing, ERP, CRM, etc database solutions. Build something for which a solution does not exist! Another sales database, for example, will result in partial credit because it is not original.

Please submit the project in one Microsoft Word file. We require that you submit your SQL code for the final project as it has to be run through an online database to assure no one else wrote the code. Screenshots should be below each piece of code. I cannot grade your final project without your code and screenshots so please be diligent on this. As always, the screenshot should contain a date, your SQL at the top, the action tab, and the results of running that particular SQL below.
Entity Relationship Diagram

Submit an Entity Relationship Diagram of your entire database design according to the following guidelines:

Your database should include at least 5 tables.
Each table should be related to at least one other table.
You must identify all primary and foreign keys in all tables.
Your design should be in 3NF or higher (if not, you must document why).
Your database tables and fields should follow a consistent naming convention.

Submit the ERD as a screenshot in your word document.
SQL CREATE Statements

Submit the SQL Statements necessary to create your database according to the following guidelines:

Your SQL statements should exactly mirror your ERD.
All primary keys, foreign keys, and relationships should be implemented in your SQL statements.
You do not have to include the CREATE DATABASE command, as your instructor will assume the database has already been created and selected.
Include DROP TABLE statements before your CREATE TABLE statements so your script can be run multiple times.

Submit your SQL CREATE Statements (code for safe assign) followed by one screenshot for the create table script running.
SQL INSERT Statements

Submit SQL INSERT Statements that will populate the database with sample data. You must insert at least 5 records into each table in your database. Submit your SQL INSERT Statements (code for safe assign) followed by screenshots of your script running.
SQL SELECT Statements

Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines:

You must submit at least 5 SELECT Statements.
Each statement must select data from more than one table.
Each table should be selected from by at least one statement.
You must use at least one aggregate function (e.g. sum, count, max, avg, etc.).
Each statement should have a WHERE clause.
Each statement should have an ORDER BY clause.
When selecting data from multiple tables, do not use "old-style joins" with the tables delimited in the FROM clause. Use the JOIN clause instead.

Each select statement / report requires a screenshot and the code in the final (1) Microsoft Word document.
Suggestions

The project is graded largely on originality. It should attempt to solve a business problem or idea that you have. For example, your dream startup company or a current problem at your place of work that needs a database. A basic school, university, customer or any other textbook example is not the goal. A new energy source for power would be another good example.

We do not want to see what someone else has designed, written, or created. This includes the textbook solutions; I should not see any re-designs from assignments or the textbook. We are grading you on what you learned, designed, created, and what you wrote not someone else!



See the rubric below for points on deliverables necessary to complete the final project successfully.
Rubric
Grading Rubric
Item Points Received
Problem statement 20 20
2-3 paragraphs
Summary of DB objectives
Efficiencies created
Proper APA formatting
Proper spelling and grammar

Entity Relationship Diagram (ERD) 100 100
5 table minimum
Each table must have a relationship
Proper primary and foreign keys
3NF normalization or justified
Naming convention/descriptions

SQL CREATE Statements 60 60
Mirrors ERD
PK/FKs implemented as designed
Proper create table statements
Proper drop table statements

SQL INSERT Statements 50 50
Proper insert statements
5 records in each table

SQL SELECT Statements 50 50
5 select statements
Each select includes multiple tables
Each table included in sql
Min aggregate functions
WHERE/ORDER BY
Join clause used
Tota
Submitted: 1 year ago.
Category: Writing Homework
Expert:  Carla replied 1 year ago.
Hello


I can help you with this assignment but because it will take probably a full day to complete, I will submit a new fair price for this question.

You will receive an email and if you agree, you can adjust the question price.


Thank you
Customer: replied 1 year ago.
Ok and if I can also get screenshots and and the codes included.

Thank you
Expert:  Carla replied 1 year ago.
Sure, I can also include the screenshots and the SQL code.
Customer: replied 1 year ago.
Thank you.
Expert:  Carla replied 1 year ago.
You should have the email now with the new suggested price.

Thank you
Customer: replied 1 year ago.
I have not seen ityet.
Expert:  Carla replied 1 year ago.
Please check your spam or junk folder as well.
If it's not there, you should get an email soon.
Customer: replied 1 year ago.
I checked my folders and spam folder, it was not received.
Expert:  Carla replied 1 year ago.
Okay. Please wait a few more minutes. I will try to send it again.
Customer: replied 1 year ago.
Ok
Customer: replied 1 year ago.

I'm sorry that particular email did not post and I check the spam folder also.

Expert:  Carla replied 1 year ago.
I have informed our system administrations. I will let you know.
Customer: replied 1 year ago.
Ok thank you
Expert:  Carla replied 1 year ago.
I will let you know.

Thanks
Customer: replied 1 year ago.

My account does show that I was already charged for the 60 for the assignment.

Expert:  Carla replied 1 year ago.
That is only a deposit that JustAnswer holds until you rate my answer.

It can be refunded if you no longer need help with this question.

Customer: replied 1 year ago.

oh ok.

Expert:  Carla replied 1 year ago.
I will let you know when I have heard back from our system admins.

In the meantime please only reply if necessary otherwise you will block me from answering other questions on the website. :)


Thank you
Customer: replied 1 year ago.

If I dont see the email do I need to redo the question and put the pricing you want back in there again?

Customer: replied 1 year ago.
Relist: Incomplete answer.
Have not received answer yet

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Steve Herrod

    Master's Degree

    Satisfied Customers:

    651
    Masters in Literature and a Bachelors Degree in French with Management
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Master's Degree

    Satisfied Customers:

    651
    Masters in Literature and a Bachelors Degree in French with Management
  • http://ww2.justanswer.com/uploads/VE/verbsrule/2013-3-25_232622_MamaandEllie.64x64.jpg verbsrule's Avatar

    verbsrule

    Bachelor's Degree

    Satisfied Customers:

    439
    8 yrs teaching experience in English and history. Writing consultant.
  • http://ww2.justanswer.com/uploads/GY/gypsydust1/2012-3-31_71657_me3a.64x64.jpg DXJ Writer's Avatar

    DXJ Writer

    Master's Degree

    Satisfied Customers:

    350
    Research writer, educator, tutor with 20+ years experience.
  • http://ww2.justanswer.com/uploads/ST/stayathomemomof2/2012-3-20_152711_cameracleanup362012653.64x64.JPG stayathomemomof2's Avatar

    stayathomemomof2

    Bachelor's Degree

    Satisfied Customers:

    214
    Freelance writer.
  • http://ww2.justanswer.com/uploads/ED/educatortech/2012-6-7_1256_williams4.64x64.jpg Mr. Gregory White's Avatar

    Mr. Gregory White

    Master's Degree

    Satisfied Customers:

    176
    M.A., M.S. Education / Educational Administration
  • http://ww2.justanswer.com/uploads/JU/judybailey61/2012-6-23_23846_Resized.64x64.jpg judybailey61's Avatar

    judybailey61

    Bachelor's Degree

    Satisfied Customers:

    167
    Two years writing expert with justanswer.
  • http://ww2.justanswer.com/uploads/MB/MBJC11/2012-6-6_171228_1837551861548780869311000007725919373587357549561n.64x64.jpg Eric M.'s Avatar

    Eric M.

    Master's Degree

    Satisfied Customers:

    148
    Five years in academia, over a dozen peer-reviewed publications, multiple best paper awards, working toward PhD.
 
 
 

Related Writing Homework Questions