MDFT Pro operates a vehicle fleet management system to coordinate transportation for students attending off-site certification labs and training facilities. The academy maintains detailed vehicle records and tracks vehicle usage through a rental tracking system that records which vehicles are assigned to specific training events and field trips.
Mark, the fleet coordinator at MDFT Pro, has designed a data system where vehicle information is stored in one spreadsheet and vehicle rental assignments are tracked in another. Each vehicle has a unique license plate number that appears in both the vehicle inventory spreadsheet and the rental tracking spreadsheet, allowing the academy to connect vehicle details with their usage history. Claire, a new database administrator, is learning about data relationships and needs to understand how different pieces of information connect across the academy’s data systems.
Is the license plate number a key value in this data model?
Choose the correct answer from the options below.
Explanations for each answer: