YouTube channels host branded video messages, thus offering…
Questions
YоuTube chаnnels hоst brаnded videо messаges, thus offering an organization a form of _____ media.
We use the sаme dаtаbase schema as Assignment 2. Specifically, the database has five tables, whоse schema is shоwn belоw. Primary key attributes are underlined and foreign keys are noted in the superscript.• Customer = {customerID, firstName, lastName, income, birthDate}• Account = {accNumber, type, balance, branchNumberFK-Branch}• Owns = {customerIDFK-Customer, accNumberFK-Account}• Transaction = {transNumber, accNumberFK-Account, amount}• Employee = {ssn, firstName, lastName, salary, branchNumberFK-Branch}• Branch = {branchNumber, branchName, managerSSNFK-Employee, budget} Notes:• The customerID attribute (Customer) is a unique number that represents a customer, it is not a customer’s SSN• The accNumber attribute (Account) represents the account number• The balance (Account) attribute represents the total amount in an account• The type (Account) attribute represents the type an account: checking, saving, or business• The transNumber attribute (Transactions) represents a transaction number, combined with account number it uniquely identify a transaction• The branchNumber attribute (Branch) uniquely identifies a branch• The managerSSN attribute (Branch) represents the SSN of the branch managerWrite SQL queries to return data specified in the following questions, which have to satisfy the following requirements: The answer to each question should be a single SQL query. Every column in the result should be named. So if the query asks you to return something like income times 10, make sure you include an AS statement to name the column. While your question will not be assessed on their efficiency, marks may be deducted if unnecessary tables are included in the query (e.g., including both Owns and Customer when you only require the customerID of customers who own accounts). 1. Write the DDL query for creating the Transaction table, where the primary key and foreign key constraints must be explicitly stated. You can assume both transaction numbers and account numbers are integers, while the transaction amount is represented as a decimal number showing the dollar amount which must be precise to cents ($0.01). Please assume the Account table already exists. [4] 2. In regards to the account table mentioned above, assume the account 100011 has a balance of 4500, Now state what will be the final balance of the account after the following updates. [4] set autocommit = 0; commit; update account set balance=100 where accNumber ='100011'; update account set balance=500 where accNumber ='100011'; rollback; update account set balance = balance + 1500 where accNumber ='100011'; commit;