[Solved]Create Er Diagram Tables Mysql Workbench Following Entities Access Rules Table Field Name Q37180955

Create an ER diagram and tables in MySQL workbench for the following entities Access Rules table Field Name Description ex: Analyst, Administrator, ets Ealies time of the day access is allowed , ex: 08:00:00 Latest time of the day access is allowed , ex: 17:00:00 ex: Element, Table, Node, Cluster, ex: Select, Append, ets Role Allowed Start time Allowed End time Component Request type Model table Field Name Description Time of day of the transaction, ex: 18:00:00 ex: Tom, Harvinder, Sally, User A, ets ex: Analyst, Administrator, Business, etc ex: Element, Table, Node, Cluster, etc ex: Select, Append, e ex: Non-Normal Time, No Authorization, e ex: True or False Requestor Role Component Request type Violation type Score Discrepancies table Field Name Description Time of day of the transaction, ex: 18:00:00 ex: Tom, Harvinder, Sally, User A, ets ex: Analyst, Administrator, Business, etg ex: Element, Table, Node, Cluster, etc ex: Select, Append, e ex: Non-Normal Time, No Authorization, ets ex: True or False Time Requestor Role Component Request type Violation type Score Background information: The tables will be utilized operationally by a program that will use the following logic: For each row in the Model table with a score of TRUE For each row in the Access Rules table Compare pertinent columns in the Model table to their equivalent columns in the Access Rules table If the values are valid, continue with the next row in the Access Rules table else If the values are not valid, insert a row in the Discrepancies table with the values of the Model table Show transcribed image text Create an ER diagram and tables in MySQL workbench for the following entities Access Rules table Field Name Description ex: Analyst, Administrator, ets Ealies time of the day access is allowed , ex: 08:00:00 Latest time of the day access is allowed , ex: 17:00:00 ex: Element, Table, Node, Cluster, ex: Select, Append, ets Role Allowed Start time Allowed End time Component Request type Model table Field Name Description Time of day of the transaction, ex: 18:00:00 ex: Tom, Harvinder, Sally, User A, ets ex: Analyst, Administrator, Business, etc ex: Element, Table, Node, Cluster, etc ex: Select, Append, e ex: Non-Normal Time, No Authorization, e ex: True or False Requestor Role Component Request type Violation type Score Discrepancies table Field Name Description Time of day of the transaction, ex: 18:00:00 ex: Tom, Harvinder, Sally, User A, ets ex: Analyst, Administrator, Business, etg ex: Element, Table, Node, Cluster, etc ex: Select, Append, e ex: Non-Normal Time, No Authorization, ets ex: True or False Time Requestor Role Component Request type Violation type Score Background information: The tables will be utilized operationally by a program that will use the following logic: For each row in the Model table with a score of TRUE For each row in the Access Rules table Compare pertinent columns in the Model table to their equivalent columns in the Access Rules table If the values are valid, continue with the next row in the Access Rules table else If the values are not valid, insert a row in the Discrepancies table with the values of the Model table

Expert Answer

---

Answer to Create an ER diagram and tables in MySQL workbench for the following entities Access Rules table Field Name Description … . . .