$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

MN405 Data And Information Management

tag 1 Download4 Pages / 865 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

1. 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.
Convert the conceptual data models into relational data model
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.                
(20 Marks)
A.Creating the four tables.
B.How many accounts have a balance 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 type of the second account.
E.Find details of customers having 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 have opened 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 have opened 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.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 4 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Data And Information Management. Retrieved from https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/relational-schema.html.

My Assignment Help (2021) Data And Information Management [Online]. Available from: https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/relational-schema.html
[Accessed 24 September 2021].

My Assignment Help. 'Data And Information Management' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/relational-schema.html> accessed 24 September 2021.

My Assignment Help. Data And Information Management [Internet]. My Assignment Help. 2021 [cited 24 September 2021]. Available from: https://myassignmenthelp.com/free-samples/mn405-data-and-information-management/relational-schema.html.


If you are looking for interesting essay topic ideas, we are the best essay writing services. Whether for a narrative piece or a persuasive one, our topics will keep your professor, and other readers intrigued. Our team of experts can also provide you with the best essay writing help if you want to make a quality submission. Apart from suggesting essay topics and writing them for you, we also offer complimentary editing and proofreading services. Call us for more details.

Latest Management Samples

EAPM4000 Professional Communication Practice

Download : 0 | Pages : 7

Answer Introduction Based on the case study, it could be understood that Thredbo is one of the best-known ski resorts in Australia. The ski resort possesses all the necessary attributes to attract tourists not only in the peak season but also during the low season as well. But currently, the ski resort had been facing issues like high vacancy and lower levels of profit in the low season, which was not expected because it had great potential to ...

Read More arrow Tags: Australia Footscray Management University of New South Wales 

MGT701 Managing Organisations

Download : 0 | Pages : 11

Answer Personality is depicted as "an exceptional game plan of characteristics and traits, decently stable after some time." Clearly, character is interesting in so far as each of us has our own particular character, not the same as some other person's (Hamilton, 2015). The definition also embraces that character does not change from standard. Personality is a dynamic idea delineating the change and progress of a man's entire mental structu...

Read More arrow Tags: Australia Wentworthville Management University of Sydney Masters in Business Administration 

HC1041 IT For Business

Download : 0 | Pages : 10

Answer Introduction: The “Commonwealth Bank of Australia” is one of the most popular and largest banks in Australia. It has developed in an organization with more than 50000 employees and 800000 stakeholders. It has been helping through a wide range of financial services by helping Australians managing and creating their finances. For business as well as individuals banking and finance has been affecting many things. The impact o...

Read More arrow Tags: Australia Rookwood Management Business Research Project Proposal University of Queensland MBA 

MGMT20144 Management And Business Context

Download : 0 | Pages : 7

Answer: Innovation and entrepreneurship has a key role to play in any business organisation.  If the business is a start-up, the innovation is an essential factor that has to be considered.  As given in part A, a start-up restaurant has been chosen, that is introducing Indian food in Australia.  This assignment highlights the importance of innovation and entrepreneurship on the business of the start-up restaurant. The impac...

Read More arrow Tags: Australia Malvern Management University of New South Wales 

BUS102 Introduction To Management

Download : 0 | Pages : 5

Answers Organisational Culture and Decision Making 1: Decision making process needs deep insight about a matter one deals with. In an organisation, decision making is shouldered upon the managers. As the leader of hundreds of employees, the manager of an organisation utilises his or her leadership qualities thus ensuring the basic understanding of the problems or decisive characteristics. While making decision, the managers are supposed to conc...

Read More arrow
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?