Patient Account Tables
HOSPITAL BILLING SYSTEM
[pic]
TASKS
1. Create Patient and Patient Account tables. Please bear in mind that you will be additionally tested for deciding on sensible data types and field sizes. (Assuming that all other tables are already created).
2. (a) Create a sequence for Patient’s ID which should start from 1000, should increase in steps of 1, and should not exceed the value 99999. (b) Insert a sensible record in Patient’s table by using the sequence created in (a) within an anonymous block.
3. Using PL/SQL structure, list the name of Insurance Company in which the patient ‘Eric Forrester’ is registered as a policy holder.
4. Write an anonymous block that will increase the fees of all the procedures by a given percentage. This value should be entered from the keyboard. …show more content…
List the patient’s names along with names of the patient’s physicians, but list only those physicians whose name begin with ‘K’ & end with ‘M’, and those patients who see dermatologists, psychologists, and ophthalmologists. Ensure that your query contains all these conditions.
6. Create Procedure and Patient Bill tables. Please keep in mind that you will be additionally tested for deciding on sensible data types and field sizes. (Assuming that all other tables are already created).
7. (a) Create a view that should list the basic details of the Patient along with his basic Insurance details. (b) List this view in an anonymous block but showing merely the details of ‘Erin Brokovich’ in a good and understandable format.
8. (a) Add constraints that the Patient’s name should be unique & not null. (b) Add a constraint that Fee should not be less than US$100 and can be null.
9. Write up an anonymous block showing the Patient name and his/her total Fees. The patient’s name should be provided from the
[pic]
TASKS
1. Create Patient and Patient Account tables. Please bear in mind that you will be additionally tested for deciding on sensible data types and field sizes. (Assuming that all other tables are already created).
2. (a) Create a sequence for Patient’s ID which should start from 1000, should increase in steps of 1, and should not exceed the value 99999. (b) Insert a sensible record in Patient’s table by using the sequence created in (a) within an anonymous block.
3. Using PL/SQL structure, list the name of Insurance Company in which the patient ‘Eric Forrester’ is registered as a policy holder.
4. Write an anonymous block that will increase the fees of all the procedures by a given percentage. This value should be entered from the keyboard. …show more content…
List the patient’s names along with names of the patient’s physicians, but list only those physicians whose name begin with ‘K’ & end with ‘M’, and those patients who see dermatologists, psychologists, and ophthalmologists. Ensure that your query contains all these conditions.
6. Create Procedure and Patient Bill tables. Please keep in mind that you will be additionally tested for deciding on sensible data types and field sizes. (Assuming that all other tables are already created).
7. (a) Create a view that should list the basic details of the Patient along with his basic Insurance details. (b) List this view in an anonymous block but showing merely the details of ‘Erin Brokovich’ in a good and understandable format.
8. (a) Add constraints that the Patient’s name should be unique & not null. (b) Add a constraint that Fee should not be less than US$100 and can be null.
9. Write up an anonymous block showing the Patient name and his/her total Fees. The patient’s name should be provided from the