Length of values defined for city column

Assignment Help Basic Computer Science

Reference no: EM13935915

1. There is a table called USER_TABLES that stores the information about each user's table. Use the select statement to make sure your tables are all created from assignment 2

2. You are asked to create a new table called "part2" which has the same column definitions as the table "part" you created in assignment2. However, you should not copy the data contained in the course. How do you create a copy of the "part" table without copying its data contents ?

3. What is the length of values defined for city column. Modify the length of "city" in the table "suppliers".

4. Are there any constraints defined for the above tables (table suppliers (S), supplier-part(SP), parts? (P) In order to find out, try to search through the USER_CONSTRAINTS table.5. Add the following constraints for the tables :- s# is the primary key for table "S"- s#, p# is the primary key for the table "SP"-p# in table "P" should be unique- the primary key of the "S" table is posted as foreign key in the tables "SP" - SNAME in table "S" may not be NULL- the columns "qty" in table "SP", "weight" in table "P" should be larger than 0.Part 2: More Queries (using the S-SP-P tables)

1. How many different kinds of parts do we have

2. Give the details of suppliers in Paris

3. Give details of shipments where the quantity shipped is less than 300

4. Give details of parts stored in London

5. Give the names and numbers of London based suppliers

6. Give the names of red Parts 7. Give the part number for parts weighting less than 17 8. Give details of parts supplied by S19. Give the color of parts supplied by S2 10. Where are the suppliers of P2 located 11. Get supplier numbers for suppliers who supply parts located in either Paris or London Turn in a copy of all of your SQL commands, along with a script illustrating their execution (by using paste your terminal output and save it in a file or any other way).Your script should be sufficient to convince us that your commands run successfully.

Reference no: EM13935915

Questions Cloud

Tell your personal story to share with fellow leaders : Create and tell your personal story (past experience, education, life experience, etc.) to share with fellow leaders, peers, or subordinates indicate who your target audience is and what is in it for them (what will they take away from hearing you..

Name few languages that allow use of variables : What is a keyword in a programming language? Why it is not a good practice to use reserved words as variable names?

How is it possible for ppp to hold if the ife does not : Comparing PPP and IFE. How is it possible for PPP to hold if IFE does not? How will this spot rate adjust according to PPP if the United Kingdom experiences an inflation rate of 7% while US experiences an inflation rate of 2%?

Compare and contrast humoral and cellular immunity : Protozoans are grouped through their means of locomotion; describe the three different types of locomotion. Compare and contrast humoral and cellular immunity.

Length of values defined for city column : There is a table called USER_TABLES that stores the information about each user's table. Use the select statement to make sure your tables are all created from assignment 2

What are the composition of functions : What composition of all the functions above, along with the the literal value 0 will return the value 42?

What will the spot rate be in one year according to the ife : The one-year interest rate is 11% in the United Kingdom and 7% in Singapore. What will the spot rate be in one year according to the IFE?

Analyse the leadership of a 21st century : Using relevant theories and models critically evaluate and analyse the leadership of a 21st century leader of a organisation.

Derive forecasts of the future spot rate : Deriving forecasts of the future spot rate. Use the forward rate to forecast the percentage change in the Mexican peso over the next year.

User Account

All Pages