in any progressive environment there will be collaboration. We all will have to collaborate with others throughout our lifetime. Therefore this assignment involves collaboration about structuring system data requirements and designing a database. Provide your input on 4 of the following questions below by end of day 4/21/21 end of day. There must be a least 2 questions answered for each chapter.Chapter 8Find a copy of a bill, invoice, or order form that you used in a recent business transaction. Create an Entity Relationship Diagram to describe your document.Compare Entity Relationship Diagrams and Decision Trees. How are E-R diagrams similar to and different from decision trees? In what way ways are data and logic modeling techniques complementary? What problems might be encountered if either data or logic modeling techniques were not performed well or not performed at all as part of the systems development process?Students are assigned an adviser each semester. Advisers counsel students about degree requirements and help students register for classes. The students must register for classes with the help of the adviser, but if their assigned adviser is not available, they can register with any adviser. We need to keep track of students, their assigned adviser, and with whom the student registered for the current term. Create an entity-relationship diagram to represent this situation of students and advisers.Explain how conceptual data modeling is different when you start with a prepackaged data model rather than a clean sheet of paper. What are the linkages among DFDs, decision tables, and E-R diagrams?Chapter 9What is your approach on designing a database for a private patient registration system for a small medical office? What are the advantages and disadvantages of normalization?Give a detailed and thorough example of your approach on normalizing a database to improve the performance of the database.You have recently been hired by an appliance repair company. How would you normalize the following relation? Next identify at least four relations. Client No.Last NameStreet AddressCityStateTechnician No.Technician Last NameService DateType of Service10. Suppose you were designing a file of student records for your university’s placement office. One of the fields that would be likely in this file is the student’s major. What would be your coding scheme for this field that achieves the objectives outlined in chapter 9 for field coding?

While you are required to write an 8-10 page technical paper on a technical topic of your choosing by the end of the session, you must submit an outline for approval by the end of this week. It must include a detailed outline of main points and subpoints. Outlines are basically a roadmap that helps you organize your ideas on the topic you are writing about. They are a great system to help organize your paper into a cohesive paper, connecting ideas to each other in an order that works best. It helps to create a more logical flow to your paper and keep the writer on topic. Outlines are not always written in complete sentences, but they can be. Basic Outline Format: Introduction Paragraph: Remember to open your paragraph with an introduction that provides your reader with a thesis statement. In this opening paragraph you want to prepare your reader for what is to come, but you want to reserve the specific content and details for the body of the paper. First Paragraph Main Body 1: Subtopic 1: What is this paragraph about? Subtopic 2: What are the important details I want to discuss? Do I have any supporting evidence for my statements discussed in this paragraph? First Paragraph Main Body 2: Subtopic 1 First Paragraph Main Body 3: Subtopic 1  Etc...Depending on the length of your paper, continue adding paragraphs in this manner.  Conclusion Remind your reader what your main point is. The conclusion restates your thesis statement, summarizes the subpoints of your essay and leaves the reader with an interesting final impression. Go above and beyond simply re-stating the key points you addressed. What do you want your reader to remember when they walk away from this paper? Link for APA Style: http://owl.english.purdue.edu/owl/resource/560/01/ Video Links Below are some links to help you. Invest time in watching these videos I have provided, as well as searching other Youtube videos to help if you are still unclear.  How to Write an Essay Outline - Essay Writing Tips For Exams (Links to an external site.) How to Write a College Paper : How to Structure an Outline for a College Paper (Links to an external site.) https://www.tacoma.uw.edu/sites/default/files/global/documents/library/essay_outline_worksheet.pd

Note : Need Original work and all instruction are below for this assignment Assignment InstructionsThere are 2 parts to this week’s assignment.Download the attached instruction details.The objective is to perform the same tasks; first, by issuing SQL commands, and then by using MS Access (use the graphical interface to perform the tasks).Part A SQL (70%); by following the detailed instructions you will Create a table, Insert data into that table, and use Select commands to select and display data from the table.Submit one Word document, which includes the text of the SQL commands, and screen captures of the commands along with the Web site’s feedback.Part B MS Access (30%): use MS Access to create the same tables, load the same content and perform the same Queries.The MS Access database is submitted.Two files will be submitted – a word document for Part A and an Access database for Part B.Supporting Materials