Question: Given the following TAPE table, write the SQL queries to answer each of the following questions. For create statement, assume appropriate datatype and size for

Given the following TAPE table, write the SQL

Given the following TAPE table, write the SQL queries to answer each of the following questions. For create statement, assume appropriate datatype and size for the columns. Tape (Tape_Code, Tape_Name, Tape Copy, Tape_Charge) 1. Write the SQL query to create the TAPE table with the following constraints: o Primary key: TAPE_CODE o Not null constraints on all attributes. In other terms, all attributes are mandatory. o A check constraint on TAPE_COPY to accept onl>0 values. 2. List the tapes whose code is either 'M3456-1' or 'R2345-1'. Show all columns. 3. List the tapes whose TAPE_CHARGE betweem 2 and 3. Show only TAPE_CODE and TAPE_NAME. 4. Change the TAPE_CHARGE to 3 for the tape code 'M3456-1'. 5. Delete the tapes whose TAPE_COPY is 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!