Question: Question 2 (5 marks) Create 2 tables based on the ER model shown below. Include all the constraints in the CREATE TABLE statements. You should

Question 2 (5 marks) Create 2 tables based on the ER

Question 2 (5 marks) Create 2 tables based on the ER model shown below. Include all the constraints in the CREATE TABLE statements. You should have only two create Table statements and no ALTER TABLE statements. Name all constraints except NOT NULLS 306 COMP 122W21_002_P_40. EMPLOYEE PENO CHAR (4 BYTE) ENAME VARCHAR2(30 BYTE) VARCHAR2 (30 BYTE) MANAGER CHAR(4 BYTE) JDATE TIMESTAMP GENDER CHAR (1 BYTE) SALARY NUMBER (2) COMISSION NUMBER (62) F. DEPTNO NUMBER (0) EMPLOYEE_PK (NO) 3 SYS_CO053807 (DEPTNO) COMP122W21_002_P_40 DEPARTMENT PONO NUMBER (0) U DNAME VARCHAR2 (30 BYTE) U DLOCATION VARCHAR2 (30 BYTE) DEPARTMENT_PK (NO) DEPARTMENT DNAME UN (ONAME) DEPARTMENT_DLOCATION_UN (DLOCATION Use the column datatypes and sizes as indicated in the ER model ENO and DNO are used to uniquely identify rows in these tables. Each Employee must be assigned a Department, and no duplicate department names are allowed. Assign commission default value 0. The Salary entered should be greater than zero If the data is given in Gender coloumn, only 'M' or 'F' are acceptable values Each table should have 5 data records in them Create and execute the SQL statements needed to enforce the data relationships among these 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!

using sql Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the CREATE...

USING ORACLE SQL DEVELOPER Use your judgment for column datatypes and sizes. Proj# and Wo# are used to uniquely identify rows in these tables. Each project added must be assigned a name, and no...

Create 2 tables based on the ER model shown below . Include all the constraints in the CREATE TA BLE statements. You should ha ve only two create Table statem ents and no ALTER TABLE statements. Name...

CMP-241 Homework Due February 20, 2019 Advanced Challenge Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking...

Hello, I need help on this sql assignment. I'm not sure how to populate the table since I keep getting errors. Thank you! Create a lab report for the following programming challenge: Create two...

Advanced Challenge Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the...

Please I need a solution for this exercise Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all...

Tracking Database Create two tables based on the E-R model shown the below; and the business rules in the following list for a work order tracking database. Include all constraints in the CREATE...

Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the CREATE TABLE...

a. Lab 4 Creating Constraints Save screen captures of all SQL statements used to accomplish the following tasks. Save your screen captures in a word document or PDF which must be named in the format...

Data table McDonough Products, Inc. Balance Sheet Compared with Industry Average December 31, 2021 Current assets Plant assets, net Intangible assets, net Other assets Total Current liabilities...

The following information pertains to production operations of Abernathy Corporation for May: (a) Inventories: Work in process: Beginning, 3,000 units, all materials, 1/3 converted; ending, 2,000...

Canada Child Tax Benefit, Working Income Tax Benefit are examples of refundable tax credits ? ( A ) True False

A hydrocarbon oil at 150 enters inside a pipe with an inside diameter of 0.0303 ft and a length of 15 ft with a flow rate of 80 lbm/h. The inside pipe surface is assumed constant at 350 since steam...

=+ b. In year 1, the capital stock was 6, the labor input was 3, and output was 12. In year 2, the

=+1. In the economy of Solovia, the owners of capital get two-thirds of national income, and the workers receive one-third.

=+worldbank.org, is one place to fi nd such data.) How might you fi gure out which of these factors is most responsible for the observed income