Set up a payroll authority. Create a new supplier record for the Receiver General as the payroll authority for Income Tax, El and CPP. Leave the remaining supplier record fields blank. Settings- Payroll: Remittance and suppliers - Receiver General for Canada Remitting frequency - Monthly End of remittance period - April 15, 2022. hOW TO DO THIS IN SAGE50?
Q: What is the purpose of a database audit trail? Explain in no more than 60 words how Extended Events…
A: Database audit trails:- Database audit trails consider responsibility, interruption location, and…
Q: Give a normalized version of the Index_metadata relation, and explain why using the normalized…
A: Normalized version of the Index_metadata relation The Index_metadata relation is not in first…
Q: The solution for many vulnerabilities is proper encoding of user-supplied data. Compare and contrast…
A: The solution for many vulnerabilities is proper encoding of user-supplied data. Compare and contrast…
Q: rdt_send (data)
A: Given :- In the above given question, the reliable data transfer 1.0 for sending and receiving side…
Q: Consider given database schema and write triggers for each statement. Student ( regNo, sName,…
A: Triggers are special statements/procedures for a table which are executed when an event, occurs in…
Q: operate? Provide at least two different EAP options in your d
A: Introduction: EAP is an authentication framework for delivering and utilising content and parameters…
Q: We have customers that will be accessing an eCommerce front-end for our database and will need to be…
A: View is used in SQL. It is a virtual table based on the result set of SQL statement. A view…
Q: What can be done to cut down on the amount of extra work that comes with page table shadowing?
A: Introduction: Shadow Paging is a database recovery technique. The database is believed to be made up…
Q: Why do we use contingency tables, instead of just presenting the graphical results
A: Contingency tables are also known as the cross tables and the two way tables which are used to…
Q: If the functional dependencies are consistent with the above relation, put TRUE. If they are not,…
A: functionally dependent defines the relationship between attributes, how they are related. A-> B…
Q: How did we find the total number of records in the database? (500000 million records) How we did…
A: Answer: We have write command for find the total number of record in the table
Q: Do you think optimistic or pessimistic locking would be better for the Service Update Transactions?
A: Lets see the solution.
Q: What is the balance (total across all accounts) for customerid=42?
A: Please check the step 2 for solution
Q: Design two stored procedures as the following (4 marks) Create a PARAMETER based SELECT QUERY stored…
A: Q: Write query based on given values Note: Please ensure to update correct field names as they are…
Q: Student • Student Id | Primary Key • Student Name | Not Null Phone Number | Not Null, Unique •…
A: In many to many relationship we need to create one more table consisting parent and child keys which…
Q: If you have access to SQL Server, search its help system to answer the following questions. A. Does…
A: NOTE: We are authorized to answer only the first three questions at a time when multi-part questions…
Q: at leas
A: Database security refers to a set of procedures for protecting database management systems from…
Q: What is the definition of data trust management? What applications does it have?
A: The above question is solved in step 2:-
Q: What is Database Integrity? List out all constraints used to enforce database integrity in Oracle
A: Database integrity e refers to overall completeness accuracy and consistency of the data in the…
Q: What happens if database referential integrity isn't enforced? What are the most likely blunders?
A: Introduction: The goal is to identify database issues caused by a loss of referential integrity.…
Q: What happens if your database's referential integrity isn't maintained? Is there a list of common…
A: Answer: Enabling referential integrity for a table connection is a great approach to do so.After a…
Q: Refer the schema and create the Subject table Refer the below schema diagram: College Management…
A: Given in the problem we have to create the subject table according to the given table schema. We…
Q: Given the Bank database that contains the following tables (primary keys are underlined and foreign…
A: According to the given question we just need to create the table Agency to fetch the data…
Q: Refer the schema and create the Subject table Refer the below schema diagram: College Management…
A: Based on the schema provided, we need to create subject table : where subject_id is primary key and…
Q: Why is the foreign key crucial for database integrity? Can you come up with a scenario to…
A: Introduction: Foreign keys are very important in database architecture. Using references to ensure…
Q: Using your knowledge of BITS, determine the functional dependencies that exist in the following…
A: To convert to 3NF, we need to ensure that no non-key attribute is transitively dependent on the…
Q: How view increases data security and why view for data should not be completely relied on?
A: Given; How view increases data security and why view for data should not be completely relied…
Q: Create transactions which execution could bring the DB to deadlock. Why it could occur? What could…
A: Answer to the above question is in step2.
Q: How would you compare MySQL, MSSQL, Oracle, SQLite based on current version, operating system, cost,…
A: MySQL is a relational database management system (RDBMS).A social data set composes information into…
Q: What could be a specific, realistic database "Validation Rule" which you may actually use in a real-…
A: A validation rule is a list of conditions that must be met before data can be entered into a field…
Q: What approaches can be used for the security of data in transit or data at rest? Also perform a…
A: Data in transit, or data in motion, is data actively moving from one location to another such as…
Q: Explain how views can be used as part of data security, as well as how they can be used in a way…
A: Given: To build the display, many base tables are searched, and a subscriber flexible column is…
Q: Personnel would run what kind of queries to get access to what information. which of the following…
A: A database is a collection of data systematically collected, Electronic storage and processing of…
Q: Since with no referential integrity you aren't prevented from putting in any data you want to a…
A: Data loss main reasons are-
Q: Create a list of ENAME, COMM from EMPLOYEE and DEPTNO, DNAME from DEPT for all employees in DEPTNO…
A: CREATE TABLE DEPT(DEPTNO NUMBER(2) CONSTRAINT PK_DEPT_DEPTNO PRIMARY KEY,DNAME VARCHAR2(14),LOC…
Q: Consider the database schema below and answer the questions that follow using SQL.…
A: 1. Retrieve all employees in “sales department” whose salary is between Ksh 30,000 and Ksh…
Q: Are there any helpful tips or tricks to finding out the gcf between 2 #'s??
A: GCF or Greatest common divisor, is the number that divides the two or more number exactly. It would…
Q: The client hands you a supplier file and transaction file, but isn't sure how to connect the tables…
A: Primary Key: Primary key is a unique data in a table which cannot be a NULL value.…
Q: Why is a top-down approach to data security better than a bottom-up one?
A: Because it makes data protection a company-wide priority rather than putting all the…
Q: What would happen if database referential integrity was not enforced? What are the most probable…
A: GIVEN: What would happen if database referential integrity was not enforced? What are the most…
Q: What are the distinctions between top-down and bottom-up approaches to data security? Why is the…
A: Your question is about difference between top down and bottom up approaches to data security which…
Q: Create one glue crawler in AWS and add dataset to it from s3 bucket and check whether database and…
A: The above question is solved in step 2 and step 3 :-
Q: Devise a datasheet in access based on a subject table that allows a user to enter information about…
A: Primary key: Sub_no Alternet key: Subject code Standard fiels: Chapter_name , Teacher, level…
Q: Honda Observe the VEHICLE table above. Which of the following anomalies are possible in the table…
A: Generally, the anomalies are of three types and are Insertion Anomalies, Updation Anomalies and…
Q: Recall the pharmacy system that we discussed previously. Draw two tables, one for patient and one…
A: Dotor Table Doctor_ID Doctor_Name Speciality D1001 Dr. A Ortho D1002 Dr. B Neuro D1003 Dr.…
Q: Given the following two relations, if there was a delete request on the student Jones, list and…
A:
Q: xplain integrity rules using Bank and customer as entities
A: The entity is an object of the real world. The objects like persons, employees or accounts are the…
Q: The WorkOrders table contains a foreign key, ClientNum, which must match the primary key of the…
A: 1. To determine the update to WorkOrders table that would violate referential integrity. Given…
Step by step
Solved in 3 steps
- 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. List of only the Accounts that have multiple Clients associated Provide a count and total amount of Transactions for each Type Description PLEASE DONT NOT COPY THE EXISTING SOLUTION ON BARTLEBY IT IS WRONG AND DOES NOT WORK AND INCOMPLETE. GIVEN THE BELOW: --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)); --THIS CREATES THE TRANSACTION TABLE: CREATE TABLE Transaction ( TxNbr INT PRIMARY KEY, AccountNbr INT,…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. List of only the Accounts that have multiple Clients associated Provide a count and total amount of Transactions for each Type Description PLEASE DONT NOT COPY THE EXISTING SOLUTION ON BARTLEBY IT IS WRONG AND DOES NOT WORK AND IS INCOMPLETE. GIVEN THE BELOW: --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)); --THIS CREATES THE TRANSACTION TABLE: CREATE TABLE Transaction ( TxNbr INT PRIMARY KEY, AccountNbr INT,…PRACTICE ACTIVITY FOR JOINS (using APEX) Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad Tamil A105 A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 D103 IT BSD D104 ENG Table name: STUDENTS | STUDENTID GENDER STUDENTNAME DOB ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 6/1/1999 Male 90 D102 A102 Level 1 Hisham 22 S102 Sara 12/30/1994 Female 45 D103 A104 Diploma 27 6/1/1999 Male 5/6/1995 Male S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 10/15/1992 Male 45 D104 A101 Advanced Diploma 29 S100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 4/5/1998 Male 2/23/1992 Female S104 Faisal 90 D104 A101 Advanced Diploma 23 S105 Fatima 90 D102 A102 Level 2 29 S106 Arwa 9/12/1999 Female 45 D102 A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 0103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student…
- The InstantRide User Satisfaction team are looking forward to creating discounts for the users. However, the team suspects that there could be duplicate users in the system with different emails. Check for the users with their names and surnames for potential duplicates. Therefore, you need to JOIN the USERS table with USERS table and compare for equality of USER_FIRST_NAME and USER_LAST_NAME and difference in USER_ID fields.1. Perform a unit root test for the prices and returns for the FTSE100 on Stata and Interpret the results.In Database set the shadow size of a div having 20 px shadow and this shadow should spread upto 30 px .The color of the shadow will be green. This div should have your own name and age as heading (h3) and this heading should have 5 px shadow and it will be in white color.
- Use the sample output below as a reference to compile a list of every purchase made by customers. The following criteria should be used to sort the results: code, invoice number and product description for each client All three INVOICE, LINE, and PRODUCT groups must be linked together to complete the integration.You are asked to create a database for a busing company. You need to keep track of the differ- ent buses, each having a plate number, make year, and number of seats. You also need to keep track of drivers that work in the company. The information kept on each driver should include the license number, age, and name. Finally, you need to keep information on which drivers are allowed to drive different buses. Drivers cannot drive any bus, but rather each driver is assigned with specific buses in the fleet he/she is allowed to drive. Accordingly, a driver may be allowed drive many different buses, and a bus can be driven by many different drivers. 2. Convert the ER diagram that is found in the next page to a logical relational data model. Submit in your file the relational model you arrived at (i.e. the list of tables, their columns, indicating their primary and foreign keys). Note: You are NOT asked to create an Access Database, but rather only provide the list of tables you would have in…Warehouse Database Diagrams Tables System Tables FileTables dbo.invoicearchive dbo.invoicelineitems dbo.invoicesarchive E dbo.invoicesTerms1 dbo.invoicesTerms2 E dbo.invoicesTerms3 E dbo.vendors
- The WorkOrders table contains a foreign key, ClientNum, which must match the primary key of the Client table. What type of update to the WorkOrders table would violate referential integrity? If deletes do not cascade, what type of update to the Client table would violate referential integrity? If deletes do cascade, what would happen when a client was deleted?Adding a ReviewDate to the Ratings table in this ERD serves multiple purposes.What is NOT a reason for adding it? a.) To identify a user's most recent rating b.) To determine which rating was submitted by which user c.) To identify when a rating was submitted d.) To track user activity based on the rating datesAl-Hasmi Construction Company is having many projects. It wants to develop a database to keep track of project and employee. A PROJECT has a unique Proj-Id and PType (a project can have one or more ptype). The project is broadly classified in to Residential and Commercial. Residential recorded its Resident-Id. Similarly Commercial is recorded Commercial-Id. Commercial cannot be used as Residential. There are different type of Commercial, some of them are Industrial and Institutional. Industrial recorded its Indus-Code. Institutional recorded its Inst-Code. Sometimes Industrial can be used as Institutional. A Project is lead by exactly one Manager but a Manager can lead one or more Projects. A Manger has a unique Manger-Id. Analyze the scenario and construct EER-Diagram, include participation constraint and disjoint or overall constraint.