4 Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the data. Attach Screenshots. [3+3+3+1 Marks]

Dr ID	Dr Name	P. No.	P. Name	Date	Time	Sur. No.	Sur. Name
101	Ali	107	Barber	12-10-2018	10:00 am	S1	abc
101	Ali	108	Ahmed	03-10-2018	11:00am	S2	xyz
105	Daud	109	Ghafoor	05-10-2018	10:30 am	S3	abc1
105	Daud	109	Ghafoor	10-10-2018	10:00 am	S3	abc1
135	Zahid	110	Asif	15-10-2018	10:00 am	S2	xyz

(Note: Kindly answer the full question and also according to the given scenario. Most of the Chegg answers are not up to the mark and most experts are not experts at all. They just try to answer quickly without taking care of the quality.

If you don't have in-depth knowledge about the topic then don't answer it.)

This the whole question

Q. No. 4 Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the data. Attach Screenshots. [3+3+3+1 Marks] Dr ID Dr Name P. No. P. Name Date Time Sur. No. Sur. Name 101 Ali 107 Barber 12-10-2018 10:00 am S1 abc 101 Ali 108 Ahmed 03-10-2018 11:00am S2 xyz 105 Daud 109 Ghafoor 05-10-2018 10:30 am S3 abc1 105 Daud 109 Ghafoor 10-10-2018 10:00 am S3 abc1 135 Zahid 110 Asif 15-10-2018 10:00 am S2 xyz R Assignment details Database System (CS-4B) 8. A physician writes one or more orders for a patient. Each order is for a given patient, and a patient may have many orders. Identify entities, attributes, constraints & relationships and draw ERD. [4 Marks] Q. No. 4 Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the data. Attach Screenshots. [3+3+3+1 Marks] Dr Dr P. P. Name Date Time Name No. Sur. Sur. No. Name ID 10:00 101 Ali 12- 107 Barber 10- 2018 S1 abc am 101 Ali 03- 108 Ahmed 10- 2018 11:00am S2 XYZ 10:30 05- 105 Daud 109 Ghafoor 10- 2018 S3 abc1 am 10- 105 Daud 109 Ghafoor 10- 2018 10:00 am S3 abc1 135 Zahid 110 Asif 15- 10- 2018 10:00 am S2 xyZ Q. No. 4 Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the data. Attach Screenshots. [3+3+3+1 Marks] Dr ID Dr Name P. No. P. Name Date Time Sur. No. Sur. Name 101 Ali 107 Barber 12-10-2018 10:00 am S1 abc 101 Ali 108 Ahmed 03-10-2018 11:00am S2 xyz 105 Daud 109 Ghafoor 05-10-2018 10:30 am S3 abc1 105 Daud 109 Ghafoor 10-10-2018 10:00 am S3 abc1 135 Zahid 110 Asif 15-10-2018 10:00 am S2 xyz R Assignment details Database System (CS-4B) 8. A physician writes one or more orders for a patient. Each order is for a given patient, and a patient may have many orders. Identify entities, attributes, constraints & relationships and draw ERD. [4 Marks] Q. No. 4 Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the data. Attach Screenshots. [3+3+3+1 Marks] Dr Dr P. P. Name Date Time Name No. Sur. Sur. No. Name ID 10:00 101 Ali 12- 107 Barber 10- 2018 S1 abc am 101 Ali 03- 108 Ahmed 10- 2018 11:00am S2 XYZ 10:30 05- 105 Daud 109 Ghafoor 10- 2018 S3 abc1 am 10- 105 Daud 109 Ghafoor 10- 2018 10:00 am S3 abc1 135 Zahid 110 Asif 15- 10- 2018 10:00 am S2 xyZ