Question: The diagram was created without specifying data types for the attributes Before we can create the tables in Access , we need to specify both


The diagram was created without specifying data types for the attributes Before we can create the tables in Access , we need to specify both the data type for each attribute and the field length for each that should be set in the Access tables , First set the data type and field size properties for the Supplie able . Because you will create the tables in an Access database , you will use he data types most consistent with Access . You will also be adjusting the field length found in parenthesis immediately after the data type . Click to select he suppliers entity , and in the Columns category set the Data Type properties for each attribute as follows 1 . SUPID TEXTTION SupCompany Name TEXT / 25 ) SupContactName TEXT/ 25 ) SupContact Title TEXTIZE SupAddress TEXT/20 ) Supcity TEXTIZO SupRegion TEXTIION Suppostalcode TEXTIIO ) SupCountry TEXT/ 20 ) 10 . Supphone TEXT IO ) SUPFOX TEXTIIO ) 12 . SupHomePage TEXT/ 25 ) ( See the illustration on the next page . PUDD y ME
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
