Please answer all of it, Its for a practice and a needed one. Dont just answer one question please!

Use the following listing to answer questions 17. State any assumptions you make, as needed. Green Gemini (GGC) is a consulting firm that specializes in the automotive manufacturing sector. Green Gemini is the leading expert on automotive supply chain approaches but needs help when it comes to designing databases. Below is a listing that GGC keeps of its different consulting assignments. As a budding database architect, you realize this current single list will break down as the firm grows to more consultants and clients. Your task is to determine a better approach to handling GGC's data needs, using database normalization practices. You will achieve your goal by answering, in order, the seven questions shown below. 1. Assuming that all functional dependencies are apparent in this data, which of the following are true? Highlight the answer row(s). a. Client->AssignmentID b. (AssignmentlD ConsultantName ) (StartDate, ConsultantSalary, Client, ClientNum) c. (AssignmenttD, StartDate) (ConsultantName, ConsultantSalary, Client, ClientNum) d. ConsultantSalary-CoonsultantName e. (ConsultantName, Client) (StartDate, ConsultantSalary, ClientNum) f. ClientNum Client g. (AssignmentlD )( StartDate, Client, ClientNum) h. Consultant Name->ConsultantSalarx i. (StartDate.ConsultantName) (AssignlD, ConsultantSalary, Client, SlientNum) j. (AssignmentLD StartDate ConsultantName) (ConsultantSalary, Client, SlientNum) 2. Assume the listing above represents the ASSIGNMENT entity in its initial form. List all candidate keys for ASSIGNMENT. Restrict your answer to the row(s) you highlighted in #1. 3. Based on your answer to \#2, which candidate key would make the better primary key? List your reasoning. 4. Are any determinants you highlighted in \#1 not a candidate key of the ASSIGNMENT entity? If so, list those determinants / functional dependency/ies, in standard notation. 5. Based on what you determined in questions 3 and 4 , and considering future growth, is it necessary to split the ASSIGNMENT entity into multiple entities? If so, list the themes of all entities. 6. For each theme identified in question \#5, use standard entity/relation notation to describe each entity. Use natural keys only, do not include foreign keys, and assign attributes properly to their theme. 7. Keeping future growth of the firm in mind and ease of use/understanding, consider whether it makes sense to modify any of the natural keys used in \#6 to incorporate the surrogate key concept. If so, what would the new entity / relation structure(s) look like? Use standard entity/relation notation. Identify foreign keys. Hint: If any attribute in an entity (Entity A) is part of a primary key for A and also serves as a foreign key to another entity (Entity B), you would both underline and italicize the attribute in A's notation. List any assumptions