Question: Following the text notation used below. Normalize the following charter airline database to 3rd normal form and create them into a ERD . Provide any
Following the text notation used below. Normalize the following charter airline database to 3rd normal form and create them into a ERD . Provide any assumptions (business rules) that you make in normalizing the database. Customer CustFirstName, CustFastName, CustAddress, CustCity, CustState, CustZip, CustPhone Flight FlightNumber, Pilot, PilotName, LicenseNumber, CoPilot, CoPilotName, LicenseNumber, CustomerName, TicketNumber, Destination, FlightTime, FlightDate, PlaneNumber, Model, Capacity, EmployeeThatBookedTheFlight Employee EmpFirstName, EmpLastName, EmpAddress, EmpCity, EmpState, EmpZip, EmpPhone, JobTitle
need it in a 3rd normal form ERD
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
