Dr. K Thengum Thara Quiz 4 Name Math 107 Fall 2019

Dr K Thengumtharaquiz 4namemath107 Fall 2019

5dr K Thengumtharaquiz 4namemath107 Fall 2019

This quiz covers week 4 & 5 material and is worth 100 points. You must show all necessary work neatly to receive credit. The quiz is open book and open notes. You may refer to your textbook, notes, and online course materials, but you must work independently and may not consult anyone. A brief honor statement must be signed before submission. The quiz must be submitted as a single PDF via LEO by 11:59 pm EDT on Sunday, November 10. Ensure the correct document is uploaded. Honor statement: I have completed this assignment myself, working independently and not consulting anyone. Signature: _____________________

Paper For Above instruction

This assignment involves solving various mathematical problems and designing a normalized database based on a given business scenario. The questions cover algebraic solution techniques such as extracting the square, completing the square, finding roots (including complex roots), and analyzing functions for domain, asymptotes, and holes. Additionally, it includes a practical application of rational equations, workforce problem-solving, and detailed database normalization steps.

Part 1 of the assignment requires solving specific algebraic problems. These involve rewriting quadratic equations by either extracting the square or completing the square, and then solving for the unknown variable. Finding roots, including complex roots, involves understanding quadratic formulas and their applications. Students must also analyze a given function to identify its domain, vertical asymptotes, holes, and horizontal as well as slant asymptotes, requiring knowledge of function behavior and limits.

Part 2 involves a word problem related to work rate: determining how long Sally and Steve would take together to complete a task, given their individual rates. This problem emphasizes understanding rates, combined work formulas, and collaborative effort calculations as outlined in weeks 4 and 5 course materials.

Part 3 is a comprehensive database design project based on the Brewton Enterprises scenario. Beginning with identifying candidate attributes (nouns) from the scenario, students must determine primary keys, handle repeating groups by marking them properly, and apply the normalization rules—first normal form (1NF), second normal form (2NF), and third normal form (3NF). The process includes creating a normalized table structure, drawing an ERD (Entity-Relationship Diagram), and filling out a normalization table. Key steps focus on removing repeating groups, ensuring dependencies are on entire primary keys, and defining suitable entity names. The final deliverable is a fully normalized relational schema with appropriate entities and keys.

References

  • Larson, R., & Edwards, B. H. (2018). Elementary Algebra (7th ed.). Cengage Learning.
  • Hoffer, J. A., Venkataraman, R., & Topi, H. (2016). Modern Database Management (12th ed.). Pearson.
  • Rosen, K. H. (2018). Discrete Mathematics and Its Applications (8th ed.). McGraw-Hill Education.
  • Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts (7th ed.). McGraw-Hill Education.
  • Schneider, K. (2012). Basic Algebra: An Introduction. Academic Press.
  • Mannino, M., & Sassaroli, A. (2018). Graphical Methods for Algebra. Springer.
  • Ullman, J. D., & Widom, J. (2008). A First Course in Database Systems. Pearson.
  • Fowler, M. (2018). Refactoring: Improving the Design of Existing Code. Addison-Wesley.
  • Graefe, G. (2018). Query Processing in Database Systems. Morgan & Claypool Publishers.
  • Chen, P. P. (1976). The Entity-Relationship Model—Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1), 9–36.

Related Assignments