1 red #0.00 Create a notepad and write your name and university id inside it. Data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 red #0.00 Create a notepad and write your name and university id inside it. Data Definition Language (DDL) 1. Create table named Bank with the following rules and constraints (4.5 marks) Column name Bank_id Name length 5 constraints Primary Unique key (table level) Street City Data type Number Varchar2 Varchar2 Varchar2 Varcha 25 15 10 The default value is Amman PostC 2. Create table named Account with the following rules and constraints (7 marks) 10 following rules and constraints (7 marks) Column id Name name Data type Number length 5 balance Creation_datel name the constraint aid_pk Varchar2 Numberdate 20 10 constraints Primary Not Null Should Should be key be between 1-1- (column positive 1980 and 31- level) and the 12-2021 default value is 0 3. Add the column (numberOfBranches, Number, 5) to the bank table, and the column (mobileNumber, Number, 10) to the account table. (2 marks) 4. Change the primary key of the account table to TZ Marksy 4. Change the primary key of the account table to be the Name and the id columns together. Name the constraint a_pk. (2 marks) 5. Add Not Null constraint to the street column. (1 mark) 6. Rename the column numberOfBrnaches to be Branches Number. (1 mark) 7. Remove the column Branches_Number. (1 mark) 8. Create an index for the Street column in table bank. (1 mark) 9. Create a view that contains the name of the bank and the total balances in that bank. Name the view Report. (2 marks) 10. Can you apply the delete operation on the Report view? Why? (1 mark) Data Manipulation Language (DML) and Transactions Management: 1 red #0.00 Create a notepad and write your name and university id inside it. Data Definition Language (DDL) 1. Create table named Bank with the following rules and constraints (4.5 marks) Column name Bank_id Name length 5 constraints Primary Unique key (table level) Street City Data type Number Varchar2 Varchar2 Varchar2 Varcha 25 15 10 The default value is Amman PostC 2. Create table named Account with the following rules and constraints (7 marks) 10 following rules and constraints (7 marks) Column id Name name Data type Number length 5 balance Creation_datel name the constraint aid_pk Varchar2 Numberdate 20 10 constraints Primary Not Null Should Should be key be between 1-1- (column positive 1980 and 31- level) and the 12-2021 default value is 0 3. Add the column (numberOfBranches, Number, 5) to the bank table, and the column (mobileNumber, Number, 10) to the account table. (2 marks) 4. Change the primary key of the account table to TZ Marksy 4. Change the primary key of the account table to be the Name and the id columns together. Name the constraint a_pk. (2 marks) 5. Add Not Null constraint to the street column. (1 mark) 6. Rename the column numberOfBrnaches to be Branches Number. (1 mark) 7. Remove the column Branches_Number. (1 mark) 8. Create an index for the Street column in table bank. (1 mark) 9. Create a view that contains the name of the bank and the total balances in that bank. Name the view Report. (2 marks) 10. Can you apply the delete operation on the Report view? Why? (1 mark) Data Manipulation Language (DML) and Transactions Management:
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Posted Date:
Students also viewed these databases questions
-
A modified boxplot is a boxplot that uses symbols to identify outliers. The horizontal line of a modified boxplot extends as far as the minimum data entry that is not an outlier and the maximum data...
-
After 60 seconds of PPV coordinated with chest compressions, the cardiac monitor indicates a heart rate of 70 beats per minute. What is your next action? Discuss.
-
Beginning inventory, purchases, and sales for WCS12 are as follows: Oct. 1 Inventory 310 units at $8 13 Sale 180 units 22 Purchase 370 units at $10 29 Sale 300 units a. Assuming a perpetual inventory...
-
Santa's Helpers Ltd estimates its income taxes at 35% of pre-tax income. For the quarter ended September 30, pre-tax income was $200,000. Prepare the journal entry to record the estimated income...
-
Determine the moment of inertia Iz of the frustum of the cone which has a conical depression. The material has a density . Given: = 200kg/m3 a = 0.4 m b = 0.2 m c = 0.6 m d = 0.8 m
-
Why is potential gross rent important to the investor's decision making process and give an example.
-
The Durbin-Watson statistic is designed to detect autocorrelation and is defined by \[D W=\frac{\sum_{t=2}^{T}\left(y_{t}-y_{t-1} ight)^{2}}{\sum_{t=1}^{T}\left(y_{t}-\bar{y} ight)^{2}} .\] a. Derive...
-
Each of the following scenarios is independent. Assume that all cash flows are after- tax cash flows. a. Colby Hepworth has just invested $ 400,000 in a book and video store. She expects to receive a...
-
The general ledger of Karlin Company, a consulting firm, as of January 1, 2018, contained the following account balances: Account Title Debits Credits Cash 30,200 Accounts Receivable 15,500 Equipment...
-
Consider a building with 3200 ft 2 of walls. Assume the ceiling is well-insulated and compute the energy loss through the walls based on the following materials, assuming an indoor temperature of 70...
-
Find u x v, v x u, and v x v. u = 5i + 6k v = 2i + 7j - 4k. (a) (b) (c) u x V V xu I VX V
-
How accessible and affordable is childcare for working parents? The Daycare Trust, a charity, found that the annual cost of full-time childcare for a child under the age of 2 in 2012 was, on average,...
-
You live in a city where real estate prices are skyrocketing. Home prices and rental prices are expected to go up for the foreseeable future. You decide to borrow money and buy an apartment building....
-
For each of the following three scenarios, would you rather: a. Receive \($100\) in one month or \($100\) in two months (most people prefer the former)? b. Be given an excellent meal at a nice...
-
A stock currently selling for \($50\) has an annual returns variance equal to 0.36. The riskless return rate equals 0.08 per year. Under the binomial framework, what would be the value of nine-month...
-
The fantastic variety of jobs out there for the well-prepared candidate is almost unimaginable. But our lives have gotten busy-really complicated! We spend time with work, school work, meetings,...
-
Where does the execution of the program starts? user-defined function main function void function else function O Moving to the next question prevents changes to this answer.
-
Given the table below, about how much force does the rocket engine exert on the 4.0 kg payload? Distance traveled with rocket engine firing (m) Payload final velocity (m/s) 500 320 490 310 1020 450...
-
List the advantages of a client/server architecture as compared to a file server.
-
What is data independence? Why is it desirable?
-
How is it possible to get more information from the same amount of data by using a database approach as opposed to a nondatabase approach?
-
Consider expansion of a function in terms of a series \(F_{n}(x)\) in the following form: \[f(x)=\sum_{n} A_{n} F_{n}(x)\] If the functions \(F_{n}\) are orthogonal then this property helps to unfold...
-
A concrete wall \(20 \mathrm{~cm}\) thick is initially at a temperature of \(20^{\circ} \mathrm{C}\), and is exposed to steam at pressure \(1 \mathrm{~atm}\) on both sides. Find the time for the...
-
Analyze the transient problem with the Dirichlet condition for a long cylinder and for a sphere. Derive expressions for the eigenfunctions, eigenconditions, and eigenvalues. Find the series...
Study smarter with the SolutionInn App