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)

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)

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...

See similar textbooks

Similar questions

Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
A new table has been requested to support tracking automated emails sent to customers. 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)1. Emaildate ¼ current date, customer# ¼ 10072. Emailid ¼ specify to use the column default value, emaildate ¼ current date, customer# ¼ 10083. Emailid ¼ 25, emaildate ¼ current date, customer# ¼ 1009 (refer to the tables in the JustLee Books database).
Creating tablesWhen creating the fields, make sure you select the correct data type and add enough characters per field. Field names do not contain a space. Create a table named course with the following fields; course id (primary key), course num, course name Create a table named student with the following fields; student id (primary key), first name, last name, major, phone, semester, year, age. Create a table named professor with the following fields; professor id (primary key), first name, last name, department, hire date (date field). Create a table named semester with the following fields; semester, year Create a table named teach with the following fields; teach id (primary key), course id (foreign key, based on course id in course table), professor id (foreign key, based on professor id in professor table), semester, building, class room number Create a table named take with the following fields; teach id (primary key, foreign key based on teach id in the teach table),…
Create one new table Products_xxxx. Your table names must follow the above format(table name is case sensitive) with following fields in correct data types. p_id: auto_increment integer, primary key  name: varchar(200), unique, NOT NULL  description: varchar(200), NOT NULL  type: varchar(50), NOT NULL  sell_price: float, NOT NULL  cost: float, NOT NULL  quantity: int, NOT NULL  e_id: int, NOT NULL, a foreign key to the employee_id field in the table v_id: int, NOT NULL, a foreign key to the vendor_id field in the table.
2.10 LAB - Insert rows into Horse table The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12
9. Create a table client master with the following field’s client_no, name, address1, address2, city, state, pin_code, remarks, and balance due and add the constraints? • Create a primary key constraint on the column client_no.? • create the following check constraints Data values being inserted into the column client_no must start with ‘c’. Data values being inserted into the column name should be allowed in upper case only? a) Insert five rows in the table client master? b) Show all rows of client master? c) Add a new column in your table : AGE ? d) Update the table client master ? e) Delete a row from client master where age is greater than 60?
Create a new table Courses_xxxx with following fields in correct data types.1) cid: varchar(200), unique, NOT NULL, primary key2) name: varchar(200), unique, NOT NULL3) term: varchar(200), NOT NULL4) enrollment: int, NOT NULL5) Fid: int, NOT NULL, a foreign key to TECH3740.Faculty table.6) Rid: int, NOT NULL, a foreign key to TECH3740.Rooms table.7) aid: int, NOT NULL, a foreign key to TECH3740.Admin table.
2.14 LAB - Create LessonSchedule table with FK constraints Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.
Create a simple table called Athletics. The columns in the Athletics table are named AthleteID, First_name, Last_name, DOB, SportsCode, and Date_Last_event. The AthleteID column is the primary key of the table. Use the appropriate data types. Only the SportsCode and Date_Last_event columns can have no data when a row is inserted or changed.
1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…
3.10 LAB - Update rows in Horse table The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015 Make the following updates: Change the height to 15.6 for horse with ID 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. Change every horse breed to NULL for horses born on or after December 22, 2016. 401682.2354678.qx3zqy7
3.8 LAB - Create LessonSchedule table with FK constraints Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Note: Table and column names are case sensitive in the auto-grader.