Implement the star Schema in PostgreSQL. Write the code for table creating in PostgreSQL CustomerCustomerIDCustomerNameCustomerNIDCustomerAddressSuperstoreStorelDSupplierAddressSupAddressStreetProcurement_SupSale_transaction_supCityDistrictSupplier(FK)SupAddressProduct_sup_type (FK)SupIDSupAddressSup_NameProduct_sup_typefact table(FK)CustomerIDCustomerIDStorelDSupIDTransIDItemlDCustomerIDTransIDSup_IDStore_IDItemIDCustomerAddressCustomerIDHouseNoThanaCityDistrict(FK)(FK)(FK)(FK)Product_to_supplyProduct_sup_typeMachineriesFoodClothes(FK)DivisionAgeGroupTransactionTypeTransactionTransIDTrans_typeTime_StamplDTimeOfDayWeek_DayDateWeekMonthYearQuantityTransID(FK)ItemItemlDItemNameItemTypeItem_Country_ManfCashCardUnitPriceTotal_price

Code for creating tables: create table Customer(CustomerID int primary key, CustomerName text,…

SupplierAddress SupAddress Street City District Superstore StorelD Procurement_Sup Sale_transaction_sup Customer CustomerID CustomerName CustomerNID CustomerAddress Supplier SupAddress (FK) Product_sup_type (FK) SupID SupAddress Sup_Name Product_sup_type fact table CustomerID (FK) CustomerID (FK) StorelD CustomerAddress CustomerID HouseNo Thana City District Division AgeGroup (FK) SupID (FK) TransID ItemID CustomerID TransID Sup_ID Store_ID ItemlD (FK) Product_to_supply Product_sup_type Machineries Food Clothes (FK) Transaction TransID Trans_type Time_StampID TimeOfDay Week_Day Date Week Month Year Quantity UnitPrice TransactionType TransID (FK) Cash Card Item ItemID ItemName ItemType Item_Country_Manf Total_price

SupplierAddress SupAddress Street City District Superstore StorelD Procurement_Sup Sale_transaction_sup Customer CustomerID CustomerName CustomerNID CustomerAddress Supplier SupAddress (FK) Product_sup_type (FK) SupID SupAddress Sup_Name Product_sup_type fact table CustomerID (FK) CustomerID (FK) StorelD CustomerAddress CustomerID HouseNo Thana City District Division AgeGroup (FK) SupID (FK) TransID ItemID CustomerID TransID Sup_ID Store_ID ItemlD (FK) Product_to_supply Product_sup_type Machineries Food Clothes (FK) Transaction TransID Trans_type Time_StampID TimeOfDay Week_Day Date Week Month Year Quantity UnitPrice TransactionType TransID (FK) Cash Card Item ItemID ItemName ItemType Item_Country_Manf Total_price

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 1MC

See similar textbooks

Similar questions

8. Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows: CREATE TABLE ShippingLabels (VendorName varchar(50), VendorAddress1 varchar(50), VendorAddress2 varchar(50), VendorCity VendorState VendorZipCode varchar(50), char(2), varchar(20)); Use this UPDATE statement to test the trigger: UPDATE Invoices SET PaymentTotal = 67.92, PaymentDate = '2020-02-23' WHERE InvoiceID = 100;
2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70 $400.00 29 GR56 Grant Cleaners 737 Allard Kingston TX 78084 512-555-1231 $215.00 $225.00 22…
Following script is given to you at Google Classroom. Run script to generate tables inOracle APEX. EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)DEPT (DEPTNO, DNAME, LOC)SALGRADE (GRADE, LOSAL, HISAL) INSTRUCTOR: HAROON SHAHZAD 2After setting up all relations, you need to apply following queries to get data from givenrelations: (Write queries and also paste screenshots in answer file) i. Give data of all employees whose salary is greater than 5000.ii. Give only those departments name whose deptno is 30 and Location is New York.iii. Display the employee name, job id and start date of employees hired between February20, 1998 and May, 1, 1998. Order the query in ascending order by hire date.iv. Display the data of all employees who do not have managers. (means whose managersare null)v. Display the names of all employees where the third letter of the name is ‘a’.vi. Write a query to display all employee records who have been hired in month February.vii. Give all employees…
Part 1 2 3 Following script is given to you at Google Classroom. Run script to generate tables inOracle APEX. EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)DEPT (DEPTNO, DNAME, LOC)SALGRADE (GRADE, LOSAL, HISAL) After setting up all relations, you need to apply following queries to get data from givenrelations: (Write queries and also paste screenshots in answer file)i. Display the employee id, name, salary, commissioned salary (incremented salary +commission) with label "Commissioned_Salary".ii. Write a query that displays the sum of all salaries of each job.iii. Get the average of clerks salaries.iv. President takes maximum salary in our record. Find maximum salary of employees otherthan president.v. Show employee name, job, salary and incremented salary (25% incremented salary) ofemployees.vi. Get all Clerk or Salesman salaries that are below 3000 in descending order with respectto sum of salaries.vii. Show accumulated high salary and low salary from SALGRADE table.viii.…
Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.). BranchNbr stores RefNbr of either 'D', OR 'W' transactions and MerchantNbr stores RefNbr of either 'B', 'P' or 'R' transactions. GIVEN THE BELOW: --THIS CREATES THE TRANSACTION TABLE: CREATE TABLE Transaction ( TxNbr INT PRIMARY KEY, AccountNbr INT, TxTypeCode VARCHAR(250), TxDate DATE, TxTime TIMESTAMP, TxAmount FLOAT, RefNbr INT, FOREIGN KEY (AccountNbr)REFERENCES Account(AccountNbr), FOREIGN KEY (TxTypeCode) REFERENCES TxType(TxTypeCode)); --THIS CREATES THE BANK BRANCH TABLE:CREATE TABLE BankBranch ( BranchNbr INT PRIMARY KEY, BranchName VARCHAR(250)); --THIS CREATES THE MERCHANT TABLE:CREATE TABLE Merchant ( MerchantNbr INT PRIMARY KEY, MerchantName VARCHAR(250)); -- Insert test data…
1. Query all table records in Person.Person and display records with FirstName that starts with the letter K and FirstName ends with N. 2. Create a JOIN on the table Person.Person and Person.PersonPhone and Person.EmailAddress and display the columns BusinessEntityID, PhoneNumber, EmailAddress, ModifiedDate 3. Create a JOIN on the table Person.Person and Person.PersonPhone and display the columns FirstName, LastName, PhoneNumber.
1.6) Constraints should be used to force valid data entry / modification to the databaseTrue False 1.7) A primary key can contain only single row with null value since duplicate values are not allowedTrue False 1.8) Comparison with null can be meaningfully done with equals and not equals operatorTrue False 
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in the table below.Table: Sample CLIENT records Attribute name Sample value Sample value Sample value CLIENT_NUM 298 289 289 CLIENT_NAME Marianne R. Brown James D. Smith James D. Smith CLIENT_REGION Midwest Southeast Southeast CONTRACT_DATE 10-Feb-2018 15-Feb-2018 12-Mar-2018 CONTRACT_NUMBER 5841 5842 5843 CONTRACT_AMOUNT R22,985,00.00 R1,670,300.00 R11,250,000.00 CONSULT_CLASS_1 Database administration Internet services Database design CONSULT_CLASS_2 Web applications Database administration CONSULT_CLASS_3 Network installation CONSULT_CLASS_4 CONSULTANT_NUM_1 29 34 25 CONSULTANT_NAME_1 Rachel G. Carson Gerald K. Ricardo Angela M. Jamison CONSULTANT_REGION_1 Midwest Southeast Southeast CONSULTANT_NUM_2 56 38 34 CONSULTANT_NAME_2 Karl M. Spenser Anne T. Zuma Gerald K. Jele CONSULTANT_REGION_2 Midwest Southeast Southeast CONSULTANT_NUM_3 22 45 CONSULTANT_NAME_3 Julian H.…
in mysql Take a picture of the inputs and outputs Create a user with the name IS Sead and password a789 and give him permission to connect to the databaseCreate a role function that includes allowing to create a table and create a view and then granting that function to the Sead . user Make the sead user give permission to query and enter on the student table for all users in the databaseHave the user sead withdraw the entry on the student table from user saa

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS