Entity-relationship diagram for the banking database

Assignment Help Computer Networking
Reference no: EM131626424

Purpose of the assessment

The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially available database management system development tool.
On completion of this assignment students will be able to:

a. Model organisational information requirements using conceptual data modelling techniques.

b. Convert the conceptual data models into relational data model

Assignment Description

1. Below is the entity-relationship diagram for the banking database application, there are four relations/tables in their database describing banking application details, details of projects, work assigned for eachbranch and account, namely, BRANCH, ACCOUNT, CUSTOMER and TRANSACTION. The relationship diagram for these relations are given below.

1316_Figure.jpg

A. Write one paragraph describing the E-R diagram above in your own language
B. Implement above database on MS Access. You are required to create the above 4 tables with the given attributes. Name the database as ‘OrientalBank'.
C. Enter at least 10 data records for each table in the database you created in (a) above. Here you have to enter data into all 4 tables.
D. Write 4 examples of report cards that can be generated using the ‘OrientalBank' database.
E. Write down the shorthand representation (database schema) of the structure of a relational database for the above E-R diagram
F. What is a primary key? What is the primary key for each table in the ‘OrientalBank'database.

2. Write SQL queries for the following questions and execute the queries on the ‘OrientalBank' database you created above using MS Access.

A. Creating the four tables.
B. How many accounts have abalance greater than $500.
C. Display the Name, of all accounts with a balance greater than the average balance.
D. Find the ID, Name, Transaction number, date and typeof the second account.
E. Find details of customershaving their account in the second bank branch.
F. List the numbers and names of all customers.
G. List the complete account table.
H. List the account number and name of all customers that haveopened their accounts in the second branch and that have a balance less than $1,000.
I. List the number and name of all customers that haveopened their accounts in the second branch or that have a balance less than $1,000.
J. List the number and name of all customers who have opened an account in the "Melbourne city"branch.
K. Find the total of the balances for all accounts.

3. Write the 1NF, 2NF, 3NF for the below data.

HEALTH HISTORY REPORT

PET ID    PET NAME              PET TYPEPET AGEOWNER VISIT DATE            PROCEDURE

246          ROVER                   DOG           12            SAM COOK        JAN 13/2002           01 - RABIES VACCINATION

                                                                                                                MAR 27/2002          10 - EXAMINE and TREAT WOUND

                                                                                                                APR 02/2002           05 - HEART WORM TEST

 

298          SPOT                      DOG           2              TERRY KIM        JAN 21/2002           08 - TETANUS VACCINATION            

                                                                                                                MAR 10/2002          05 - HEART WORM TEST

 

341          MORRIS                 CAT             4              SAM COOK        JAN 23/2001           01 - RABIES VACCINATION

                                                                                                                JAN 13/2002           01 - RABIES VACCINATION

 

519          TWEEDY                                BIRD           2              TERRY KIM        APR 30/2002           20 - ANNUAL CHECK UP

                                                                                                                APR 30/2002           12 - EYE WASH

Verified Expert

The solution file is prepared in ms access and word. Created 4 tables and inserted records . Created queries and report based on requirements of client which includes er diagram explanation , normalization and different queries. The word file has all queries of screen shot and answers.

Reference no: EM131626424

Questions Cloud

How much will you owe in taxes to the british government : You are a British investor who bought 500 shares of Acumen Conservative Portfolio fund a year ago for £94.50 (Pound sterling). During the year, you received £3.
What is true about demand : If as price decreases by 8 percent, total revenue increases by 5 percent, what is true about demand?
The media segment the therapeutic alliance : Select an essential characteristic that you believe will be an area of strength for you and one that you believe will be a challenge.
Absolute value of the price elasticity : In response to a prce decrease from 27 to 22 sales qty increases 13200 to 14800 calcuatente absolute value of the price elasticity of demand.
Entity-relationship diagram for the banking database : MN405 - develop skills in managing data in databases and to gain understanding of data model development and implementation
Terms of trade and comparative advantages : Describe in a one to two paragraph short essay the terms of trade and comparative advantages discussed in 1 Kings 5.
Explain each precaution using a specific example : What is meant by the term 'stagflation'? What happens if stagflation occurs within the economy in terms of consumer spending and consumer confidence?
Would taxes be important consideration in investment advice : The Reverend Mark Thomas is the minister of a church in the San Diego area. He is married, has one young child, and earns a "modest income."
Define fiscal policy in general : Define fiscal policy in general and discretionary fiscal policy in particular. Identify the tools of implementing fiscal policy and the goals intended.

