Mark has reviewed what you provided to him in Stage 1 and he has asked that you tell him what components he will need to support his "Expansion Plan." In addition to creating more 3D printed products, he needs to be able to manage his customer orders, supplies, employees, etc. He wants to replace his spreadsheet of customer orders with a small business enterprise resource management (ERP) information system in his facility to help him manage his business effectively. Review the section of the Case Study entitled "Mark's Expansion Plan" and the additional information provided below to identify all of the requirements Mark has laid out. He wants you to tell him what components he will need and what they do.

Based on your selected scenario from Hands-On Database, complete the "To Do" activities. Please check your own work to be sure it includes the elements in the list.To doReview all the requirements and business rules.Define your entities and attributes and the relations that exist between them.Create a logical model using crow’s feet notation in Visio or hand draw it on graph paper if you prefer.Add all the entities and their attributes. You don’t need to worry about data types for now.Identify the key fields for each entity and the foreign keys.Analyze the diagram. Identify which role (i.e., domain, linking, lookup, or weak) each entity plays in your database.Review it for the following:Are all the major components of the Wildwood Apartments business model represented by domain entities?Does each entity contain the appropriate attributes to fully describe it and meet the business rules you have gathered so far?Does every entity have an appropriate primary key defined?Are all many-to-many relationships resolved into one-to-many relationships by linking tables?Are the relationships valid (no cross relationships)? Is the appropriate entity is defined as the one side of a one-to-many relationship? Do the tables have appropriate foreign keys? Also check for other such issues.Are lookup tables used for attributes that have a set list of values?Documentation: Be sure to store your ERDs in your database notebook.

Practical Connection AssignmentAt UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where students will demonstrate how this course research has connected and put into practice within their own career.Assignment: Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. Requirements:Provide a 500 word (or 2 pages double spaced) minimum reflection.Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.Share a personal connection that identifies specific knowledge and theories from this course.Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.