Question: answer the following questions? recommand Database Example SUPPLIER 8261 Supplier Number Supplier_Name Supplier_Street Supplier_city Supplier_State Supplier Zip 259 CEMI Dayton OH BR Mots 1277 Gandoy

answer the following questions?

recommand Database Example SUPPLIER 8261 Supplier Number Supplier_Name Supplier_Street Supplier_city Supplier_State Supplier Zip 259 CEMI Dayton OH BR Mots 1277 Gandoy Sermet Cleveland 49345 253 Jackson Components 8233 Micker Street Lexington KY 56723 3444 Bryant Corporation 4315 M Drive Rochester NY PART 8444 Part_Number Part_Name Unit_Price Supplier_Number 137 Door latch 22.00 8259 145 | Side mirror 12.00 150 Door molding 6.00 8263 152 Door lock 31.00 8259 155 Compressor 54.00 8261 178 | Door handle 10.00 8259 Give example of record. - What is the appropriate data type for the field named "Supplier_Street" Give an example of field that can be set as a primary key Give example of foreign key. Point to the foreign key by arrow -What is the size of filed "Supplier state" - What is entity integrity - What is referential integrity? Example of Relation? Example of field? Urmule

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional basketball team plays. In addition to basketball games,...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

Tho acoounting records of Brigham Foods, Inc., include the following iloms at December 31, 2021: (Click the icon to view the accounting records.) Road the reaultements. Requirement 1. Show how each...

MUST SHOW WORK FOR PROBLEMS 40 - 50 Part A: Multiple Choice (1-16) Using the following information to answer questions 1-8: 2 _____1. a) 1.90 _____2. 1 3 0 1 2 0 5 1 4 What is the mean? b) 2.11 What...

PSYC 354 HOMEWORK 6 Percentiles and Hypothesis Testing with Z-Tests When submitting this file, be sure the filename includes your full name, course and section. Example: HW6_JohnDoe_354B01 Be sure...

Background Forrest runs Y Not Flowers, Inc. (YNF) , a wholesale flower distributor with stores in several major metropolitan areas of the U.S. He is considering expanding his business, but he thinks...

Instructions- December 3 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the November payroll. (Transaction No. 16) December 4 Prepare the payroll using the Time...

please answer problem 2-3 correctly for a thumbs up please answer 1-3 and i will give a thumbs up Problem Ai financial bank you want the state to the contact with her to the bore point 55000 and...

Payroll Project Chapter 7 Textbook is Payroll Accounting 2022 edition December 3 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the November payroll....

Assessment Details Qualification Code/Title ICT50220 Diploma of Information Technology Assessment Type Assessment -01 (Written Questions) Time allowed Due Date Location AHIC Term / Year Unit of...

Demonstrate that the relative permeability and the magnetic susceptibility are related according to Equation 20.7.

How to calculate the units complete and WIP ? Benson Paints provides the following information for the Mixing Department for the month of Septembe (Click the icon to view the information.) Complete a...

AmStore incorporated purchased and placed some of heavy machinery into service this year. AmStore uses straight line method for financial accounting depreciation and immediate expensing for tax cost...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...