Table: Author Author_ID Author_Name DZN9010 J.K. Rowling VC8931 Arthur Conan Doyle STA7686 Suzanne Collins Book Title Harry Potter Sherlock Holmes Hunger Games a. ii, iii b. ii, iii, iv Oc. i, ii, iv d. il only Author_Origin England Scotland USA How can we remove the transitive dependencies from the table above? i. Create a separate Name table with Author_ID as primary key ii. Create a separate Book table with Book_ID as primary key iii. Create a separate Origin table with Origin_ID as primary key iv. Create a Book_ID and make it a foreign key in Author table

Table: Author Author_ID Author_Name DZN9010 J.K. Rowling VC8931 Arthur Conan Doyle STA7686 Suzanne Collins Book Title Harry Potter Sherlock Holmes Hunger Games a. ii, iii b. ii, iii, iv Oc. i, ii, iv d. il only Author_Origin England Scotland USA How can we remove the transitive dependencies from the table above? i. Create a separate Name table with Author_ID as primary key ii. Create a separate Book table with Book_ID as primary key iii. Create a separate Origin table with Origin_ID as primary key iv. Create a Book_ID and make it a foreign key in Author table

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 7SCG: Delete the OWNER_INDEX 3 index from the OWNER table.

See similar textbooks

Similar questions

Delete the OWNER_INDEX 3 index from the OWNER table.
The option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for owner 005 (OwnerNum = 005) in the Owner table to become 500 (OwnerNum = 500). What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine…
The option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for owner 012 (OwnerNum = 012) in the Owner table to become 120 (OwnerNum = 120). What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine…
The option for referential integrity between the Owner table and the Pet table is cascade and an attempt is made to delete the row for owner number 012 in the Owner table. What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004 Feline 009 400 King…
The option for referential integrity between the Owner table and the Pet table is restrict. An attempt is made to delete the row for owner number 012 in the Owner table. What is the result? (Use only the data in the tables below. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004 Feline 009 400 King…
The option for referential integrity between the Owner table and the Pet table is cascade and an attempt is made to update the row for Owner 005 in the Owner table (OwnerNum = 005) to have a new OwnerNum of 500. What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004…
SQL CREATE TABLE `zoo`.`Habitats`( `id` INT(50) NOT NULL AUTO_INCREMENT, `habitatName` VARCHAR(50), `habitatLocation` VARCHAR(50), PRIMARY KEY (`id`) ); CREATE TABLE `zoo`.`Animal`( `animalId` INT(50) NOT NULL AUTO_INCREMENT, `animalName` VARCHAR(50), `animalBirthdate` DATE, `species` VARCHAR(50), `habiat` INT(50), PRIMARY KEY (`animalId`), FOREIGN KEY (`habiat`) REFERENCES `zoo`.`habitats`(`id`) ); Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.
I am trying to create this index in oracle, the table and the column exists and is not found anywhere else in the database, but it's still telling me 'Province' is an invalid identifier. I've tried changing the column name (and create statement with it), but its all just not working. CREATE INDEX StudentProvince ON ADDRESS_KR (Province);
Here we have Creating table code according to syntax in Oracle APEX. CREATE TABLE DEPT ( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR2(50) NOT NULL, LOC VARCHAR2(50) , CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) ); Step 2: Emp table CREATE TABLE EMP( EMPNO NUMBER(10) NOT NULL, ENAME VARCHAR2(50) NOT NULL, JOB VARCHAR2(50) , MGR VARCHAR2(50) , HIREDATE DATE, SAL NUMBER(5) , COMM VARCHAR2(50) , DEPTNO NUMBER(10) NOT NULL, CONSTRAINT EMP_PK PRIMARY KEY (EMPNO), CONSTRAINT EMP_FK FOREIGN KEY ( DEPTNO ) REFERENCES DEPT (DEPTNO ) ); Step 3 CREATE TABLE SALGRADE ( GRADE NUMBER(10) NOT NULL, LOSAL NUMBER(10) , HISAL NUMBER(10) , CONSTRAINT SALGRADE_PK PRIMARY KEY (GRADE) ); Question: Give all employees records who have salaries in between 1000 and 2000 (both included)Get all employee names whose name the second letter is ‘A’.Retrieve all employees records who don’t take a commission.Get all employee's records who work as ‘CLERK’.
Use OlympicsDBv2. Create a ChangeLog table in the database that will be used a trigger to monitor an officials PayRate for an irregularities in terms of updates. The ChangeID is to be autogenerated and should be set as the primary key. The User who made the change, the date, along with previous payrate and the new payrate should be captured. TABLE [dbo].[ChangeLog] [ChangeID] [int] IDENTITY(1,1) NOT NULL, [OfficialID] [int] NULL, [User] [nchar](30) NULL, [Date] [datetime2] NULL, [OldRate] [money] NULL, [NewRate] [money] NULL,
Hi triggers Update and using Xampp and this table: CREATE TABLE MEMBER(STUDENT_ID CHAR(6) NOT NULL,CLUB_CODE VARCHAR(4) NOT NULL,MEMBER_DATE DATE NOT NULL,MEMBER_POSITION VARCHAR(15) NOT NULL,MEMBER_ATTENDANCE CHAR(2) NOT NULL,PRIMARY KEY (STUDENT_ID,CLUB_CODE),FOREIGN KEY (STUDENT_ID) REFERENCES STUDENT (STUDENT_ID) ON DELETE RESTRICT ON UPDATE CASCADE,FOREIGN KEY (CLUB_CODE) REFERENCES CLUB (CLUB_CODE) ON DELETE RESTRICT ON UPDATE CASCADE); INSERT INTO MEMBER VALUES('100027','C201','2020-03-25','Secretary','12'),('100027','C202','2020-04-11','Member','11'),('100032','C201','2020-02-23','President','12'),('100050','C201','2020-03-25','Member','10'),('100132','C202','2020-04-11','Treasurer','10'),('100074','C203','2020-04-09','President','12'),('100074','C204','2020-04-25','Treasurer','12'),('100051','C204','2020-04-25','Member','9'),('100064','C207','2020-04-25','Vice…
Create an ADD TRIGGER. Explain what the trigger does. Test and show the related results of this trigger. Table 1: CREATE TABLE BSR_PASSENGER (PASSENGER_ID INT NOT NULL UNIQUE, FULL_NAME VARCHAR(30), COUNTRY VARCHAR(40), CITY VARCHAR (40), PRIMARY KEY (PASSENGER_ID)); Table 2: CREATE TABLE BSR_FLIGHT (FLIGHT_ID INT NOT NULL UNIQUE, AIRLINE_NAME VARCHAR(50), CREW_MEMBERS INT, PRIMARY KEY (FLIGHT_ID)); Table 3: CREATE TABLE BSR_BOOKING (BOOKING_ID INT NOT NULL UNIQUE AUTO_INCREMENT, PASSENGER_ID INT NOT NULL, FLIGHT_ID INT NOT NULL, COST DEC(6,3), PRIMARY KEY (BOOKING_ID), FOREIGN KEY (PASSENGER_ID) REFERENCES BSR_PASSENGER(PASSENGER_ID), FOREIGN KEY (FLIGHT_ID) REFERENCES BSR_FLIGHT(FLIGHT_ID));