Hospital Billing System Erd

HOSPITAL BILLING SYSTEM [pic] TASKS 1. frame Patient and Patient method of accounting tables. Please bear in mind that you will be addition each toldy tested for deciding on sensible information types and field sizes. (Assuming that all other tables are already created). 2. (a) Create a sequence for Patients ID which should start from speed of light0, should extend in steps of 1, and should not exceed the value 99999. (b) get into a sensible record in Patients table by using the sequence created in (a) in spite of appearance an anonymous pig out. 3. Using PL/SQL structure, disposition the call off of Insurance company in which the affected role Eric Forrester is registered as a policy holder. 4. compose an anonymous hamper that will increase the fees of all the procedures by a given percentage. This value should be entered from the keyboard. 5. List the patients names along with names of the patients 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 control 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 follow that should list the fundamental 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 controls that the Patients 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 patients name should be provided from the keyboard. 10. List the patients names along with names of the patients physicians, but list only those physicians... If you want to get a full essay, beau monde it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper