COMP_551_Winter_2024_Assignment_2

Please share the resource link or website or author reference - how to  download or extracted the dataset used for this project will be the crime data provided by the City of Los Angeles Open Data Portal. The dataset includes information about crime incidents, including the type of crime, date, time, location, and other details. The dataset covers the period from January 2010 to the present and contains more than 2 million rows.

Create a MS Access report showing the following for Jan, Feb, Mar in 2009. Duty-free sales, duty-paid sales, and taxes (original) are collected monthly by location. The report should be grouped by month, sorted by location, and include detail (one per month) and summary (the quarter) numbers. For printing purposes, ensure the report prints each month on a new page with portrait orientation. This report will be distributed at a meeting. Name the report ‘MGMT Boutique INC, Monthly Sales Q1, 2009 ’ and put the title on each page

Wk 1 - Apply: Database Management Plan: Part 1 - Extracting Information [due Day 7]   Assignment Content You are the vice president for information technology at a small, growing business. You have been tasked with developing a plan for maintaining databases for the storage of business data and use in business analytics. In Weeks 1–5, you will work on gathering information in a Database Management Plan. In Week 6, you will present your plan in a 20-minute presentation (10 to 12 slides) to the president of information technology.   The presentation will provide recommendations to an organization regarding how to develop a plan for the maintenance of databases that store business data and its use in business analytics.   To begin preparations for your presentation, create a 700-word entry in your Database Management Plan. You will use information from this entry in your presentation due in Week 6. In your Database Management Plan entry, include the following: Provide…

Warehouse Database Diagrams Tables System Tables FileTables dbo.invoicearchive dbo.invoicelineitems dbo.invoicesarchive E dbo.invoicesTerms1 dbo.invoicesTerms2 E dbo.invoicesTerms3 E dbo.vendors

Acording to the table in the image Database Using MySQL commands, answer the following questions ;               (iv) Insert the following data to table students                Matrixnum: S0003 Name: Raudah   (v) Delete the data entered in question (iv)

Question 6 You must give a word count for any question with a maximum word limit. This question tests your understanding of Block 3. Additionally, you are expected to follow the guidance on report writing that is provided in Section 1.5 of Block 2 Part 1. The introduction to Block 3 included part of a speech by Martha Lane Fox, in which she spoke of the need for greater digital understanding. For this question you are required to write a short report on digital understanding for a non-technical audience. Your report should contain two main sections: How has your digital understanding changed because of studying TM112 Block 3? You should explain what you have learned. Give at least one example of an activity that you have completed as part of TM112 Block 3 which has changed your digital understanding. Explain how it has changed your understanding: what understanding did you gain by doing it? You should support your explanation with at least one reference to the module materials.…

Create lessonSchedule table with FK constraints

How is redundancy identified and eliminated during the normalization process?

Explain the distinction between a request for proposal (RFP) and a request for quotation (RFQ) (RFQ)

Assignment Due: Fri, Jun 18 2021 at 11:59 PM 1. What are the basic steps in processing research data? 2. What are the uses of dummy tables?

de Show Review View Tell me whatyou want to do. Sign in & Share less you need to edit, it's safer to stay in Protected View. Enable Editing Calculate mean value Mean Amean value Ex = sum of all data values (x,, X, X3,) n= number of data values

Solve the follow y=2x+3 y=-x+9 Edit View Inse

student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) For the following mysql schema above, create a mysql query for the following question: For each department that has one or more majors with a GPA under 1.0, print the name of the department and the average GPA of its majors.

student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) For the following mysql schema above, create a mysql query for the following question: For those departments that have no majors taking the College Geometry 1 or College Geometry 2 course, print the department name and the number of PhD students in the department.

Question 2)     Maintaining an Audit Trail of Product Table Changes   The accuracy of product table data is critical, and the Brewbean’s owner wants to have an audit file containing information on all DML activity on the BB_PRODUCT table. This information should include the ID of the user performing the DML action, the date, the original values of the changed row, and the new values. This audit table needs to track specific columns of concern, including PRODUCTNAME, PRICE, SALESTART, SALEEND, and SALEPRICE. Create a table named BB_PRODCHG_AUDIT to hold the relevant data, and then create a trigger named BB_AUDIT_TRG that fires an update to this table whenever a specified column in the BB_PRODUCT table changes.     Preparation :   Step1: ALTER TRIGGER sales_date_trg DISABLE;   Step2: CREATE TABLE bb_prodchg_audit  (user_id VARCHAR2(10),   chg_date DATE,   name_old VARCHAR2(25),   name_new VARCHAR2(25),   price_old NUMBER(5,2),   price_new NUMBER(5,2),   start_old DATE,   start_new DATE,…

1. What is Consignment? (please give full explanation and avoid plagiarism. thank you.)

Using data as shown above, you need to : 1)Create January to March data each from different worksheet. 2)Calculate UTHM Trading First Quarter Summary from January to March data. 3)Create a pie chart for each sales percentage and profit percentage. 4)Create a line chart for overall UTHM Trading Quarter Summary 5)Hide January to March data. 6)Protect workbook for STRUCTURE ONLY using your 6 digit matric number as password. 7)Print screen all the step above and save. 8)Insert (name, matric number, section) on top (left side) of every worksheet. 9)Please rename and save your work as (matricnumber_LabSheet 5_2).