Question: Hi, would you please help me do the critique and do rubric. here's the instructions how to do critique based on standards rubric.... Please answer
Hi, would you please help me do the critique and do rubric. here's the instructions how to do critique based on standards rubric....







Please answer asap.
Sample Data Received Below is a copy of the sar This email is in regards to the database design we discussed for Amanda's Gourmet Grilled Cheese Enclosed you will find an entity-relationship (ER) diagram showing the tables, keys, and relationships of the model In addition, I have a few more questions I thought of when designing your database I relize the ER diagram is a technical document that may not be informative to you I am including it as it is the basis for my DB work It may also be useful if you engage other IT professionals on this project I will await your feedback on the questions I asked We can then update the design and begin the implementation process I noticed that there was some information related to orders that was not in your sample data. Consider the following questions and we can discuss them in our next meeting. 1 - Would you like to know the delivery date of the order? 2 - Would you like to track the payment type that was used for an order? When we nxt get together I can walk thru how you're sample data will map to each of the fields in the database. cuL8r Company Standards (Rubric) Grammar - The status report should be written in a professional manner with correct spelling and grammar. A free tool like Grammarly is a great place to review grammar and spelling Report Format - The communication should be formatted as a professional looking status report. You might want to go back and read the section on "Reports" from Introduction to Professional Communications. (Link to reports information here.) Focus on the information about the "Progress Report" and "Report Organization." Note, with respect to the "Report Organization" section you only need to focus on the information about the "Introduction," "Body," and "Conclusion." Additional Questions - The report should include 3 additional questions regarding the analysis of the problem. These should be focused on decisions that will impact the design, as opposed to external questions like "who will be the administrator of the database." Primary Key Identified - Each table in the design should have the primary key(s) for each table defined. Anomalies Avoided - The design of each of the tables should be in 3rd normal form. When tables are in 3 rd Normal form, they do not have insertion, update, or deletion anomalies. Design/model can represent all example data - The DB design can support all example data provided by the client. In each area, you will give the status report a score based on the following table. If you think the report does not deserve full credit ( 5 points) in any category, provide feedback to your colleague to let them know how to improve the status report to better fit the standard. For categories that do not have any issues needing correction, This critique is not for the design in this task. It is for an imaginary design. The purpose of the example is to show you the format that you should have in the assignment you turn in. Grammar - Rating 2.6 There were a few spelling mistakes. I found several run-on sentences Your spelling/grammar mistakes caused me to have to read the report a few times in order to understand it. This critique is not for the design in this task. It is for an imaginary design. The purpose of the example is to show you the format that you should have in the assignment you tum in. Grammar - Rating 2.6 There were a few spelling mistakes. I found several run-on sentences. Your spelling/grammar mistakes caused me to have to read the report a few times in order to understand it. Report Format - Rating 3.2 Your introduction was sparse and included slang that is not appropriate for a professional status report. Additional Questions - Rating 0 You did not include any additional questions. Primary Key Identified - Rating 4 Out of the 7 tables identified, you did not label the primary key for 3 of them Design/model can represent all example data - Rating 4 There were 2 columns in the sample data that were not represented in your ER - Diagram Anomalies Avoided - Rating 5 All tables are in 3rd normal form, so no data anomalies will exist. Primary Key Identified - Rating 4 Out of the 7 tables identified, you did not label the primary key for 3 of them. Design/model can represent all example data - Rating 4 There were 2 columns in the sample data that were not represented in your ER - Diagram Anomalies Avoided - Rating 5 All tables are in 3rd normal form, so no data anomalies will exist. Total Score 14.8 out of a possible 25 points Huge i The design you are critiquing does not have any problems with data anomalies/3rd Normal form. You can focus your critique on the other areas of the company standards
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
