Please answer the following five questions using the provided materials (materials are either included in this document or are linked on the Blackboard course website for this module). This is an individual assignment, and as such please submit your own work. Submit your answers as a Word [.doc doc) file to the Blackboard course website by the due date listed in the course schedule spreadshert program). This dataset contains data about manufacturing work arders for producing specific products for a company Generally, when assessing table structure, you wil want to examine the attributes (columns) and daa values to gauee what the potential entities are and how they might be related. You will aso determine which of the attributes might act as keys, or whether you need to use surrogate krys to uniquely identiy mstances of entities. Additionally, look for repeat values that men suggest where data dpiated and thus data redundancy (and the possilbility for modification anomalies) s an issue, and hence where normalization principles would apply. A correctly-specified the duplication of data For questions 1-2, please use the logical entity-relationship (ER) model in Fipure 1 to answer the questions model will attempt to reduce inot elminate) Figure 1. Bank Accounts ER Model 3. Create a logical ER model (using o, etc.) of the dataset based on modeling and normalization principles taught in the prior and/ or current readings and video. In this model, you will need to eate the eroties, attritutes (both key and non-ket and correctysperhed relationships between entities 4. Using the model you created in Question 4 as a reference, create a physicel tR model (using Lucidchart, draw io, etc) that includes MySQL data types for each attribune province For question 5, please use the ER model in Figure 2 to answer the question Figure 2. Book Authors ER Model Accounes Tran Types PK auth id short bo year rhat is based on the model above hat rescives the many-to-many relationship 1. What would need to change in the tove model if the bank that uses this model) wanted to elso differentiate betwreen model (using lasieshatt draw io, etc.) that is besed on the model above that suggested changes. accounc types iee. cheoine savings, etcaf Ceae calER aliso indludes your 2 using the model you created in Question 1 as a reference. create a physical ER model (lusing Lucidcbert, draw io, etc i that includes MySQL data types for each attribute For questions 3-4, you will use the Moqule 03 LE Dotoset.cou file inked on the Blackboard course website (this file is a comma-separated values fie. and can be opened in Excel or some othier