Question Details

[solution] »

Hello.  Can you do this homework for me?  You did the previous one which I've attached. I also at


Description

Answer Download


The Question

Hello.  Can you do this homework for me?  You did the previous one which I've attached. I also attached the Module one instructions because it was the original one which continuously revised in Module 2 and 3.  The third one (CSC316Module4-SLP Assignment Instruction) is one that needs to be done.  Thank you so much.

MUST BE ORIGINAL WORK, NOT COPIED FROM OTHER WORK.

School is using Turintin to check work that are copied from other sources. Thank you.


Running Head: NORMALIZATION 1 Normlization

 

Name:

 

Nstitution: NORMALIZATION

 

1. 2 Normalize the tables from the previous module. Discuss 1NF, 2NF, and 3NF.

 

In a relational database, normalization refers to a process of organizing database columns or attributes and tables which are referred to as relations so as to mainly minimize data

 

redundancy and ensure that data dependencies make sense. It takes a three step process to full

 

remove data redundancy in a relation. Here we are going to analyze the products database and

 

see if all the repeating attributes and data have been fully normalized using the following

 

database normalization processes.

 

First Normal Form (1NF)

 

In this step, all the data items are define which includes organizing the data into columns,

 

looking at the data to be stored, putting related columns into their table and defining what type of

 

data each column contains. Therefore, a relational database is said to be in 1NF if and only if he

 

domain of each attribute contains unique values, and the value of each attribute contains only a

 

single value from that given domain. The database provided attached partially normalized to

 

1NF. Some attributes are not classified to their respective relation. Attached is a fully 1NF

 

normalized form both as a screenshot and a .bak do the backup of the same (Khalil et al. 2013).

 

Second Normal Form (2NF)

 

A table referred to s being in second normal form if both the following conditions hold: The table is in 1NF and,

 

No non-prime attribute is normally based on the proper subset of any candidate key of the

 

table. NORMALIZATION

 

Regarding the tables in Products database the tables are in 2NF since all are in 1NF and

 

the all the columns (attributes) are fully dependent on the candidate key.

 

ThirdNormal Form (3NF)

 

In the third normal form, the attributes must fully depend on the primary key. Hence, for

 

a table that has a foreign key, each column not part of the primary key must be based upon the

 

entire foreign key for its existence. Thus if a column doesn?t depend on the primary key it

 

violates the rules of 3NF. The tables in the Products database are fully dependent on the primary

 

keys. Therefore, they have passed 3NF rules.

 

2. Drop the tables no longer needed, and create those that the new design requires, using SQL in DBMS

 

This is the new database that is fully normalized (Khalil et al. 2013). 3 NORMALIZATION 4 REFERENCES

 

Khalil, O. K., Boudjella, A., & Samir, B. B. (2013). Comparison Between Normalized Databases

 

Implemented With Different Database Systems. In Advanced Materials Research (Vol.

 

774, pp. 1827-1832). Trans Tech Publications.

 


Solution details

Solution #000176251

[solution] »

Hello.  Can you do this homework for me?  You did the previous one which I've attached. I also at.zip

Uploaded by: Tutor

Answer rating:

This paper was answered on 14-Oct-2020

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Oct 14, 2020

EXPERT

Tutor

ANSWER RATING

BEST TUTORS

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

STUCK WITH YOUR PAPER?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now