Assignment
In this assignment we will work on the same database as Lab 6 (chapter 7). I uploaded the Query script, if you don't have the Database on your MySql, please run the script and create the database.
You will create word document and answer the following questions. For the Question b, the screenshot of the query is NOT acceptable. After completing the assignment save it as a PDF file and submit it.
OnyxCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project.
Suppose that the company is hired for a new project called "Green Field". Alice Johnson will be the project manager and the value of the project is estimated at $978000. The project will start on 4/20/2020. Beside Alice, three additional employees will be assigned to this project; "John News", "Delbert Joenbrood", "Angie Williamson". The total hours that are needed for this project is 100 hours. You are the manager, so divide this time between these three employees. The project manager should be assigned all 100 hours to manage the project.
I. Which tables will be updated by this transaction? Just Name of the tables.
II. Using SQL, write each database request that is needed to complete the transactions. Write the complete transaction in MySql and run the query. COPY and PASTE the query and SCREEN SHOT the result table.
III. Write the transaction log, using Table 10.1 as your template.
IV. Suppose that the company has another branch in a distant location. At the same time, Branch 1 is starting the new project, and another project just finished at branch 2. If adding the assignment and deleting another assignment happen at the same time, what types of concurrency problems can arise? And how we can prevent these problems?