Create the table and add data as described below. • Tablename: email_log • Columns: emailid (numeric), emaildate (datetime), customer# (numeric) • Primary key: emailid column, define as an Identity Column • Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected)

2. Create a view named Top10PaidInvoices that returns three columns for each vendor: VendorName, LastInvoice (the most recent invoice date), and SumOfInvoices (the sum of the InvoiceTotal column). Return only the 10 vendors with the largest SumOfInvoices and include only paid invoices.

SQL script which is the physical design for this database   ### Animals This table contains the following data about all animals in the zoo. - animal ID (primary key) - animal name - animal birthdate - species - habitat (foreign key) [1 habitat to many relationship]   ### Habitats This table contains data about the habitats in the zoo.  Each animal lives in a specific habitat.  The habitat table should include the following data - habitat name, foreign key) - habitat location   ### Database CREATE DATABASE zoo;     Write queries to create the tables. Be sure to include primary keys for each table and the required foreign keys and referential integrity actions.   Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT.   ANSWER IN MYSQL PLEASE

Assignment 6: Creating the Babbage Bookkeeping Database Create a relationship between two tables. Specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table). Save the Relationships.   Create the following queries.   Create a query for the Client table. The query must display Client Number, Client Name, and Balance fields for all clients located in Empeer with a balance greater than $300.00.  Do not display City field. Save the query as “Q21-Client-Empeer Query.”   Create a query to display the Client Number, Client Name, and Address fields for all clients with an address on Maum. Save the query as “Q22-Client-Maum Query.”   Create a query that will allow the user to enter the city to search when the query is run. The query results should display the Client Number, Client Name, and Bookkeeper Number. Test the query by searching for those records where the client is located in Portage. Save the query as “Q23-Client-City…

Compare between the following: Temporary table vs. View Assertion vs. Triggers

Write all the sql code (including create, insert and select), screenshot the output alongside the codes please.

How do duality concepts enrich our understanding of dual spaces in functional analysis?

1. Create one new table Courses_xxxx. Your table names must follow the above format(table name is case sensitive) with following fields in correct data types. This table will be used in yourproject.cid: auto_increment integer, primary key name: varchar(200), unique, NOT NULL term: varchar(200), NOT NULL enrollment: int, NOT NULL Fid: int, NOT NULL, a foreign key to TECH3740.Faculty table. Rid: int, NOT NULL, a foreign key to TECH3740.Rooms table. aid: int, NOT NULL, a foreign key to TECH3740.Admin table.

Read the data into a DataFrame with ID as the index. Convert the “Hired” column into Date/Time data type Create a new column with years of experience with the company at present without rounding. Create a new Boolean column for senior status with employees with at least 10 years of experience as senior and others are not. Create a new column for longevity pay equal to $150 per whole year of experience in the company. Create a list of column names for each data type in the DataFrtame.