2. Create a table named sizeTvpe with the following attributes, data types, and constraints: a. ID, integer, 7 characters, not null, auto increment b. size, variable character, 20 characters, not null c. primary key is the ID field 3. Update table product, row with description as "tiramisu classico" so the size = '3 ounce' versus '3 oz 4. Insert into table şizeType, column size the distinct character portion of table product, column size using the SUBSTRING_INDEX function, the arguments passed should be column size, an explicit space and the value -1. Example SUBSTRING INDEX(,'", -1). 5. Alter table product, add column şizeTypeld as integer, 7 characters, not null 6. Update table product, set column şizeTypeld equal to the corresponding size in table sizeType In my sizeType table I have the following: 1 ounce | 2| pound 13 count

2. Create a table named sizeTvpe with the following attributes, data types, and constraints: a. ID, integer, 7 characters, not null, auto increment b. size, variable character, 20 characters, not null c. primary key is the ID field 3. Update table product, row with description as "tiramisu classico" so the size = '3 ounce' versus '3 oz 4. Insert into table şizeType, column size the distinct character portion of table product, column size using the SUBSTRING_INDEX function, the arguments passed should be column size, an explicit space and the value -1. Example SUBSTRING INDEX(,'", -1). 5. Alter table product, add column şizeTypeld as integer, 7 characters, not null 6. Update table product, set column şizeTypeld equal to the corresponding size in table sizeType In my sizeType table I have the following: 1 ounce | 2| pound 13 count

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

CREATE TABLE employees8(employee_id NUMBER(10) PRIMARY KEY,first_name VARCHAR(25) UNIQUE,last_name VARCHAR(25) UNIQUE,job_id NUMBER(3),salary NUMBER(6) NOT NULL,department_name VARCHAR2(20));CREATE TABLE jobs8(job_id NUMBER(3) PRIMARY KEY,job_title VARCHAR2(25),min_salary NUMBER(4)check(min_salary >=2900),max_salary NUMBER(6)check(max_salary<=100000)); CREATE TABLE departments8(department_id NUMBER(2) PRIMARY KEY,department_name VARCHAR2(30),location_name VARCHAR2(15) DEFAULT 'Istanbul'); how can I do this question according to these 3 tables ? Create a complex view that joining with three tables.
The 'customer' table contains ten columns but no row. The table is then updated with 10 new rows and 3 rows removed. What is the table 'customer's degree and cardinality?
The 'customer' table contains ten columns but no rows. The table is then updated with 10 new rows and 3 rows discarded. What is the table'customer's degree and cardinality?
CREATE TABLE DOCTOR(DOC_ID NUMBER(3),DOC_NAME VARCHAR2(9),DATEHIRED DATE,SALPERMON NUMBER(12),AREA VARCHAR2(20),SUPERVISOR_ID NUMBER(3),CHGPERAPPT NUMBER(3),ANNUAL_BONUS NUMBER(5),CONSTRAINT DOCTOR_DOC_ID_PK PRIMARY KEY (DOC_ID)); INSERT INTO DOCTOR VALUES(432, 'Harrison' , TO_DATE('05-DEC-94'), 12000,'Pediatrics', 100, 75, 4500); INSERT INTO DOCTOR VALUES(509, 'Vester' , TO_DATE('09-JAN-00'), 8100,'Pediatrics', 432, 40, null); INSERT INTO DOCTOR VALUES(389, 'Lewis' , TO_DATE('21-JAN-96'), 10000, 'Pediatrics', 432, 40, 2250); INSERT INTO DOCTOR VALUES(504, 'Cotner' , TO_DATE('16-JUN-98'), 11500,'Neurology', 289, 85, 7500); INSERT INTO DOCTOR VALUES(235, 'Smith' , TO_DATE('22-JUN-98'), 4550, 'Family Practice', 100, 25, 2250); INSERT INTO DOCTOR VALUES(356, 'James' , TO_DATE('01-AUG-98'), 7950,'Neurology', 289, 80, 6500); INSERT INTO DOCTOR VALUES(558, 'James' , TO_DATE('02-MAY-95'), 9800, 'Orthopedics', 876, 85, 7700); INSERT INTO DOCTOR VALUES(876, 'Robertson' , TO_DATE('02-MAR-95'),…
Please written by computer source Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML statements on your table. To do this you write two triggers: 1. To log any DML statements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table (e.g. John Dow will create table j_dow_log). The table should have unique event ID, values for both the Oracle and the system user who ran the query, the time it was executed and the type of DML query user ran. 2. To capture any data that was changed in the table. The results must be stored in the First Initial _ Last Name _ History table (e.g. John Dow will create table j_dow_history). The table should reference the event ID from the log table, and store both old and new values for both columns. What to submit: Name this file according to submission guidelines and include the following answers: Code to create all three…
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
Use the data from the class assignment, ALTER TABLE and add two more columns Phone and email. Describe the table (show its structure) and drop the country column, describe the table (show structure). Now, create a new table based on the existing table person with the help of a subquery (The new table will contain the data from “person” table) and name the table person_self. Show its output (table created and its structure). NOTE: Use the ALTER TABLE command with ADD clause Use the ALTER TABLE command with DROPCOLUMN clause Use the CREATE TABLE command with AS (SELECT SUBQUERY) clause
1. Use Design view to create a new table. Add AccountType as the first field name, with data type Short Text and field size 10. Ensure AccountType is set as the primary key. Save the table and name it AccountTypes. Add three records: Platinum, Silver, and Gold. Close the table.2.Open the Customers table in Design view. Set the PhoneNumber and AccountType fields to Required. Save the table. Close the table.3.Open the Loans table in Design view. Establish a validation rule for the InterestRate field that requires the value to be greater than or equal to 2.5 but less than or equal to 10. Create validation text for the InterestRate: Value must be between 2.5 and 10 (no period). Save the table. Change the InterestRate in the first record to 2. The validation text appears. Press ESC to restore the original value. Close the Loans table.4.Open the Customers table in Design view. Add a phone number input mask for the PhoneNumber field, storing the symbols with the data.5.Change the Data Type of…
-- 1 - Write a view to show all data from Sales.Sales Person table
Insert any 5 rows of athletes including your details into the Athletics table you created in the previous Question. The table created previously CREATE TABLE Athletics ( AthleteID int NOT NULL First_name varchar(255) NOT NULL, Last_name varchar(255) NOT NULL, DOB DATE NOT NULL, SportsCode INT, Date_Last_event DATE, PRIMARY KEY (ID) ); varchar(255) use for define string column, int stand for integer field etc.
Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
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.