this is a introduction to database design question, i'm stuck. please help solve asap Subtle Emphasis D>
Fantastic news! We've Found the answer you've been seeking!
Question:
this is a introduction to database design question, i'm stuck. please help solve asap
Transcribed Image Text:
Subtle Emphasis D> N LZ Editing Dictate Editor Reuse Files Voice Editor Reuse Files Q4 [Pts 25] Make updates to below table structure. Picture A Name CU ID CUS NAME CUS ZIP CUS Information T Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) Picture B CUS Information _T Null Type Name CUS_ID CUS NAME CUS ZIP CUS PHONE NUMBER(10) VARCHAR2(255) VARCHAR2(10) VARCHAR2(10) 1- Create a table in picture A [Pts 3] 2- Modify the table to picture B 1. Change table name to Customer T[Pts 2] 2. Change CU_ID (column name) to CUS_ID [Pts 3] 3. Change CUS Name data type VARCHAR2 25 to 255 [Pts 2] 4. Change CUS ZIP data type from Number(10) to Varchar2(10) [Pts 2] 5. Query to show table structure [Pts 2] 6. Add CUS_PHONE data type Varchar(10) [Pts 2] 7. Add Constraint Primary Key to Cus ID (column) [Pts 3] 8. Disable Primary Key on Cus ID [Pts 2] 9. Delete/Drop Primary Key on Cus. JD [Pts 2] 10. Show table structure [Pts 2] + 50% Focus Subtle Emphasis D> N LZ Editing Dictate Editor Reuse Files Voice Editor Reuse Files Q4 [Pts 25] Make updates to below table structure. Picture A Name CU ID CUS NAME CUS ZIP CUS Information T Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) Picture B CUS Information _T Null Type Name CUS_ID CUS NAME CUS ZIP CUS PHONE NUMBER(10) VARCHAR2(255) VARCHAR2(10) VARCHAR2(10) 1- Create a table in picture A [Pts 3] 2- Modify the table to picture B 1. Change table name to Customer T[Pts 2] 2. Change CU_ID (column name) to CUS_ID [Pts 3] 3. Change CUS Name data type VARCHAR2 25 to 255 [Pts 2] 4. Change CUS ZIP data type from Number(10) to Varchar2(10) [Pts 2] 5. Query to show table structure [Pts 2] 6. Add CUS_PHONE data type Varchar(10) [Pts 2] 7. Add Constraint Primary Key to Cus ID (column) [Pts 3] 8. Disable Primary Key on Cus ID [Pts 2] 9. Delete/Drop Primary Key on Cus. JD [Pts 2] 10. Show table structure [Pts 2] + 50% Focus
Expert Answer:
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these databases questions
-
Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
discuss the benefits and challenges of the employee job performance evaluation process as it relates to the ratings of an individual. For example, if an employer uses a standard Likert Scale (1...
-
Melanie has been promoted as the operations head of Apex Inc. She aims to lead the organization in an effective manner. Which of the following should be implemented by Melanie to achieve her aim? A)...
-
Hudson Corporation's balance sheet at December 31, 2016, is presented below. During January 2017, the following transactions occurred. Hudson uses the perpetual inventory method. Jan. 1 Hudson...
-
Using a one-term Fourier cosine series, develop an empirical equation for solar declination as a function of day number counted from January 1 (see Table 5.1 and Figure 5.7). Figure 5.7 Table 5.1...
-
What tests of difference are appropriate in the following situations? a. Average campaign contributions (in $) of Democrats and Republicans are to be compared. b. Average campaign contributions (in...
-
Cherry Ltd entered into a non-cancellable three year lease agreement with Mango Ltd on 1 July 2022. The machinery cost Mango Ltd $140,000 to manufacture and at the inception of the lease, it had a...
-
ABC Corporation owns AUS Corporation. For the year ending December 31, 2018, AUS has the following information Shares issued and outstanding Revenue COGS Dividends declared and paid to shareholders...
-
3 Consider the following possible alternatives to the vector norms we encountered in the notes. For each, state whether the proposed definition satisfies the conditions of a norm or not. If it does,...
-
When 3 0 , 0 0 0 shares of $ 1 0 par - value common stock are issued at $ 3 0 per share, Paid - In Capital in Excess of Par, Common Stock is credited for:
-
On January 2, 2014, Cain, Inc. agreed to pay its newly hired chief financial officer\ $550,000 under a deferred compensation arrangement. Cain should have recorded this\ expense in its income...
-
Suppose that we are drilling an oil well. The drilling rig costs $1300 today, and in one year the well is either a success or a failure. The outcomes are equally likely. The discount rate is 4%. The...
-
Given that P(A)=1/3, P(B) = 1/2 and P(AIB) = 1/2: a. Find P(A n B). b. Find P(BIA). c. Find P(AUB). d. Are A and B independent? Why or why not? e. Are A and B mutually exclusive? Why or why not?
-
In what ways did the rise of socialist ideas lead to the development of the discipline of Sociology? Capitalism had wreaked havoc in the society. The poor were getting poorer while the rich were...
-
You deposit $10,000 in a savings account that earns 7.5% simple interest per year. What is the minimum number of years you must wait to double your balance? Suppose instead that you deposit the...
-
Distinguish between legal, political, and governmental influences on the international marketer.
-
What do you see as the future for the Internet as a basic advertising medium and/or as a means for implementing sales promotion in foreign markets?
-
In your domestic country of origin what are some reasons that consumers might have to disidentify with their country?
-
Sandblasting is a process in which an abrasive material, entrained in a jet, is directed onto the surface of a casting to clean its surface. In a particular setup for sandblasting, the casting of...
-
\(f(t)=\delta(t-\tau)\) corresponds to a force applied at a. \(t-\tau=0\) b. \(t-\tau <0\) c. \(t-\tau>0\)
-
Find the response of a viscously damped system under the periodic force whose values are given in Problem 1.116. Assume that \(M_{t}\) denotes the value of the force in newtons at time \(t_{i}\)...
Study smarter with the SolutionInn App