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 database application where various customers has their accounts. The customer has been given an id which is the unique identification of the customer. The customer can have their account in various branches of the same bank. Every branch has its own unique code and a name. A distinct account number is provided to every customer that holds their private transactions such as Account Type and Balance. All the transactions made by the bank customers are recorded in the bank database and every single transaction made by any of the customer possesses a unique identification number. The date and type of transaction is recorded and if it is monetary transaction then amount used is also recorded in the database. In brief it depicts that, a customer has an account in some branch of the given bank and performs 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. All the four tables were created with the desired fields and same has been shown thorugh screenshots using snippin tool:Figure 1: Customer Data Table
Figure 2: Branch Data TableFigure 3: Account Data TableFigure 4: Transaction Data Table
C.Following are the screenshots of the 4 tables after entering 10 data records in each table:Figure 5: Customer TableFigure 6: Branch Table
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Fundamentals of Database Systemlg...
|10
|1933
|432
MN405 Data and Information Managementlg...
|15
|1303
|122
Database Design and Uselg...
|29
|3676
|113
Database Design and Implementation Assignmentlg...