MANAGING DATA IN DATABASES1Table of ContentsQuestion 1: Design of the database in MS Access...........................................................................2A. Description of the provided E-R diagram....................................................................................2B. Creation of 4 tables in MS Access................................................................................................2Table Customer................................................................................................................................2Table Branch....................................................................................................................................3Table Account..................................................................................................................................3Table Transaction.............................................................................................................................4C. Input of data................................................................................................................................4Table Customer................................................................................................................................4Table Branch....................................................................................................................................5Table Account..................................................................................................................................5Table Transaction.............................................................................................................................6D. Examples of report cards.............................................................................................................6Report 1...........................................................................................................................................6Report 2...........................................................................................................................................7Report 3...........................................................................................................................................7Report 4...........................................................................................................................................8E. Shorthand representation of the E-R diagram............................................................................8F. Definition of primary key and primary key of each table in ‘OrientalBank’ database................8Primary key of each table in the database......................................................................................9Question 2: Implementing SQL commands.....................................................................................9Query for A......................................................................................................................................9Table customer................................................................................................................................9

+13062052269

info@desklib.com