Examine the Relational Schema below.  Translate the relational schema into a schema that is normalized into first normal form and second normal form.

Model (id, name, manufact, range)

Aircraft (id, c_cap, p_cap, p_date,id_FK)

CrewMember (id, type, milesFlown)

Employee (id, name, s_Date)

Charter (id, email)

Customer (name, start, email) 

Answer rating: 100% (QA)

To normalize the given relational schema into the First Normal Form 1NF and the Second Normal Form 2NF we first need to understand the functional depe... View the full answer