Topic: Database Creation, ER Diagrams, * Hospital Automation Design a database for a hospital automation. In the system of the hospital, the doctor, the patient, Information such as appointment, treatment applied are kept. Information such as appointment, treatment applied are kept. Things to be done in the homework regardless of the subject of the model: 1) Create the tables and show the relationship between them with an ER diagram. Crow's ER diagrams Show with foot notation. Use Draw.io to create the diagram Table 1: Example of ER Diagram 2) Create the tables with SQL commands and add 3 sample records to each table. 3) Describe the database you designed with a report: - Why you are defining each table and what significance it has to your model please explain. - Explain why and how you chose primary key/foreign keys for which tables. - Explain the general working structure of your model. 4) The procedure that performs the necessary actions in the database when a patient makes an appointment write. 5) Function that returns how many patients a doctor has examined on a desired date write. 6) Write down the procedure showing the test results of the patients. 7) Average annual earnings of doctors over the fees they receive per surgery Write the finder function. NOT: Things to be done in the homework regardless of the subject of the model: 1) Create the functions and procedures explained in the table above with SQL. 2) Use the database you created before for the functions and procedures you will write. There may be situations where you need to change. With the reasons for each change you make. specify in your report. Show the final version of your database with an ER diagram. (ER Show diagrams with Crow's Foot notation. Draw.io to create the diagram use it.) 8) Trigger that performs the necessary actions in the database when a patient makes an appointment write. 9) Rollback if a patient has another appointment on the same date when he makes an appointment write the transaction. NOT: Things to be done in the homework regardless of the subject of the model: 1) Create the triggers and transactions, whose explanations are given in the table above, with SQL. 2) The database you created before for the triggers and transactions you will write. There may be situations where you need to change. With the reasons for each change you make. specify in your report. Show the final version of your database with an ER diagram. (ER Show diagrams with Crow's Foot notation. Draw.io to create the diagram use it.) - The work to be done - Your report - Your ER Diagram - SQL code where you create the tables - SQL code where you create functions and procedures - Prepare a report for the assignment. What your report should include: - A brief summary of your database design. - If you made changes to your initial model, why and how did you make these changes? did you do? 2 - Include your ER diagram in your report. - Provide information about functions and procedures. What are the differences, in what cases Explain with examples in which cases the function is used as a procedure. - Give a brief description of the functions and procedures you have created. - Give information about the concept of transaction. Why it is used, its features, advantages and What are the disadvantages, explain how Transaction management is done with examples. Topic: Database Creation, ER Diagrams, * Hospital Automation Design a database for a hospital automation. In the system of the hospital, the doctor, the patient, Information such as appointment, treatment applied are kept. Information such as appointment, treatment applied are kept. Things to be done in the homework regardless of the subject of the model: 1) Create the tables and show the relationship between them with an ER diagram. Crow's ER diagrams Show with foot notation. Use Draw.io to create the diagram Table 1: Example of ER Diagram 2) Create the tables with SQL commands and add 3 sample records to each table. 3) Describe the database you designed with a report: - Why you are defining each table and what significance it has to your model please explain. - Explain why and how you chose primary key/foreign keys for which tables. - Explain the general working structure of your model. 4) The procedure that performs the necessary actions in the database when a patient makes an appointment write. 5) Function that returns how many patients a doctor has examined on a desired date write. 6) Write down the procedure showing the test results of the patients. 7) Average annual earnings of doctors over the fees they receive per surgery Write the finder function. NOT: Things to be done in the homework regardless of the subject of the model: 1) Create the functions and procedures explained in the table above with SQL. 2) Use the database you created before for the functions and procedures you will write. There may be situations where you need to change. With the reasons for each change you make. specify in your report. Show the final version of your database with an ER diagram. (ER Show diagrams with Crow's Foot notation. Draw.io to create the diagram use it.) 8) Trigger that performs the necessary actions in the database when a patient makes an appointment write. 9) Rollback if a patient has another appointment on the same date when he makes an appointment write the transaction. NOT: Things to be done in the homework regardless of the subject of the model: 1) Create the triggers and transactions, whose explanations are given in the table above, with SQL. 2) The database you created before for the triggers and transactions you will write. There may be situations where you need to change. With the reasons for each change you make. specify in your report. Show the final version of your database with an ER diagram. (ER Show diagrams with Crow's Foot notation. Draw.io to create the diagram use it.) - The work to be done - Your report - Your ER Diagram - SQL code where you create the tables - SQL code where you create functions and procedures - Prepare a report for the assignment. What your report should include: - A brief summary of your database design. - If you made changes to your initial model, why and how did you make these changes? did you do? 2 - Include your ER diagram in your report. - Provide information about functions and procedures. What are the differences, in what cases Explain with examples in which cases the function is used as a procedure. - Give a brief description of the functions and procedures you have created. - Give information about the concept of transaction. Why it is used, its features, advantages and What are the disadvantages, explain how Transaction management is done with examples
