What is the difference between a database and a table?
Answer to relevant QuestionsA database user manual notes that, “The file contains two hundred records, each record containing nine fields.” Use appropriate relational database terminology to “translate” that statement.Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.Create the ERD to show the relationship between EMPLOYEE and JOB.Identify the TRUCK table’s candidate key(s).Create 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 ...
Post your question