CaseBest Products Limited is a large manufacturer which sells a large collection ofproducts to distributors all over the world. The company uses a central databasesystem to store the data collected from various business departments. A slice of thedatabase of Best Products Limited as captured at the end of 2022 is stored in the Exceldata file Assign_database_2023.xlsx.file:///Users/cyy/OneDrive/304/Assign database 2023.xlsxRequirements1. Identify and discuss business decision that can be enhanced with the dataincluded in the date file. State clearly the functional area of the relatedbusiness process, the nature of the decision, and then propose and explain thebusiness analytics that can be utilized to support the decision.2. Create a dashboard using Tableau from the data file to support the decisionmaking as identified in requirement (1). The dashboard should consist of atleast THREE (3) (sets of) graphs which provide a coherent set of information.You need to export and upload the Tableau file to the OLE together with yoursubmission.3. Demonstrate and discuss how the dashboard constructed in requirement (2)can help the management to make business decisions as identified inrequirement (1).

1.Business Analytics and Decision Making In order to improve inventory management, one…

Best Products Limited is a large manufacturer which sells a large collection of products to distributors all over the world. The company uses a central database system to store the data collected from various business departments. A slice of the database of Best Products Limited as captured at the end of 2022 is stored in the Excel data file Assign_database_2023.xlsx.

Best Products Limited is a large manufacturer which sells a large collection of products to distributors all over the world. The company uses a central database system to store the data collected from various business departments. A slice of the database of Best Products Limited as captured at the end of 2022 is stored in the Excel data file Assign_database_2023.xlsx.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create the table that would result from Tstu_code (student). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT STU CODE PROF_CODE 100278 128569 512272 531235 531268 2 553427 1 Table name: PROFESSOR PROF CODE DEPT CODE 12 26 36 44
The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the name of the supplier who sells shoes at prices below the average shoe price- Show the name of the customer who bought shoes with odd sizes- Show Customer Name and Average Payment Amount for Customers who make 5transaction more than 1 Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier: INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8'); Merek: INSERT INTO Merek values('AS', 'Adidas','MA');INSERT INTO Merek values('DA', 'Diadora','SS');INSERT INTO Merek values('PA', 'Puma','SO');INSERT INTO Merek…
Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
Question 2 and 3
EMPLOYEE Fname Minit Lname Ssn Bdate | Address Sex Salary Super_ssn Dno 444 DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dlocation Dnumber PROJECT Pname Pnumber Plocation Dnum WORKS ON Esan Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship Q#1 Insert two records in each table or use if you have already created this schema. Q#2 Display Employees Fname and salary who are males and salary is greater than equal to 1000. Q#3 Display Address of employees where salary range starting from 1000 to 2000. Q#4 Display Last name of employee that starts with A and end on B. Q#5 Display Fname of employee that starts with A and have size of 3. Like: Ali,Ans etc Q#6 Display Project name and Project number that belongs to department 1. Q#7 Display Dependent name who were not born in 2002,2003 and 2004. Q#8 Display Pno who take a time more than 3 hours and less than 10 hours. Q#9 update working hours 3 hours to 5 hours. Q#10 Delete record in Dependent who have gender Male.
use the information above to: With the aid of Microsoft SSMS (SQL Server Management Studio), create both database schema and insert 10 records into each relation for each database. Specify primary keys Specify foreign keys All sample SQL statements must be submitted.
Database
A view is updatable when it is derived from joining two base tables on the _________ command
Referring to the Set Operations image above, which relational operation should I use to display current certificates and the full names of the colleges from which they were earned? Question 45 options: 1) Join 2) Difference 3) Union 4) Intersect
Project 4 : Working On University Data Set Project: Working on university dataset Industry: Education Problem Statement: How to improve the teaching process of a university Topics: In this PL SQL project you have the Student and Staff data in tables. You will create the Course table and insert data into it. Then you will join the three tables and analyze the data. This includes coming up with all the courses with corresponding students and the teachers associated. Then finally you will create a detailed report on the teaching structure and ways to improve it. Highlights Inserting data into the table and joining tables Querying the data for various conditions Prepping the data for analysis.
Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.
create database CTU__YourICASNoGOUSE CTU__YourICASNo;GOCREATE TABLE Course( CourseID int PRIMARY KEY, CourseName varchar(255), CourseDesc varchar(255),);insert into Course(CourseID,CourseName,CourseDesc)values(11334,'Foundation','Basic1')insert into Course(CourseID,CourseName,CourseDesc)values(11335,'MCSD','Basic2');insert into Course(CourseID,CourseName,CourseDesc)values(11336,'MCSE','Basic3');insert into Course(CourseID,CourseName,CourseDesc)values(11337,'MCSA','Basic4');insert into Course(CourseID,CourseName,CourseDesc)values(11338,'CAD','Basic5'); CREATE TABLE Students( ICASNo int Primary Key, StudentName varchar (255), StudentSurname varchar (255), StudentContact varchar (255), StudentEmail varchar(255), HighSchoolAttended varchar(255), courseID varchar (255),);insert into…