Wrong/copied answers will be flagged
Use MySQL Workbench to answer the following. Provide screenshots mainly.
READ THE SPECIFICATIONS
1. Use the MySQL Workbench to create an ER model with the specifications below. Make reasonable assumptions and adjustments to fit the specifications as much as possible but be sure to state and describe these. After, use the Forward Engineering function for the model into a set of relations (Crow's foot notation). Finally, include screenshots from the workbench and the database. Show all tables (using a screenshot) without their details and then for each one list the details in terms of attributes and keys Z Your identifying (key) attributes in your model and the primary keys in your tables must be such that their names end with '22' (e.g.: a Department has an attribute 'employeenumber' which is a primary key. Employee numbers would have to end in '22'. e.g.: 135919022. 1035100022. 99922. etc. 3 Create at least 3 random values for each attribute and recall that prmary key values have to end with '22' 4 Include the auto-generated script from the Forward Engineering function as a part of your answer. Specifications . Patents make many appointments in a clinic, where one appointment is between one patient and one doctor on a particular date and time. If a patient does not show up, it is must be recorded. If a patient keeps her/his appointment (ic., if a patient shows up), the doctor examines the patient and records the problem, diagnosis, and treatment by recording their corresponding codes (i.c., it is assumed that there is a standardized coding scheme for each of the problem, diagnosis, and treatment). Each patient visit results in a bill. The bill specifies the patient and the doctor. It also includes the problem, diagnosis, and treatment codes that are used to determine how much is being charged for each. The total bill is the sum of the charges as determined by the three codes-and then adding the clinic's overhead of X%. If the patient has insurance, then the bill is submitted by the clinic as a claim to the insurance company; otherwise the clinic bills the patient directly. The clinic receives, from the insurance company, information on how much the insurance company payed out for each of the problem, diagnosis, and treatment codes. Of course, the patient has to pay any amount not covered by the insurance . . . When a patient makes a payment, he/she specifies how much of the amount is to be applied to which bill. Of course, a patient makes many payments and may make a number of payments on one bill Minimal information kept on Patient: patient number, first and last names, phone number, id number of the patient's (one) insurance company (if the patient has a plan with an insurance company) Doctor: doctor ID number, first and last name, phone number Bill/invoice: invoice/bill number, date issued, date of visit,.. o o o 1. Use the MySQL Workbench to create an ER model with the specifications below. Make reasonable assumptions and adjustments to fit the specifications as much as possible but be sure to state and describe these. After, use the Forward Engineering function for the model into a set of relations (Crow's foot notation). Finally, include screenshots from the workbench and the database. Show all tables (using a screenshot) without their details and then for each one list the details in terms of attributes and keys Z Your identifying (key) attributes in your model and the primary keys in your tables must be such that their names end with '22' (e.g.: a Department has an attribute 'employeenumber' which is a primary key. Employee numbers would have to end in '22'. e.g.: 135919022. 1035100022. 99922. etc. 3 Create at least 3 random values for each attribute and recall that prmary key values have to end with '22' 4 Include the auto-generated script from the Forward Engineering function as a part of your answer. Specifications . Patents make many appointments in a clinic, where one appointment is between one patient and one doctor on a particular date and time. If a patient does not show up, it is must be recorded. If a patient keeps her/his appointment (ic., if a patient shows up), the doctor examines the patient and records the problem, diagnosis, and treatment by recording their corresponding codes (i.c., it is assumed that there is a standardized coding scheme for each of the problem, diagnosis, and treatment). Each patient visit results in a bill. The bill specifies the patient and the doctor. It also includes the problem, diagnosis, and treatment codes that are used to determine how much is being charged for each. The total bill is the sum of the charges as determined by the three codes-and then adding the clinic's overhead of X%. If the patient has insurance, then the bill is submitted by the clinic as a claim to the insurance company; otherwise the clinic bills the patient directly. The clinic receives, from the insurance company, information on how much the insurance company payed out for each of the problem, diagnosis, and treatment codes. Of course, the patient has to pay any amount not covered by the insurance . . . When a patient makes a payment, he/she specifies how much of the amount is to be applied to which bill. Of course, a patient makes many payments and may make a number of payments on one bill Minimal information kept on Patient: patient number, first and last names, phone number, id number of the patient's (one) insurance company (if the patient has a plan with an insurance company) Doctor: doctor ID number, first and last name, phone number Bill/invoice: invoice/bill number, date issued, date of visit,.. o o o
