Bright Academic Experts

Author: admin

  • Crime Data Report

    Please ensure no AI usage or plagiarism, and complete this by 11 pm Monday.

    In this assignment, you will analyze crime data to create a polished-looking Crime Data Report. Imagine that your boss wants you to produce a report comparing crime statistics in your jurisdiction to another jurisdiction, as well as detailed information about crime in the community, to present to the commissioner. To do so, you will use UCR and NIBRS data from the

    • UCR Data:
    1. Describe what the UCR is, what data it contains and one strength and limitation.
    2. Download data on a Part 1 or Part 2 Crimes in two locales to compare. You can select two states or two police departments. In your report, provide a graphic of the rate of that crime over time on a line graph.
    3. Be sure to describe the trend you observe and point out unique data points specifically.
    4. Consider the visual format and aesthetic of the graphic, making sure its readable, appealing and the axes and other aspects are labeled properly.
    5. NIBRS Data:
    1. Describe what NIBRS is, what data it contains and one strength and limitation
    2. Download data from two local-level police jurisdictions to compare it to on three different NIBRS crime characteristics variables (if you want to explore homicide specifically, CA reports this via the Expanded Homicide Data).
        • Compare two reporting police agencies on any NIBRS variable (in a single year or cumulatively over time), and
        • Two more NIBRS variables in reporting police agencies in separate figures.
      2. For each graphic, describe the data presented, including any decisions to exclude data (i.e. you dont have to include all the data points or you could combine data points, just note your rationale) or any important qualifying information detailed in the Crime Data Explorer.
      3. Consider the visual format and aesthetic of the graphic, making sure its readable, appealing and the axes and other aspects are labeled properly.

    IMPORTANT: Download the .csv files from the Crime Data Explorer and be sure to save them as Excel workbooks. Copy and combine all your data into separate worksheets in a single Excel workbook, making sure to label each worksheet appropriately.

    Be sure to describe the data youre reporting on in full, including whether it’s percents/proportions or raw counts, the rate, as appropriate for your data. Be sure to consider the best type of graphic to depict the data (line chart, bar chart, pie chart, etc.).

    Crime Data Report: Copy and paste the charts you make in Excel into a Word document (CAUTION: If you use GoogleSheets, it will copy it as a picture and the data are not clearly linked. Only copy from Excel and be sure to paste as the figure/chart not a picture). Please do not copy screenshots from the FBI website or Excelcopy the actual image of the chart/figure that you created.

    At the beginning of the document, provide information regarding the data being presented (such as year of collection, source, authors, etc.). Then create a figure visually depicting these data. For each table and graph, provide a brief description/interpretation of what is depicted. Be sure to label each figure and table. Some additional things to make the best report:

    • Use a report design theme to polish up your report.
    • Be sure the formatting and font is consistent throughout (as in the same font and size),
    • Make sure all the parts of the graph are properly labeled.
    • Make sure the table is on the same page (not crossing over pages)
    • Be sure to discuss the data and refer to the graph/table before presenting

    Guidelines

    You will submit two files for this assignment.

    1. Submit your report via Canvas in a Word document (.doc, .docx) or PDF named with the title of your report and your last name (ex. Crime Report_KRAS). The format of the report is as follows:
    • Title Page (title of project, name, date)
    • Introduction (including information on the data source and what you are examining)
    • Explanation/Interpretation, Figure 1
    • Explanation/Interpretation, Figure 2
    • References (the data tool and any other resource you used; on a separate page)
    1. Your Excel Workbook (so that I can examine the data used)

    Grading Rubric:

    Accuracy (35): Accurately analyzes the data frequencies, trends, and other descriptive information and accurately depicts it in the graphical displays.

    • Labeling of axes on figures and graphs and columns on tables
    • Completeness of data presented
    • Proper calculations in tables (if any)

    Consistency and formatting (15): Consistency (the same) in presentation of information and formatting across the document.

    • Font style and size consistency and appropriateness
    • Completeness of all sections of the report

    Style (10): Creativity of data display using tools in Word, Excel or other elements (color, size, style, position, etc.) to improve the readability and aesthetic of the report.

    Excel Workbook (10): Accurate data and graphs that correspond with that reflected in the report.

    I attached the example report and excel they gave me

  • 457 – Library

    Task Assignment Library Membership & Resource Access System

    Project Overview

    You are required to design and implement a complete database system for a university library in the Sultanate of Oman. The system must manage physical books, digital resources, and user access while ensuring data security and compliance with Omans Personal Data Protection Law (PDPL).

    The solution must include:

    • SQL Database (Relational)
    • NoSQL Database (MongoDB)
    • Security & Legal Analysis

    Use Arabic names for members and staff throughout the system.

    Part 1: SQL Database Implementation (50 Marks)

    1. Database Design & Normalization

    You must:

    • Start with UNF (Unnormalized Form)
    • Convert step-by-step into:
      • 1NF
      • 2NF
      • 3NF

    Requirements:

    • Clearly list all attributes
    • Identify:
      • Primary Keys (PK)
      • Foreign Keys (FK)
    • Explain functional dependencies
    • Justify why tables are separated

    Example Entities (use Arabic names):

    • Members (e.g., Ahmed Al-Harthi, Fatma Al-Balushi)
    • Books
    • Borrowing Records
    • Librarians
    • Digital Resources

    2. ERD Design

    Create a Crows Foot ERD diagram that includes:

    • All entities
    • Attributes
    • PK & FK
    • Relationships
    • Cardinalities

    Ensure:

    • No redundancy
    • Clear structure

    3. SQL Implementation (SSMS)

    Write SQL code to:

    • Create all tables
    • Define:
      • PK, FK
      • Constraints
    • Enforce referential integrity

    Important:

    • Add at least TWO CHECK constraints, for example:
      • Fine amount 0
      • Access duration > 0

    4. Insert Sample Data

    Insert realistic data using Omani Arabic names, such as:

    • Ahmed Al-Harthi
    • Salim Al-Rawahi
    • Fatma Al-Balushi
    • Aisha Al-Zahra

    Include:

    • Book records
    • Borrowing transactions
    • Digital access logs

    5. Role-Based Access Control (RBAC)

    Implement access rules:

    Rules:

    1. A student can only view their own borrowed books
    2. Admin has full access
    3. Others (e.g., librarians) have read-only access

    Deliverables:

    • SQL code for roles/permissions
    • Show:
      • Allowed action
      • Denied action

    6. SQL Queries

    Write and test the following queries:

    1. Retrieve the most borrowed books
    2. Identify librarians with highest transactions
    3. Find members who borrowed but never returned books
    4. Identify members with above-average digital resource usage
    5. Find digital resources with:
      • Avg usage > 30 minutes
      • Used by at least 3 members
      • Sort descending

    Part 2: NoSQL Database (MongoDB) 25 Marks

    1. Design NoSQL Model

    • Create one collection (e.g., LibraryActivity)
    • Store:
      • Member info
      • Borrowing records
      • Digital access logs

    Use a document-based structure

    2. Insert Data

    Insert 5 realistic documents using Arabic names.

    3. Queries

    Implement:

    1. Top 3 most borrowed books
    2. Members who:
      • Accessed digital resources
      • Borrowed at least 2 books

    4. Justification (Max 200 words)

    Explain:

    • Why NoSQL is suitable
    • Focus on:
      • Flexibility
      • High-volume logs
      • Hybrid system (SQL + NoSQL)

    Part 3: Security, Legal & Distributed Systems (25 Marks)

    1. PDPL Compliance (Oman)

    Analyze two data categories:

    A. Library Members Data:

    • Personal info
    • Borrowing history

    B. External Providers:

    • Vendors
    • Digital subscriptions

    For EACH:

    • Identify relevant PDPL principles
    • Justify one database design decision
    • Explain differences in compliance challenges

    2. Security Risks

    Identify TWO risks, for example:

    • Unauthorized data access
    • Data leakage

    For EACH risk:

    • Technical solution (e.g., encryption, access control)
    • Organizational solution (e.g., policies, training)

    3. CAP Theorem

    Explain:

    • Consistency
    • Availability
    • Partition Tolerance

    Scenario:

    If a branch library in Oman loses connection:

    Decide:

    • Prioritize Consistency OR Availability

    Justify your answer logically.

    General Instructions

    • Use Microsoft Word (.docx)
    • Include:
      • SQL code as TEXT (not screenshots)
      • Output screenshots
    • Word count:
      • ~2000 words total
      • Activity 3 600 words
    • References:
      • 46 academic sources (Harvard style)
    • Ensure:
      • Plagiarism < 15%
      • AI detection = 0%

    Expected Outcome

    The final work should demonstrate:

    • Strong database design
    • Correct SQL implementation
    • Proper NoSQL usage
    • Understanding of Omans legal framework
    • Awareness of security and distributed systems

  • Lesson 11, 12, 13 &amp; 14

    Instructions:

    1. Click and choose one (1) Case Study below and post answers.
    2. Answers must:
      • Be 100 words or more
      • Use the standard English grammar and spelling
      • References are cited (if necessary)
    3. Responses must:
      • Use the standard English grammar and spelling
      • Be substantial.
      • Do NOT just say, “I agree” or “Good point”.

  • Lesson 11, 12, 13 & 14

    Instructions:

    1. Click and choose one (1) Case Study below and post answers.
    2. Answers must:
      • Be 100 words or more
      • Use the standard English grammar and spelling
      • References are cited (if necessary)
    3. Responses must:
      • Use the standard English grammar and spelling
      • Be substantial.
      • Do NOT just say, “I agree” or “Good point”.

  • Programming Question

    Hi, I have an Excel assignment where I need to follow step-by-step instructions and complete tasks in a workbook. The assignment requires using different Excel tools and formulas to organize and analyze data. For example, I need to format text, split addresses into columns, combine names, and extract information using functions.

    I also need to use more advanced Excel features such as filtering data, calculating totals and averages with database functions, creating unique lists, sorting and filtering arrays, and using lookup formulas to find specific values in the dataset. The workbook has multiple worksheets, and each sheet requires different formulas and functions to complete the tasks.

    I have several assignments like this, so I need help making sure the Excel file is completed correctly according to the instructions.

  • Organization Design and Development (MGT 404)

    Please find the General Instructionsin the attachment.

  • Programming Question

    Hi, I have an Excel assignment where I need to follow step-by-step instructions and complete tasks in a workbook. The assignment requires using different Excel tools and formulas to organize and analyze data. For example, I need to format text, split addresses into columns, combine names, and extract information using functions.

    I also need to use more advanced Excel features such as filtering data, calculating totals and averages with database functions, creating unique lists, sorting and filtering arrays, and using lookup formulas to find specific values in the dataset. The workbook has multiple worksheets, and each sheet requires different formulas and functions to complete the tasks.

    I have several assignments like this, so I need help making sure the Excel file is completed correctly according to the instructions.

  • Communications Management (MGT 421)

    Please find the General Instructionsin the attachment.

  • Anatomy and phisology 2 powerpoint presentation on kawasaki…

    Need to create a. powerpoint for me on kawasaki disease. will attach the requirements below.

  • Studypool Professional

    “I, Menna, can write anything you need in both English and Arabic, such as assignments, submissions, articles, and research papers. I can also add images if the topic requires it, and I deliver everything with high quality. Thank you.”