Data and Information Management Managing Data in Databases

Added on - 20 Nov 2019

  • 16


  • 1156


  • 78


  • 0


Showing pages 1 to 4 of 16 pages
qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuioData and Information ManagementManaging Data in Databases
Task 1A)In the given Entity-Relationship diagram, there are four main entities Customer, Branch, Transaction andAccount. The purpose depicted from this ER diagram is: It shows the operations of a banking databaseapplication where various customers has their accounts. The customer has been given an id which is theunique identification of the customer. The customer can have their account in various branches of thesame bank. Every branch has its own unique code and a name. A distinct account number is provided toevery customer that holds their private transactions such as Account Type and Balance. All thetransactions made by the bank customers are recorded in the bank database and every singletransaction made by any of the customer possesses a unique identification number. The date and typeof transaction is recorded and if it is monetary transaction then amount used is also recorded in thedatabase. In brief it depicts that, a customer has an account in some branch of the given bank andperforms transaction on his account which all gets recorded in database.B.The database has been created using MS ACCESS and the database has been named as OrientalBank. Allthe four tables were created with the desired fields and same has been shown thorugh screenshotsusing snippin tool:Figure1: Customer Data Table
Figure2: Branch Data TableFigure3: Account Data TableFigure4: Transaction Data Table
C.Following are the screenshots of the 4 tables after entering 10 data records in each table:Figure5: Customer TableFigure6: Branch Table
You’re reading a preview

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document