object-oriented program that reads a list of Customer objects from a CSV file and

Help please for 1 abc

Identify for each table, the followings: Foreign keys Candidate keys Primary key Alternate keys

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 215 84 2002 215 HS 1991 215 JC 1994 216 B4 1989 216 CDP 2004 216 CNP 2002 216 HS 1985 217 HS 1992 217 JC 2000 218 B4 1990 218 CDP 2000 218 CNP 2005 218 HS 1984 218 M2 1995 TABLE EMPLOYEE EDUCATION Table name: EDUCATION EDU_CODE EDU_DESCRIPTION a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. EMP_EDUC 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma PRIMARY KEY(s) Junior College degree Master's degree FOREIGN KEY(s)

Please solve!

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree

Appendix EMPLOYEE Fnamo Minit Lname Ssn Bdato Addross Ser Salary Super ssn Dno 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 333445555 1955年12月08日 638 Voss, Houston, TX John B Smith Franklin Wong 40000 888665555 25000 987654321 999887777 1968年01月10日 3321 Castlo, Spring, TX Wallaco 987654321 1941年06月20日 201 Borry, Bollaire, TX Alicia Zolaya 4. Jonnifor 43000 888665555 4. Narayan 666884444 1962年09月15日 975 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972年07月31日 5631 Rice, Houston, TX Ramosh K Joyce 25000 333445555 Ahmad V Jabbar 987987987 1969年03月20日 980 Dalas, Houston, TX M 25000 087654321 4. James Borg 888665555 1937年11月10日 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnamo Dnumber Mgr ssn Mgr start date Dnumbor Dlocation Rosearch 333445555 1988年05月22日 Houston Administration 4. 987654321 1995年01月01日 Stafford Headquarters 1. 888665555 1981年06月19日 5. Bellaire 5. Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789...

Manufacturer's Name International Standard Book Number Manufacturer's Code Title and Publisher Date of Distribution 04 PROVIDER Provider оooк Writers' Phone Numbers Authors' Addresses Conie Count City Suburbs – On Sale:

Use the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 S1 C1 114 Sticky Note Fanta Воx 4.3 S3 C1 117 Paper Clips Nizwa Packet .5 S4 C1 111 A4 Paper Double A Ream 2 S1 C2 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Вох 2.2 S3 C2 116 Stapler Small Nizwa Pieces S4 C1 Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; 2 - SELECT product_name FROM products WHERE product_name like "%Ma%' 3 - SELECT price * 2 FROM products WHERE product_id = 111 4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'

Quick Answer please

Customer_ID Customer_Name Order_ID Order_Date Product_Name Quantity 101 Alice 1 2023年09月01日 Laptop 2 101 Alice 1 2023年09月01日 Mouse 1 102 Bob 2 2023年09月02日 Monitor 1 102 Bob 2 2023年09月02日 Keyboard 1 103 Carol 3 2023年09月03日 Laptop 1 103 Carol 3 2023年09月03日 Speaker 2 Create a 3nf model

Please don’t reject this professor

SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345