Question: You need to create a database and tables to store information about a company's employees, departments, and job titles. Details of tables to be created

 You need to create a database and tables to store informationabout a company's employees, departments, and job titles. Details of tables to

You need to create a database and tables to store information about a company's employees, departments, and job titles. Details of tables to be created (only three tables): 1. The employees table should include fields for the employee's ID, name, address, social security number, salary, department id, and job title id. 2. The departments table should include fields for the department name and department id. 3. The job titles table should include fields for the job title name and job title id. You will also need to populate the tables with sample data (at least 5 rows each) and write SQL queries to retrieve specific data from the database. These queries should include: 1. A SELECT statement to retrieve all data from a single table 2. A SELECT statement with a WHERE clause to retrieve specific data from a single table 3. A SELECT statement with a GROUP BY clause to retrieve aggregated data from a single table 4. A SELECT statement with a HAVING clause to retrieve aggregated data based on specific conditions 5. A SELECT statement to retrieve data from multiple tables (Without using a JOIN. Use subqueries) In your submission, be sure to include all the following (one section in the solution template for each): - Schema diagram for your database (Handwritten) - SQL schema definition for each table (typed text, not images) - SQL insertion statements (quires) for each table (five per table) (typed text, not images) - SQL queries to retrieve data (see requirements above) (typed text, not images) Section 1: Schema diagram for your database (Handwritten) (Scan your handwritten schema and insert it here) (in addition type a short paragraph 50-100 words discuss your tables, keys, and arrows) Section 2: SQL schema definition for each table (in addition to the schema definition typed as text, add a short paragraph 50-100 words discuss your solution; e.g. discuss using keywords like primary key, not null, int, decimal) Section 3: SQL insertion statements (quires) for each table (five per table) (in addition type a short paragraph 50-100 words discuss your company example from which you considered employees, departments and job titles) Section 4: SQL queries to retrieve data (Write your SQL queries and explain them in short paragraph for each query)

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!