Reviews

inf1626424

10/25/2017 5:02:32 AM

Good job. On time. I have HD for it. Recommended to do business with. Very satisfied this job . great service bit honestly i think it is not too expensive and i don't think ill not be able to use it regularly. thanks for such help.

inf1626424

10/25/2017 5:01:22 AM

Any discount as I refer one of my friend. I need this assignment today not friday I paid my fees .please start your work and make sure to deliver it as soon as possible. But status shows payment is pending. okay its fine now... in part B you have to create four tables on the basis of A like Custmor, branch,transaction and account.In part D we have to write four exampkes. Please take time and make it good according to the requirements as the time of my assignment is extended.If I get good grades I will definitely make rest of my assignments from you guys.

len1626424

9/4/2017 7:16:32 AM

Analyse Logic is clear and easy to follow. Consistency logical and convincing. Mostly consistent logical and convincing. Adequate cohesion and conviction. Arguments are confused and disjointed. Design /Presentation All elements are present and very well integrated. Most of the components present and integrated. Components present and mostly well integrated. Most components present. Report lacks structure. Evaluate/ justification Excellent outstanding effort made. Extremely good effort. Good effort made but not outstanding. Made some effort. Very little attempt. Lazy effort with inaccuracies.

len1626424

9/4/2017 7:16:26 AM

Marking Rubric for Assignment 1 –Part B: Total Marks 60 Excellent Very Good Good Satisfactory Unsatisfactory Query writing skills Evidence of accurate and well- written queries Evidence of good query writingskills. Generally relevant. Displayed reasonable query writing skills. Demonstrated little evidence of understanding the topic. Identification Demonstrated excellent ability to think critically. Demonstrated anability to think critically. Demonstrated reasonable ability to think. Demonstrated some ability to think critically but not complete. Did not demonstrate ability to think critically.

len1626424

9/4/2017 7:16:14 AM

Assessment Title Managing Data in Databases Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially available database management system development tool. On completion of this assignment students will be able to: a. Model organisational information requirements using conceptual data modelling techniques. b. Convert the conceptual data models into relational data model

len1626424

9/4/2017 7:16:07 AM

This assignment consists of threeQuestions: Question 1:Designing a database using the Ms-Access. Question 2: Implementing the SQL Commands Question 3: Normalisation • All work must be submitted on Moodle by the due date. • The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings. • Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style.

Write a Review

Computer Networking Questions & Answers

  Networking and types of networking

This assignment explains the networking features, different kinds of networks and also how they are arranged.

  National and Global economic environment and ICICI Bank

While working in an economy, it has a separate identity but cannot operate insolently.

  Ssh or openssh server services

Write about SSH or OpenSSH server services discussion questions

  Network simulation

Network simulation on Hierarchical Network Rerouting against wormhole attacks

  Small internet works

Prepare a network simulation

  Solidify the concepts of client/server computing

One-way to solidify the concepts of client/server computing and interprocess communication is to develop the requirements for a computer game which plays "Rock, Paper, Scissors" using these techniques.

  Identify the various costs associated with the deployment

Identify the various costs associated with the deployment, operation and maintenance of a mobile-access system. Identify the benefits to the various categories of user, arising from the addition of a mobile-access facility.

  Describe how the modern view of customer service

Describe how the greater reach of telecommunication networks today affects the security of resources which an organisation provides for its employees and customers.

  Technology in improving the relationship building process

Discuss the role of Technology in improving the relationship building process Do you think that the setting of a PR department may be helpful for the ISP provider? Why?

  Remote access networks and vpns

safekeeping posture of enterprise (venture) wired and wireless LANs (WLANs), steps listed in OWASP, Securing User Services, IPV4 ip address, IPV6 address format, V4 address, VPN, Deploying Voice over IP, Remote Management of Applications and Ser..

  Dns

problems of IPV, DNS server software, TCP SYN attack, Ping of Death, Land attack, Teardrop attack, Smurf attack, Fraggle attack

  Outline the difference between an intranet and an extranet

Outline the difference between an intranet and an extranet A programmer is trying to produce an applet with the display shown in Figure 1 below such that whenever one of the checkboxes is selected the label changes to indicate correctly what has..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd