Given the invoice table with sample data, Please determine an appropriate Key. Then list the Functional Dependencies normalize the relation to BCNF.

Given the sample records in the CHARTER table shown in Table P6.11, do the following:a. Write the relational schema and draw the dependency diagram for the table structure. Make sure that youlabel all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry isbased on round-trip miles, including pickup points. (Hint: Look at the data values to determine the natureof the relationships. For example, note that employee Melton has flown two charter trips as pilot and onetrip as copilot.)b. Decompose the dependency diagram you drew to solve Problem 11a to create table structures that are in3NF and write the relational schema.c. Draw the Crow’s Foot ERD to reflect the properly decomposed dependency diagrams you created inProblem 11b. Make sure the ERD yields a database that can track all of the data shown in Problem 11.Show all entities, relationships, connectivities, optionalities, and cardinalities.

Given the sample records in the CHARTER table shown in Table P6.11, do the following: A. Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry is based on round-trip miles, including pickup points. (Hint: Look at the data values to determine the nature of the relationships. For example, note that employee Melton has flown two charter trips as pilot and one trip as copilot. B. Provide the 3rd Normal Form Tables based on the information in Table P6.11 C. Once you have converted to 3rd Normal form, draw the normalized ER Model

Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise. [Hint: Use multi-step and multi-line queries to ease the formulation of queries. Use the rename operator ρ to give intermediate query results a name (some textbooks use the equivalent ‘←’ notation). Aggregate functions as you can find them defined in some textbooks are not allowed, neither in homework assignments nor in exams.] Student(sID , name, degree: integer, dID) Department(dID , name, address) Lecture(lID , name, degree: integer, pID, dID) Professor(pID , name, dID) Register(rID , sID, lID, Semester, score: integer)   Relational Algebra Queries:   1. Find the names of students who have registered every lecture of CISE department. 2. Find the students who got the highest score in the lecture ‘DB’ in 2021 Fall semester. Show names and scores together. 3. Find the names of students in CISE department who never received a score less than 80. 4. Find the…