DQ 1  Who would be the ideal candidate(s) from whom to elicit information during the requirements gathering and analysis phase of the database project? Explain why. DQ 2  Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication. Identify different entities from this scenario. Create an entity-relationship diagram illustrating 1:1 and 1: many relationships. Compare your ERD with another classmate's and discuss the differences each of you had. Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication. Identify different entities from this scenario. Create an entity-relationship diagram illustrating 1:1 and 1: many relationships. Compare your ERD with another classmate's and discuss the differences each of you had. TIPs: You can create your entity relationship diagram by typing in your search engine: free entity relationship program. There are many free programs for creating these diagrams, but ALL of them take time to learn to use. (Microsoft Visio, OmniGraffle, LucidChart, and MySQL are few of these programs that will give free trials to create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word, PowerPoint Shapes, or SmartArt.) Please add a photo of your ERD to the post so that your classmates can discuss it. After students have added this information, you can create a reply to discuss your classmates ERD. Please allow yourself time to learn to utilize whatever program that you use. You can also use PowerPoint, but this also takes time if you have never created an ERD before. There are many different kinds of ERD diagrams such as (Crow, Chen, UML) (pick one you would like to use, as there is not a specific diagram format for this DQ). You will be utilizing one of the programs again to create an ERD for your database design. Please see Figure 4.6 and Figure 4.35 in Chapter 4 of your eBook for an example of an ERD (Entity-Relationship Diagram). Please see Chapter 13 of your eBook and see Figure 13.12 of an example of an ERD diagram. Please note you can use a Snipping tool in Windows to take a picture of your diagrams and insert the picture(s) into a Word document. You will not be able to upload the diagram in the program you pick to make your ERD such as Visio or other diagram programs. Please see section 2.3 in Chapter 2 of your eBook the discusses Data Model Basic Building Blocks as this will help to get you started with the cardinalities between your entity-attributes. You can set-up a data dictionary so that you understand the concept-- as you will be creating one down the road—so take the time to digest some of this now: You can set this up like a table in a word document and please see TABLE 8.2 in your eBook to see the required items in a data dictionary. (You will need a data dictionary just like TABLE 8.2 for Part 2 of your Proposal. Have I mentioned how important TABLE 8.2 is to view in your e-text?????!!!!!!!!! Naming conventions will be needed for your data dictionary and ERD (schema) diagram. Please see table 6.7 in your eBook and review the information related to naming conventions. The naming conventions will need to work in SQLfiddle. (I have added additional resources in files in the Topic 2 Resources). Naming conventions will be needed for your data dictionary and ERD schema) diagram. Please see table 6.7 in your eBook and review the information related to naming conventions. The naming conventions will need to work in SQLfiddle. (I have added additional resources in files in the Topic 2 Resources). 

All posts must be a minimum of 250-300 words. For this assignment, answer the following:What is the purpose of an audit?What information is contained within an audit trail?What are the advantages and disadvantages of using an audit trail?Forum Grading Rubric (100 points)Synthesis of Concepts55Clear Citations using APA Format10Writing Standards10Timeliness10Peer Reviews (minimum of 2)15This assignment is a formative assessment of the Course Objectives.