Ask a question from expert

Ask now

MN405 Data and Information Management

15 Pages1303 Words122 Views
   

Melbourne Institute of Technology

   

Data and Information Management (MN405)

   

Added on  2020-02-19

MN405 Data and Information Management

   

Melbourne Institute of Technology

   

Data and Information Management (MN405)

   Added on 2020-02-19

BookmarkShareRelated Documents
Running head: MANAGING DATA IN DATABASESMN405 - Data and Information ManagementAssignment 1 (T2 2017)Student Name:University Name:
MN405 Data and Information Management_1
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
MN405 Data and Information Management_2
MANAGING DATA IN DATABASES2Table Account..................................................................................................................................9Table Branch....................................................................................................................................9Table Transaction.............................................................................................................................9Query for B.......................................................................................................................................9Query for C.....................................................................................................................................10Query for D....................................................................................................................................10Query for E.....................................................................................................................................10Query for F.....................................................................................................................................10Query for G....................................................................................................................................10Query for H....................................................................................................................................10Query for I......................................................................................................................................11Query for J.....................................................................................................................................11Query for K.....................................................................................................................................11Question 3: Normalization.............................................................................................................11Un-normalized form......................................................................................................................11First Normal form..........................................................................................................................12Second Normal form......................................................................................................................12Third Normal form.........................................................................................................................12Bibliography...................................................................................................................................13
MN405 Data and Information Management_3
MANAGING DATA IN DATABASES3Question 1: Design of the database in MS AccessA. Description of the provided E-R diagram The E-R diagram that has been provided reflects that there are four relations/tables inthe database describing banking application details, details of projects, work assigned for eachbranch and account, namely BRANCH, ACCOUNT, CUSTOMER and TRANSACTION. Therelationship between the entities shows that Customer holds an Account and each Account iscontained in Branch. Transaction is performed within Account. B. Creation of 4 tables in MS AccessTable Customer
MN405 Data and Information Management_4

End of preview

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

Related Documents
Data and Information Management
|16
|1156
|242

Database Design and Use
|29
|3676
|113

Fundamentals of Database System
|10
|1933
|432

Music Artist Management System : Assignment
|15
|1577
|47

Database Structure And Design Assignment
|15
|1031
|28

Database Design with MySQL | Assignment
|9
|739
|235