Realtor Database: Data Redundancy and AnomaliesConduct an in-depth examination and analysis of the database,Week1_Realtor.mdb(Download Here). Apply the concepts of database systems that you have learned this week.For example, you may want to include a definition and analysis of these concepts:Describe the data contained in the database.Describe the tables, fields, and records in the database.Describe the keys, indexes, and relationships in the database.Identify data redundancy and describe potential solutions.Identify data anomalies and describe potential solutions.Identify fields containing more than one item of data and describe potential solutions.Identify other design concerns and describe potential solutions.The document should be written in Microsoft Word. The format should be APA style, double-spaced, and sufficient length to thoroughly complete the assignment (usually 2-3 pages). Be sure to cite your sources. Your final submission will be a Microsoft Word document.

Discussion boardPrior to beginning this discussion, read Chapters 7, 8, and 9 from the course text.In Week 2, you went through the structure of an Ethernet cable and its usage. Based on your readings this week, you will learn about the connection between the Ethernet cable and physical layers, as well as the internet and Ethernet cable for various purposes. Based on your resources, state additional information related to the Ethernet cable you discovered.Your initial post should be a minimum of 100 words.Interactive AssignmentPrior to completing this interactive assignment, be sure that you have completed the hands-on activities from the course text: 7A, 7C, 8A, and 8B.A company has hired you as a contractor to install their backbone to connect four 100base-T Ethernet LANs (each of which uses a 24port hub) for connection to the Internet. Let’s assume Cat5, Cat5e, Cat6, and optical fiber cables all have a fixed cost per circuit to purchase and install of $50, $60, $120, and $300, respectively (disregard the installation distance of the cables).For this assignment, consider how you would design an efficient backbone and create a total cost worksheet for your design. Your worksheet should include selecting and pricing of the backbone technology, cabling, devices, etc. You can get an idea of the prices at sources such as www.cdw.com (Links to an external site.).In your initial post, attach your total cost worksheet for your design and provide a rationale (to the company that hired you) for your selections.AssignmentPrior to completing this interactive assignment, be sure to have reviewed the hands-on activities from the course text: 7A, 7C, 8A, 8B, 9A, 9B. In addition, review the required videos for this week, and complete the following lab:Lab: Install and Configure VPN ServerFor this assignment, you will be completing a lab in which you will Install and Configure a VPN Server. The purpose of this lab is for you to compare various communication technologies and networking in simulated environments and recommend the use of suitable technologies.Part I:Complete the lab, and provide a screen shot of the final output for the lab.Part II:In 150 words or more, compare the differences between a VLAN and your VPN, explain how the VPN you set up can protect your data and describe the recommendations for use of either of the technologies discussed in part II. Support your recommendations with scholarly and/or credible sources.The Install and Configure a VPN Server LabMust include a screen shot of each lab.Must be a minimum of 300 words in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center (Links to an external site.).Must include a separate title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedMust use at least one scholarly, peer-reviewed, and/or credible source in addition to the course text.The Scholarly, Peer Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.Must document all sources in APA style as outlined in the Ashford Writing Center.Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center.