Custom «Alexamara Marine Group Case Database Management» Essay Paper Sample

Alexamara Marine Group Case Database Management

Normalization

Normalization defines simple rules that ensure that a database is structured in the best way possible. it ensures that no data is unnecessarily  duplicated .This means that no data is held in no more than one table. This is called duplication anomalies.

Buy Alexamara Marine Group Case Database Management essay paper online

Title of your paper

Type of assignment

Academic level

Urgency

Spacing

Pages

Currency

Total price:

 

* Final order price might be slightly different depending on the current exchange rate of chosen payment system.

The most important thing about normalization is that it allows the user to perform all types of queries which out errors.

1st Normal Formal Form

(CategoryNum ,   Category Description  ServiceID , SlipID, Description,  CategoryNum,  Staus, EstHours ,SpentHours ,NextServiceDate).

This is table in the first normal form. It has already been normalized from the 0nf because it has a primary key(Date, 2006). The table is in the first normal form (NF1) because it contains no repeating attributes or group of attributes.

Want an expert write a paper for you?

 
Talk to an operator now!

2nd Normal Formal Form

(CategoryNum ,CategoryDescription  ServiceID , SlipID, CategoryNum,  Status, EstHours ,SpentHours ,NextServiceDate).

This table is in second normal form because it is in first normal form and has no partial key dependency. It also means that there is no column that is not part of a primary key is dependent on only portion of the primary key.

 Functional dependencies in Marina (Marina Num, Name, (Slip Num, Length, Rental Fee, Boat Name))

The functional dependencies are one is to many because marina can have many slips

Hurry up! Limited time offer

Get

19%OFF

Use discount code

0
0
days
:
0
0
hours
:
0
0
minutes
:
0
0
seconds
Order now

Marina Slip (Slip ID, Marina Num, Slip Num, Length, Rental Fee, Boat Name, Boat Type, Owner Num, Last Name, First Name)

To convert this to third normal form one need to test non key dependency .A table in 3NF optimizes the way of holding data with no attributes  being duplicated anywhere.

Most popular orders

PrimeWritings.com Testimonials

We provide excellent custom writing service

Our team will make your paper up to your expectations so that you will come back to buy from us again.

Place your order now
 
Happy Independence Day!
get 18% OFF
discount code: USA2020
X
Online - please click here to chat