Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).

ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear

Below is a database with 2 tables - Painter, Painting: Painting table: primary key = Painting Num, foreign key = Painter_Num 11 Painting Num Painting_title Painter_Num 1336 Tired peasants 123 1337 Dawn Thunder 111 1338 Plastic Paradise 111 Hasty Exit Vanilla Chocolate 123 1339 134 1340 1341 X-files 123 Painter table: primary key Painter Num, no foreign key Painter Num Painter_lastname Painter_Firstname Painter_Initial Nationality 111 Ross Smithson P British 123 Angela Itero X Italian The above database contains an error in the data. Identify and describe this error.

So if I have this table: staffNo dentistName patientNo patientName appointment_date appointment_time surgery_no S1011 Tony Smith P100 Gillian White 12-Aug-03 10:00 S10 S1011 Tony Smith P105 Jill Bell 13-Aug-03 12:00 S15 S1024 Helen Pearson P108 Ian MacKay 12-Sep-03 10:00 S10 S1024 Helen Pearson P108 Ian MacKay 14-Sep-03 10:00 S10 S1032 Robin Plevin P105 Jill Bell 14-Oct-03 16:30 S15 S1032 Robin Plevin P110 John Walker 15-Oct-03 18:00 S13   Here the non-trivial functional relations include at least the following: staffNo --> dentistName patientNo -->patientName partientNo, appointment_date, appointment_time --> surgery_no Do you believe there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed.How do I draw this out?

1. Table : ASSIGNMENT 2. TABLE: EMPLOYEE E EMPLOYEE E ASSIGNMENT EMP NU . EMP LNAM - EMP FNAM - EMP INITIA - EMP HIREDAT JOB COL - EMP YEAI - 4101 - 102 E 103 ASSIGN_NUM - ASSIGN_DATE. PROJ_NUM . EMP_NUM . ASSIGN_JOB . ASSIGN_CHG_HR - ASSIGN_CHARGE. 295.75 ASSIGN_HOURS News Senior G 08-Nov-00 502 12 Jul-89 501 01-Dec-96 503 John 6. 1001 22-Mar-14 18 103 503 84.50 3.5 David H. 17 1002 22-Mar-14 22 117 509 34 55 4.2 145.11 1003 22-Mar-14 18 117 509 34.55 2.0 69.10 Arbough June E 10 1004 22-Mar 14 18 103 503 84.50 5.9 498.55 - 104 Ramoras Anne K 15-Nov-87 501 19 - 105 + 106 O 107 - 108 Johnson Smithfield Alonzo Washington Alice William 1005 K 01-Feb-93 502 14 22-Mar-14 25 22-Mar-14 22 22 Mar-14 25 108 501 96.75 96.75 22 212.85 406.35 1006 104 501 4.2 22-Jun-04 500 2 1007 113 508 50 75 38 192 85 Maria D 10-Oct-93 500 13 1008 22-Mar-14 18 103 503 84.50 0.9 70.05 Ralph Larry 22-Aug-91 501 18-Jul-97 501 B 15 1009 23-Mar-14 15 115 501 96 75 5.6 541.80 + 109 - 110 - 111 + 112 Smith 9 1010 23…

How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films

In the NONCAT table, change the description of item ID DT12 to Dog Toy Gift Bonanza.

I need C please

ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear