QUESTION IMAGE
Question
in the database you have built, you need to create a relationship between two fields in two tables. field 1 in table a has the number data type and field 1 in table b has the currency data type. will you be able to build a relationship? no
For a relationship to be established between two fields in different tables in a database, they should have compatible data types. The Number data type and Currency data type are different. Currency data type has specific formatting and precision rules related to monetary values, while Number data type is more general - purpose for numeric values. So, a relationship cannot be created as - is.
Snap & solve any problem in the app
Get step-by-step solutions on Sovi AI
Photo-based solutions with guided steps
Explore more problems and detailed explanations
No