group b presentation
TRANSCRIPT
![Page 1: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/1.jpg)
Group B: Denise SheehyRobert Hoffman
![Page 2: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/2.jpg)
The overall objective of this project was to create a fullyfunctional database system for a online bank.
The database should allow the introduction of newcustomers along with allowing existing customers toview their account as well as obtain new productsin terms of loans and additional accounts.
To produce this database there are three main steps;Conceptual data model, Logical
data model and Physical data model
Introduction
![Page 3: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/3.jpg)
Designed for a bank which has a online presenceonly
The bank only offers personal accounts and does notcater for business customers
There are 4 account types; Student Account, CurrentAccount, Savings Account and Investment Account
There are 4 loan types; Student Loan, Car Loan,Overdraft and Credit Card
Underline Assumptions and Limitations
![Page 4: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/4.jpg)
‘Products’ refers to all services which the bank offers
Credit card bills are generated on a monthly basis
Bank statements are generated on a quarterly basis
Each customer automatically receives a debit cardand ICT ID and password when they create anaccount with the bank
Underline Assumptions and Limitations Cont.
![Page 5: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/5.jpg)
![Page 6: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/6.jpg)
![Page 7: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/7.jpg)
![Page 8: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/8.jpg)
![Page 9: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/9.jpg)
![Page 10: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/10.jpg)
![Page 11: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/11.jpg)
![Page 12: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/12.jpg)
Query One
What is the ICT ID and Password for all thecustomers with the surname Doyle?
![Page 13: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/13.jpg)
![Page 14: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/14.jpg)
![Page 15: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/15.jpg)
![Page 16: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/16.jpg)
![Page 17: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/17.jpg)
Query Two
What is the sum of all transactions which have beencarried out by Mr. O’ Connor?
![Page 18: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/18.jpg)
![Page 19: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/19.jpg)
![Page 20: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/20.jpg)
![Page 21: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/21.jpg)
![Page 22: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/22.jpg)
On completion of this project we have learned
extensively about the different stages involved when creating a database system.
One of the key learning outcomes we received from completing this database system is that before one can continue on to the next stage of the project you must first ensure the previous stage is correct, if not this will only cause errors in future stages.
Conclusion
![Page 23: Group B presentation](https://reader033.vdocuments.us/reader033/viewer/2022052912/55a1c6891a28ab6c758b46b8/html5/thumbnails/23.jpg)