Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . Using Table Design view, create and save a new table named Vendors with the following fields: Field 1 : Field Name: VendorID Data

1. Using Table Design view, create and save a new table named Vendors with the following fields: Field 1: Field Name: VendorID Data Type: AutoNumber Primary Key Field 2: Field Name: ContactName Data Type: Short Text Field 3: Field Name: ContactPhone Data Type: Short Text Important note: After adding fields, remember to save your changes to the table.2. Using Database Tools, create the following table relationship: Link the Employees table to the EmployeePhones table, use the EmployeeID attribute. One-to-many relationship: an employee can have many phones, but a phone can only belong to one employee.\deg Enforce Referential Integrity

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

IBM Db2 11 1 Certification Guide Explore Techniques To Master Database Programming And Administration Tasks In IBM Db2

Authors: Mohankumar Saraswatipura ,Robert Collins

1st Edition

1788626915, 978-1788626910

More Books

Students also viewed these Databases questions

Question

What is the role of market makers, and how do they earn profits?

Answered: 1 week ago