Consider the matrix list x = [[1, 2, 3], [4, 5, 6], [7, 8, 9]].
Write...
Consider the matrix list x = [[1, 2, 3], [4, 5, 6], [7, 8, 9]].
Write a list comprehension to extract the first column of the
matrix [1, 4, 7]. Write another list comprehension to create a
vector of twice the square of the middle column.
Write a script to create the following tables with attributes
as specified(SQL)
Customer table with Customer’s...
Write a script to create the following tables with attributes
as specified(SQL)
Customer table with Customer’s id, name, address, city as
varchar, customer’s date of birth as date type and zip code number
where the customers id is the primary key in the table, name and
date of birth are mandatory. Id has a 10-character limit, name,
address and city have a 50-character limit, zip has a 5-character
limit
Product Table with Product id, description and finish as
varchar, price...
CREATE TABLE Customers
(Customer# NUMBER(4),
LastName VARCHAR2(10) NOT NULL,
FirstName VARCHAR2(10) NOT NULL,
Address VARCHAR2(20),
City...
CREATE TABLE Customers
(Customer# NUMBER(4),
LastName VARCHAR2(10) NOT NULL,
FirstName VARCHAR2(10) NOT NULL,
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4),
Region CHAR(2),
Email VARCHAR2(30),
CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#),
CONSTRAINT customers_region_ck
CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E'))
);
CREATE TABLE Orders
(Order# NUMBER(4),
Customer# NUMBER(4),
OrderDate DATE NOT NULL,
ShipDate DATE,
ShipStreet VARCHAR2(18),
ShipCity VARCHAR2(15),
ShipState VARCHAR2(2),
ShipZip VARCHAR2(5),
ShipCost NUMBER(4,2),
CONSTRAINT orders_order#_pk PRIMARY KEY(order#),
CONSTRAINT orders_customer#_fk FOREIGN KEY (customer#)
REFERENCES customers(customer#));
In...
Fill in the blank
1. The ______ is used to record all transactions affecting
the checking...
Fill in the blank
1. The ______ is used to record all transactions affecting
the checking account.
2. ______are additions to the checking account and can be
classified into two types.
3. The Write check window should not be used to record ______,
______, ______ and ______.
4. ______ is the process of comparing the bank statement with
your accounting records for the checking account.
5. A customer list contains information such as _______,
______ and ______.
6. Three possible...
Fill in the blank (11)
1. The ______ is used to record all transactions affecting
the...
Fill in the blank (11)
1. The ______ is used to record all transactions affecting
the checking account.
2. ______are additions to the checking account and can be
classified into two types.
3. The Write check window should not be used to record ______,
______, ______ and ______.
4. ______ is the process of comparing the bank statement with
your accounting records for the checking account.
5. A customer list contains information such as _______,
______ and ______.
6. Three...