Blog

Write you answer to part (a) in the box below (be sure to also indicate which essay you are answering: 1, 2, 3, or 4). (6 Points)

The Department table was created as follows:CREATE TABLE Department (   DepartmentCode SMALLINT UNSIGNED AUTO_INCREMENT,   DepartmentName VARCHAR(20) NOT NULL,   PRIMARY KEY (DepartmentCode));The Department table now contains the following rows: DepartmentCode DepartmentName 1 Sales 2 Marketing 3 Development What is the result of the following statement?INSERT INTO Department (DepartmentName)VALUES (‘Shipping’);

Refer to the Product table. Which products are selected by the query below?                      ProductSELECT *FROM ProductWHERE Quantity > 5 AND UnitPrice

How many columns are created by the SQL statement below?CREATE TABLE Supplier (    SupplierId INT,       CompanyName VARCHAR(40),    ContactName VARCHAR(50),    City VARCHAR(40),    Country VARCHAR(40),    Phone VARCHAR(30));

In the SQL code below, which of the following is an identifier?UPDATE Product SET UnitPrice = 9.50WHERE ProductId = 20;

Denormalization eliminates _____ queries, and therefore, query performance is improved.

When an entity-relationship model is implemented in SQL, an entity typically becomes a _____.

An atom with a total of 12 electrons would have how many electrons in each shell located around the nucleus? Write the answer indicating the number of electrons in each shell separating the numbers with dashes like this:   1-2-3

A database management system reads and writes data in a database, and _____.

What is a major theme of “The Yellow Wallpaper”?