Question 1 18 pts Please write pseudo-code to read all time cards, process them, and then output Total_Regular_Hours and Total_Overtime_Hours for the worker. Each time card has Time_In (09:00 for example and Time Out (17:00 for example). If the worker worked more than 8 hours for a day, any hours over 8 must be treated as overtime hours for that day, (Time Out - Time_In) would be the number of hours the worker worked for that day. The worker may have many time cards to be read and processed. Edit View Insert Format Tools Table : 12ptParagraph BI UN ALTYD MacBook Air 11 20 DO DOO FE 15 F2 # 3 $ 4 % 5 & 7 0 6 8 9 0 U Y T R V E H c K K Amazon App Strea.. o Mail-Arcelia Nav... LA COUNT 365 Login . Access Panel Appl. RPOSD - WebGra... VULIURE (1) Explain primary key (PK) and foreign key (FK) of a table or relation. (2) What may be the relationshipis) from PK to FK: 1-to-1, 1-to-many, many-to-one, or many-to- many, or some combinations? (3) Please show the primary keyls) and foreign key(s) in STUDENT table, COURSE table, and TAKE table. Please note that a student can take many courses, and a course can be taken by many students. Please design this database (which has 3 tables as shown above) by showing some columns (including their PK and FKs if any) for each table. Edit View Insert Format Tools Table 12De Paragraph BIVA e pour avou 1 words 20 DOO * 25 FT * $ 4. 3 % 5 & 7 6 8 9 0