Which tables are lookup tables? Category Category, AddressType, PhoneType PhoneType, AddressType Customer, Category
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.
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1ec33595-f02c-48d8-a683-f0a54a7d7226%2F8bd6d3e0-a7b3-4a49-9a48-5d84bbc81ce0%2F3haiegi_processed.png&w=3840&q=75)
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1ec33595-f02c-48d8-a683-f0a54a7d7226%2F8bd6d3e0-a7b3-4a49-9a48-5d84bbc81ce0%2F1wi8r5c_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![Enhanced Discovering Computers 2017 (Shelly Cashm…](https://www.bartleby.com/isbn_cover_images/9781305657458/9781305657458_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)