Overview:

Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed to protect the data and make the database more flexible by eliminating redundancy and inconsistent dependency. Lab $3$ will have you work with the normalization of database tables.

Instructions:

Given the sample records in the CHARTER table shown in Table $3\mathrm{.}1,$ do the following:

Table $3\mathrm{.}1.$ Sample CHARTER Records

$\backslash$table$[[$Attribute Name,$\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]]],[$CHAR$\_$TRIP,$10232,10233,10234,10235],[$CHAR$\_$DATE,$\backslash$table$[[15-$Jan$-],[2018]],15-$Jan$-2018,16-$Jan$-2018,\backslash$table$[[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,$235lbs,18,940$ lbs$.,348lbs.,155lbs.],[$PILOT$,$Melton,Chen,Henderson,Melton$],[$COPILOT$,,$Henderson,Melton,$],[$FLT$\_$ENGINEER,,O'Shaski,,$],[$LOAD$\_$MASTER,,Benkasi,,$],[$AC$\_$NUMBER,$1234Q,3456Y,1234Q,2256W$