Please help to proved the fully detailly answer(by typed) for all the 5 question blew, thank you so much

Question:

1.

This table is un-normalized form. Convert this table from 1NF to 3NF.

Show your work.

2. What are the 1^st, 2^nd and 3^rd NF?

Pet_id	Pet_Name	PET_Type	Pet_Age	Owner	Visit Date	Procedure
1	Brown	DOG	12	Sam	JAN 13/2002	01 - RABIES VACCINATION
					MAR 27/2002	10 - EXAMINE and TREAT WOUND
					APR 02/2002	05 - HEART WORM TEST
2	Tucker	DOG	2	John	JAN 21/2002	08 - TETANUS VACCINATION
					MAR 10/2002	05 - HEART WORM TEST
3	Maggie	CAT	4	Sam	JAN 23/2001	01 - RABIES VACCINATION
					JAN 13/2002	01 - RABIES VACCINATION
4	Tweety	BIRD	2	John	APR 30/2002	20 - ANNUAL CHECK UP
					APR 30/2002	12 - EYE WASH

3. The following schema is used to register information on repayment of loans.

Repayment(borrower_id, name, address, loanamount, requestdate, repayment_date, repayment_amount)

4. Consider the below table structure that a company uses to keep track of office equipments.

ITEM_ID	ITEM_LABEL	ROOM_NUM	BLD_NUM	BLD_NAME	BLD_MGR
125457	Dell Desktop	224	CDM	College of Digital Media	I.M. Jackson
145287	Dell Laptop	224	CDM	College of Digital Media	I.M. Jackson
175486	Brother Printer	145	LDM	Collge of Law	R.F John

Given the above information

Write the relational schema and identify partial and transitive dependencies if any.

Normalize the schema. Show all your work.

Make the normalization to 3^rd Normal Form. Show your work.

5. Normalize the below data

EMP_NUM	PROF_RANK	EMP_NAME	DEPT_ID	DEPT_NAME	PROF_OFFICE	ADVISEE	COMMITTEE_CODE	JOURNAL_CODE
147587	Professor	John	CDM	College of Digital Media	CDM 642	4578, 1452, 5987, 2360	PROMO, MEDIA, DEV, PROG	ITIM, ITSC, QTS
412547	Adjunct	Mark	CIS	College of Information SyS	CDM 641	1457,4789,3652,2541,8596,7853,9654	DEV	ITIM
234654	Asst. Prof	Mary	CDM	College of Digital Media	CDM 785	2578,7896,5896,5874,5214,5236,3258,3257	TEST,MEDIA	ITSC, QRT
789654	Asst. Prof	Joe	LAW	College of Law	CDM 478	5678.9087,2014,5630,2140	Promo, PROG	QRT

Given the below information

Identify the multivalued, partial and transitive dependencies, if there are any.

Eliminate the dependencies and normalize the data.

Show your work.

our y Rate protect T Project-T project Code rojecTEmployee Employee DepartmenT No. epartment Name Title Name Manager Buudget No. COT ensions NT 24500 S1O0 A Smith L004 System Phillips C010 Pensions C010 PC045 Salaries H Martin17400 ST0010 L Jones ensions 18.5 System Philips ensions System Phillps 24500 S21010 P Lewis 21.00 BJones System System System System System System System 18.00 PC045 Salaries atabase LO08 Salary Richards Gilbert 028 Database ewis PC064HR Lewis 12250 S10034 HR- 16.50- B James