What is the length of values defined for city column

Assignment Help Basic Computer Science

Reference no: EM13782898

Start early-this programming assignment requires a fair amount of work to use ISQLPLUS.

Part 1: Queries

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 (each 3 marks, total 18 marks): - 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 S1

9. 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.

Submission Guideline: 1. Upload your submission on CMS

Reference no: EM13782898

Questions Cloud

Mintzberg distinguishes between deliberate and emergent : Mintzberg distinguishes between 'deliberate' and 'emergent' strategies. What are the advantages of emergent strategies? Are they particularly appropriate and effective in certain kinds of organizations? In certain kinds of environmental and competiti..

Practical definition of the multidisciplinary team : The practical definition of the multidisciplinary team that the product idea requires describing the different types of team members needed and their respective skill sets where one would find them for an intrapreneurial versus entrepreneurial app..

Can doug be convicted of murder : Tom entered Doug's apartment and threatened to beat Doug badly, to which Doug, fearing for his life, grabbed a gun in a nearby drawer, and shot and killed Tom. Doug then panicked and fled. Doug was arrested three days later. Can Doug be convicted ..

Question on ethics : ethics.

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

Is he an agent of international widgets : Review your textbook and library references to assist you in answering these questions.Is John in a fiduciary relationship with International Widgets? Why or why not? Is he an agent of International Widgets? Identify the duties and responsibilitie..

You are the project manager of a retail marketing project : You are the project manager of a retail marketing project that has 12-month duration. Your status reports indicate a need for an individual with more knowledge of the retail operations of the company. The operation manager is resisting allowing the p..

How to make treatment centers better : Issues being examined will be the importance of Juvenile Treatment Centers, have these treatments centers made a difference since started, how to make treatment centers better, how community can get involved to help contribute and not focus on the..

Punishment versus positive management techniques : Identifying good motivational techniques for use in the workplace is a crucial component of effective management.

User Account

All Pages