Write a query to display the first name, last name, and email address of employees hired from January 1, 2005, to December 31, 2014. Sort the output by last name and then by first name. Write the answer to each query and the result of the query (screen capture). You should submit all design work, program documentation, and relevant sample screen shots of your implementation. A script file with all database creation and table populating is required.

StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.

Write a 200 word summary comparing and contrasting what you saw in terms of time to execute each step from 1-3, and why you think this is so. Next (not part of the aforementioned 200 words) state a situation in which you think each may be appropriate Append 10 records to the Student table of your own design – this means you will be creating 10 records to insert into the table This is accomplished via an Insert Into Student Values(1,2,3,etc....) You can model your queries off of the samples within Module 1, but bear in mind you now have indexes built and will not be able to duplicate rows so make sure you don’t use an ID in the student table that is already in use. Truncate and Replace the Sections table the truncate statement conveyed in the lecture slides, and then insert the data from Module 1 (note you do not want to run the create table portion again, as you’ve truncated the table it keeps the structure in place and just deletes the records).

Convert this ER model to a list of tables (Please provide a picture of the tables from Access)Provide the queries that implement the database

Task 1: The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign...

Use data definition commands, data manipulation commands, and data control commands correctly.

10. An EMPLOYEES table was added to the JustLee Books database to track employeeinformation. Display a list of each employee’s name, job title, and manager’s name. Usecolumn aliases to clearly identify employee and manager name values. Include allemployees in the list and sort by manager name.

Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each...

You will need to add a CREATE DATABASE and USE database statement at the beginning of the script in the file of the Sample Database in order for SQL Script in the Sample Database to execute/run correctly If you discover any ambiguity between the written Metadata and the actual table definitions, the path that I recommend is to use the SHOW TABLES Statement and the DESCRIBE Table Statement to eliminate any ambiguity between the written Metadata and the actual Metadata. CustOrders.sql download Aggregation Part of the Exercise . Select the maximum price of any orders in the items_ordered table. Hint: Select the maximum price only. . Select the average price of all of the orders that were purchased in the month of Dec. . Return the total number of rows in the orders table? . For all of the tents that were ordered in the orders table, what is the price of the lowest tent? Hint: Your query should return the price only. Group By Exercises . How many people are...

The main aim of your project is to create a database schema consists of 3 tables suggested by yourself and simulate it through a graphical application program: Part 1: SQL By using sql-plus environment create your database tables: 1- Your tables must be relationally complete. 2- Make three Sequences (One for each table). 3- Make any Materialized view. 4- Insert some records to your tables. (use the created sequences to generate numbers to be inserted into a fields of your tables).

Development You will be writing the Python code to support the business requirements that were outlined in theWhatABook Rules/Requirements There is no deliverable for this assignment. Instead, use this time to work on the program, database queries, and tables. If you run into issues while developing the database queries to use in the program, refer to the course's GitHub repository, module_10/whatabook_program_queries.sql. Again, try to write the queries on your own and only use this resource as a last resort.

I need help with understanding how to do the SQL code for the following question (attached is the CSV database file): These are the header titles from the picture: ProductModelName, ProductCategory, ProductPrice, RetailerName, RetailerZip, RetailerCity, RetailerState, ProductOnSale, ManufacturerName, ManufacturerRebate, UserID, UserAge, UserGender, UserOccupation, ReviewRating, ReviewDate, Review Text 1. Get the total number of products reviewed and got Rating 5 in Every City

Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.