n Is-opened-by ACCOUNT ID number balance TELLER status BRANCH bnumber ID1 nane address date-when-opened tine-when-opened Is-assigned-to ID2
Fantastic news! We've Found the answer you've been seeking!
Question:
n
Transcribed Image Text:
Is-opened-by ACCOUNT ID number balance TELLER status BRANCH bnumber ID1 nane address date-when-opened tine-when-opened Is-assigned-to ID2 SAVINGS-ACCOUNT CHEQUE-ACCOUNT ID3 Is-opened-at EMPLOYEE enumber full-name address date-of-birth salary IT-SPECIALIST skills [...] ID LOAN-ACCOUNT Owns Performs-operation OTHER-EMPLOYEE date time OPERATION DEPOSIT amount cid CUSTOMER first-name last-name date-of-birth email 10..11 home-address WITHDRAWAL ID Your task is to perform the steps of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. Before transforming add the attribute 'phone to the BRANCH and the attribute 'mobile-phone' to the CUSTOMER class. Draw the resulting conceptual schema adding your name, student number and the date to the drawing. Use UMLet and paste images of your drawings into your Microsoft Word document using the template provided. List the names of attributes, primary key, candidate keys (if any), and foreign keys (if any) for each class in the relational schema. Assume that an association method is used to implement the generalisation. Show your working and explain as you step through the transformation process. Convert your Microsoft Word document based on the template provided into a pdf and submit your answer as a file question1.pdf If a submitted file has an incorrect filename or file type, it may lose marks. Is-opened-by ACCOUNT ID number balance TELLER status BRANCH bnumber ID1 nane address date-when-opened tine-when-opened Is-assigned-to ID2 SAVINGS-ACCOUNT CHEQUE-ACCOUNT ID3 Is-opened-at EMPLOYEE enumber full-name address date-of-birth salary IT-SPECIALIST skills [...] ID LOAN-ACCOUNT Owns Performs-operation OTHER-EMPLOYEE date time OPERATION DEPOSIT amount cid CUSTOMER first-name last-name date-of-birth email 10..11 home-address WITHDRAWAL ID Your task is to perform the steps of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. Before transforming add the attribute 'phone to the BRANCH and the attribute 'mobile-phone' to the CUSTOMER class. Draw the resulting conceptual schema adding your name, student number and the date to the drawing. Use UMLet and paste images of your drawings into your Microsoft Word document using the template provided. List the names of attributes, primary key, candidate keys (if any), and foreign keys (if any) for each class in the relational schema. Assume that an association method is used to implement the generalisation. Show your working and explain as you step through the transformation process. Convert your Microsoft Word document based on the template provided into a pdf and submit your answer as a file question1.pdf If a submitted file has an incorrect filename or file type, it may lose marks.
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these programming questions
-
You have been asked to write a SQL query to retrieve information about customers sales orders. 1. What database tables would be used in the query? 2. What database fields would be used in the query?
-
I need you to write interview question for example how they prefer to communicate -are they prefer Arabic or English -written or face to face ....etc for principals I need to know their personality...
-
There are many more isomers of CH3NO2 other than nitro methane and methyl nitrite. Some, such as Carbamic acid, an intermediate in the commercial preparation of urea for use as a fertilizer, are too...
-
Jensen Company has the following information for the pay period of January 15 - 31, 20xx. Gross payroll $10,000 Federal income tax withheld $1,500 Social security rate 6% Federal unemployment tax...
-
Jim Nance has been offered a future payment of $500 three years from today. If his opportunity cost is 7% compounded annually, what value should he place on this opportunity today? What is the most...
-
The volume of a shampoo filled into a container is uniformly distributed between 374 and 380 milliliters. (a) What are the mean and standard deviation of the volume of shampoo? (b) What is the...
-
Explain the nature and purpose of the three major financial statements.
-
A newly hired staff accountant prepared the pre-audit income statement of Be Fit Recreation Incorporated for the year ending December 31, 2011. The following information was obtained by Be Fits...
-
Gru is creating his budget for material costs for the coming year. Last year\'s total actual material costs were 2 0 0 , 0 0 0 . Material cost inflation is currently 3 % per annum. This year Gru is...
-
Check my Demarco and Janine Jackson have been maried for 20 years and have four children who qualify as their dependents (Damarcus, Janine, Michael, and Candice). The couple recelved salary income of...
-
Express 55.3 J of heat (or energy) in units of calories. * 0.76 cal O 231.4 cal 0.0132 cal O 13.2 cal One is defined as the heat needed to raise 1 lb of water by 1 Fo. * BTU O J/g Cal O J
-
How many whole atoms are there per unit cell in a face centred cubic crystal with a motif containing one copper atom at 0 0 0? Explain how you obtained your answer.
-
Given an array A = [a1, a2, ..., an] of n positive integers, the goal is to determine whether A can be partitioned into two subsets B and C so that |B| ICI b E B = C EC, i=1 i=1 i.e, the summations...
-
35 kg solid Lead is heated from -30C to 45C at atmospheric pressure. Assuming that there is no change in the volume of the Lead, what is the heat transfer (in kJ) for this process?
-
1:12 < Back Leadership Essay 1 Instruction... MGNT 3235 - Spring 2024 Leadership Essay 1 Instructions Due Thursday, 2/22 by 11:59 pm in the Folio Dropbox First off, essays 1 and 2 aren't intended to...
-
What steps can you take to make sure all relevant colleagues' voices are heard when discussing budget outcomes ?
-
The following pages contain annual data on interest rates, inflation rates, and percentage change in exchange rates (based on indirect quotes) for foreign countries, including the US, for the period...
-
Why is it necessary to study the diffusion of molecules in biological systems?
-
Using a document at your own school (for example, a class schedule), determine the attributes present in the document. Using your knowledge of the policies at your school, determine the functional...
-
Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. 1. Design a database to...
-
When do you use an update query?
-
How has the escalating role of board members and the audit committee affected corporate governance?
-
Describe regulatory influences on board members and management. What have been the effects of these influences?
-
For three organizational structure types (entrepre neurial, bureaucratic, adhocracy), briefly describe the likely characteristics of corporate governance.
Study smarter with the SolutionInn App