Login|Contact Us
Question and Answer

Homework

Ask a Homework Question, Get an Answer ASAP!

  • Ask A Question
  • Browse Answers
  • Meet The Experts
  • How JustAnswer Works

Assignment 5: Logical Design, Part IIDue Week 6 and worth

 

Customer Question

Assignment 5: Logical Design, Part II
Due Week 6 and worth 50 points Your E-R Model from a prior week was a success (Assignment 2 – Logical Design, Part I)! Now, your boss wants you to normalize the database to 3NF. However, one of the executives is not convinced that there would be any value in normalizing the database. He thinks that the system would be too “ constrained” and would not permit “flexibility” in entering data. Write a two to three (2-3) page paper in which you: 1. Introduce the concept of normalization in a letter to the executive and explain the pros and cons.
2. Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.
3. Discuss your rationale for normalizing from your E-R Model and demonstrate:
a. How you derived at your 3NF from the earlier assignment
b. The process you took in arriving at your 3NF
c. The three (3) step technique of transforming your data model into first normal form, second normal form, and third normal form
4. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements: • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. The specific course learning outcomes associated with this assignment are: •& nbsp;Recognize the purpose and principles of normalizing a relational database structure.
• Design a relational database so that it is at least in 3NF.
• Use technology and information resources to research issues in database systems.
• Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions. Click here to view the grading rubric for this assignment.

Submitted: 188 days and 13 hours ago.
Category: Homework
Value: $45
Status: CLOSED
Picture
Expert:  jatechexpert replied188 days and 11 hours ago.

hi

thanks for using justAnswer.com

if have any more details, send them

Customer replied188 days and 10 hours ago.

Paper is due by Sunday at 10:00 PM. Outside of that everything is listed above!


Thanks-you

Picture
Expert:  jatechexpert replied188 days and 10 hours ago.

hi

ok i will give it on sunday morning

Customer replied188 days and 10 hours ago.

Thank-you!! Have a good night!


 

Picture
Expert:  jatechexpert replied188 days and 10 hours ago.

hi

ok then see you

Accepted Answer

Picture
Expert:  jatechexpert replied186 days and 23 hours ago.

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.

Expert TypeEngineer
Category: Homework
Pos. Feedback: 96.1 %
Accepts: 84
Answered: 11/18/2012

Experience: I can help you with your home work questions

Ask this Expert a Question >
Customer replied173 days and 21 hours ago.

Hi there,


I received my grade back from the instructor and he gave a 60% due to the tables not being included. I must have over looked them and wondering if you can do those by tomorrow, as he is allowing me till then to submit?


"Assignment 5: Logical Design, Part II
Due Week 6 and worth 50 points Your E-R Model from a prior week was a success (Assignment 2 – Logical Design, Part I)! Now, your boss wants you to normalize the database to 3NF. However, one of the executives is not convinced that there would be any value in normalizing the database. He thinks that the system would be too “ constrained” and would not permit “flexibility” in entering data. Write a two to three (2-3) page paper in which you: 1. Introduce the concept of normalization in a letter to the executive and explain the pros and cons.
2. Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.
3. Discuss your rationale for normalizing from your E-R Model and demonstrate:
a. How you derived at your 3NF from the earlier assignment
b. The process you took in arriving at your 3NF
c. The three (3) step technique of transforming your data model into first normal form, second normal form, and third normal form
4. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements: • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. The specific course learning outcomes associated with this assignment are: •& nbsp;Recognize the purpose and principles of normalizing a relational database structure.
• Design a relational database so that it is at least in 3NF.
• Use technology and information resources to research issues in database systems.
• Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions. Click here to view the grading rubric for this assignment."


His comments were......


Thanks for assignment. Missing display and explanation of prior assignment and going from 1NF to 2NF to 3NF for it. Please resubmit that part by Dec. 2 for additional partial credit.


 

Customer replied173 days and 20 hours ago.

Hi again,


I will include a bonus for your time!


Thanks

Picture
Expert:  jatechexpert replied173 days and 20 hours ago.

hi

when is due this

Customer replied173 days and 20 hours ago.

I have to have it turned in by tomorrow at 5:00 PM. The paper is complete the only thing we missed were the .....



Thanks for assignment. Missing display and explanation of prior assignment and going from 1NF to 2NF to 3NF for it. Please resubmit that part by Dec. 2 for additional partial credit.


 


I included the entire assignment for reference. Is it possible?


Thanks for your time!!

Customer replied173 days and 18 hours ago.

Hello can you do this or shall I ask someone else?? Pleas reply soon!


Thanks

Picture
Expert:  jatechexpert replied173 days and 12 hours ago.

hi

ok i will do this

Customer replied171 days and 22 hours ago.

Never mind it was due yesterday and I completed it!


Thanks

Picture
Expert:  jatechexpert replied171 days and 22 hours ago.

hi

ok, and sorry for the delay

 
Tweet

8 Tutors are Online Right Now

Ask Your Question Now
Homework Questions Date Submitted
Create a text file that contains at least 5 Web-related terms 5/22/2013
For LogicPro only. I am in the process of starting a test in 5/21/2013
Creating JOptionPane boxes 5/21/2013
I have a Psychology assignment due and I need help on it. 5/20/2013
40633000 or 406800 5/20/2013
Hi, I have this physics homework I need help with, can someone 5/20/2013
Wow Your good, ok one more time please 40632900 5/20/2013
Thank you Chris, i sand you exam #40632800 can you help! 5/20/2013
For Teacher Greg ! If Teacher Greg is not available, I have 5/20/2013
exam 40632700 5/19/2013
RSS
Next 10 >
Ask A Tutor
Type Your Homework Question Here...
characters left:

Top Homework Experts

See More Tutors

JustAnswer in the News

Nbc
Washington Post
New York Times
Cnn
Learn More

How It Works

  • Ask an Expert
  • Get a Professional Answer
  • Ask Followup Questions
  • 100% Satisfaction Guarantee
Learn More

Ask a Tutor

Get a Professional Answer. 100% Satisfaction Guaranteed.
188 Tutors are Online Now
Type Your Homework Question Here...
characters left:
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Truste
Contact Us | Terms of Service | Privacy & Security | About Us | Our Network
© 2003-2013 JustAnswer LLC
  • Pearl.com
  • JustAnswer UK
  • JustAnswer Germany
  • JustAnswer Spanish
  • JustAnswer Japan