How Can I Sign Hawaii Banking Presentation

Help me with industry sign banking hawaii presentation online

and good morning everyone hi my name is neet so this is the final project of database so the name of the database project is online banking system so this is a name of our teams so the name of our teams is the first one is muhammad and ilham bin shahidi and the second one is me and that one is muhammad sophie adam yusuf so we go to the introduction so the introduction of the online banking system is online banking also known as internet banking or web banking is electronic payment system that number customers of a bank or other financial integration to conduct a range financial transaction through the financial integrations websites so this is with online banking we can pay anything and buy anything with easy way so that is our introduction of the online baking systems and the second part is the problem statements the problem statements we have the a lot of the problem statements but we have um we take the main of the problem statements that have the three three ways uh the first one these are all transactions need more time to do because they're still using file that will take time to do the transition for all people you see this still using the file to do this transition with the take time to do the transition second part is the old transaction cannot do transaction add-ons so this will make it difficult for people like traders will often use payment as a business so the third part is the all transaction need more space to put file and difficult to maintain this way okay the part is the next is the objective of the project so the objective of the project is to develop bank customers and users to use the online banking system to provide the foundation services for a full range of mobile based on banking services so the management of the online banking system must have a good system to to for all people can use this online banking system transaction so that's the objective or the online banking system for for the online banking systems so next is next is two different scope to be identified so we have the two scope here so first scope is first code is the electronic gadget can be used to transfer funds right directly and the second part is use the electronic can fund transfer and deposit directly into your car your accounts so this is our scope to be identified so the next one is the project significations so the project signification is based on the project certifications through the motivation and inspiring for the online banking project are the consumer not required to visit a bank branch to complete most of their basic banking transactions they are they can do all of this at their own convenience whenever they want and stay at home at work and so on so this is help people to do their transaction more easy so we can do the transaction where we want so like at home and work at work and so on so this is very very very very lovely to us like now is coffee 19 you can use that and do the transaction more easier so the next part is the business rules okay this is uh our business rules okay the business rules a user has one or many accounts an account is belong to one and only one user and the second part for the payment a payment is made using one or one account and account is used to make one or more payments a transaction for the transaction a transaction is made using one or many accounts an account is used in one or many transaction and for the receiver is a receiver is involved in many transactions in the transaction has involved only the one receiver and the next one is the bank so a bank has a many receivable account and receiver account belong to only one bank so that is our business rule for our projects next one is the project erd okay so the project erd you can see here the first is the accounts so the attribute account go to the user and transaction and payment here so the account for the account ssc number is as the premier primary key and the user id as the foreign key and the user user id as the premium primary key in translation and then go to the transaction transaction id as the primary key and the sec number as the foreign key for the receiver receiver receiver id as the primary key and the bank id is foreign and go to the bank and bank id as the primary key so here are the for the account go to the payment and payment for the payment attributes is a payment id as the primary key and the bill sec account as a foreign key and go to the last one is the bill then prior my key is the biller account bill account so that is the our project erd go on so next is the data dictionary so we have the seven data dictionary first is accounts receivable bank user transaction payment and bill so we can go to on okay this is our user so on data dictionary of user so user you can see here on the user id as a primary key and they have a lot of attributes here so and next is the translation and translation id as the primary key you can see here and have seven uh translation here attributes so the next one is the accounts okay account you can see here account number as a primary key so and the user id as a foreign key so the next one is the bank this is our bank bank attributes this is a bank id as a primary key and next one is the b b as a primary key to and they have a billion name as attributes and next one is the receiver so receiver id as a price hello and assalamu alaikum my name is muhammad ilham bin today i will print i will present about the sql data definition language or ddl okay so now i will explain the sql data definition language or ddl firstly this ddl has a grid table user this create table user has a user id support the data type and number in column 12 and has a null command second has a first name was supported data type by watching 2 in column 25 and has a not now that has a last name watcha 2 25 and not now and then this this table user has a date of birth or d o p was support that data by the update and and the command is not now this table this table used a user has an address for support the the data was default that attacked by watch out to 35 into the 35 and has a note now this click table has a email bachatu 25 not not and lastly has an account password char then and has a not null and the lastly has a primary key prime family gif remember key in call in column user id and lesson and don't forget the semicolon secondly has a great table great table account data definition language that has a great table builder for as a creative payment okay okay today i will continue the sql data definition language or ddl okay sql data definition language or ddl has a grid table receiver and then sql data definition language by our project has a three table transition and lastly has a free table for bank okay now i will present the sql data manipulation or dml the sql data manipulation has a three three types that is a insert update and delay alright today i will explain the sql dml for insert are this question one's five insert a queries question and sql statement notes insert add at least five rows of the data for each table okay firstly this instant has a file uh has a five five five insert in the every table instead insert table user has a user id first name last name letter of faith birth or dob address email and account password secondly this project this this our project has a insert table account this this and the insert table account has an account num number account type account amount and user id user id is a foreign key and from the user this our project has insert table for transaction the the table under insert tablet for translation has a transition identification um i translation of amount date translation receivable account and account number account number that is prompted from the term from the table account okay my my our project has an insert table billion instead tableville has a villa account and biller name this our project also has an insert table payment reset table payment has a payment identification payment type payment biller account payment amount okay example payment payment first first uh first row at the payment id is a 0 9 9 7 7 the the payment type is a debit bill account as a 8766 and lastly the payment amount is one one thousand eight hundred okay and the third last and the second last uh my our project has a insert table for bank there is a table for bank has a bank identification and has a bank bank name okay example uh the first the first row at the at the vertebral table bank as a at the bank identification four two three six seven that is the bank bank id and the bank name at the end and the bank name is a mini bank last the last the fourth insert of dmf is a insert table for receiver instead table for receiver has a three there's a receiver of identification receiver name and bank id bank id is a foreign key from the table bank okay okay all right after the insert table so we go through the update table the update table there are five five update qr five are the query and questions okay the firstly this update table has an update table for user the question is change the first name of user with user identification five six seven seven to hurry first name and and verify the change made to the table okay okay this uh first name is uh the jahari and the user id is five six seven seven okay second this update has an update table account update the question for the updateable account has exchanged the account type of account with user identification 997.9917 to loan okay and verify verify the change made to the table okay update table yeah this is sql sql sql first is update account set the account account type to loan where user i am where user id is 9919917 okay next okay well next table also has a table update for biller the the question of the update table wheeler is a convert the name of billy with pillar account 2 2 4 1 to last food verify the change made to the above to the table but the sql is uh firstly our sql for that updateable firstly is update table firstly master write that update table the second set biller name nice food and thirdly where biller account where biller account is 2241 and lastly don't forget put the semicolon okay this uh this answer is this two two four one and the change name is a billion name is a nice word okay the next the table also has a as a table a table update for for table upfront for table payment the question of the table payment is a convert the amount of payment with payment identification k9 7662 by 5100 verify the change made to the table the sql is an update payment here firstly the address from the sql is the update payment secondly set payment amount and the payment amount is of 5100 and lastly where payment id of payment identification is the k9 766 okay next okay the lastly for the update table is the update table for update table for transition okay the the query or question for the update table is to change the amount of transition with up we would be for date transition at zero six day a day june 2018 and with transition identification is the a 65 4 3 2 0 9 1 2 2 1 2 1 0 0 mount and verify the change made to the table okay firstly uh update table from the sql is the update now firstly must have an update translation second must have a set uh set amount is the 100 one and last name must have a one that translation zero six uh six six six day monday june 2018 and translation identification or transition id is m89 m86543209112 okay the first uh the first delete statement is the question is a delete a receiver which is a receiver name and the asman from receiver table verifying the change made to the table okay the sql is i show the delete from the table receiver where receiver name is equal as month so the sql sql result which much upper the assured receiver must have the receiver identification receiver name and bank id okay the second upper the question is delete a payment which is a payment identification is zero nine seven three four five we x verify changes made to the table so the sql is there delete from payment one payment payment identification equals 0-97345 px so the result is a payment identification payment type bill account and bill amount okay lastly for the simple and complex statement is the is the table delete okay table delete has the five delete queries and question and must include the sql statement okay the first the first delete table is the the question is that delete a transaction which is a date is a 10 then march 2020 and verifying chess made to the table okay the okay the sql from that sql from the delete delete transition is a delete from transition and second when where where that transition then much much 20 20 uh 2020 okay that is the okay that is uh the answer for ourselves for the after sql okay go through the delete query of question and sql statement okay the the question is location of the delete table from bank is the delete delete a table a bank which is a bank name is in uob bank from the table bank table explain the result you get after processing this query okay okay firstly i firstly my sql is a delete from bank where bank where bank name is the uob bank and then after event and then and then the result is a god uh quite uh error okay okay i will explain why why the why why result is what is error okay because the explanation is the result the result is error because we cannot delete data usb bank from table bank because the data from table bank they will bring a foreign key to table receiver okay like okay the last from the delete delete statement is the delete statement is the delete for the user from user is a delete user which is a last name as me from the user table and then explain the result you get after processing this query okay okay from the from mysql the sql is the delete from user and the second while last name is ask me and then and then the result is got uh error okay why error because what error okay i will explain that i will explain that as i will explain that i i will explain it the result is error because we cannot delete data as me from table user because the data from table is a foreign key to table account okay so so that also data from the table user of warranty to table account okay all right so now i i will continue the sql data manipulation language or dml sql data manipulation language must have a has a relational algebra and select statement okay okay next firstly that is a five data queries and question for the selection the selection and projection operation okay the the first ah the firstly the first other firstly the question is the list all the transaction with amount greater than 200 okay the okay the ask you at the front and the sql is the seller transition where amount greater than 200 and don't forget to put the semicolon okay that is our result result result answer it's pretty answered the amount they said the amount is the 2 600 240 300 and 500 and then the relation algebra that is a relation algebra for this question okay the next is the the question is the two to retrieve information of payment identification a0997 which type is debit okay the relation algebra is the bracket symbol selection payment underscore type equal comma debit and symbol n payment underscore either identification or payment id equal a a09977 close bracket and open bracket for the table payment okay close bracket okay the next again that is uh sql sq the sql select from payment okay the second is the web payment and a payment payment type equal is a debit and payment identification a0997 okay this uh the answer is uh this uh the result is this result identification is that 800 997 [Music] 8766 okay the next is a question or query is that to produce a list of one for all translation showing only transition identification date transaction receiver name and amount details the relation algebra is the the the sim address projection symbol transition and translation identification date salary receivable account receivable amount and and bracket in the bracket from the table transition and close bracket okay the the sql is the sql is the select translation id translate translation receivable account and amount and then lastly it is from transition and the result is the must have a must have the transition id translation data transition receivable account and amount okay next the query of question is tha to retrieve the account identify open bracket identified by account number close bracket whose amount above 2 000 the relation algebra is the symbol symbol projects i must have a symbol projection and then sec underscore underscore num number and account and and have the must have the x sec underscore amount or account amount and open bracket and open bracket must have this symbol selection and has a and has an account amount and then it has a symbol greater than 2000 and close bracket and open bracket from table amount sorry from table account and cost lose bracket okay the sql the sql is the select select account account num account account number and account amount from account where account amount credit graded greater than 2000 okay the lastly for the the selection and projection operation question is the to get a monthly amount for all transition together with transition identification and date okay the relation algebraicer must have the projection symbol transition underscore identification or transition id and has a did underscore transition and and the group and and the open bracket salary over over 12 over symbol f12 and close bracket and open bracket from from staff table and close bracket the sql is the select transition underscore id underscore transition and and open bracket amount over 12 close bracket and the from and lastly was from the table that is a table from transition okay the result is there has a transition identification date transition and amount over over over over year over okay the next is the five the that is a topic the aggregation and grouping operation okay the first the first question of theory is the find the minimum of transition amount that is a relation algebra and then that is a and that is a sql the sql is the select mean mean is a minimum minimum minimum of transition and transition of amount and then break and then open bracket amount and close bracket as the my mean and then and then from and then the lastly is the from transition table from translation table okay the answer okay the result the result from the sql is the my mean is 100 for the minimum transition mind so the minimum translation is a 100 okay all right define the number of translation identification and sum of a moment on the date at one march 20 2020 until 12 in november 2020. there is a relation algebra okay and then the second and the last is uh the third is the sql statement the sql statement must have the select count open bracket translation underscore id or identification close bracket as the my count and then must have the sum open bracket amount close as my sum from transition table all right and then lastly must have the where did underscore translation between between is until november 2020 so the result is the quad the micron and the micron is the five and then the my sound i have the my sum sum of the amount is the 16 640 okay is the the next uh is uh the the query or question is to find the number of translation identification of translation of the translation they were in each account and there are total amounts all right secondly that is a there is a relation algebra okay and then uh that uh is the sql statement the sqs sql statement must have the select account num economy is an account number and then second account and then come for the translation id okay as the my count and then sum and then and then some for the amount and then as the my sum okay the table from the table translation from okay group by group by the account num or sec num so the answer is the quarter sec num num num that is my account and then lastly got the my sum my my some results is to get the number transition identification or transition in each account and their total amounts there is a relational algebra okay the the sql is the select account num number count translation item underscore identification as my account sum amount as my sum the table from the transition group by all right the last of the aggregation and grouping operation the question is that find the number of transition identification who earn more than 300 amount in each account this and the sum of the amounts okay the second is that is a relation algebra okay the third is a sql statement sql statement must have the select account number or sec num and then must have the account count for the translation i translation identification and as a and then they call it as a smi count and then and then and then has a and that has a sum of amount as is my sum okay we call it as a sub as a my sum okay the table from the transition where where amount where amount greater than 300 okay group by account number order by account number ok the next okay the top okay then okay the next is the five data query of question let's let's involve the inner and outer join operation there is a topic from the inner and outer join operation okay then firstly the question location location this part is the list name of all user whose has an account bank with any any account type okay the wanna the the relation algebra is the user dot user id equal account dot user id open called open bracket open bracket cell projection symbol must have the symbol projection and then has a user id first name last name and open bracket from table user close bracket and has a table a hand has a has a symbol join symbol join and then open bracket has a open bracket i must have the projection symbol user id account type and and has a and then open bracket has a table from account and then close bracket the sql has the sql has a select u dot user id first name and last name in a dot account that's a means or the account from the account and then account and then has an account type from there from eastern and then from the table user that is you and from that and then from the account that is a they call it a where a dot a a dot user id equal u dot user item notification or user id the answer is that is the answer answer is now must have the user id list the user id place the first name last first last name icon account number and account type okay the okay the next is there the along with any unmatched payment payment okay this yeah this is use the left join okay this relation algebra has a projection symbol as a payment identification payment type payment account and open bracket from payment and close bracket and then has a symbol left join and then and then join and then from a join pillar okay the sql is the select select p dot uh and then b dot p is mean from the payment b that is from biller from v and on and then and then the last uh last name has a on b dot biller underscore account equal p dot pillar account so that is the answer answer for left join answer for left join from the sql the question is at least at least complete detail of payment who made pay type by credit okay the payment okay payment that is a symbol a simple charge symbol join symbol symbol on payment.biller dot payment.biller account equal biller dot biller dot builder an account underscore account open bracket and then must have this symbol selection payment underscore type equal credit and then equal and then open bracket biller clause and then close bracket okay the sql must have the select payment dot not from payment join join biller on pay on payment dot biller account equal dealer [Music] [Music] ready so that so the answer is got the payment payment identification payment type bill account and pillar amount so the payment id payment id is lk9978 the payment type that is a credit and then bill account 6878 and then the payment amount is the 980 okay okay the next is the question is that can at least complete details of transition or use account type variant okay the relational price transition join transition.account num number equal account dot account number open bracket must have the selection symbol and then has the account underscore type equal rental close open open bracket account from table account and then close bracket so the sql has the select translation dot dot from transition join account on transaction dot account number equal account number where account dot account type is rental so this i saw the result is got the transaction id 9456 the amount is 600. the transaction is 9 november 2020 receiver account is the 987456731 the account number is nine 6600 nine nine twenty five six twenty one okay the lastly of the inner or and the outer joint operation is there the question is the for each transition please list number of transition account and who made amount with among the accounts the relation algebra is the open bracket has a symbol of a symbol projection transaction i underscore identification as the account number icon type amount open bracket transfer table from transition close bracket and then hack and then has a table and then has it and then has a symbol symbol join as a transition dot account number equal account dot account number so the yes and so that is a sql sql statement and then got uh and then got the result must uh must uh must display and then got that result from the sk from the sql that is uh translation and identification account number account time and amount the last topic of the sql data manipulation language or sql dml top and last topic is the the next uh or subscribe operation okay the first question is the final payment whose amount is larger than amount of at least one payment at type at type transfer okay the okay okay the second that is a relation algebra okay the third is the sql statement the sql statement is the select must have the select underscore identification payment type payment amount and then from there and then from the payment where payment amount greater than any open bracket select payment underscore upon payment underscore amount from payment where payment type is the trans equal transfer so the answer got the payment type so example the result is the payment type is the [Music] nm98763 the payment type is the payment type is a credit a repayment amount is a six thousand the second payment id is the k9766 and then got the payment the got the type is the saving and then got the amount is a 5100 and then the the third is a the third uh the third is i didn't i didn't identification is they got the iv four four five six and then payment type is a debit and then payment and then the amount is at three to three thousand three hundred and then the last got the zero nine seven three four three four four five vx the type is a transfer and then the amount is a 3900 all right the second is the okay the second is that get at least who made a payment and billing name at the tt market okay then uh again second this is this uh relation algebra okay the as i get that is the uh the sql statement as their sql statement the show is uh it uh it is the select payment underscore identification payment amount payment type from payment web builder account equal open bracket select pillar account from filler web builder builder name equal that is a tt market so that's the answer at the sql is the payment identification so the payment identification nm98763 the the amount is at 6000 and then the type is a graded okay the okay the question uh the third uh the question thirdly is uh display the account number type and amount of account which have a maximum maximum account so uh so the the color yellow is the relation algebra okay the the last the last thing is the sql statement the sql statement must error must show must have the account number or an account type account amount from the table account where account amount equal equal is the open bracket select maximum maximum decimal percent maximum account maximum open bracket account amounts and then and then cross bracket from account from table account so the seller so i will explain the select maxis max max the account the mac find the max account amount so the sql the sql result got the account now uh the account number for the first link got the account number seven eight two three five zero four two three zero four four and then the type is a income income type and then the amount is six thousand okay the second last is there find uh define that earth amount greater than one one april 2020 so for so this question want to find the date did uh that month but greater than than this date then did so second that is a relation algebra direction algebra is the open bracket and then has a symbol projection date transition and then amount close bracket open bracket selection amount greater than open bracket selection of node selection sorry the projection amount close bracket open bracket selection date translation equal 1 1 1 april 2 2020 and then open bracket translation from table translation and then close bracket so the sql statement is the select that transition up and then amount from the from and then from the table transition where amount where amount greater than then select greater than open bracket select amount from transition where that transition equal is a one one april 2020 so got that now so the answer the so the sql is the date translation and then and then the and then the and then the amounts okay the lastly the last leaf the lastly is the the question is that display the account number type for all account that amount is greater than the average amount for all account so the second the second the the the color the color table is uh the color white table is the relation relation algebra for for these questions okay the third is the sql is a sql statement the sql statement has the select account number account type account account amount and then minus open bracket select average open bracket account amount close bracket from account an end close bracket as a and then and then and then call it as the average amount and then and then from that and then from the table from the table account and then where and then after that when where where account account amount greater than open bracket salary average open bracket account amount close bracket from a from table account so the so that the answer is the account account num is the 90146 4211322 the account type is an income the average amount is there one that is so that the so-called average amount amounts okay the second account number is the 782350 four three three zero four four and then the type and the type is the income and then the amount and then the second and the second the amount is three one three upper three thousand one 157 point one two zero one one two four one four two eight eight five one one four one one one four two eight five okay okay so that that's uh so that's it for this and that's uh that's for all uh that's all for me my my part hi my name is mohammad free adams i'm from s3 g2 okay today i want to talk about conclusions okay first is con system contributions online making also called as an internet banking allow the customer to use all the banking service from a computer which has internet access the customer can perform financial taxation on a secure website operated by the bank online banking offers futures such as bank statements loan applications fund transfer e-bill payments and account uh regression allow the customer to monitor all their accounts in one place okay so you have five contributions of online banking system okay the final contribution is pay your bill online you can use your bank's website to pay your bills online and never worry about your check getting lost in the mail most banks have a section in which you set up pages you will need to fill out the information once and then you can simply choose the payer every time you want to pay from the company second is view your transaction online banking allows you to access your account history and transactions from anywhere this is the quickest way to see whether a stun station has cleared your account it also enables you to find out about any unauthorized transactions more quickly so you can dispute them right away so anyone or everybody who want to like you you can you you you can know okay number three transfer money between accounts you can quickly transfer money between accounts which when you do it online it's more convenient that going to a bank in the person of using an automated phone service which requires you to provide information when prompts prompt okay number four bank on your phone with a mobile app most banks offers a mobile app that allows you to more easily take advantage of online banking on your phone you can quickly check up your on your accounts when you are out shopping transfer funds so you don't end up overdrawing or make sure a merchant has double charged you double charge you okay number five the last one is since we do your budget application money many budgeting apps such as min and pocket that can be seen with your online banking information that future makes sticking to your budget more easier okay okay uh if you have a spouse or partner you share bank and credit card account with you might want to look for an app that enables you to easily sense your info with each other better have home budget and honey you for example a budgeting apps design specification specifically for couple or household okay but the more is system drawback strategy and service instructions anytime we use computer or internet service we are at the mercy of the systems stability and efficiency your ability to access account online will naturally be affected if your internet service is running slowly and complete completely out of completely out for a period of time similarly if the bank servers go down or are temporarily unavailable due to the shadow site maintenance you won't be able to gain online or mobile access to your banking information then limitations on deposit daily or monthly mobile deposit limitations may make it difficult for individuals but especially businesses to make large deposit online once you have published your designated limit you will need to track to a branch to deposit money also not all types of cheques are easily read by computer scanning software for example business checks that are highlighted and have a black line of the riverside to make a carbon record in an account register may be kicked out of the onion deposit system requiring and on the onsite deposit [Music] you