1- Create a NONGAME table with the following structure:ColumnТуpeLengthDecimal Places Nulls Allowed? DescriptionITEM NUMCHARPrimary Key4NoDESCRIPTIONCHAR30ON HANDDECIMAL4CATEGORYCHAR3PRICEDECIMAL2- Insert into the NONGAME table the item number, description, number of units onhand, category, and unit price from the ITEM table for each item that is not incategory GME.3- In the NONGAME table, change the description of item number DL51 to "ClassicTrain Set".4- In the NONGAME table, increase the price of each item in category TOY by twopercent. (Hint: Multiply each price by 1.02).5- Add the following item to the NONGAME table: item number: TL92; description:Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95.6- Delete every item in the NONGAME table for which the category is PZL.7- In the NONGAME table, change the category for item FD11 to null.8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-handvalue is a seven-digit number with two decimal places that represents theproduct of the number of units on hand and the price. Then set all values ofON_HAND_VALUE to ON_HAND * PRICE.9- In the NONGAME table, increase the length of the DESCRIPTION column to 40characters.10-Delete the ON_HAND_VALUE column from the NONGAME table.InctriuctionCI

2.) INSERT INTO NONGAME (item number,description,category,price) SELECT item…

1- Create a NONGAME table with the following structure: olumn Турe Length Decimal Places Nulls Allowed? Description TEM_NUM ESCRIPTION Primary Key CHAR 4 No CHAR 30 ON_HAND CATEGORY RICE DECIMAL 4 CHAR 3 DECIMAL 6 2. 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table category GME. each item that is not in

1- Create a NONGAME table with the following structure: olumn Турe Length Decimal Places Nulls Allowed? Description TEM_NUM ESCRIPTION Primary Key CHAR 4 No CHAR 30 ON_HAND CATEGORY RICE DECIMAL 4 CHAR 3 DECIMAL 6 2. 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table category GME. each item that is not in

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 Add the four maintenance types to the MAINTENANCE_TYPES table.
Parent row is a row where there is a ? Primary key Foreign key non-null field null field
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
LAB - Select horses with logical operators The Horse table has the following columns: • ID integer, primary key • RegisteredName - variable-length string • Breed - variable-length string • Height-decimal number • BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0 THIS IS IN SQL FORMAT FOR CENGAGE MINDTAP, PLEASE HELP I AM STUCK
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0
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 keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.
Given the tables: reading StationNo rainfall mintemp maxtemp 100 10 18 27 101 15 20 29 102 12 19 28 Stationregion station stationname 100 Savanne 101 Pamplemousses 102 Rose Belle (i) Write the statement to create the two table structures with the primary key as the field underlined. You may decide on the size of the fields. (ii) Write the statement to enter the data. (ii) Write the statement to display all the records with the fields station. stationname, mintemp, maxtemp .
Create table EMP and DEPT with the below mentioned structureStructure for EMP tableEmpIDNUMBER(4)DeptIDVARCHAR2(10)EmpNameCHAR(10)JobCHAR(10)HireDate DATESalary NUMBER(7, 2)Commission NUMBER (7, 2)Structure for DEPT tableDeptId VARCHAR2(10)Deptname VARCHAR2(20)No_of_Faculties NUMBER(2)In table EMP : EmpID should be the Primary Key and DeptID should be the foreign key.In table DEPT : DeptId should be the primary key. a) Find out the number of employees having “manager” as job.b) Display only the jobs with maximum salary greater than or equal to 3000c) Find all those employees whose job does not start with ‘M’. Find the names of the employees who are Managers and their date of joining is after “02-Jan-2006”.
herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints