Your assignment is based on the following three tables.Employee:e_idfirst_namelast_namegendersalary1EllenMonkF600002JoeBradyM500003DaveDavidsonM550004SebastianColeM350005MichaelDooM250006RubyClarkF300007BobHouseM475008HannahStanleyF700009BradleyWilsonM75000Â Departments:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â dep_iddep_namedep_location1ResearchIndianapolis2Human ResourceÂ Â Â Â Â Â Â Chicago3SalesÂ Salt Lake City4MarketingÂ Chicago5FinanceÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â IndianapolisÂ Register:e_iddep_id116241752253948331Â Â 1) CREATE TABLE statements to create the three tables given above. Don't forget to specify appropriate primary and foreign keys when you do so! You are welcome to pick data types of your own choice.For each table, include a justification of why you picked each data type, and any other decisions taken. (This is worth 30 points).2) Next, insert the data you see here into each of the tables created in step 1) using INSERT statements.Remember, not your own data, but the data that i've presented above. (This is worth 30 points).3) create appropriate SQL queries to answer the following questions.(16Â points per question for a total of 96Â points + 4 points for cleanness of presentation = 100 points).For each department, list department number, department name and number of employees in these departmentsList department number, department name, and number of employees in departments that have two or more employees, ordered by department number.Â List employee names (first_name and last_name) of each male employee, together with their department name.List the distinct name of employees who are not working in "Research"List the name and number of departments whose employee average salary is between 30000 and 60000.List the name of employees who works (department location) in Salt Lake City and whose last nameÂ start with 'D'.4) This question consists of fourÂ parts, and is worth 40 points. Please note that you need to work on this individually even if you are working as part of a group. So for a team of three, i'm expecting three different answers to this question.Imagine that the aforementioned three tables are part of an organization database, and propose three other tables that could help improve their day to day operations.to do so,Propose a specific area/field that your hypothetical organization focuses on. As an example, lets say that my organization is a bank.Imagine that your organization already has the three tables that we just created. List three additional tables that would be of use to your organization, and provide a rationale.Write create statements for your table using SQL. The better your SQL and design, the better your grade!Identify one logical question that you would be able to answer for your organization if you had these new tables populated with data. In this case, i'm not looking for SQL, but rather, a meaningful question that you could answer using queries on the new tables. Please note that the questions need to be as objective and specific as possible!Save the file as a pdf or wordÂ doc,
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this Question
Jan 02, 2020
YES, THIS IS LEGAL
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
As a reference for in-depth understanding of the subject.
As a source of ideas / reasoning for your own research (if properly referenced)
For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.
NEW ASSIGNMENT HELP?
Order New Solution. Quick Turnaround
Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions.
New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.
WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.