Question
Page 1 of 2 INSY- 5335/ 3304 Assignment -1 The homework is about creating the tables and adding your own rows. Refer to the below
Page 1 of 2 INSY- 5335/ 3304 Assignment -1 The homework is about creating the tables and adding your own rows. Refer to the below points that help you to achieve the task. Question 1: Create tables Part 1: Create three different tables namely Employee table, Department table and Positions table. Part 2: Each table will have different columns as mentioned below. Part 2 is to add the below-specified columns to the respective table and then paste the screenshot for the created tables on your SQLlite. Employee Table Columns Names Description e_id Unique id of employee e_name Name of the employee dep_id Department id of the employee rank rank is the position of an employee. CEO of the company holds the highest rank say 1, followed by CFO, Managers, supervisors, etc., salary The amount of salary an employee earns per year Department Table Columns Names Description dep_id Unique id of department d_name Name of the department. For example: Accounting, Finance, sales, HR, etc. Positions Table Column Names Description rank rank is the position of an employee. CEO of the company holds the highest rank say 1, followed by CFO, Managers, supervisors, etc p_title Position of an employee. For example: CEO, CFO, Supervisor, Manager, e.t.c. Hint- Rank in position table and dep_id in department table are referenced in employee table. Question 2: Insert data(rows) to the above created tables. Part 1: Insert you own rows to the tables. Note that each table much have at least 5 rows. For example: d_name: Accounting, Finance, sales, HR, etc. p_title: : CEO, CFO, Supervisor, Manager, e.t.c. Likewise, Define your own values for other columns too. Part 2: Query the tables and display all the values of the table. Make sure there are no Null values in the tables. Paste all 3 screenshots of the newly created tables along with their queries. Question 3: Write your own query to select name of the employee, position of the employee, their rank, and department name. Your result table should have only 3 columns e_name, p_title, rank and d_name. Question 4: Write your own query to show the employees name with highest salary.
Can someone do this and make it unique plus tell me what app I need to use I have an macbook
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