Ask a question from expert

Ask now

Data and Information Management

16 Pages1156 Words242 Views
   

Added on  2019-11-20

Data and Information Management

   Added on 2019-11-20

BookmarkShareRelated Documents
qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuioData and Information ManagementManaging Data in Databases
Data and Information Management_1
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
Data and Information Management_2
Figure 2: Branch Data TableFigure 3: Account Data TableFigure 4: Transaction Data Table
Data and Information Management_3
C.Following are the screenshots of the 4 tables after entering 10 data records in each table:Figure 5: Customer TableFigure 6: Branch Table
Data and Information Management_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Fundamentals of Database System
|10
|1933
|432

MN405 Data and Information Management
|15
|1303
|122

Database Design and Use
|29
|3676
|113

Database Design and Implementation Assignment
|19
|811
|294

Database Design for Food Delivery Service
|8
|646
|458

Database Management Analysis 2022
|45
|7918
|27