3 | Information Systems homework help

Hello, 

I need help with this. Please review thoroughly before accepting the bid. I will be checking for plagiarism!

Thanks 🙂

Part 1:

 Prior to beginning work on this interactive assignment, read chapter 6 of your textbook as well as the Absolute Beginner’s Guide to Database Normalization (Links to an external site.), Database Normalization (Links to an external site.) and Normalization: How far is far enough (Links to an external site.) online resources, and review any relevant information in this week’s lecture.

Normalization is an important step towards translating models and diagrams into relational databases. In this exercise, you will need to normalize the Grade_Report table below and explain the steps needed to do so.

For this assessment, consider the following entity and its attributes and normalize the entity Grade_Report to 3NF.

Entity: Grade_Report (StudentID, StudentName, Phone, DOB, Address, Email_Address, CourseNumber, CourseName, Grade, DepartmentID, DepartmentName)

Explain the steps needed to normalize this entity to 1NF, 2NF and 3NF. List the resultant Normalized entities in the same format as the original Grade_Report.

Once the entity is normalized to 3NF, describe any issues this entity might have that can be solved by normalization. Explain the functional dependencies that exist between the attributes. Provide the steps required to break up the Grade_Report entity into multiple entities that each have a single theme.

minimum of 250 words.

Part 2:

 

The Normalization Process: Converting the ERD

Prior to beginning work on this assignment review Chapter 6 in your textbook, read the Absolute Beginner’s Guide to Database Normalization (Links to an external site.) and Database Normalization (Links to an external site.) online resources, and review any relevant information in this week’s lecture. These sources will be used to support your work in the assignment.

You developed and revised your ERD in Week Two, bringing you one step closer to creating the physical database in the Structured Query Language (SQL) server in your virtual lab environment. However, before doing so, you need to check the conceptual model you created and ensure that it meets the First, Second and Third normal forms.

For this assignment, explain the purpose of the normalization process including a description for each of the five normal forms (1NF, 2NF, 3NF, 4NF, and 5NF) and providing examples for each. Cite the sources for all examples. You will then translate the ERD model you created and revised in Week Two into 3NF.

Within your paper explain how each table in your ERD meets 1NF, 2NF, and 3NF. If the tables do not meet the forms, you need to resolve any issues and normalize the database in order to meet 1NF, 2NF, 3NF. If issues were encountered and had to be resolved, describe the rules that were violated and how you resolved them.

The assignment

  • Must be two pages in length (not including title and references pages) and formatted according to APA style as outlined in the Writing Center (Links to an external site.).
  • Must include a separate title page with the following:
    • Title of paper
    • Student’s name
    • Course name and number
    • Instructor’s name
    • Date submitted
  • Must use at least two professional sources in addition to the course text.
  • Must document all sources in APA style as outlined in the  Writing Center.
  • Must include a separate references page that is formatted according to APA style as outlined in the Writing Center.
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency