Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of
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 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Creating Queries Using SQL Queries CREATE TABLE ARTIST ArtistID INT12 NOT NULL LastName VARCHAR25 NO...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started