Question: DATABASE 1. Write SQL code to create the tables with column names and types from Figure 2. STAFF COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 STAFFID NUMBER

DATABASE

DATABASE 1. Write SQL code to create the tables with column names

1. Write SQL code to create the tables with column names and types from Figure 2. STAFF COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 STAFFID NUMBER (6,0) No (null) 2 FNAME VARCHAR2 (20 BYTE) Yes (null) 3 LNAME VARCHAR2 (25 BYTE) No (null) 4 SALARY NUMBER (8,2) Yes (null) 5 MANAGER ID NUMBER (6,0) Yes (null) 6 BRANCHID NUMBER (4,0) Yes (null) BRANCH COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 BRANCHID NUMBER (4,0) (null) 2 BRANCHNAME VARCHAR2 (30 BYTE) NO (null) 3 MANAGER ID NUMBER (6,0) Yes (null) 4 PLACEID NUMBER (4,0) Yes (null) NO PLACE COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 PLACEID NUMBER (4,0) NO (null) 2 CITY VARCHAR2 (30 BYTE) No (null) 3 COUNTRY ID CHAR (2 BYTE) Yes (null) Figure 2: Schema Tables

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 Databases Questions!

DATABASE 1. Write SQL code to create the tables with column names and types from Figure 2. STAFF COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 STAFFID NUMBER (6,0) No (null) 2 FNAME VARCHAR2 (20...

ANSWER THE LAST 4 PLEASE ! Now create a view over the LEDGER table called LEDGER_SALES. The query for this view will provide a summary of data from the LEDGER that is only ACTION = BOUGHT rows,...

ANSWER 5,6,7,8 PLEASE 1. Write a query to show the distinct occurrences of ACTION in LEDGER. (5) SELECT DISTINCT ACTION FROM LEDGER; Now create a view over the LEDGER table called LEDGER_SALES. The...

1. Write a query to show the distinct occurrences of ACTION in LEDGER. (5) SELECT DISTINCT ACTION FROM LEDGER; 2. Now create a view over the LEDGER table called LEDGER_SALES. The query for this view...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

QUESTIDN 1 (3n MAKES.) A. The following diagram shows a table structure for a Project Management data. _u _u _u Iaa- Iaa- m m - - REQUIRED: (a) Discuss TWO [2) types of anomalies exhibited in the...

Database Management System - Require use of Word, Powerpoint and Access C. After the presentation about the functionalities and advantages of using DBMS to manage customer information data in the...

DATABASE | PLEASE NEED YOUR OWN ANSWER! DO NOT PROVIDE ME COPIED OR OTHER PEOPLE ASNWER...THANKS Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) );...

What assumptions underlie the EOQ model? Andria Mullins, financial manager of Webster Electronics, has been asked by the firms CEO, Fred Weygandt, to evaluate the companys inventory control...

A taxpayer owned 1,000 shares of common stock in Barlo Corporation, which manufactures automobile parts. The taxpayers cost basis in the stock was $82,700. Last week, Barlo declared bankruptcy and...

E10.28 (LO 6) Groupwork (Ratio Analysis) A recent annual report of Eastman plc contains the following information. (in millions) Current Year-End Prior Year-End Total assets 13,659 14,320 Total...

Develop a program using Python that uses recursion to convert a prefix expression containing single letter operands and the operators +, -, *, /, and $ (representing exponentiation) to postfix...

In 1960, McGregor stated that management does not know enough about how to create the conditions for individual growth and integrity in the group situation. To what degree have theory and practice...

McGregor anticipated an inevitable transition from conceiving of organizations as a pattern of individual relationships to conceiving of them as a pattern of relationships among groups. Is there a...

McGregor praises the personal self-awareness that commonly emerged from T-group experiences. To what degree is this sort of intense, interpersonal feedback and shared learning relevant in todays...