For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided.
Answer to relevant QuestionsCreate the ERD to show the relationship between EMPLOYEE and JOB.Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.For each table, where possible, identify:a. The primary keyb. A superkeyc. A candidate keyd. The foreign key(s)e. A secondary keyCreate the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by both employee 105 ...What three (often conflicting) database requirements must be addressed in database design?
Post your question