please do it asap because i have to submit within a hour thanks

1-On the EMPLOYEE table and the DEPARTMENT table. Identify the columns you consider to be the primary key and foreign key columns. (1 point) EMPLOYEE DEPTNO 40 SALARY $80.000 $ 130,000 $70.000 $90.000 0 20 EMPLOYEE 10 FIRST NAME LAST NAME 230 Kyle Kirsten Sooner 232 Madeline Dimitri Joshua Hunter DEPARTMENT DEPT NO DEPARTMENT NAME 20 Human Resources DO Sie 00 Information Systems 2-How can you Uniquely Identify a table called STUDENT? Give an example. (1 point) non 3-Describe the type of relationship between the PRODUCT and PRODUCT_PRICE. (1 point) Primary key PRODUCT PRODUCT_ID PRODUCT NAME MANUFACTURER 10001 Bolt ACME, Inc 10002 Screw KR MO 10003 Nail ABC, Lid Foreign and Primary Key PRODUCT_PRICE PRODUCT ID RETAIL PRICE IN STOCK QTY 10001 $0.45 10.000 10002 SO 02 20,000 10003 $0.10 50.000 al 4-Write a pseudo script. Identify the Primary Keys and the foreign keys. Write the table's name (UPPER CASE) and its attributes (COLUMN_NAMES). Also, make sure that you identify the primary key and Foreign Key by underlining and using (PK) or (FK). (2 points) Print Layout View 2014 1995 Sec Pages O of 188 Words Normal Text Besfihape parent category id Category name 5-Design the ERD for the four tables bellow. Hint: The Underline represents primary keys. Use Visio, LibreOffice or Google Draw. add relationship connector. (3 points) STUDENT (Customer ID, Name, Address, City, State, Zip, Membership, Phone, Email); 1 CLASSES (Class ID, Class-name Schedule, Instructor ID); PAYMENT METHOD (Pay Method ID, Name on Card, CreditCardNum, Exp date, Security Code); BILLING (Billing ID, Member ID(FK), Amount, Amount date, Pay Method ID(FK)); 191 Words O of 188 Sec 1 Pages Print Layout View