Create the following tables using SQL Developer, based on the given data types and constraints. Please...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of the tables/columns thoroughly and create the tables using SQL queries. Name ADMIN Admin D LastName FirstName AManager D AGREEMENT AgreementNbr GrossAmount AtSource TaxWithheld EventID Contractio ARTIST Artisti LastName FirstName Gender YearOfBirth PhoneNumber Email Artist Type Desc PK PK PK Data type NUMBER(12) VARCHAR2(25) VARCHAR2(25) NUMBER(12) NUMBER(12) NUMBER(12,2) NUMBER(12,2) NUMBER(12) NUMBER(12) NUMBER(12) VARCHAR2(25) VARCHAR2(25) CHAR(1) NUMBER(4) CHAR(10) VARCHAR2(50) CHAR(1) Format/Ref Table Allowable values References ARTISTMANAGER References CONTRACT M, F, N <CurrentYe ar C, P Not Null Y Y Y Y Y Y Y Y Y Y Y Y Y Y ARTISTMANAGER AManagerID LastName FirstName ArtistID CONTRACT ContractID StartDate EndDate RoyaltyPercentage ArtistID PK PK NUMBER(12) VARCHAR2(25) VARCHAR2(25) NUMBER(12) NUMBER(12) DATE DATE NUMBER(3,2) NUMBER(12) References ARTIST References ARTIST Y Y Y Y Y Y Y Y Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of the tables/columns thoroughly and create the tables using SQL queries. Name ADMIN Admin D LastName FirstName AManager D AGREEMENT AgreementNbr GrossAmount AtSource TaxWithheld EventID Contractio ARTIST Artisti LastName FirstName Gender YearOfBirth PhoneNumber Email Artist Type Desc PK PK PK Data type NUMBER(12) VARCHAR2(25) VARCHAR2(25) NUMBER(12) NUMBER(12) NUMBER(12,2) NUMBER(12,2) NUMBER(12) NUMBER(12) NUMBER(12) VARCHAR2(25) VARCHAR2(25) CHAR(1) NUMBER(4) CHAR(10) VARCHAR2(50) CHAR(1) Format/Ref Table Allowable values References ARTISTMANAGER References CONTRACT M, F, N <CurrentYe ar C, P Not Null Y Y Y Y Y Y Y Y Y Y Y Y Y Y ARTISTMANAGER AManagerID LastName FirstName ArtistID CONTRACT ContractID StartDate EndDate RoyaltyPercentage ArtistID PK PK NUMBER(12) VARCHAR2(25) VARCHAR2(25) NUMBER(12) NUMBER(12) DATE DATE NUMBER(3,2) NUMBER(12) References ARTIST References ARTIST Y Y Y Y Y Y Y Y
Expert Answer:
Answer rating: 100% (QA)
Creating Queries Using SQL Queries CREATE TABLE ARTIST ArtistID INT12 NOT NULL LastName VARCHAR25 NO... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
After watching the videos about budgets, what are your key takeaways? Do you think you will take any of this advice and use it? In your experience, what makes budgets difficult? Do you have any other...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
The SEC Form 10-K of Google is reproduced online at www.wiley.com/college/pratt. REQUIRED: Review the Google 2012 SEC Form 10-K, and answer the following questions: a. Compute Googles long-term debt...
-
Let f(x) = | x 1|. Show that there is no value of such that f(3) f(0) = f(c)(3 0). Why does this not contradict the Mean Value Theorem?
-
Identify at least 10 questions that might be asked in the review of practices for continuous improvement.?
-
The data in Table 19.5 originate from the 1991 edition of the Historical Loss Development Study, published by the Reinsurance Association of American. These data have been widely used to illustrate...
-
On June 1, 2015, the City of Cape May authorized the construction of a police station at an expected cost of $250,000. Financing will be provided through transfers from a Special Revenue Fund. The...
-
Previously we addressed the problem of a pinned-joint truss in the shape of a regular pentagon that is supported on rollers and loaded by a single vertical force F. We want to determine the loads in...
-
The sector rotates with the indicated angular quantities about a fixed axis through point B. Simultaneously, the particle A moves in the curved slot with constant speed u relative to the sector....
-
It takes courage to lead an organization with ethics. For instance, Leaders at AIG argued that they were obligated to pay bonuses to executives even after the company was bailed out by the U.S....
-
Indicate whether each of the following statements is true or false by writing T or F in the answer column. Only professionals such as doctors and lawyers can be charged with ne gligence.
-
Indicate whether each of the following statements is true or false by writing T or F in the answer column. While the term malpractice is usually applied to physicians, dentists, attorneys, and...
-
Indicate whether each of the following statements is true or false by writing T or F in the answer column. Directors and offi cers of corporations can be charged with breach of their duty resulting...
-
Determine the hydrologic risk of a roadway culvert flooded with 50 years of expected service life designed to carry a 100-year storm.
-
Indicate whether each of the following statements is true or false by writing T or F in the answer column. Clergy cannot be charged with negligence.
-
H1. Does the series H2. Does the series 8 8 2 1 1 n (In n) 1 n n converge or diverge? 72 converge or diverge? 8 H3. Does the series E-2 converge or diverge?
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
Identify the set of functional dependencies in the relation instance CAR shown below. Does this constitute the minimal cover for the set of functional dependencies present in CAR? If it is not a...
-
Contrast categorization and aggregation.
-
Is the relation instance SHIRT in Exercise 2 in 5NF? If the answer is yes, explain. If the answer is no, provide a solution.
-
By using the yield to maturity on AT&Ts debt, we found that its pretax cost of debt is 3.65%. If AT&Ts tax rate is 25%, what is its effective cost of debt?
-
You work in Walt Disney Companys corporate finance and treasury department and have been assigned to the team estimating Disneys WACC. You must estimate this WACC in preparation for a team meeting...
-
You are working for Microsoft evaluating the possibility of selling energy drinks. Microsofts WACC is 8.1%. Energy drinks would be a new line of business for Microsoft, however, so the systematic...
Study smarter with the SolutionInn App