1. Week 5 – Data Management Project: Physical DesignThe final project requires a physical design of the database you have selected for your project (Car Rental MySQL Database. this assignment just builds on this project each week that you have submitted to me. i attached what you wrote week one, in case you need the previous weeks answer you submitted to me i can send you ) .This database should be normalized in 3rd normal form. Write the CREATE TABLE statements for all the entities in the database you have been designing. Make sure to include the primary keys and foreign keys, plus the data types for each attribute. In addition, write INSERT statements to input 10 rows of data into at least one of your tables. Please make sure your physical data model is included with the submission. 2. Week 5 – Data Management Research PaperYour research paper, based on the topic you selected in week 3 ( topic: Mining Social Media Data attached below). Submit a research paper regarding an aspect of data management. Use this website to help with APA formatting. Here is a sample paper in APA format.Requirements:The paper must concentrate on a topic chosen in week 3 ( Mining Social Media Data) . APA 6.0 format should be followed in regard to the completion of this paper. That means there must be a title page and a separate reference page. The paper must be double spaced using Times New Roman 12 pt. font. Not counting the title and reference pages, the body of the research paper should be 5 - 7 pages. A minimum of three references should be cited in the body of the paper and shown on the reference page. assignment will be graded according to Data Management Research Paper Rubric (attached below)Resources:Google Scholar

Research the Model-View-Controller (MVC) layered architectural pattern and the Client-Server architectural pattern.Explain each architectural approach and describe how each is organized (i.e., how they work).Compare and contrast each architectural pattern. What types of systems and application development environments might each be best suited for?Which of the two architectural patterns are best suited for dynamic application development environments characterized by high rates of change?  Why?Your analysis should be at least 300 but not more than 500 words.

The case study company provided a situation in which threats pose a real risk to the infrastructure. The company assets are not well-protected, and they all share a common network. Little additional security mechanisms are in place other than the demilitarized zone (DMZ). What are typical information security (IS) assets that are used by such a company, and what risks exist in the current model? What will adding a flexible solution for the consultants to connect to the network do to this risk model? What are some safeguards that can be implemented to reduce the risk?The tasks for this assignment are to identify the major applications and resources that are used by the company. Then, for each application, review the security threats that the company now faces and could face after the expansion. Describe how you can test for the presence of these (or new) risks? Provide a discussion about an approach that you will take after the risk assessment is complete to address the identified risks.Create the following section for Week 2:Week 2: Security AssessmentA description of typical assetsA discussion about the current risks in the organization with no network segregation to each of the assetsA discussion about specific risks that the new consultant network will createDetails on how you will test for risk and conduct a security assessmentA discussion on risk mitigationWorked ExamplePlease refer to the following worked example of this assignment based on the problem-based learning (PBL) scenario. The worked example is not intended to be a complete example of the assignment, but it will illustrate the basic concepts that are required for completion of the assignment, and it can be used as a general guideline for your own project. Your assignment submission should be more detailed and specific, and it should reflect your own approach to the assignment rather than just following the same outline.