Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Law Of Tort

Authors: John Cooke

14th Edition

1292251360, 978-1292251363

More Books

Students also viewed these Law questions

Question

=+Might this help explain why

Answered: 1 week ago

Question

5. Give some examples of hidden knowledge.

Answered: 1 week ago