NCCU Compare Entity Relationship Diagrams and Decision Trees Discussion

I’m working on a computer science writing question and need a sample draft to help me study.

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 8

1. Find 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.
2. 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?
3. 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.
4. Explain how conceptual data modeling is different when you start with a prepackaged data model rather than a clean sheet of paper.
5. What are the linkages among DFDs, decision tables, and E-R diagrams?

Chapter 9

1. What is your approach on designing a database for a private patient registration system for a small medical office?
2. What are the advantages and disadvantages of normalization?

1. Give a detailed and thorough example of your approach on normalizing a database to improve the performance of the database.
2. You have recently been hired by an appliance repair company. How would you normalize the following relation?

Next identify at least four relations.

10. 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?