Write SQL commands to create a database and add data to them.   There will be two tables: Courses and Sections CourseNo --> Credits, Title CRN --> CourseNo, Sec, Campus, Days, MeetingTime, Capacity, Actual, Remaining, Instructor, StartDate, EndDate, Location The table design requirements are as follows (refer to picture with dark background).   -Create SQL commands to create the two tables.  -Import the data shown in the other picture into the two tables.

Answer the following SQL questions using MySQL command language in MySQL Workbench, sakila database environment!

Write a SQL script that performs the following. Creates an updatable view based on the employee table. The view must contain the following features Rename all of the columns Display all "manager" records Insert 5 new records into the base table (using the view) Display all the view records using the base table (to verify that the view performed the inserts)

Practice Question 1. Assume that the Users table has a plenty of records but only three colums: UserID, FirstName and LastName. Write the following: a) Write an SQL query to show the top 5 records of the Users table.  (in order to test it populate your table with more than 5 records) in the PHP file and to display the result in well-readable format (table preffered) in the browser using parameters. b) Write a SQL query in the  PHP file  that will print details of all users excluding those with the FirstName “Will” and “Michael” from the Users table and to display the result in well-readable format (table preffered) in the browser using parameters. Hint: you can either write all your code in the same file or use two different files

Code SQL (Screenshot code and output)   Create three tables for a company that sells computer software, the tables are employees, department, and product. You can specify the attributes for each table based on what you see fit. Then, Link the three tables together. Note : Work on Oracle SQL live, take a screenshots of you work.

PLZ help with the following: The manager wants to add a new painter as an artist in the database. What would the insert statement look like? For a painter to be considered in the Artist database, the painter must have painted at least one painting, however, a painting might not be exhibited in a gallery. Based on these business rules, please insert one painting for the painter that you inserted in Q1. sql file CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER…