Assignment 2 – Normalization and ERDs

Assignment 2 – Normalization and ERDs (25pts)

Assignment 2 – Normalization and ERDs

Using the following table please create an ERD in Crow’s Foot notation that is in 3NF.

Attribute Name

Sample Value

Sample Value

Sample Value

Sample Value

CHAR_TRIP

10232

10233

10234

10235

CHAR_DATE

15-Jan-2018

15-Jan-2018

16-Jan-2018

17-Jan-2018

CHAR_CITY

STL

MIA

TYS

ATL

CHAR_MILES

580

1,290

524

768

CUST_NUM

784

231

544

784

CUST_LNAME

Brown

Hanson

Bryana

Brown

CHAR_PAX

5

12

2

5

CHAR_CARGO

235 lbs.

18,940 lbs.

348 lbs.

155 lbs.

PILOT

Melton

Chen

Henderson

Melton

COPILOT

 

Henderson

Melton

 

FLT_ENGINEER

 

O’Shaski

 

 

LOAD_MASTER

 

Benkasi

 

 

AC_NUMBER

1234Q

3456Y

1234Q

2256W

MODEL_CODE

PA31-350

CV-580

PA31-350

PA31-350

MODEL_SEATS

10

38

10

10

MODEL_CHG_MILE

$2.79

$23.36

$2.79

$2.79

 

Please create the ERD using draw.io

Hint: You will need a CREW table that links to an EMPLOYEE table.

Also, there is a difference between an AIRCRAFT and an aircraft MODEL

 

Exemplary (5pts)

Very Good (3pts)

Needs Improvement (1pt)

Novice (0pt)

Score

Schema

Schema in 3NF

Schema in 2NF

Schema in 1NF

No Normalization Implemented

      /5

Primary Keys

PKs Defined Correctly

PKs Defined Mostly Correctly

PKs Defined Somewhat Correctly

PKs Not Defined

      /5

Foreign Keys

FKs Defined Correctly

FKs Defined Mostly Correctly

FKs Defined Somewhat Correctly

FKs Not Defined

      /5

Relationships

Relationships Correct

Relationships Mostly Correct

Relationships Somewhat Correct

Relationships Not Defined

      /5

Attributes

Attributes Defined Correctly

Attributes Defined Mostly Correctly

Attributes Defined Somewhat Correctly

Attributes Not Defined

      /5

ADDITIONAL INSTRUCTIONS FOR THE CLASS

Who we are

We are a professional custom writing website. If you have searched for a question and bumped into our website just know you are in the right place to get help with your coursework.

Do you handle any type of coursework?

Yes. We have posted our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill out our Order Form. Filling the order form correctly will assist our team in referencing, specifications, and future communication.

Is it hard to Place an Order?

  • 1. Click on “Order Now” on the main Menu and a new page will appear with an order form to be filled.
  • 2. Fill in your paper’s requirements in the “PAPER INFORMATION” section and the system will calculate your order price/cost.
  • 3. Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • 4. Click “FINAL STEP” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • 5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

SCORE A+ WITH HELP FROM OUR PROFESSIONAL WRITERS – Assignment 2 – Normalization and ERDs

We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium. Assignment 2 – Normalization and ERDs

  • Discussion Questions (DQ)

Initial responses to the DQ should address all components of the questions asked, including a minimum of one scholarly source, and be at least 250 words. Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source. One or two-sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words. I encourage you to incorporate the readings from the week (as applicable) into your responses. Assignment 2 – Normalization and ERDs

  • Weekly Participation

Your initial responses to the mandatory DQ do not count toward participation and are graded separately. In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies. Participation posts do not require a scholarly source/citation (unless you cite someone else’s work). Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week. Assignment 2 – Normalization and ERDs

  • APA Format and Writing Quality

Familiarize yourself with the APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in Loud-cloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required). Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation. I highly recommend using the APA Publication Manual, 6th edition.

  • Use of Direct Quotes

I discourage over-utilization of direct quotes in DQs and assignments at the Master’s level and deduct points accordingly. As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content. It is best to paraphrase content and cite your source. Assignment 2 – Normalization and ERDs

  • LopesWrite Policy

For assignments that need to be submitted to Lopes Write, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me. Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes. Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own? Visit the Writing Center in the Student Success Center, under the Resources tab in Loud-cloud for tips on improving your paper and SI score.

  • Late Policy

The university’s policy on late assignments is a 10% penalty PER DAY LATE. This also applies to late DQ replies. Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances. If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect. I do not accept assignments that are two or more weeks late unless we have worked out an extension. As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading.

  • Communication

Communication is so very important. There are multiple ways to communicate with me: Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class. Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours.

  • GuaranteeAssignment 2 – Normalization and ERDs

  • Zero Plagiarism
  • On-time delivery
  • A-Grade Papers
  • Free Revision
  • 24/7 Support
  • 100% Confidentiality
  • Professional Writers

  • Services Offered

  • Custom paper writing
  • Question and answers
  • Essay paper writing
  • Editing and proofreading
  • Plagiarism removal services
  • Multiple answer questions

SCORE A+ WITH HELP FROM OUR PROFESSIONAL WRITERS

We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium.

Looking for a Similar Assignment? Order a custom-written, plagiarism-free paper

NEED HELP WITH YOUR NURSING ASSIGNMENTS ?

We are dedicated to delivering high quality nursing papers that adhere to the provided instructions, are adequately referenced with the latest scholarly knowledge,

Timely Delivery

Respecting your time and needs, we complete and deliver your orders within the specified timeframe.

Highly skilled writers

We employ experienced and qualified PhD and MD writers able to deal with any types of academic papers

100% unique content

Thorough research and the best academic writing practices ensure complete originality and high quality of every paper we deliver.

Order Now