New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN: 9781305503922
Author: Patrick M. Carey
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 9CP2
Program Plan Intro
To insert a nested table belonging to the subTable class and within these nested tables, insert 3 rows and 3 columns and enter the digits in the appropriate table cells in the file jpf_sudoku.html.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
CREATE TABLE Employee( Eid INT PRIMARY KEY, E_name VARCHAR(20), E_Age INT CHECK (E_Age between 18 and 60), ECity VARCHAR(20), E_Street VARCHAR(20), E_House# INT, E_Basic_Salary DECIMAL(18,2), E_Bonus DECIMAL(18,2), E_Rank VARCHAR(20) CHECK (E_Rank IN('Manager','Develper','Admin')), E_Department VARCHAR(20) DEFAULT 'CS' CHECK (E_Department IN ('HR','CS','IT','Labour')));
Create Table Porjects:
CREATE TABLE Project1( p_id INT , pName VARCHAR(20), p_bonus DECIMAL(18,2), duration_in_months INT, Eid INT, PRIMARY KEY(p_id,Eid), FOREIGN KEY(Eid) REFERENCES Employee(Eid));
now the question is...
Display Total expenditures of company. (total expenditures = basic salary + bonus of employee + all project bonus)
Display names of projects in which ‘Ahmar’ is
Display total project bonus of ‘Danish’.
Display total expenditures of only those departments whose total expenditures are more than 1 Million. (total expenditures = sum of basic salary of all employees of that…
CREATE TABLE consumer ( ConsumerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Age INT, Gender VARCHAR(10), OnlineInStore VARCHAR(20));
INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online');
CREATE TABLE InStoreRetailer ( RetailerID INT PRIMARY KEY, RetailerName VARCHAR(50), StoreLayout VARCHAR(50), CustomerService…
Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements.
Create a Table Named Student.
The first column should be named ID, and have a data type of Integer
The second column should be named First_Name, and have a data type of varchar(255).
The third column should be named Last_Name, and have a data type of varchar(255)
The fourth column should be named DOB (short for date of birth), and have a data type of date.
The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.
Chapter 6 Solutions
New Perspectives on HTML5, CSS3, and JavaScript
Ch. 6.1 - Prob. 9QCCh. 6.2 - Prob. 1QCCh. 6.2 - Prob. 2QCCh. 6 - Prob. 1RACh. 6 - Prob. 2RACh. 6 - Prob. 3RACh. 6 - Prob. 4RACh. 6 - Prob. 5RACh. 6 - Prob. 6RACh. 6 - Prob. 7RA
Ch. 6 - Prob. 8RACh. 6 - Prob. 9RACh. 6 - Prob. 10RACh. 6 - Prob. 11RACh. 6 - Prob. 12RACh. 6 - Prob. 13RACh. 6 - Prob. 14RACh. 6 - Prob. 15RACh. 6 - Prob. 16RACh. 6 - Prob. 17RACh. 6 - Prob. 18RACh. 6 - Prob. 19RACh. 6 - Prob. 20RACh. 6 - Prob. 21RACh. 6 - Prob. 22RACh. 6 - Prob. 23RACh. 6 - Prob. 24RACh. 6 - Prob. 1CP1Ch. 6 - Prob. 2CP1Ch. 6 - Prob. 3CP1Ch. 6 - Prob. 4CP1Ch. 6 - Prob. 5CP1Ch. 6 - Prob. 6CP1Ch. 6 - Prob. 7CP1Ch. 6 - Prob. 8CP1Ch. 6 - Prob. 9CP1Ch. 6 - Prob. 10CP1Ch. 6 - Prob. 11CP1Ch. 6 - Prob. 12CP1Ch. 6 - Prob. 13CP1Ch. 6 - Prob. 14CP1Ch. 6 - Prob. 15CP1Ch. 6 - Prob. 16CP1Ch. 6 - Prob. 17CP1Ch. 6 - Prob. 18CP1Ch. 6 - Prob. 1CP2Ch. 6 - Prob. 2CP2Ch. 6 - Prob. 3CP2Ch. 6 - Prob. 4CP2Ch. 6 - Prob. 5CP2Ch. 6 - Prob. 6CP2Ch. 6 - Prob. 7CP2Ch. 6 - Prob. 8CP2Ch. 6 - Prob. 9CP2Ch. 6 - Prob. 10CP2Ch. 6 - Prob. 11CP2Ch. 6 - Prob. 12CP2Ch. 6 - Prob. 13CP2Ch. 6 - Prob. 14CP2Ch. 6 - Prob. 15CP2Ch. 6 - Prob. 16CP2Ch. 6 - Prob. 17CP2Ch. 6 - Prob. 1CP3Ch. 6 - Prob. 2CP3Ch. 6 - Prob. 3CP3Ch. 6 - Prob. 4CP3Ch. 6 - Prob. 5CP3Ch. 6 - Prob. 6CP3Ch. 6 - Prob. 7CP3Ch. 6 - Prob. 8CP3Ch. 6 - Prob. 10CP3Ch. 6 - Prob. 11CP3Ch. 6 - Prob. 12CP3Ch. 6 - Prob. 13CP3Ch. 6 - Prob. 14CP3Ch. 6 - Prob. 15CP3Ch. 6 - Prob. 16CP3Ch. 6 - Prob. 17CP3Ch. 6 - Prob. 18CP3Ch. 6 - Prob. 19CP3Ch. 6 - Prob. 20CP3Ch. 6 - Prob. 21CP3Ch. 6 - Prob. 22CP3Ch. 6 - Prob. 23CP3Ch. 6 - Prob. 24CP3Ch. 6 - Prob. 1CP4Ch. 6 - Prob. 2CP4Ch. 6 - Prob. 3CP4Ch. 6 - Prob. 4CP4Ch. 6 - Prob. 5CP4Ch. 6 - Prob. 6CP4Ch. 6 - Prob. 7CP4
Knowledge Booster
Similar questions
- Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters.arrow_forward8.Create a Frequency table to identify the Shopping Basket size using the “FREQUENCY” function and “Net Sales” column. Create a Bin Table to create a Frequency Table (bin array – 0-$10, $11-$20, $21-30, $31-40, $41-50).arrow_forward1- 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…arrow_forward
- Add a new customer row by using the sequence created in Question 1. The only data currently available for the customer is as follows: last name = Shoulders, first name = Frank, and zip = 23567.arrow_forwardModify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.arrow_forwardCreate a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID, and the other columns should keep their original names. Name the new table BOOK_PRICING.arrow_forward
- Save the changes permanently to the database.arrow_forwardInsert 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.arrow_forwardMicrosoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables and each 5 by 5 table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table AND again, each table cannot repeat the same number. I need to create this without having to manually type numbers and create the 5 by 5 tables.What is the fastest way to create these tables using formulas? This assignment demonstates the examples for formulas on excel. Here is two examples for 2 tables.TABLE 1:1 2 3 4 56 7 8 9 1011 12 13 14 1516 17 18 19 2021 22 23 24 25TABLE 2:59 2 3 4 133 72 8 9 6611 22 13 88 1516 17 18 19 529 40 99 30 21Here is an example that will NOT work.1 2 66 4 216 7 8 7 910 11 12 39 4182 88 88 88 29100 33 35 32 51arrow_forward
- The SAS table hold.work contains a numeric column named ID. Write an entire DATA step to create a table named hold.work2 that is a copy of hold.work but additionally contains a new character column named Name. Name should have the value "Food" when the existing numeric column ID is 50, and it should have the value "Ok" otherwise. [Note: Make sure the entire value is stored.]arrow_forwardTrue or False Rather than showing multiple rows at once, a Details view lets the user see one row at a time.arrow_forwardHow can i fix this error its not going away and i have tryed everythingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- New Perspectives on HTML5, CSS3, and JavaScriptComputer ScienceISBN:9781305503922Author:Patrick M. CareyPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage