Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started