For the ER diagram you created in assignment 1, the artefact of the conceptual database design, map the ER model into the relational model according to how it was designed in the ER diagram. You may however first refine your ER diagram if necessary. The actual assessment of this part is in the point 3 below. While there can be a variety of acceptable designs, we here attach one simplistic rough sketch for the comparison purpose.For all the relations that arise from this (first-cut) ER diagram, list all those (in schemas) that are already in 3NF. If there are some relations that arenotin 3NF yet, then convert them into 3NF with proper procedure and explanations.(2 marks)Draw the global relation diagram for your final, revised, and normalised database design, and keep all the relevant details there. It should be in a similar form to Figure 17.9 (page 516) of the textbook, but all the attributes should be kept there too. Include in the diagram all the primary keys, foreign keys, and the multiplicity constraints. Identify and discuss the potential data redundancies or anomalies that may still exist in your design, if any. (3 mark) Calculate and list the average response time taken from the current set of job recruitment records, i.e. all the communications between the School and casual candidates for the express recruitments, and then update the response time for each casual staff according toupdatedresponse time =(currentresponse time+theaverageresponse time just calcuated)/2. We note that depending how your database is designed, some may find the use of the functionDATEDIFFhelpful. (1 mark) For each casual job, list all those casual staff who are suitable for the job, ignoring their availability for the timeslots. In other words, the suitability will not be affected by whether a casual can only work on certain days or he has already got a commitment for another casual job with the School. (1 mark) Attached to the document is the Case Study and ER Model for the first part. Can you please email me with a price on bjuszczak92@gmail.com asap please Attachments: Case-Study.rtf ER-model.docx.docx; For the ER diagram you created in assignment 1, the artefact of the conceptual database design, map the ER model into the relational model according to how it was designed in the ER diagram. You may however first refine your ER diagram if necessary. The actual assessment of this part is in the point 3 below. While there can be a variety of acceptable designs, we here attach one simplistic rough sketch for the comparison purpose.For all the relations that arise from this (first-cut) ER diagram, list all those (in schemas) that are already in 3NF. If there are some relations that arenotin 3NF yet, then convert them into 3NF with proper procedure and explanations.(2 marks)Draw the global relation diagram for your final, revised, and normalised database design, and keep all the relevant details there. It should be in a similar form to Figure 17.9 (page 516) of the textbook, but all the attributes should be kept there too. Include in the diagram all the primary keys, foreign keys, and the multiplicity constraints. Identify and discuss the potential data redundancies or anomalies that may still exist in your design, if any. (3 mark) Calculate and list the average response time taken from the current set of job recruitment records, i.e. all the communications between the School and casual candidates for the express recruitments, and then update the response time for each casual staff according toupdatedresponse time =(currentresponse time+theaverageresponse time just calcuated)/2. We note that depending how your database is designed, some may find the use of the functionDATEDIFFhelpful. (1 mark) For each casual job, list all those casual staff who are suitable for the job, ignoring their availability for the timeslots. In other words, the suitability will not be affected by whether a casual can only work on certain days or he has already got a commitment for another casual job with the School. (1 mark) Attached to the document is the Case Study and ER Model for the first part. Can you please email me with a price on bjuszczak92@gmail.com asap please Attachments: Case-Study.rtf ER-model.docx.docx
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]