Create the relational diagram for this database.
Answer to relevant QuestionsFor 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 either employee ...Suppose you are working within the framework of the conceptual model in Figure Q4.5.a. Write the business rules that are reflected in it.b. Identify all of the cardinalities.Write the ten cardinalities that are appropriate for this ERD.Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not carry any ...
Post your question