PK productIDFK categoryIDnameProductdescriptionpriceWhich tables are lookup tables?CategoryO PhoneType, AddressTypeProductCategoryCustomer, CategoryPK productIDFK categoryIDCategoryPK categoryIDCategory, AddressType, PhoneTypename Review the sample eCommerce ERD after 3NF.PK credit CardIDFK customerIDCredit Cardcredit CardNumberexpDateCCVPK orderIDFK customerIDFK billingAddressIDFK shippingAddressIDFK creditCardIDOrderorder Dateorder TotalOrderLinePK orderLineIDFK orderIDFK productIDquantityunitPrice90°FSunnynamaPK productIDFK categoryIDProductPK customerIDfirstNamelastNameuserNamepasswordCustomerPK addressIDFK customerIDFK addressTypeIDcityaddressaddress2stateAddresszipcountryProductCategoryPK productIDFK categoryIDPhoneTypePK phoneTypeIDnamePhonePK phonelDFK phoneTypeIDFK customerIDphoneNumbernameAddress TypePK addressTypeIDQ

What is a Lookup table?: => An array or matrix of data that includes items that are…

Answered: Which tables are lookup tables?…

Engineering

Computer Science

Which tables are lookup tables? Category Category, AddressType, PhoneType PhoneType, AddressType Customer, Category

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

Related questions

Q: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: Select the best answer from the given choices: To add a new attribute (column) to an existing table,…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: How many distinct visit reasons start with the word "Pain"? Name the result column as NumPainReason.…

A: SELECT COUNT(DISTINCT VisitReason) AS NumPainReason FROM VisitWHERE VisitReason LIKE 'Pain%';

Q: When must you define constraints at the table level rather than the column level? ( refer to the…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: . Which manufacturers are located in the city of New York? Show the manufacturer's name, state,…

A: First, three parts will be answered. SQL query: 1) In this query, the SELECT statement along with…

Q: Create a list showing only the Employee ID, Sales, and Projected Sales columns sorted from highest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

Q: Create a new table, named Senior Teaching Staff, using the existing teacher table as your source.…

A: Structured query language is a programming language for storing and processing information in a…

Q: The number of times the table structure has been altered by SQL queries. Which major changes need to…

A: Yes, by tracking modifications in the history table and using SQL commands, you can keep a record of…

Q: How many SQL queries change the structure of the table? Which significant alterations must to be…

A: The answer is given below

Q: Use the appropriate MySQL command to view the structure of the user table

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: List every table that contains a column named OWNER_NUM. The output table should display one column…

A: The first ever freely programmable computer came into play in 1936, however after that International…

Q: How many different SQL queries do you think changed the table's structure? Which substantial…

A: The answer is given below step.

Q: How do we decide which sample table to use as a starting point when creating new tables in Microsoft…

A: When creating new tables in Microsoft Access, it is essential to select an appropriate sample table…

Q: Add a WHERE clause that joins the Reservation table and the Parent table. The common field in both…

A: syntax--> SELECT column1, column2....columnNFROM table_nameWHERE CONDITION;

Q: Which type of column can be simple or composite while also being correctly defined as both unique…

A: The question is asking about a type of column in a database table that can be simple or composite,…

Q: WEEK 9 SQL ASSIGNMENT Part I: Complete the following exercise: Create the following table with…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: What are joins and mention different types of joins?

A: Joins in SQL are used to combine two or more tables with common fields between them. there are 4…

Q: reate a query in query design view based on both tables to answer the question, What is the concert…

A: Query: Create query: CREATE TABLE `sponsor`( `concert_id` INT(50), `sponsor_name` VARCHAR(50),…

Q: Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer…

A: The BOOK_PRICING table is a part of a database used for managing pricing information for books. One…

Q: Alter table supplierTransaction add column paymentDate as data type date, not null, default value of…

A: Query from table Purchase Order ALTER TABLE purchaseOrder RENAME COLUMN WHERE EXISTS (SELECT 1…

Q: 1) Rewrite the query below to use GROUP BY CUS_CODE : SELECT CUSTOMER.CUS_CODE,…

A: In step 2, you will get the answer for 1. In step 3, you will get the answer for 2. In step 4, you…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

100%

PK productID
FK categoryID
name
Product
description
price
Which tables are lookup tables?
Category
O PhoneType, AddressType
ProductCategory
Customer, Category
PK productID
FK categoryID
Category
PK categoryID
Category, AddressType, PhoneType
name

Review the sample eCommerce ERD after 3NF.
PK credit CardID
FK customerID
Credit Card
credit CardNumber
expDate
CCV
PK orderID
FK customerID
FK billingAddressID
FK shippingAddressID
FK creditCardID
Order
order Date
order Total
OrderLine
PK orderLineID
FK orderID
FK productID
quantity
unitPrice
90°F
Sunny
nama
PK productID
FK categoryID
Product
PK customerID
firstName
lastName
userName
password
Customer
PK addressID
FK customerID
FK addressTypeID
city
address
address2
state
Address
zip
country
ProductCategory
PK productID
FK categoryID
PhoneType
PK phoneTypeID
name
Phone
PK phonelD
FK phoneTypeID
FK customerID
phoneNumber
name
Address Type
PK addressTypeID
Q

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Reference table 6-28. Include both SQL commands and results/answers in your answers. In the NONCAT table, increase the price of each item in category BRD by five percent. (Hint: Multiply each price by 1.05.) In the NONCAT table, increase the length of the DESCRIPTION column to 40 characters.
Use SQL to complete the following exercises. Provide SQL screenshots of the resutls of both questions. 1. Create a table named REP. The table has the same structure as the SALES_REP table shown in Figure 3-15 except the LAST_NAME column should use the VARCHAR data type and the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table. 2. Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser; address: 427 Billings Dr.; city: Cody; state: WY; postal: 82414; cell phone: 307-555-6309; commission: 0.00; and rate: 0.05. Display the contents of the REP table.
in sql When a view is dropped, the underlying table is also dropped. Select one: a. False b. True
How many SQL alter table structure? Which major adjustments should be considered? These changes need which commands?
Please give me correct solution.
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
2. Create a SELECT statement that returns the ORDER_NUM and PROD_ID for all records in the ORDERITEMS table. Using inner joins include the vendor name, product name and customer name for each item.
plz help with the following: When joining three or more tables, you need to specify a join condition for one pair of tables. Select one: a. True b. False
Please match the keyword or operator from the list below to its correct SQL explanation and syntax in the table. Replace ? with a correct option from the following list: Right outer join, UNION, Left outer join, Cartesian product, Inner join, Full outer join Keyword/Operator Explanation Syntax ? Combine tables vertically SELECT * FROM <table 1> UNION SELECT * FROM <table 2>; ? Produces all possible combinations of rows from the two tables SELECT * FROM <table name 1>, <table name 2>; ? Only matching rows are returned SELECT * FROM <table name 1>, <table name 2> WHERE <join condition> <AND other conditions> <other CLAUSES>; SELECT * FROM <table name 1> INNER JOIN <table name 2> ON join-condition <other clauses>; ? Includes all rows from the left table and inserts NA for non-matching rows SELECT * FROM <table name 1> LEFT JOIN <table name 2> ON <join…
How do we join multiple tables in a SELECT statement? Give an example.
How many rows after inner join, left join, right join, cross join table 1 to table 2? Table1 Column A A B C B A B B Table2 Column B A B D A 0 0 Y
Add a foreign key constraint to the movie table: the column prod_id is the foreign key, referencing the column id from the production table (use sql) following is movie and production table