Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create HR database with the following tables. 2. Table 2: Departments 5. Table 5: Regions begin{tabular}{|l|c|c|} hline Column Name & Null? & Type hline
Create HR database with the following tables. 2. Table 2: Departments 5. Table 5: Regions \begin{tabular}{|l|c|c|} \hline Column Name & Null? & Type \\ \hline REGION_ID & NOT NULL \\ \hline REGION_NANE & & NUMBER. \\ \hline \end{tabular} 6. Table 6: Job_history 7. Table 7: Employees Data Integrity constraints are shown below: Data for each table is shown below: 1. For Regions table VALUES (1, 'Europe'); VALUES (2, 'Americas '); VALUES (3,'Asia'); VALUES (4, 'Middle East and Africa'); 2. For Countries table VALUES ('AR ', 'Argentina ', 2); VALUES ('AU', 'Australia', 3); VALUES ('BE', 'Belgium' , 1); VALUES ('BR', 'Brazil', 2); VALUES ('CA', 'Canada', 2); VALUES ('CH', 'Switzerland ', 1); VALUES ('CN', 'China', 3); VALUES ('DE', 'Germany', 1); VALUES ('DK', 'Denmark', 1); VALUES ('EG', 'Egypt', 4); VALUES ('FR', 'France',1); VALUES (' HK ', 'HongKong', 3); VALUES ('IL', 'Israel', 4); VALUES ('IN', 'India', 3); VALUES ('IT', 'Italy', 1); VALUES ('JP','Japan', 3); VALUES ('KW', 'Kuwait', 4); VALUES ('MX', 'Mexico', 2); VALUES ('NG', 'Nigeria', 4); VALUES ('NL', 'Netherlands' , 1); VALUES ('SG', 'Singapore', 3); VALUES ('UK', 'United Kingdom', 1); VALUES ('US', 'United States of America', 2); VALUES ('ZM', 'Zambia', 4); VALUES ('ZW', 'Zimbabwe', 4); 4. For Jobs table 5. For Departments table 6. For Employees table Write SQL query for the following questions based on above database
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started