Question: Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. Relational diagram CUSTOMER PRODUCT VENDOR PK Cus Code INVOICE PK

Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer.

Relational diagram CUSTOMER PRODUCT VENDOR PK Cus Code INVOICE PK P Code PK V Code Cus_LName PK Inv Number PK,FK1 Inv Number Line Number Cus_FName HOCPK DO-H- P_Descript V_Name Cus_Initial FK 1 Cus_Code P_Code P_InDate Cus_AreaCode Inv_Date FKZ Line_Units P_QOH V_Contact V_AreaCode Cus_Phone Line_Price Cus_Balance P_Price v_Phone P_Discount V_State FK1 V_Code V_Order Table name: CUSTOMER Table name: VENDOR V_CODE V NAME CONTACT V AREACODE V PHONE V_STATE|V_ORDER CUIS_CODE CUS_LAKE CUS_FNAME CUS_NITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE 21 225 Bryson, Inc. Smithson 615 223-3234 10010 Romas 615 844-2573 21 226 SuperLco, he. Flushing 904 215-8995 FL 10011 Durne 713 894-1238 0 00 21251 DE Supply Sigh 615 228-3245 TN 10012 Smith WV 615 894-2285 345 86 KY IN 10013 0low8K Paul 615 894-2180 21 344 Gomez Bros 615 889-2546 901 10014 Orlando Myton 615 222-1672 0 00 22567 Dome Supply Smith 678-1419 GA 10015 O'Brien 713 142-3381 0.00 29119 Randsets Lid. Anderson 678-3993 GA 10016 Brown 615 207-1 228 221.19 24004 Brackman Bros. Browning 615 228-1410 TN 10017 Williams George 615 290-2558 768 .93 24288 CRDVA, Inc. Hakford 615 898-1234 10018 Farriss Arre 302-7105 218.56 25443 BM, hc. Smith 904 227-0093 FL 10019 Smith Olette 815 60OC-167 0.CO 25501 Damal Supplies Smythe 615 890-3529 TN 25585 Rubicon Systems Orton 904 456-0092 FL Table name: INVOICE Table name: LINE Table name: PRODUCT INV NUMBER CUS_CODE INY_DATE INV_NUMBER UNE_NUMBER P_CODE LINE_UNITS LINE_PRICE P_CODE P_DESCRIPT P_INDATE P_OOH P_MIN | P_PRICE |P_DISCOUNT |Y_DOCE 1001 1001 1 13-Q2.P2 14 99 11GER(31 Power painter , 15 pal., 3-nozzle 2 231 09-HB 13-Dec-17 15 21344 1003 10012 16-Jan-18 4 9c 4-91/13 9.00-h. per. saw blade 13-NOY-17 12 17.49 0.00 21344 1004 1002 1003 1548-902 Hrd. cloth, 1/4 in., 2x50 15.Jan-18 15 39.95 0.00 23119 1005 10018 17-Jan-18 273BCPD 1008 10014 17-Jan-18 1003 2 1546-QQ2 39 93 1568-CMV1 H-l. cloth, 10-h., 3.50 15-Jon-18 23 43.90 0.00 23119 1003 3 13-02P2 2232/QTY BED jigsaw, 12-i. blade 30-Dec-17 8 109.92 0.05 24288 1007 154778-2T 6 1 008 1004 3 2 23109-HB 2238/GPD BSD cordless drill, 1/2 in 20-Jan-18 12 38.95 0.05 1004 9 9 25595 PYC2-CRT 12 5 6 231 09-HB Claw hammer 20-Jer-18 23 10 9.95 0.10 1005 231 14-AA Sledge hammer , 12 b 02-Jon-18 8 14.40 005 1008 1 ST4-18277 B O 2 2292JQTY 54770-2T Fat-tal fly, 1.0-n. nine 43 20 0.00 21344 109 92 15-Dec-17 1008 1008 3 23109- HB 80-WIRE-Q Hcut chain saw, 16 in 07-Feb-18 11 256.99 005 PVC23CRT PVC pipe, 3.5-in, 8-fl 20-Feb-18 188 75 5.87 0.00 1008 1 89-VRE Q 256.89 SM-18277 1.25-h. metal screw, 25 01-4.45-18 172 75 6.93 21225 1 007 13-02.P2 14.89 SV/. 23116 2.5.m. wid. screw, 50 24.Feb-18 237 100 0.00 21231 1 007 2 54778-2T 4.89 WR3/TT3 Steel Inatting, 4'x8x16', .5' mesh 17-Jer-18 119.95 0.10 1008 1 PYC23CRT 5 87 1008 2 VIR3/TTS 119.85 1008 3 23109-HB 9.95

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 Mathematics Questions!

Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE BMP LNAME EMP_FNAME EMP_INTIAL EMP DOB STORE CODE 1 Nr. Wiliamson John W 21-May-84 2 MS. Ratula Nancy 09-Feb-89 3 Ns. Greenboro...

Please answer CLEARLY and LEGIBLE from question 5-15. Consider the database model below: The database model FIGURE 7.1 CUSTOMER INVOICE LINE PK INV PK.FK1 |INV NUM?ER PK ?LINE.NUMBER PK CUS CODE...

Homework #3 Due: see Syllabus Total: 20 Points What to submit: Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen...

War W30 Three tables Employee, Store and Region are given in Figure P3.1. Please go through these tables and answer the following questions. (Hint: Each store employs many employees, one of whom...

MIS 3 3 0 6 Database Management Systems Module 3 Exercise 4 0 points Required for Grading: I am ( type your full name ) and I complete this assignment following the UHD academic integrity policy. ( 5...

Lab 2 Database Design Part 1 Use the database shown below to work Problems 1 through 7. Note that the database is composed of four tables and reflects these relationships: A CUSTOMER has only one...

Chapter 3 - Relational Database Model 1. What is the difference between a database and a table? 2. What is attribute domain and give an example. 3. What is a composite key? 4 When does a table...

Use the database shown in Figure 3 to answer Problems 8-11. Table name: TRUCK Primary key: TRUCK_NUM Database name: Ch03_TransCo Foreian kevs: BASE CODE. TYPE CODE Table name: BASE Primary key:...

bog C Page nuse The Database in Fig.X 28930-dt-content-rid-3932686_1/courses/20210114946/Assignment-3_%20CITA340%20-%20Google... 2 / 3 100% + 12 2 Database Comer 3 Tuple Charge 4 Attribute Alley 5...

What is the Laffer Curve? How do supply-siders use it with respect to tax rates?

A random sample is selected from a normal population with a mean of = 100 and a standard deviation of s = 20. After a treatment is administered to the individuals in the sample, the sample mean is...

Multiple Choice Question Which structure controls the movement of substances into and out of the cel O cytoplasm plasma membrane O nucleus O endoplasmic reticulum O golgi apparatus

Julian Birkinshaw, James Manktelow, Vittorio DAmato, Elena Tosca, and Francesca Macchi In recent years, one of the most profound transformations in the workplace has been the increase in age...